Power Query and the Data Model: Consolidate a Multi-Branch Business

<p>Every month Tessa Lindgren, finance and operations analyst at Larkspur Home &amp; Garden, spends three days pasting four branches' till exports into one sheet. The new CFO wants a report he can refresh himself, with target attainment by branch, before the board meets. In five lessons you build it on your own generated data: combine a folder of CSVs with Power Query, fix mismatched headers, Total lines, day-first dates and dirty SKUs, unpivot the plan, load a star schema into the Data Model, and write DAX measures you pull into cells with CUBEVALUE. At every step you hand the same job to your AI assistant and learn to catch what it gets wrong. In the capstone July's files arrive: you direct your AI to refresh and report, and Bartman checks the workbook you upload.</p><p>This course needs desktop Excel for Windows (Microsoft 365, or Excel 2016 and later). Power Query and the Data Model are not in Bartman's in-browser Excel lab, so every lesson is built in Excel and checked by uploading your workbook.</p>

Tools: Power Query (M), Get Data from Folder, Excel Data Model, Power Pivot, DAX Measures, CUBEVALUE, AI-Assisted Excel