IntermediateData Analytics project · about 10 hours

Sales performance dashboard in Excel and Power BI

Clean sales data and build a management dashboard with KPIs and drill-down.

The real-world brief

A retail chain wants a one-page view of sales against target by region and store.

What you will build

  • A cleaned dataset with Power Query
  • A data model with a date table
  • DAX measures for sales, target and growth
  • A one-page dashboard with drill-down

Skills you will practise

Data cleaningKPIsData modellingDashboard design

Tools

ExcelPower QueryPower BIDAX

Project tasks

The detailed steps, checklists and trainer review open in the SOTT student portal for enrolled students.

1Clean Steps in portal
2Model Steps in portal
3Measures Steps in portal
4Dashboard Steps in portal

How companies use Data Analytics

Retail: Which stores need attention. Managers got 40-page reports and could not see which stores were falling behind. A one-page Power BI dashboard with targets, trends and drill-down by region and store. Area managers act on problems in the weekly meeting instead of after month end.

Healthcare: Reducing missed appointments. A clinic chain lost revenue from patients who missed appointments. Analysis of booking data found patterns by day, lead time and reminder type. Changing reminder timing reduced missed appointments.

E-commerce: Understanding customer churn. Marketing could not tell which customers were about to leave. Cohort and RFM analysis in SQL and Python, with a churn-risk segment in the CRM. Targeted offers kept more at-risk customers.

Questions

Can I add the Sales performance dashboard in Excel and Power BI project to my resume?

Yes. Once your trainer approves it, list it under Projects with the tools you used, one line on the problem it solves and a link to your repository and demo video.

How long does this project take?

About 10 hours of hands-on work, and it fits best after week 5 of the Data Analytics course.

Where do I get the step-by-step tasks?

Enrolled students get every task with steps, "done when" checks, the submission form and a trainer review in the SOTT student portal.