← All courses

Course · 12 modules · 88 lessons

Data Analytics I: Excel, Power BI & SQL

A 12-week hands-on course that turns raw business data into checked, defensible answers. You start with the analyst's real job — pinning down the stakeholder, the decision, and the question — then work in Excel or Google Sheets: cleaning messy data with a transformation log, writing formulas and lookups, and building pivot tables and honest charts. Next you move to Power BI: importing and transforming data in Power Query, designing a star-schema model, writing DAX measures, and building a dashboard a manager can actually use. You finish with SQL: querying a relational database, joining and aggregating at the right grain, subqueries, CTEs, window functions, and reading query plans. Every week uses the same small practice dataset you can check by hand, and you ship three graded projects — an Excel workbook, a Power BI report, and a SQL query portfolio — each with checks and a one-page stakeholder summary. No prior experience required; expect 8–12 hours per week. This is Course 1 of the Orglobal Data Analytics track, followed by Python for Data Analytics and Machine Learning & AI Engineering.

You can preview 3 lessons free.

Enroll for full access to every lesson, practical and instructor review.

Enroll for full access

01Week 1 — Questions, Data & Spreadsheets

  1. Using AI in this course: the rules
    Free preview20m
  2. The analyst's question
    Free preview50m
  3. Field types, provenance & what the data can't tell you
    45m
  4. Working in a spreadsheet without breaking it
    45m
  5. Formulas, operators & references
    55m
  6. Lab: data dictionary & three answerable questions
    Practical60m
  7. Lab: filter, calculate & check references
    Practical75m
  8. Weekly project: analysis brief & data dictionary
    ProjectFree preview120m

02Week 2 — Cleaning & Formulas

  1. Profiling messy data
    55m
  2. Cleaning techniques: trim, case, split, convert
    55m
  3. Cleaning decisions & the transformation log
    50m
  4. Calculations & conditional logic
    60m
  5. Lab: clean the dirty orders file
    Practical90m
  6. Lab: calculator, category totals & flags
    Practical75m
  7. Weekly project: a checked, cleaned workbook
    Project180m

03Week 3 — Lookups, Pivots & Charts

  1. Lookups: XLOOKUP, VLOOKUP, HLOOKUP & friends
    55m
  2. Pivot tables & the grain of a result
    55m
  3. Charts that tell the truth
    50m
  4. Grouping, external data & macros
    50m
  5. Lab: lookups & reconciling unmatched keys
    Practical75m
  6. Lab: two pivots, two charts, one surprise
    Practical75m
  7. Weekly project: summary & interpretation
    Project180m
  8. AI formula helpers: using them as a tutor
    20m

04Week 4 — Excel Project

  1. Structuring an analysis workbook
    45m
  2. Finding a 1,000-row dataset you may use
    40m
  3. Checks & reconciliation across sheets
    45m
  4. The one-page stakeholder summary
    40m
  5. Lab: the region × category × month quest
    Practical60m
  6. Lab: timed analysis exercise (100–500 rows)
    Practical90m
  7. Excel project: a checked workbook for a stakeholder
    Project300m

05Week 5 — Power BI: Requirements, Import & Power Query

  1. Reporting requirements: what must the report answer?
    45m
  2. Power BI Desktop: views, import & data feeds
    50m
  3. Power Query: repeatable transformations
    60m
  4. Merge vs append — and counting rows every time
    50m
  5. Lab: report brief & data dictionary
    Practical60m
  6. Lab: repeatable Power Query cleaning & quality log
    Practical90m
  7. Weekly project: import, transform & quality report
    Project180m

06Week 6 — Data Modelling

  1. Facts, dimensions, grain & the star schema
    50m
  2. Relationships & how filters flow
    55m
  3. Building a date dimension
    45m
  4. Calculated columns vs measures
    50m
  5. Lab: draw the entity relationship diagram
    Practical60m
  6. Lab: build the model & reconcile counts
    Practical90m
  7. Weekly project: model diagram, glossary & checks
    Project180m

07Week 7 — DAX Measures & Report Design

  1. DAX measures: sums, counts, averages & ratios
    55m
  2. CALCULATE, filter context & misleading totals
    60m
  3. Choosing visuals & designing the page
    45m
  4. Interactivity, accessibility & performance
    50m
  5. Lab: a measure glossary checked by hand
    Practical75m
  6. Lab: build the dashboard & test it on someone
    Practical120m
  7. Weekly project: dashboard draft & user test report
    Project180m
  8. AI-drafted DAX: trust nothing you haven't reconciled
    20m

08Week 8 — Power BI Project

  1. Dashboard storytelling: from numbers to a decision
    45m
  2. Validation before handoff
    45m
  3. Refresh, access & sharing — before you publish
    45m
  4. The stakeholder walkthrough
    35m
  5. Lab: structured peer usability test
    Practical75m
  6. Lab: the handoff pack
    Practical60m
  7. Power BI project: a checked model & dashboard for a decision
    Project300m

09Week 9 — SQL: Databases & Retrieval

  1. Relational databases: tables, keys & grain
    45m
  2. Setting up SQLite & the practice database
    50m
  3. SELECT, aliases, DISTINCT, ORDER BY & LIMIT
    50m
  4. Filtering with WHERE — and the truth about NULL
    55m
  5. Lab: create the practice database & map it
    Practical60m
  6. Lab: retrieval & filtering drills
    Practical75m
  7. Weekly project: ten annotated queries
    Project150m

10Week 10 — SQL: Aggregation & Joins

  1. Expressions: arithmetic, CASE, NULL handling, text & dates
    55m
  2. Aggregation, GROUP BY & HAVING
    55m
  3. Joins: inner, left, right, full & self
    60m
  4. Set operations, EXISTS & fan-out
    55m
  5. Lab: revenue summaries that reconcile
    Practical75m
  6. Lab: joins with row-count reconciliation
    Practical90m
  7. Weekly project: a join & aggregation portfolio
    Project180m
  8. AI-generated SQL & the fan-out trap
    20m

11Week 11 — SQL: Subqueries, CTEs & Window Functions

  1. Subqueries: scalar, table & correlated
    55m
  2. Common table expressions & recursive CTEs
    55m
  3. Window functions: partitions, ranking & ties
    60m
  4. LAG, LEAD, running totals & moving averages
    60m
  5. Lab: above-average customers, two ways
    Practical75m
  6. Lab: window function drills with hand checks
    Practical90m
  7. Weekly project: intermediate SQL portfolio
    Project180m

12Week 12 — Query Quality & SQL Project

  1. Query plans, scans & indexes
    55m
  2. The N+1 pattern & measuring honestly
    50m
  3. Writing up a reproducible SQL analysis
    40m
  4. Lab: compare equivalent queries
    Practical75m
  5. Lab: the university schema (extra practice)
    Practical75m
  6. SQL project: answer business questions with reproducible SQL
    Project360m
  7. Lead stage: defending AI-assisted work
    15m

Already enrolled? Sign in with your enrollment email to unlock all lessons.