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.
01Week 1 — Questions, Data & Spreadsheets
- Using AI in this course: the rulesFree preview20m
- The analyst's questionFree preview50m
- Field types, provenance & what the data can't tell you45m
- Working in a spreadsheet without breaking it45m
- Formulas, operators & references55m
- Lab: data dictionary & three answerable questionsPractical60m
- Lab: filter, calculate & check referencesPractical75m
- Weekly project: analysis brief & data dictionaryProjectFree preview120m
02Week 2 — Cleaning & Formulas
- Profiling messy data55m
- Cleaning techniques: trim, case, split, convert55m
- Cleaning decisions & the transformation log50m
- Calculations & conditional logic60m
- Lab: clean the dirty orders filePractical90m
- Lab: calculator, category totals & flagsPractical75m
- Weekly project: a checked, cleaned workbookProject180m
03Week 3 — Lookups, Pivots & Charts
- Lookups: XLOOKUP, VLOOKUP, HLOOKUP & friends55m
- Pivot tables & the grain of a result55m
- Charts that tell the truth50m
- Grouping, external data & macros50m
- Lab: lookups & reconciling unmatched keysPractical75m
- Lab: two pivots, two charts, one surprisePractical75m
- Weekly project: summary & interpretationProject180m
- AI formula helpers: using them as a tutor20m
04Week 4 — Excel Project
- Structuring an analysis workbook45m
- Finding a 1,000-row dataset you may use40m
- Checks & reconciliation across sheets45m
- The one-page stakeholder summary40m
- Lab: the region × category × month questPractical60m
- Lab: timed analysis exercise (100–500 rows)Practical90m
- Excel project: a checked workbook for a stakeholderProject300m
05Week 5 — Power BI: Requirements, Import & Power Query
- Reporting requirements: what must the report answer?45m
- Power BI Desktop: views, import & data feeds50m
- Power Query: repeatable transformations60m
- Merge vs append — and counting rows every time50m
- Lab: report brief & data dictionaryPractical60m
- Lab: repeatable Power Query cleaning & quality logPractical90m
- Weekly project: import, transform & quality reportProject180m
06Week 6 — Data Modelling
- Facts, dimensions, grain & the star schema50m
- Relationships & how filters flow55m
- Building a date dimension45m
- Calculated columns vs measures50m
- Lab: draw the entity relationship diagramPractical60m
- Lab: build the model & reconcile countsPractical90m
- Weekly project: model diagram, glossary & checksProject180m
07Week 7 — DAX Measures & Report Design
- DAX measures: sums, counts, averages & ratios55m
- CALCULATE, filter context & misleading totals60m
- Choosing visuals & designing the page45m
- Interactivity, accessibility & performance50m
- Lab: a measure glossary checked by handPractical75m
- Lab: build the dashboard & test it on someonePractical120m
- Weekly project: dashboard draft & user test reportProject180m
- AI-drafted DAX: trust nothing you haven't reconciled20m
08Week 8 — Power BI Project
- Dashboard storytelling: from numbers to a decision45m
- Validation before handoff45m
- Refresh, access & sharing — before you publish45m
- The stakeholder walkthrough35m
- Lab: structured peer usability testPractical75m
- Lab: the handoff packPractical60m
- Power BI project: a checked model & dashboard for a decisionProject300m
09Week 9 — SQL: Databases & Retrieval
- Relational databases: tables, keys & grain45m
- Setting up SQLite & the practice database50m
- SELECT, aliases, DISTINCT, ORDER BY & LIMIT50m
- Filtering with WHERE — and the truth about NULL55m
- Lab: create the practice database & map itPractical60m
- Lab: retrieval & filtering drillsPractical75m
- Weekly project: ten annotated queriesProject150m
10Week 10 — SQL: Aggregation & Joins
- Expressions: arithmetic, CASE, NULL handling, text & dates55m
- Aggregation, GROUP BY & HAVING55m
- Joins: inner, left, right, full & self60m
- Set operations, EXISTS & fan-out55m
- Lab: revenue summaries that reconcilePractical75m
- Lab: joins with row-count reconciliationPractical90m
- Weekly project: a join & aggregation portfolioProject180m
- AI-generated SQL & the fan-out trap20m
11Week 11 — SQL: Subqueries, CTEs & Window Functions
- Subqueries: scalar, table & correlated55m
- Common table expressions & recursive CTEs55m
- Window functions: partitions, ranking & ties60m
- LAG, LEAD, running totals & moving averages60m
- Lab: above-average customers, two waysPractical75m
- Lab: window function drills with hand checksPractical90m
- Weekly project: intermediate SQL portfolioProject180m
12Week 12 — Query Quality & SQL Project
- Query plans, scans & indexes55m
- The N+1 pattern & measuring honestly50m
- Writing up a reproducible SQL analysis40m
- Lab: compare equivalent queriesPractical75m
- Lab: the university schema (extra practice)Practical75m
- SQL project: answer business questions with reproducible SQLProject360m
- Lead stage: defending AI-assisted work15m
Already enrolled? Sign in with your enrollment email to unlock all lessons.