API Integrated Power BI Dashboards

Job ID: 39945806

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.