Model Your Data in Power BI: Star Schemas, Filter Flow & Field Lists @HavensConsulting
Model Your Data in Power BI: Star Schemas, Filter Flow & Field Lists  @HavensConsulting
Uploaded September 2026 | Updated November 2026, 1 day ago
Plenty of Power BI issues that look like DAX issues start one layer down, in the model. The formula is correct, the relationship underneath it isn't doing what you assumed, and you spend an afternoon rewriting a measure that was never the problem.

This one covers the foundation the rest of it sits on. Why a model beats one giant flat table (smaller storage, better compression, faster refresh, and filter paths you get without writing any code), how dimensions and facts split the who-what-when-where from the numeric events, and what actually happens when someone picks a value in a slicer and that filter travels down the relationship into the fact table.

Then star versus snowflake, compared on the four things that decide it in practice: query performance, DirectQuery latency, how long the DAX ends up, and whether business users can find a field without asking someone. Star wins on all four. I also get into why the snowflake version keeps turning up anyway, since it usually arrives from a source system rather than from a decision anyone made.

The last section is the one that gets skipped. Every visual in Power BI generates a query with three ingredients (filter, group, summarize), and once that clicks, a wrong number stops being mysterious. After that it's the fields list itself: friendly names instead of cgo_key_fk, display folders, hidden keys, and descriptions that surface as tooltips. It sounds cosmetic, but an unreadable fields list is how you end up with six competing Excel copies of the same report.

CHAPTERS 🎬
00:00 -- Why a fundamentals video
01:00 -- Why model data
02:01 -- Dimensions & facts
03:44 -- Filter flow
04:58 -- Star vs snowflake
07:00 -- Analytic queries
08:45 -- Intuitive fields list

RELATED CONTENT πŸ”—
Modeling Fundamentals Guide -- go-ae.org/hc-yt-modeling-fundamentals-guide

BECOME A CHANNEL MEMBER πŸŽ‰
-- youtube.com/channel/UCjlfQwqb-0S40XQ8seYPLSw/join

CHECK OUT OUR MERCH STORE πŸ‘•
-- havens-consulting.creator-spring.com

LET'S CONNECT! πŸ§‘πŸ½β€πŸ€β€πŸ§‘πŸ½ 🌟
-- linkedin.com/in/reidhavens
-- youtube.com/c/HavensConsulting

BUSINESS PAGES πŸ“„
Home Page -- havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
Online Courses -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
Contact & Support -- havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
Analytic Endeavors -- analyticendeavors.com/make-an-enquiry.html?ae_source=HC&utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM

EMAIL US AT πŸ“§
info@havensconsulting.net

#PowerBI #Fabric #microsoft #businessintelligence #datascience #data #dataanalytics #excel #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel
Model Your Data in Power BI: Star Schemas, Filter Flow & Field ListsBox (and Whisker) Plot Visual with Native Visuals + Error BarsCreate your own Power Query Connector for Power BI & Dataflows (with Miguel Angel Escobar)Design Scalable BI Solutions with BI Solution Algebra (with Chris Wagner)[DAX] Lib - From Zero to Community Hero (with Jake Duddy)Empower BI Professionals to Do More Using Microsoft Fabric (with Christian Wade)Havens Consulting Live StreamAvoid AI noise: use weekly summaries, not daily panicIntroducing the Core Visuals - Vision Board (Miguel Myers & Alper Sarikaya)Next Generation Maps in Power BI with Icon Map (with James Dales)Examples for Comparing Values (Ratios) to TargetsPower BI Report Cleanup Just Leveled Up (Duplicate Images, Orphans, Saved Scripts)
Havens Consulting |

Model Your Data in Power BI: Star Schemas, Filter Flow & Field Lists

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER