Power Platform developer (Power BI + Power Automate + SharePoint)
Looking for an experienced IT specialist to develop a data integration and automation system based on Microsoft Power Platform.
The goal is to create a centralized solution for collecting, merging, and visualizing data from multiple sources.
Tasks:
- Create a master Excel file in SharePoint (single data source)
- Merge data from:
- ERP system (SAP or similar)
- Microsoft Forms (user data input)
- External data (employees outside the system)
- Use Power Query for:
- data cleansing
- transformation
- merging
- Set up Power Automate:
- sending forms to employees
- reminders to those who haven't responded
- automatic data updates
- Organize data collection for users without corporate access:
- via link or QR code
- Connect data to Power BI:
- create dashboards
- filters (projects / business areas / risks)
- data completeness control (compliance)
Deliverables:
- Working automated system
- Clean and structured dataset
- Dashboard in Power BI
- Brief documentation
Requirements:
- Experience with Power BI, Power Automate, Power Query
- SharePoint, Excel (advanced level)
- Experience in data integration
Preferred:
- Experience with SAP
- Experience in oil and gas / operational projects
Important:
Please attach examples of similar projects (dashboards, automation, integrations).
-
1 day850 USD1 day850 USD
Alibek, I see the task as a single data flow: SharePoint source, cleaning and merging through Power Query, automation of mailings and reminders in Power Automate, then clear dashboards in Power BI with data completeness control. I have 7 years in IT and experience in integrating disparate systems into workflows. I can build the architecture, set up updates, and provide brief documentation. I will send examples of similar solutions and we can discuss the details.
-
30 days4000 USD
858 2 0 30 days4000 USDGood afternoon, I have over 8 years of experience in Power BI, Power Automate, Power Query, SharePoint, and Excel. I would be happy to work on your project; I can send my resume if needed.
-
14 days1200 USD
286 1 0 14 days1200 USDHello!
I have over 6 years of experience in analytics and BI. I specialize in building centralized reporting systems, automating processes, integrating data, and creating BI solutions for businesses.
I work with Power BI, Power Query, Excel/SharePoint, SQL, and Power Automate. Your request fully aligns with the tasks I handle in practice - from building a single source of data to automating information collection and creating dashboards.
I am ready to help implement a solution tailored to your business needs and discuss the project details.
Feel free to reach out!
-
30 days350 USD
2259 5 1 30 days350 USDHello! I have reviewed your task and believe that I can successfully complete it. I would be happy to collaborate, please write to me personally for further details.
-
10 days999 USD
1872 9 0 10 days999 USDHello.
Regarding the architecture, everything is clear; I will go through the areas where such projects usually struggle.
Where to have master data. Excel in SharePoint with large volumes and multi-user access becomes a bottleneck (lock conflicts, row limits, slow refresh). I recommend using SharePoint List or Dataverse as the primary source, with Excel as a slice for users who find it more convenient. The solution at the start and migration later is worth the time.
SAP integration. The riskiest part. It depends on the version of SAP, the presence of Gateway, the rights of the service account, and the policy on premium connectors. Often, it is not about the technology but about agreements with the SAP team and the security department. We need to understand who the stakeholders are from the SAP side.
Compliance control. DAX measures (% fill of mandatory fields) are standard. Real value comes when we add a data quality dashboard: where there are gaps, who is not responding, which sources provide dirty data. This transforms the system from a reporting one to a management one.
External users. Anonymous Forms are limited in field types and validation. An alternative is Power Pages with a custom form and QR code, offering more control and branding. This is resolved based on the number of users.
How we propose to work. First, Discovery: auditing sources, talking to SAP and SharePoint owners, an architectural document with a risk assessment. This pays off by not rolling out a solution that breaks corporate policies. Then full implementation with milestone demos along the way. In the end, documentation and handover.
We can do a demo. We will take one clear segment (for example, Microsoft Forms with recording in SharePoint List and a basic Power BI dashboard on top), and build end-to-end on test data. We will show the approach to work and quality before the main contract. No upfront payment.
Standards we work by. All Power Automate flows are documented. Power Query M code is stored in version control. Dashboards are exported as .pbit templates for reproducibility. When we leave, your team continues without us.
… We will send relevant projects on integrations and Power BI in private. Team website with product works: quentar.space/en/startups.
A few questions before the assessment.
What version of SAP and who is responsible for integrations on its side?
How many employees will enter data through Forms?
What Microsoft licenses do you have (Pro, Premium, E5)?
Who is the administrator of the Power Platform tenant and SharePoint?
I would be happy to clarify in private.
-
1 day850 USD
265 1 day850 USDGood day! We are the Devoxen team, specializing in the development and automation of business processes, including solutions on the Microsoft Power Platform. We have reviewed your project. We understand the specifics of working with Power Apps, Power Automate, and integrations within the Microsoft ecosystem. What we can offer: - Development and enhancement of solutions on the Power Platform - Automation of business processes through Power Automate - Creation of interfaces and internal applications on Power Apps - Integrations with Microsoft 365, Excel, SharePoint, APIs, and external services - Optimization of existing processes and logic We have experience in: - Automating internal processes - Integrations and backend logic - Building systems for business tasks We understand that in such projects, it is important not only to implement functionality but also to make the system convenient for further support and scaling. After launch, we provide a warranty period for fixing possible bugs and stabilizing operations. We are ready to discuss the project details, current architecture, and tasks to provide an accurate estimate of timelines and stages. If our approach resonates with you, we would be happy to communicate and move forward.
-
114 days2000 USD
396 114 days2000 USDHello!
My name is Aleksey, and I represent the NC-1 development group.
We have extensive experience in building centralized data ecosystems and automated workflows. I would like to propose our Senior Backend & Data Solutions Developer for your project. He specializes in transforming fragmented data into structured, actionable insights—exactly what your SharePoint/Power BI architecture requires.
Why he is a strong fit for this role:
Advanced ETL & Data Transformation: With a mastery of Python (Pandas, NumPy), he brings a high-level engineering approach to Power Query. He excels at data cleansing, merging complex datasets from ERP systems, and ensuring "single source of truth" integrity in SharePoint master files.
… Workflow Automation Expert: He has a proven track record in Workflow Optimization and business process automation. Setting up sophisticated Power Automate logic—including triggered reminders, data refresh cycles, and multi-channel distribution—is a core part of his expertise.
System Integration (ERP & External Data): He is highly skilled in API development and integrating third-party data. Whether it’s extracting data from SAP or managing public access forms via QR codes, he ensures secure and seamless data flow.
Data Visualization (Power BI): Beyond the backend, he focuses on E-commerce Analytics. He designs functional Power BI dashboards that focus on high-level KPIs, risk filtering, and compliance monitoring.
Technical Expertise:
Tools: Power BI, Power Automate, Power Query, SharePoint, Advanced Excel.
Data Engineering: Python (Pandas/NumPy), SQL, RESTful APIs.
Automation: Workflow logic, automated reporting, and data validation (Compliance).
Deliverables we guarantee:
Robust Data Architecture: A clean, automated SharePoint-based master file.
Full-Cycle Automation: Seamless data collection from internal (ERP/Forms) and external users.
Executive Dashboards: High-fidelity Power BI reports with intuitive filtering for projects and risks.
Documentation: Clear technical guides for future system maintenance.
We are ready to demonstrate examples of our automation and data visualization projects. We can ensure your system is not just "working," but optimized for scale and accuracy.
Looking forward to discussing your project requirements in detail!
Best regards,
Aleksey
NC-1 Team
-
14 days2000 USD
4467 102 0 14 days2000 USDGood day. I have the necessary experience and skills. I would be happy to assist with the implementation of this project.
-
10 days800 USD
976 4 0 10 days800 USDHello
My name is Dmitry.
I have reviewed the task — I can help build a centralized system for data collection, processing, and visualization based on Microsoft Power Platform.
I have experience with data integration, process automation, Power BI dashboards, and creating a unified data flow between multiple sources.
What I can implement:
— master file and data structure in SharePoint / Excel
— data consolidation from ERP, Forms, and external sources
— Power Query pipelines (cleaning, transformation, merge)
— automation through Power Automate
… — mailings, reminders, data updates
— data collection through public forms / QR codes
— Power BI dashboards with filters, KPIs, and data completeness control.
I also pay attention to:
— data structure and scalability
— update speed
— dataset cleanliness
— ease of support after project handover.
I understand the importance of compliance and correct data consolidation from different sources, especially when some users are outside the corporate system.
Experience with SAP will be a plus — I will be able to quickly connect to the existing integration process.
I can provide a more accurate timeline and cost after discussing the current data structure and the scope of automation.
I am ready to quickly engage in the project 👍
-
1 day60 USD
2292 38 2 1 day60 USDGood day. You are offering a very interesting project.
I have experience with Microsoft systems, such as process automation in Power Automate, building reports in Power BI/Power Query for any reporting, and controlling information storage in SharePoint.
Currently, I have a project that is also being conducted in the Microsoft environment, so there will be minimal issues during development.
I suggest we connect privately to discuss in more detail and start working. Thank you.
-
30 days900 USD
404 2 0 30 days900 USDHello! I am interested in your offer: "a centralized solution for collecting, merging, and visualizing data from multiple sources." I have over 15 years of experience in web application development.
Current freelance projects in the category Databases & SQL
Accounting, planning, and sales system for a mushroom farm
607 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 ∙ 14 hours 1 minute back ∙ 44 proposals |
External report 1C 8.3 — forecast of goods balances
22 USD
An external report (.erf) is needed for 1C:Enterprise 8.3 (configuration to be specified). What it should do: Extract product balances from the database Analyze sales history for the last 30 days Calculate the average sales rate for each product Determine how many days until the… Databases & SQL, Client Management & CRM ∙ 14 hours 36 minutes back ∙ 10 proposals |
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (PenetrProject Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 1 day 3 hours back ∙ 9 proposals |
Database synchronizationSynchronization of Microsoft Access programs and CRM SalesDrive. Data transfer from CRM to Microsoft Access in the first stage (changing the funnel status). Data transfer from Microsoft Access to CRM in the second stage (changing the status in the program). Databases & SQL ∙ 1 day 8 hours back ∙ 10 proposals |
Setting up a backup system and optimizing server infrastructureObjective of the work: Ensure reliable data storage for the CRM system and application by implementing an automated backup system, as well as carry out a series of server improvements to enhance the stability, security, and performance of the infrastructure. DevOps, Databases & SQL ∙ 2 days 7 hours back ∙ 23 proposals |