AdvancedData Analytics with AI: Excel, SQL, Power BI & Python project · about 18 hours

Natural-language analytics assistant

Build a simple assistant that answers business questions from a sales database, with guardrails and checks.

The real-world brief

Managers want to ask questions like "sales by region last month" without waiting for an analyst.

What you will build

  • A question-to-SQL assistant over a read-only database
  • Guardrails (read-only, allowed tables, row limits)
  • A test set of 20 questions with expected answers
  • A simple web app with charts

Skills you will practise

Text-to-SQLGuardrailsEvaluationData storytelling

Tools

PythonSQLAn LLM API (OpenAI, Claude or Gemini)Streamlitpandas

Project tasks

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

1Data and access Steps in portal
2Text to SQL Steps in portal
3Guardrails Steps in portal
4Evaluate Steps in portal
5App and report 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 Natural-language analytics assistant 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 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.

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.