Build a simple assistant that answers business questions from a sales database, with guardrails and checks.
Managers want to ask questions like "sales by region last month" without waiting for an analyst.
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 18 hours of hands-on work, and it fits best after week 12 of the Data Analytics with AI: Excel, SQL, Power BI & Python course.
Enrolled students get every task with steps, "done when" checks, the submission form and a trainer review in the SOTT student portal.