Texas A&M UniversityWork In Progress

Build production-quality reports with proper data modeling and security. ~1 week to complete.

Intermediate Guides

Build production-quality reports with proper data modeling and security. ~1 week to complete.

Common measures, fiscal year calcs, SWITCH, CALCULATE.

Star schema, conformed dimensions, relationship rules.

Build Row-Level Security from scratch, step by step.

DirectLake vs Import vs DirectQuery — when to use each.

Apps, subscriptions, embedding, and what NOT to do.