Downloads
Download

Excel and Power BI downloads

Practice files built from the live LearnSQL databases: Excel workbooks with instructions, questions and a Check Your Work answer sheet, and complete Power BI projects that teach DAX, relationships, time intelligence and security on real data.

Excel practice workbooks

Open in Excel (any recent version). Each has the data, instructions, questions and a Check Your Work sheet.

Beginner classicmodels 2,996 rows 141 KB

Classic Models: Sales Order Lines

Every order line from a model-car wholesaler: customer, country, product line, quantity and price. Build a PivotTable and answer four questions.

PivotTableSUMIFSSorting & filtering
Download .xlsx
Beginner northwind 58 rows 11 KB

Northwind Traders: Orders and Line Items

Order lines with quantities, prices and discounts. Practice calculated columns, SUMIFS and lookups.

XLOOKUPSUMIFSCalculated columns
Download .xlsx
Intermediate contoso 864 rows 45 KB

Contoso: Monthly Sales by Channel and Category

Three years of retail sales summarized by month, channel and category. A realistic starting point for PivotTables, slicers and margin analysis.

PivotTableSlicersMargin %Year-over-year
Download .xlsx
Beginner world 239 rows 24 KB

World: Countries of the World

Population, area, GNP and life expectancy for every country. Good for filters, sorting and dealing with blanks.

Sorting & filteringAVERAGEIFSHandling blanks
Download .xlsx
Intermediate dvdrental 16,044 rows 391 KB

DVD Rental: Payments by Customer and Category

Thousands of rental payments with customer, date and film category. Practice grouping dates and finding top customers.

PivotTableDate groupingTop N
Download .xlsx
Intermediate northwind 63 rows 11 KB

Northwind: Clean Up the Messy Data

The Northwind orders data with realistic problems planted in it: blanks, stray spaces, numbers stored as text and duplicate rows. Find and fix them.

Data cleaningTRIMVALUERemove DuplicatesPower Query
Download .xlsx

Power BI projects

Complete, working Power BI Desktop projects on the Contoso database: a data model, DAX measures, and report pages. Extract the whole zip, open the .pbip file in Power BI Desktop, click Refresh, and sign in with the SQL Server login that comes with your CPE Today course. Each project also contains a TMDL script that rebuilds the model if it will not open.

Advanced contoso 53 KB

Power BI: Advanced DAX Patterns

Calculation groups, field parameters, running totals, a user-defined function and quick measures.

20 measures7 pages24 visuals
Download .zip
Intermediate contoso 42 KB

Power BI: CALCULATE and Filter Context

CALCULATE with Boolean filters, REMOVEFILTERS, ALLSELECTED, KEEPFILTERS and FILTER.

18 measures4 pages15 visuals
Download .zip
Beginner contoso 48 KB

Power BI: DAX Basics

SUM, COUNTROWS, DIVIDE, calculated columns, variables and the first measures.

12 measures5 pages27 visuals
Download .zip
Intermediate contoso 38 KB

Power BI: Iterators (SUMX, RANKX, TOPN)

SUMX, AVERAGEX, RANKX, TOPN and row context versus filter context.

17 measures4 pages15 visuals
Download .zip
Beginner contoso 41 KB

Power BI: Relationships and RELATED

Relationships, RELATED, RELATEDTABLE, inactive relationships and USERELATIONSHIP.

11 measures5 pages12 visuals
Download .zip
Intermediate contoso 76 KB

Power BI: Report Design

Drillthrough and tooltip pages, navigation buttons, conditional formatting, dynamic titles, mobile layout.

14 measures6 pages29 visuals
Download .zip
Advanced contoso 35 KB

Power BI: Row-Level Security

Row-level security roles (static and USERPRINCIPALNAME) plus an object-level security script.

5 measures3 pages9 visuals
Download .zip
Intermediate contoso 47 KB

Power BI: Time Intelligence

Date table, YTD, prior year, year-over-year, rolling 12 months and fiscal periods.

15 measures5 pages22 visuals
Download .zip
Beginner contoso 62 KB

Power BI: Visual Gallery

Every core visual type once, on the Contoso star schema.

14 measures7 pages37 visuals
Download .zip

How to use a download

Excel: read the Instructions sheet first, do the work on Data and Output, then compare with Check Your Work. Power BI: extract the zip, open the .pbip, refresh, then open each page and the measures in Model view to see how the DAX works. The data is real rows from the sample databases, so the same questions can also be answered with SQL in the Playground, and you can pull the live data into Excel or Power BI yourself (how). Stuck on DAX? Ask an AI assistant connected through the MCP server: it can look up DAX patterns and explain them.

It is all synthetic

These databases contain made-up data for learning. The Contoso files use a 10% sample of the full sales table so they stay small and quick to open. The messy-data file has problems planted on purpose; the hidden About sheet lists them if you get stuck.