Executive Sales Dashboard in Power BI

I keep all live sales transactions in a SQL Server database and receive additional monthly CSV extracts for legacy channels. I need the whole dataset blended, modelled, and surfaced in Power BI as a single, lightning-fast dashboard my exec team can open and immediately understand.

Scope of work
• Connect directly to the SQL database and configure an automated import for the monthly CSVs.
• Build an efficient star-schema model in Power Query and DAX so refreshes remain snappy.
• Create intuitive Bar Charts, Line Graphs, and Pie Charts that highlight the three critical metrics we track: Total Sales, Sales by Region, and Top Products.
• Publish the report to the Power BI Service and set up a reliable weekly scheduled refresh (no manual steps).
• Optimise visuals and measures for desktop, web, and mobile viewing.

Deliverables
1. The fully documented .pbix file with clean queries, labelled tables, and reusable DAX measures.
2. A live workspace link demonstrating the finished dashboard with data refreshed on the weekly cadence.
3. A short hand-off guide outlining data-source credentials, refresh settings, and any gateway requirements.

Acceptance criteria
• Dashboard loads in under five seconds on first page.
• All three metrics update correctly after a test CSV is added and the scheduled refresh runs.
• Visuals render without errors on both desktop and mobile layouts.

If you have deep Power BI, DAX, and SQL skills and can meet these benchmarks, let’s get started right away.