Excel Sales Dashboard with KPI Tracking
Budget: $10 – $30 USD
I need an expert in Excel to create an interactive sales dashboard for me.
Key Tasks:
- Gather and clean dummy sales data representing the car parts industry over the last 3 years. The data should be sourced from platforms like ChatGPT, Kaggle, or Mockaroo and should be coherent and sensible.
- Develop an Excel dashboard that tracks at least 10 key sales KPIs (such as Revenue, Growth, Average Order Value, Retention, etc.) with clear visualization and user-friendly navigation.
- Implement interactive elements like charts, tables, dropdowns, filters, and slicers to enhance the dashboard's interactivity.
Deliverables:
- A functional Excel dashboard with KPI tracking.
- A clean sales dataset.
- A user guide for usage and maintenance.
- Well-documented formulas and calculations for transparency.
Ideal Candidate:
- An Excel expert with strong experience in sales data analysis and KPI reporting.
- A professional who can create clear and visually appealing dashboards.
Please note: Further information regarding specific KPIs and other details will be provided upon confirmation of the project.
Key Tasks:
- Gather and clean dummy sales data representing the car parts industry over the last 3 years. The data should be sourced from platforms like ChatGPT, Kaggle, or Mockaroo and should be coherent and sensible.
- Develop an Excel dashboard that tracks at least 10 key sales KPIs (such as Revenue, Growth, Average Order Value, Retention, etc.) with clear visualization and user-friendly navigation.
- Implement interactive elements like charts, tables, dropdowns, filters, and slicers to enhance the dashboard's interactivity.
Deliverables:
- A functional Excel dashboard with KPI tracking.
- A clean sales dataset.
- A user guide for usage and maintenance.
- Well-documented formulas and calculations for transparency.
Ideal Candidate:
- An Excel expert with strong experience in sales data analysis and KPI reporting.
- A professional who can create clear and visually appealing dashboards.
Please note: Further information regarding specific KPIs and other details will be provided upon confirmation of the project.