Data Analyst with AI

By the end

What you'll build

• Clean and transform data
• Query databases using SQL
• Analyze data using Python
• Build interactive dashboards in Power BI
• Use Generative AI responsibly
• Generate business insights
• Present findings effectively
• Build a portfolio of real-world projects

Curriculum

What's inside

8 modules · 230 lessons

1. 01

   Excel for Data Analysis

   35 lessons
   • Module Orientation: Why Spreadsheets Run the World
   • Spreadsheet Foundations: Cells, References, and Formulas
   • Practice: Quarterly Sales Setup — SUM Across Rowsspreadsheet lab
   • Practice: Daily Takings — SUM a Single Rowspreadsheet lab
   • Practice: Counter Totals — SUM Down a Columnspreadsheet lab
   • + 30 more lessons
2. 02

   SQL for Data Analysis

   42 lessons
   • Module Orientation: The Language Every Database Understands
   • SELECT and Filtering: The Lingua Franca of Data
   • SELECT & WHERE — Filtering Rowssql lab
   • Practice: Filter by Citysql lab
   • Practice: Combine Two Conditionssql lab
   • + 37 more lessons
3. 03

   Python for Data Analytics

   34 lessons
   • Module Orientation: From Clicking Cells to Commanding Data
   • Python and pandas Fundamentals: Your Spreadsheet in Code
   • Your First Variablespython lab
   • Lists and Loopspython lab
   • Dictionaries: Build and Look Uppython lab
   • + 29 more lessons
4. 04

   Statistics & Analytics for Decision-Making

   27 lessons
   • Module Orientation: Why Analysts Live and Die by Statistics
   • Descriptive Statistics: Summarising Data
   • Practice: Mean vs Median — Don't Get Fooledpython lab
   • Practice: Measuring Spread (Range & Std Dev)python lab
   • ★ Practical Quiz: Outlier Hunt with the IQR Rulepython lab
   • + 22 more lessons
5. 05

   Power BI

   33 lessons
   • Module Orientation: Turning Numbers Into Decisions People Can See
   • Data Visualization Principles: Choosing the Right Chart
   • Explore the Data — Sort & Read the Statsdataset explorer
   • Build a Bar Chart — Revenue by Regionchart lab
   • Choose the Right Chart — Part-to-Whole (Pie)chart lab
   • + 28 more lessons
6. 06

   Generative AI for Data Analysts

   27 lessons
   • Module Orientation: Your New Analytical Co-Pilot
   • How Large Language Models Work (for Analysts)
   • Prompt Engineering Fundamentals: Writing Prompts That Get Results
   • Zero-Shot Prompting — One Clear Instructionprompt lab
   • Few-Shot Prompting — Steer With Examplesprompt lab
   • + 22 more lessons
7. 07

   Final Capstone: Executive Business Intelligence Platform

   7 lessons
   • Capstone Brief: Your First Board Deck
   • Step 1 — Data Cleaning & Prepspreadsheet lab
   • Step 2 — SQL Analytical Queriessql lab
   • Step 3 — Python Trend Analysispython lab
   • Step 4 — Executive Dashboardchart lab
   • + 2 more lessons
8. 08

   Career Launchpad: Land Your Data Analyst Role

   25 lessons
   • Module Orientation: From Learner to Hired Analyst
   • The Analyst Workflow & Mindset
   • Check: The Analyst Workflow & Mindsetquiz
   • Build a Portfolio That Gets Interviews
   • Draft a case-study README for your capstone projectprompt lab
   • + 20 more lessons

The shape of it

How this course works