Database and assistance with PowerBI
There is a database in the cloud, it is necessary to retrieve data via API to another server, and also need help with PowerBI, to set up several reports (data will be pulled from several databases on different servers, as well as from Excel spreadsheets)
-
30 days112 USD
30 days112 USD
Hello!
Directly connecting PowerBI to several disparate databases and local Excel files creates a fragile architecture that will start to "crash" your servers when generating the first massive report. As my current project with complex data integration of SAP and OpenCart shows, trying to work with "raw" streams without an intermediate storage turns business analytics into a generator of system failures and inaccurate figures.
Abandoning data chaos "on the wire": Collecting metrics via API from various sources directly into the visualizer creates a critical bottleneck. It is necessary to implement an ETL (Extract, Transform, Load) architecture for centralized extraction, cleansing, and normalization of data from clouds, servers, and Excel into a single storage (Data Warehouse), and only from there safely deliver them to PowerBI.
Isolating analytics from production: Pulling arrays for reports directly from working servers means creating uncontrolled load on active databases. Analytical queries should refer to an independent, prepared copy of the data to avoid blocking transactions and slowing down current business processes.
Eliminating logic conflicts: Manual Excel spreadsheets and disparate SQL databases always have different formats and structures. Without prior strict standardization in the intermediate database, your consolidated dashboards will inevitably start to produce distorted metrics and discrepancies when trying to merge them.
…
How exactly do you plan to ensure the reliability of metrics and the stability of working servers if PowerBI starts pulling hundreds of thousands of unsynchronized rows directly from all sources at the same time?
Sincerely, Arseniy.
-
1 day16 USD
656 9 0 1 day16 USD
Good day, Maxim!
In general, the task is clear, but for an accurate response regarding deadlines and price, I would like to clarify some questions that arose after analyzing your task.
Please write in private messages – we will discuss the details and your wishes.
-
6 days156 USD
615 3 0 6 days156 USD
Hello.
I can set up data retrieval via API from a cloud database to a separate server and build reports in Power BI based on data from multiple databases and Excel sources.
In such tasks, it is important to first properly organize the synchronization scheme, data structure, and logic for merging sources, and only after that to collect stable reporting in Power BI.
What is included in the work:
API sync to a separate server
preparation and normalization of the data structure
… merging multiple databases and Excel sources
setting up several reports in Power BI
basic update control and logging
Before the final approval of the project, I am ready to create a short proof of concept on a portion of the data or one of the reports to immediately check the correctness of the import scheme, source merging, and the logic of future reporting. We can discuss the details in private messages.
-
2 days22 USD
667 5 0 2 days22 USD
Hello! I am interested in your project. I have extensive experience in:
📊 Data processing: working with databases, structuring and analyzing information, automating the processing of large volumes of data, import/export and validation;
🤖 Automation and emulation of user actions; development of bots of varying complexity;
⚡️ Asynchronous and multithreaded parsing: collecting and processing data with performance optimization;
🔍 OCR and text search: recognition and structuring of information;
🖼 Media processing: working with images and multimedia;
🖥 Software development, desktop applications, system services and utilities;
📱 Mobile development: native and cross-platform applications;
… 🌐 Working with APIs and third-party services: integration, automation, and data exchange;
🗣 Translation and text processing: automation of translation, working with language models and text analytics;
🤖 AI/LLM solutions: integration and use of artificial intelligence, working with language models and automating intelligent processes.
I will complete the work quickly and efficiently. Contact me to discuss the details and deadlines of the project!
-
7 days335 USD
286 1 0 7 days335 USD
Hello!
I have been working in data analytics for over 5 years, with experience in SQL, Python, and BI tools, particularly Power BI. I regularly set up automated data pipelines and create management dashboards for businesses that do the most important thing - help make decisions.
I can assist with data integration through API, setting up automatic uploads to the server, and building reports in Power BI from data from various sources (databases and Excel).
-
1 day22 USD
890 1 0 1 day22 USD
Good day, Maxim.
The key task is to ensure stable data synchronization from a remote storage and combine it with local sources for analytics. The main risk is the fragmentation of formats and delays in obtaining information.
To address this, implement the ETL process: data will be retrieved via REST API and stored in a structured format in PostgreSQL. This will allow PowerBI to quickly query a single source rather than multiple fragmented servers or files.
This approach will simplify dashboard updates and ensure data integrity.
Documentation and source code are included.
…
P.S: Since the reports will be based on data from various sources, consider the possibility of creating a centralized data warehouse. This will simplify the data structure, improve its quality, and provide a single point of access for all reports, enhancing analytics.
-
5 days112 USD
241 5 days112 USD
Hello Maxim,
I have over 4 years of commercial experience in structuring and visualizing information in Power BI, ready to take your order into work after clarifying the details regarding reports and data sources.
-
3 days22 USD
5011 41 4 1 3 days22 USD
Good day!
I have experience in data integration via API from cloud databases to other servers. I professionally set up complex reports in PowerBI, combining data from various databases and Excel. I am ready to implement your project.
Write to me in private messages, and we will discuss the details.
-
7 days446 USD
976 4 0 7 days446 USD
Good day
My name is Dmytro, from King Kong Web
We can set up data retrieval via API from a cloud database to another server and implement stable synchronization. We will connect everything correctly, with error handling and logging, so that the transmission works reliably.
We will also assist with Power BI: we will set up connections to several databases on different servers, add data from Excel, combine them into a single model, and create the necessary reports and dashboards.
We are ready to discuss the details of access and data structure, after which we will provide timelines and costs.
Current freelance projects in the category Databases & SQL
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 19 hours 40 minutes back ∙ 9 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 1 day 6 hours back ∙ 4 proposals |
CRM system for Railway LogisticsCreation of a CRM system for a logistics company mainly focused on rail and road transport, 1) Financial reporting 2) Processing applications 3) Contractors 4) Automatic issuance of invoices and acts upon closure, it is possible to create a simplified system based on 1C below… Databases & SQL, Client Management & CRM ∙ 1 day 18 hours back ∙ 39 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 4 days 13 hours back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
602 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 6 days 17 hours back ∙ 58 proposals |
Ukraine