Start here
Lessons and reference
Look things up
Start here
SQL
Power Query
Data modeling
Power BI and DAX
Finance playbooks
Run queries
Build and check
A manufacturer's order history: 25 million order lines to wholesalers, retail chains and retailers, plus a three-level bill of materials and a customer hierarchy. On SQL Server it is a compressed columnstore table; on MariaDB the same rows are computed on the fly, so nothing large sits on disk.
Big data: manufacturer orders (mfgorders): 25 million order lines from a manufacturer to wholesalers and retailers, stored as compressed columnstore on SQL Server and computed on the fly on MariaDB; plus a bill of materials.
Write each as a query in the SQL editor, or ask an AI assistant to walk you through it.
Server learnsql.cpetoday.com,1433, database mfgorders, 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 bom.
Download the Excel connection (.odc)
How to use it: download the file and open it. Excel opens it as a connection to mfgorders
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.
Click a table to preview it in the Playground.