Objective:
Test your ability to turn raw data into a simple, actionable dashboard that a non-technical business leader can understand.
Scenario
You are working as a Data Analyst at Worli Dairy.
Your manager has given you the attached dataset containing daily sales information for the past 3 months.
Dataset Fields
mock_sales_dataset.xlsx
Your Task
Using any tool you prefer (Excel, Google Sheets, Power BI, Tableau, Google Data Studio, etc.):
- Create a single-page dashboard that shows:
- Total Sales & Orders trend over time
- Sales by Product Type
- Top 3 Regions by Sales
- Make sure the dashboard is:
- Visually clear (easy to understand at a glance)
- Business-friendly (avoids technical jargon)
- Highlights at least 1 insight you found
Deliverables
- The dashboard file or a shareable link (if using an online tool)
- A short note (max 5 sentences) explaining your key findings
Evaluation Criteria
- Clarity and simplicity of visualizations
- Accuracy of metrics
- Ability to communicate insights effectively
- Presentation quality