Interactive deep-dives into Power BI, DAX, and Microsoft Fabric.
When to use Field Parameters vs Calculation Groups in Power BI. Includes an interactive decision tool and demos.
Master dynamic titles, conditional formatting, SVG measures, and other report-scoped measures in Power BI. Learn organization patterns and best practices.
Field parameters, calculation groups, what-if parameters, and composite models. Learn departmental vs single-report patterns for extending semantic models.
Connection modes in Microsoft Fabric: DirectQuery, Import, and Direct Lake. How OneLake works and why Direct Lake combines import speed with live data.
Organizing data for analytics in Microsoft Fabric: Bronze, Silver, and Gold layers from raw ingestion to curated reporting.
The building blocks of Microsoft Fabric: engines, experiences, items, and how they connect.
How data is stored, compressed, and optimized in Microsoft Fabric: Column Store, Delta Tables, Optimizations, and Direct Lake.
Version control fundamentals for Microsoft Fabric and Power BI developers: branching, collaboration, and Developer Mode.
What DAX is, how it evolved from Excel, the three calculation types, star schema design, and how filters propagate through your data model.
Filter context, query context, and row context. How CALCULATE works, iterator functions, and context transition with interactive visualizations.
Time intelligence, variables, inactive relationships, SWITCH, SELECTEDVALUE, calculation groups, and a look under the hood at how the engine processes DAX.
Understanding fact tables, dimension tables, and proper model design for optimal performance and DAX simplicity. The foundation of semantic model architecture.
Cardinality, cross-filter direction, inactive relationships, and troubleshooting common relationship issues. Master the connections in your semantic model.
Standalone guides coming soon. Check back later!
When to use Field Parameters vs Calculation Groups in Power BI. Includes an interactive decision tool and demos.
Master dynamic titles, conditional formatting, SVG measures, and other report-scoped measures in Power BI. Learn organization patterns and best practices.
Field parameters, calculation groups, what-if parameters, and composite models. Learn departmental vs single-report patterns for extending semantic models.
Connection modes in Microsoft Fabric: DirectQuery, Import, and Direct Lake. How OneLake works and why Direct Lake combines import speed with live data.
Organizing data for analytics in Microsoft Fabric: Bronze, Silver, and Gold layers from raw ingestion to curated reporting.
The building blocks of Microsoft Fabric: engines, experiences, items, and how they connect.
How data is stored, compressed, and optimized in Microsoft Fabric: Column Store, Delta Tables, Optimizations, and Direct Lake.
Version control fundamentals for Microsoft Fabric and Power BI developers: branching, collaboration, and Developer Mode.
What DAX is, how it evolved from Excel, the three calculation types, star schema design, and how filters propagate through your data model.
Filter context, query context, and row context. How CALCULATE works, iterator functions, and context transition with interactive visualizations.
Time intelligence, variables, inactive relationships, SWITCH, SELECTEDVALUE, calculation groups, and a look under the hood at how the engine processes DAX.
Understanding fact tables, dimension tables, and proper model design for optimal performance and DAX simplicity. The foundation of semantic model architecture.
Cardinality, cross-filter direction, inactive relationships, and troubleshooting common relationship issues. Master the connections in your semantic model.