Downloads
Power Query practice

Power Query Lab

A Power Query playground: a joinable retail backbone plus deliberately messy tables, one per technique, from promoting headers and unpivoting to JSON, fuzzy merges, geocoding and custom functions.

pqlabSQL ServerMariaDB 86 tables
core_order_linescore_orderscore_customerscore_productscore_calendar

Read the guide

Power Query playground (pqlab): 86 tables built for practicing Power Query: a retail backbone plus deliberately messy tables (now with geospatial exercises), a technique index and M recipes.

Good for

Power Query in Excel and Power BICleaning messy dataMerges, appends and custom functionsGeocoding and distances

Questions to try

  • How do I promote the real header row?
  • How do I unpivot twelve month columns?
  • How do I parse JSON into rows?
  • How do I merge on a fuzzy match?

Write each as a query in the SQL editor, or ask an AI assistant to walk you through it.

Connect to it

Server learnsql.cpetoday.com,1433, database pqlab, in Excel or Power BI (Import mode) or DBeaver. These tables are in the dbo schema, so once you have picked the database you can use plain names such as core_calendar.

Download the Excel connection (.odc)

How to use it: download the file and open it. Excel opens it as a connection to pqlab and asks for the SQL Server username and password from your CPE Today course. The file holds no password. The first table is selected by default, and you can pick others from the Data window. Setup details for other tools are on Connect.

Tables (86)

Click a table to preview it in the Playground.

← All databases