Most expense reports start as a flat table — and stay that way. With a single VBA macro, you can turn that raw Data sheet into a polished, interactive dashboard, with no manual chart-building required. The macro does the heavy lifting. It formats your table, builds seven PivotTables, lays out six KPI cards (total spend, budget, approval rate and more), draws five charts, and wires up Month and Department slicers so everything filters together. A live status bar shows each ste

This post walks through the exact setup shown in your screenshots: folder-based CSV ingestion in Power Query, a tidy star schema, an FX bridge for currency conversion, a P&L layout table for the matrix, and a simple report page with monthly columns and KPI cards. No fluff—just what’s in your files. Check out some of our FREE templates and materials. PRACTICE MATERIAL BELOW!👇 What we’ll build (at a glance) Tables : dimDate, dimAccount, factGL, dimFX, dimPnL, plus your Calcula