Star schema, relationships, and model design.
5 tutorials in this category
Slow Power BI reports frustrate users and kill adoption. Learn the systematic approach to diagnosing and fixing performance issues — from Performance Analyzer to DAX optimization to model tuning.
Calculated tables let you build tables with DAX instead of loading them from a source. What-if parameters turn static assumptions into interactive slicers. This guide covers both features, the syntax, and five practical patterns — from date tables to scenario analysis.
Bidirectional filtering is powerful and dangerous. It solves certain modeling problems elegantly — and creates performance disasters and ambiguous filter paths when overused. This guide covers what bidirectional filtering does, the three scenarios where it's the right tool, and the warning signs that you're using it wrong.
A well-designed star schema makes DAX easier and reports faster. Learn fact vs. dimension tables, relationship cardinality, and why bidirectional filters are usually a mistake.
Relationship cardinality determines how filters flow through your data model. One-to-many is the default and the safest choice. Many-to-many is sometimes necessary but introduces ambiguity and performance costs. This guide covers both, when each is appropriate, and the patterns that make many-to-many manageable.