Dynamic Excel Sales Dashboard Build
Budget: $250 – $750 USD
I will hand over a raw sales dataset that needs light cleaning and structuring before any visuals are built. Once the data is tidied up, I need a fully interactive dashboard inside the same workbook that lets me drill into monthly trends with slicers and filters.
The key insights I want to surface are:
• Which products are the top-sellers each month
• How different customer segments are performing over time
Bar charts should carry the main story, but feel free to blend in other Excel visuals where they genuinely add clarity. The layout has to feel intuitive for non-technical users, with everything updating automatically when new rows are appended.
Deliverables
- A single, unlocked .xlsx file containing
• cleaned/structured data (Power Query or well-documented formulas are fine)
• a dashboard sheet with interactive slicers, bar charts and any supporting visuals
- Brief, in-file notes that show me how to refresh or extend the data without breaking the model
If something is unclear in the dataset, flag it early so we can adjust before you finalise the visuals.
The key insights I want to surface are:
• Which products are the top-sellers each month
• How different customer segments are performing over time
Bar charts should carry the main story, but feel free to blend in other Excel visuals where they genuinely add clarity. The layout has to feel intuitive for non-technical users, with everything updating automatically when new rows are appended.
Deliverables
- A single, unlocked .xlsx file containing
• cleaned/structured data (Power Query or well-documented formulas are fine)
• a dashboard sheet with interactive slicers, bar charts and any supporting visuals
- Brief, in-file notes that show me how to refresh or extend the data without breaking the model
If something is unclear in the dataset, flag it early so we can adjust before you finalise the visuals.
Related categories:
PHP
Visual Basic
Data Processing
Excel
Word
Excel VBA
Data Visualization
Data Analysis
Data Management
Micropython