Power Query Sales Dashboard

Excel workbooks containing sales data that need to be merged using Power Query and presented as an in-workbook dashboard.

Job is to set up the query logic so every time I drop new files into a designated folder the data refreshes automatically, then build a clean, easy-to-read ONE Dashboard page that features both bar and line charts.

Key deliverables
• One Excel file that consolidates all source workbooks/tabs through Power Query
• Dynamic bar and line charts visualising Data, trends and any other insights
• Slicers or filters to let me explore the data by month, product and region
• Clear instructions inside the file—ideally a short “How to refresh / add data” sheet
• Look and feel like a dashboard
• format other 2-3 other tabs in excel

Acceptance criteria
The dashboard must update in a single click with no broken links, the charts must reflect the refreshed data instantly, and the file should remain fully usable in standard desktop Excel (no add-ins).

When you reply, please outline:
1. Your estimated turnaround time from kickoff to delivery REPLY ONLY IF YOU CAN START RIGHT AWAY
2. A fixed price or milestone breakdown covering consolidation, visual design and final tweaks

I’m ready to start as soon as I choose the right freelancer, so let me know your timeline and cost and we can move forward.