Skip to content
Digital & BusinessBeginnerAges 16+

Data Analysis & Visualization

Turn raw data into decisions — Excel to Python, charts to dashboards, and the storytelling skills analysts actually use.

What you will learn

  • Clean and prepare messy real-world datasets
  • Analyse data with Excel, SQL and Python/pandas
  • Design clear, honest visualisations and dashboards
  • Present findings that drive decisions

Course syllabus

  1. 1Thinking with Data

    • Types of data
    • Questions before charts
    • Analysis workflow
  2. 2Excel Analytics

    • Formulas & lookups
    • Pivot tables
    • Charts that communicate
  3. 3SQL for Analysts

    • SELECT to JOIN
    • Aggregations
    • Querying real databases
  4. 4Python & Pandas

    • DataFrames basics
    • Cleaning & transformation
    • Grouping & summary statistics
  5. 5Dashboards & Storytelling

    • Visual design principles
    • Building interactive dashboards
    • Executive presentation project