Data Analytics · Guided project
Sales Performance Dashboard with Insights — Guided Project
Clean a real sales dataset, analyse it with pivot tables or SQL, and build a one-page dashboard with KPIs, trends and three written recommendations.
- Beginner
- ~6 hours
- 5 steps
The brief
Use a public retail or e-commerce sales dataset. Clean it, answer five business questions, and build a dashboard in Power BI, Tableau or Looker Studio for a sales manager. Finish with a one-page summary: three findings and what the business should do about each. This is the most common analyst take-home task — do it well and you have your interview story.
What you will submit: the cleaned data (or cleaning script), the dashboard link or screenshots and a one-page insight summary.
Skills you will use: Data cleaning · Pivot tables / SQL · Dashboard design · Storytelling
Build it
Step by step
Tick each step as you finish it. 0 of 5 done.
-
Step 1Write the questions
List five questions a sales manager would ask: top categories, monthly trend, best and worst regions, average order value, return rate.
-
Step 2Clean the data
Run the eight-point cleaning checklist and write a short data-quality note of what you changed.
-
Step 3Analyse
Answer each question with a pivot table, SQL query or pandas, and record the numbers.
-
Step 4Build the dashboard
KPI cards on top, trend and breakdown charts in the middle, filters for date and region, titles that state findings.
-
Step 5Write the summary
Three findings, each with evidence and a specific recommendation with expected impact.
Self-review before you call it done
Tick each point once your project really meets it. These are the things an interviewer will look for.
Check all 4 points, then mark the project as finished.
Next