Star Schema vs Snowflake vs Flat File in Power BI Speed Test😮
I've tested the 3 main Power BI Data Models against each other: Star Schema, Snowflake Schema and Flat File with unexpected results.
Join this channel to get access to perks:
/ @mms-powerbi
Watch next: Data modeling best practices - • 7 Best Practices to Improve your Data Mode...
How I choose my data models - • SIMPLE Technique for Choosing the Ideal Po...
Understanding Star Schema in Power BI: Understanting Star Schema in Power BI: • Star Schema in Power BI - Is it the BEST C...
Power BI for Beginners Playlist - • Power BI for Beginners
DISCLAIMER: This does not represent the absolute truth, and a real-life scenario should and would differ, based on multiple factors including and not limited to DAX complexity, size, and connection type.
Data modeling in Power BI is a crucial step when creating a report. And a better Power BI Data model translates into a better Power BI semantic model.
The data model is the foundation of every successful report. So the choices you make when it comes to data modeling in Power BI become even more important.
In this speed test, I have run a performance test for a flat file data model, a star schema data model, and a snowflake schema data model.
The datasets that I’ve used have 240k, 480k, 950k, and 4.75M rows, ensuring a whole range of sizes.
⌚ TIMESTAMPS
00:00 Intro
00:12 Test scenario
00:47 Preparation for the test
01:12 1st Size dataset
01:31 Caveat
01:59 2nd Size dataset
02:17 3rd Size dataset
02:32 Last chance
03:03 Conclusion