Multi-Source Power BI Dashboard
Budget: ₹750 – ₹1,250 INR
I need a solid Power BI build that pulls together three separate data sources—our live MySQL database, several Excel workbooks, and a handful of CSV files—into one clean, refreshable tabular model. Once the data is shaped and related properly, the goal is to surface the key metrics in interactive bar and pie charts that tell the story at a glance.
You’ll connect through Power Query (ODBC for MySQL), normalise the tables, create any necessary DAX measures, and lay out the initial report pages in the company colour palette. All work must live inside a single PBIX file that refreshes without errors and matches the control totals I supply.
Deliverables
• PBIX file with automated connections to MySQL, Excel, and CSV data
• Star-schema/tabular model with documented relationships and calculations
• Report pages featuring bar and pie charts (heatmaps may be added later)
• Short setup guide so I can deploy and refresh on my end
Acceptance criteria: refresh completes in Power BI Desktop without manual intervention, totals reconcile against the benchmark spreadsheet, and each visual loads in under five seconds on a standard laptop.
You’ll connect through Power Query (ODBC for MySQL), normalise the tables, create any necessary DAX measures, and lay out the initial report pages in the company colour palette. All work must live inside a single PBIX file that refreshes without errors and matches the control totals I supply.
Deliverables
• PBIX file with automated connections to MySQL, Excel, and CSV data
• Star-schema/tabular model with documented relationships and calculations
• Report pages featuring bar and pie charts (heatmaps may be added later)
• Short setup guide so I can deploy and refresh on my end
Acceptance criteria: refresh completes in Power BI Desktop without manual intervention, totals reconcile against the benchmark spreadsheet, and each visual loads in under five seconds on a standard laptop.