IntermediateData Analytics with AI: Excel, SQL, Power BI & Python project · about 10 hours

AI-assisted Excel and Power BI sales report

Use Copilot and AI features to clean data, write formulas and build a sales report faster.

The real-world brief

A retail team wants its weekly report done in an hour instead of a day, without losing accuracy.

What you will build

  • A cleaned dataset using AI-suggested steps
  • Measures written with AI help and checked
  • A sales dashboard
  • A log of prompts and corrections

Skills you will practise

Prompting for analysisData cleaningDAXChecking AI output

Tools

ExcelPower QueryPower BICopilot or ChatGPT

Project tasks

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

1Clean with help Steps in portal
2Formulas Steps in portal
3Dashboard Steps in portal
4Prompt log Steps in portal

How companies use Data Analytics with AI: Excel, SQL, Power BI & Python

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 AI-assisted Excel and Power BI sales report 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 with AI: Excel, SQL, Power BI & Python 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.