Downloads
Learn

Learning paths

Not sure where to start? Pick the path closest to your job and follow the steps in order.

SQL from zero

About 3 hoursAnyone new to databases

You will be able to: Write SELECT, WHERE, JOIN and GROUP BY queries with confidence.

  1. Run your first queryNinety seconds, no sign-up.
  2. How databases workTables, rows, keys and relationships.
  3. Learn SQL step by stepSELECT through joins, with a runnable example each.
  4. Copy and adapt sample queriesA cookbook of working queries.
  5. Summarize with aggregatesSUM, COUNT, AVG and GROUP BY.
  6. Practice in the editorWrite your own queries against any database.
  7. Keep the cheat sheet handyOne page of syntax.

Excel analyst

About 4 hoursFinance and accounting professionals who live in Excel

You will be able to: Pull live data into Excel, shape it with Power Query and summarize it with PivotTables and Power Pivot.

  1. Connect Excel to the databasesNative SQL Server or ODBC, with Power Query.
  2. Download a practice workbookClassic Models sales lines, with questions and an answer key.
  3. Clean messy dataThe Northwind cleanup workbook has planted problems to fix.
  4. Learn Power PivotThe Data Model, relationships and measures.
  5. Model a databaseA star-schema recipe for Contoso and Classic Models.
  6. Write your first measuresSUM, DIVIDE, and the idea of filter context.

Power BI and DAX

About 8 hoursAnalysts who want to build interactive reports

You will be able to: Build a model, write time-intelligence and percent-of-total measures, and design a report with drillthrough and security.

  1. Get started in Power BI DesktopConnect, model, and build visuals.
  2. DAX fundamentalsMeasures, row context and filter context.
  3. CALCULATE and filtersThe key function, in depth.
  4. RelationshipsStar schemas and RELATED.
  5. Time intelligenceYear to date, prior year, rolling 12 months.
  6. Open a finished projectNine Power BI projects to dissect.
  7. Pattern cookbookRank, Pareto, cohorts, budget variance, calculation groups.
  8. When something is wrongErrors, wrong totals and slow reports.

Accounting data

About 5 hoursAccountants working with QuickBooks or Sage data

You will be able to: Analyze receivables, payables and the ledger from accounting-system tables.

  1. Meet the accounting databasesQuickBooks Online style data.
  2. QuickBooks Desktop styleCustomers, bills, payments and journal entries.
  3. Sage 100Hundreds of real-world tables; start with AR and AP.
  4. Learn the SQL you needTotals by customer, by month and by account.
  5. Aging and balances in DAXSemi-additive balances and variance.
  6. Report layoutsAR aging, P&L and budget versus actual.

Power Query

About 6 hoursExcel and Power BI users who want to clean and reshape data

You will be able to: Clean messy extracts, reshape them, combine tables and write your first M functions.

  1. Connect to the Power Query labThe pqlab database, with a table for every technique.
  2. Fix headers and layoutStart with lab_hdr_title_rows and lab_hdr_first_row.
  3. Clean text and fix typesSplitting, trimming, locale-aware dates and numbers.
  4. Unpivot and pivotWide months, survey checkboxes, key-value attributes.
  5. Merge, append and fuzzy matchJoin kinds, schema drift and company-name matching.
  6. Parse JSON and XMLNested orders, optional fields and broken documents.
  7. Write custom functionsRun one function over a list of API pages.

Professional services and nonprofit analytics

About 5 hoursAccountants and finance leaders in firms and nonprofits

You will be able to: Report on realization, WIP and aging for a CPA firm, and on donors, grants and funds for a nonprofit.

  1. Meet the CPA firm databaseClients, engagements, billing and the ledger.
  2. Billing and collections queriesOpen the Playground on cpafirm.
  3. Meet the nonprofit databaseDonors, grants, funds and fiscal years.
  4. Fund and grant reportingOpen the Playground on nonprofit.
  5. Learn the SQL you needTotals by client, fund and fiscal year.
  6. Report layoutsAR aging, budget versus actual and more.

Maps and fiscal calendars

About 3 hoursAnyone who wants to map data or report by fiscal period

You will be able to: Plot addresses on a map, measure distances, and chart by fiscal year, quarter and period.

  1. How the geography and fiscal columns workCoordinates, reference tables and fiscal calendars shared by four databases.
  2. Map clients and donorsClients, visits and donors all carry latitude and longitude.
  3. Report by fiscal yearJuly-June billing by quarter and by tax season.
  4. Retail fiscal weeksA February-start year with a true 4-5-4 calendar.
  5. Time intelligence for a fiscal yearYear to date with a fiscal year end.
  6. Map a whole cityParcels, streets, 311 requests and dispatch calls with a July-June fiscal year.
  7. Geocoding practiceMessy coordinates and addresses with an answer key.

Data modeling for Excel and Power BI

About 6 hoursAnyone building a model, report or warehouse

You will be able to: Recognize star, snowflake, slowly changing, snapshot and bridge patterns, model them in Power BI, and handle very large tables.

  1. Which structures existA map of the patterns, the sample database for each, and what Power BI cannot do.
  2. Explore a warehouseFacts, dimensions, a type-2 customer and snapshots.
  3. Read the warehouse guideQueries for every pattern, on both engines.
  4. Model it in Power BIRelationships, filter direction and star schemas.
  5. Go big25 million rows, columnstore, aggregates and the bill of materials.
  6. Time intelligence on a fiscal yearApril-March in retailwh, November-October in mfgorders.

Local government analytics

About 5 hoursAnyone who works with, or around, a city or county

You will be able to: Answer budget, service-level, public-safety and revenue questions for a small city, and map them.

  1. Meet the cityA small resort city: tables, joins and the events hidden in the data.
  2. Open it in the PlaygroundBrowse 311 requests, parcels, dispatch calls and the ledger.
  3. Budget versus actualAdopted, amended and actual by department and fund.
  4. Service levels and response times311 service levels, permit cycle times, fire and sheriff response.
  5. Tourism, weather and revenueThe lodging tax, snow costs and the visitor index.
  6. Map the cityParcels, streets, requests and calls on a map, by fiscal period.

Operations, maintenance and billing analytics

About 4 hoursAnyone reporting on work orders, purchasing, customer billing or reliability

You will be able to: Answer maintenance-cost, backlog, vendor-payment, billing and outage questions for a utility, and build the report in Excel or Power BI.

  1. Meet the utilityAssets, work orders, purchasing, billing and outages, all keyed.
  2. Open it in the PlaygroundBrowse work orders, vendors, accounts and outages.
  3. Maintenance cost and backlogLabor cost by asset type, days to complete by priority, open orders.
  4. Procurement and invoice agingDays to pay against vendor terms, disputed invoices.
  5. Billing and seasonal usageMonthly usage by rate class and the summer peak.
  6. Model it in Power BIShared dimensions, role-playing dates and large facts.

IoT and smart home

About 4 hoursAnyone curious about sensor data and personal household data

You will be able to: Work with 1.6 million sensor readings, reconcile solar, battery and grid energy, and explore events, automations and trips.

  1. Meet the smart home83 devices, 13 months, and a few memorable incidents.
  2. Open it in the PlaygroundBrowse the readings, events and energy tables.
  3. Energy and billsSelf-sufficiency, time-of-use pricing and the April rate change.
  4. Maps and floor plansTrips on a map and a heat map of the house.
  5. Aggregate time seriesGroup readings by hour, day and fiscal period.
  6. Ask an assistantHave an AI assistant investigate the outage or the leak.

Learn with an AI assistant

15 minutes to set upAnyone who prefers asking questions in plain English

You will be able to: Connect Claude or another MCP assistant and have it explain data, check your SQL and help with DAX.

  1. Connect an assistantAdd the server and sign in once.
  2. Ask about the dataPrompts that work well.
  3. Ask about DAXThe assistant reads the same guides you see here.