This hands-on bootcamp teaches a pragmatic, measurement-driven approach to performance. I will tune Delta tables (partitioning, file sizing, Z-Order/V-Order, compaction), address tiny file and high-cardinality pain, and use shortcuts and metadata strategies wisely. On the semantic side, I will build star schemas, composite models, and aggregations that keep p95 latency down without ballooning costs.

You’ll learn when to choose Direct Lake vs Import vs DirectQuery, how to diagnose bottlenecks, and how to monitor freshness/latency with a lightweight perf dashboard. Bring your toughest scenarios as this day is about fixes you can apply immediately.