Data Analysis: Zero to Job-Ready

What you'll be able to do

• Clean and organise any messy dataset
• Write SQL queries that answer business questions
• Build a Power BI dashboard a manager understands in a minute
• Use Python for core analysis
• Tell a story with numbers and make recommendations
• Finish with two real portfolio projects

Curriculum

1. 1 Excel for analysts

   • Data cleaning and key formulas
   • Pivot tables and charts
   • Power Query
2. 2 SQL

   • Queries, filters and aggregation
   • Joining tables
   • Real business questions
3. 3 Power BI

   • Data modelling
   • Core DAX
   • Dashboard design
4. 4 Python for analysis

   • pandas for tables
   • Charts
   • Exploratory analysis
5. 5 AI-assisted analysis

   • Writing formulas and queries with AI
   • Checking results and catching errors
   • Summarising findings for management
6. 6 Capstone project

   • Real data from start to finish
   • Dashboard and recommendations
   • Presentation and review

Tools you'll use

• Excel
• SQL
• Power BI
• Python
• ChatGPT

This course is for you if you are

• Business, engineering or CS graduates moving into data
• Employees buried in spreadsheets who want to work smarter
• Accountants and marketers who want to understand their numbers
• Anyone who likes numbers and wants an in-demand job