Resources for Power Query Demo Day, a free live demo of First Steps for Power Query with Microsoft Excel. Built on the Stringfest Analytics brand, with the Palmer Penguins dataset replacing the old star.xlsx for the basics.
| File | What it is |
|---|---|
power-query-demo-day.pptx |
The slide deck (15 slides) with speaker notes. Demo references point to worksheets in the supplied workbook; no membership access is required. |
power-query-demo-day-notes.docx |
Step-by-step demo and speaker notes to replay every demo. |
power-query-demo-day-data.xlsx |
All practice datasets in one workbook. |
Open power-query-demo-day-data.xlsx and select the worksheet for the demo. Keep the workbook open and switch worksheets between demos. On each data sheet, click inside the data and choose Data > From Table/Range. Keep query results on new worksheets so the source data remains available for refresh.
| Worksheet | Used in |
|---|---|
penguins |
Demo: Profiling data (load, data types, View-tab profiling). |
signups |
Demo: Manipulating rows (filter nulls, sort, dedupe, refresh). |
roster |
Additional department/sign-up practice data. |
wholesale-customers |
Warm-up plus the grand-finale Unpivot (make data PivotTable-ready). |
readme |
Original wholesale dataset source link. |
All original data, including the blanks, duplicates, and intentional misspelling used in the cleanup demo, is retained. The original separate workbooks remain in this folder for reference; participants only need the combined workbook.
It is a free live demo. Attendees receive the files directly and can follow along with the combined workbook or revisit the examples afterward. No membership page or sign-up is required to access the supplied files.
- Practice: use the supplied workbook and demo notes.
- Go deeper: Modern Data Analytics in Excel (O'Reilly) at https://stringfestanalytics.com/maxl/
The deliverables are generated by build_deck.js (deck), build_notes.js (notes), and build_cheatsheet.py (cheat sheet). Brand assets live in assets/. To rebuild the deck and notes: npm install pptxgenjs docx, then node build_deck.js.
pq-pdq.pptx and star.xlsx are the original deck and dataset from the old "Power Query PDQ" event, kept for reference only. The current event is Power Query Demo Day (power-query-demo-day.pptx).