AI & Data · Decision-ready data

Data Analytics & Dashboarding

Clean data, write useful queries, discover patterns, and communicate decisions through clear dashboards and reports.

10 weeksBeginner friendly5 projects
Course overview

Learn the whole workflow, not isolated tricks.

Learn the full analytics loop: clarify the question, inspect and clean data, query it efficiently, choose honest visualizations, build a usable dashboard, and explain what the evidence supports.

What you will be able to do

Clear outcomes you can demonstrate.

Clean and structure messy datasets with a documented process.

Write SQL queries that answer practical product and business questions.

Choose visualizations that communicate patterns without distortion.

Build and present an interactive decision-focused dashboard.

Curriculum

A focused path from foundation to final build.

05Modules
  1. Analytics thinking

    4 topics

    Questions, metrics, dimensions, data quality, stakeholder context, and avoiding misleading conclusions.

    • Metrics
    • Data quality
    • Questions
    • Context
  2. Spreadsheet analysis

    4 topics

    Cleaning, formulas, lookups, pivot tables, validation, and repeatable analysis workflows.

    • Excel
    • Cleaning
    • Pivots
    • Reporting
  3. SQL for decisions

    4 topics

    Filtering, grouping, joins, subqueries, window concepts, and turning questions into queries.

    • SQL
    • Joins
    • Aggregation
    • Analysis
  4. Python and visualization

    4 topics

    Data frames, exploratory analysis, charts, reusable notebooks, and communicating patterns.

    • Pandas
    • EDA
    • Charts
    • Notebooks
  5. Dashboard capstone

    4 topics

    Model data, design a useful dashboard, validate the experience, and present recommendations.

    • Power BI
    • Dashboard UX
    • Storytelling
    • Presentation
Portfolio projects

Build work worth explaining in an interview.

Project 1

Operational performance report

A cleaned and automated analysis answering a defined set of business questions.

Project 2

SQL insight case study

A query-driven investigation with documented assumptions and concise findings.

Project 3

Interactive dashboard

A polished, decision-focused dashboard supported by a clear presentation narrative.