Clean sales data and build a management dashboard with KPIs and drill-down.
A retail chain wants a one-page view of sales against target by region and store.
The detailed steps, checklists and trainer review open in the SOTT student portal for enrolled students.
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.
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.
About 10 hours of hands-on work, and it fits best after week 5 of the Data Analytics course.
Enrolled students get every task with steps, "done when" checks, the submission form and a trainer review in the SOTT student portal.