API Integrated Power BI Dashboards
Budget: $250 – $750 USD
I’m looking for a Power BI specialist who can pull data from two main sources—our existing Excel workbooks and several SaaS platforms that expose REST APIs we will specify—then model it in a way that supports three distinct but related dashboards: sales performance, operational efficiency, and financial reporting.
You’ll need to:
• Build and document robust connections to each API and to our Excel files, ensuring automatic refresh works reliably.
• Create a clean data model with the right relationships, calculated columns, and DAX measures so the numbers tie out every time.
• Design visuals that make insights obvious. For sales and trend tracking I already know I’ll want bar charts and line graphs, but I’m open to other visual types where they add clarity.
• Package everything in a single .pbix file (plus a short “how-to-refresh” note) so my team can maintain it after hand-off.
Please base your proposal on similar projects you’ve completed, note any relevant connectors or custom code you plan to use, and include an estimated timeline for the first working draft.
You’ll need to:
• Build and document robust connections to each API and to our Excel files, ensuring automatic refresh works reliably.
• Create a clean data model with the right relationships, calculated columns, and DAX measures so the numbers tie out every time.
• Design visuals that make insights obvious. For sales and trend tracking I already know I’ll want bar charts and line graphs, but I’m open to other visual types where they add clarity.
• Package everything in a single .pbix file (plus a short “how-to-refresh” note) so my team can maintain it after hand-off.
Please base your proposal on similar projects you’ve completed, note any relevant connectors or custom code you plan to use, and include an estimated timeline for the first working draft.
Related categories:
SQL
Data Visualization
Data Integration
Power BI
ETL
Microsoft Azure
API Development
Data Modeling
Data Management
REST API