Power BI Data Modelling Tutorial 1 - Star Schema?
Learn how to set up your data model in Power BI by following these best practices and essential steps. What kind of schema should you use. Snowflake, Star Schema or Waterfall? Actually Power BI loves them all. However, you should set up the model that is best for your data set and DAX functions.
Please subscribe to support the channel and let me know if you like the videos:
https://www.youtube.com/channel/UCSQvwTdavISOusGhJW6H0Vg?sub_confirmation=1
Lear the Data Model Basics. This is a great tutorial for Power BI beginners.
00:01:00 - Auto Detect Relationships
00:05:15 - Manage Relationships
00:06:51 - Waterfall Schema
00:07:35 - Appending Queries
00:09:35 - Turning Off AutoDetect
00:10:28 - Enable Load Feature
00:12:47 - Create Lookup Tables with VALUES()
00:15:40 - Reference Table
00:17:15 - Enrich Tables
00:18:45 Merge Queries
Check me out on LinkedIn: https://www.linkedin.com/in/gaelimholland/
#PowerBI #DataModeling #StarSchema
Видео Power BI Data Modelling Tutorial 1 - Star Schema? канала Absent Data
Please subscribe to support the channel and let me know if you like the videos:
https://www.youtube.com/channel/UCSQvwTdavISOusGhJW6H0Vg?sub_confirmation=1
Lear the Data Model Basics. This is a great tutorial for Power BI beginners.
00:01:00 - Auto Detect Relationships
00:05:15 - Manage Relationships
00:06:51 - Waterfall Schema
00:07:35 - Appending Queries
00:09:35 - Turning Off AutoDetect
00:10:28 - Enable Load Feature
00:12:47 - Create Lookup Tables with VALUES()
00:15:40 - Reference Table
00:17:15 - Enrich Tables
00:18:45 Merge Queries
Check me out on LinkedIn: https://www.linkedin.com/in/gaelimholland/
#PowerBI #DataModeling #StarSchema
Видео Power BI Data Modelling Tutorial 1 - Star Schema? канала Absent Data
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Data Modelling: From Single Table To Star Schema - Chris Barber](https://i.ytimg.com/vi/F4tK0dwJKU4/default.jpg)
![Data modelling 101 with Power BI | Community Webinars](https://i.ytimg.com/vi/islhUWaCiJ0/default.jpg)
![Handling MULTIPLE fact tables in Power BI](https://i.ytimg.com/vi/TnyRsO4NJPc/default.jpg)
![The Perfect Data Model for Power BI - Creating a STAR SCHEMA from a Flat File / Excel Table source!](https://i.ytimg.com/vi/VV3tYTudNBY/default.jpg)
![Power BI Tutorial | From Flat File To Data Model](https://i.ytimg.com/vi/vjBprojOCzU/default.jpg)
![Microsoft Power BI: The Do’s and Don’ts of Power BI Relationships - BRK3019](https://i.ytimg.com/vi/78d6mwR8GtA/default.jpg)
![Data Modeling (Star Schema 🌟) in Power BI – Creating Dimension Tables](https://i.ytimg.com/vi/7ciFtfi-kQs/default.jpg)
![DIMENSIONAL DATA MODELING TUTORIALS - STAR SCHEMA | Based on a case study | Part 1](https://i.ytimg.com/vi/7HyGM3Iw0Kc/default.jpg)
![Why Power BI loves a Star Schema](https://i.ytimg.com/vi/vZndrBBPiQc/default.jpg)
![DA-100: Analyzing Data with Microsoft Power BI – FULL COURSE in 2 hours](https://i.ytimg.com/vi/Tfk3ae0qz3A/default.jpg)
![Real World Power BI Interview Questions & Answers](https://i.ytimg.com/vi/DEWMOBRWXeY/default.jpg)
![Building the English Premier League Table with Power BI](https://i.ytimg.com/vi/7mqshe_C-jQ/default.jpg)
![Data modeling best practices - Part 1 - in Power BI and Analysis Services](https://i.ytimg.com/vi/kiVXI7zjSzY/default.jpg)
![Power BI Modelling - Part 1 | Star Schema | Reduce Model | Date Table | Power BI Tutorial (43/50)](https://i.ytimg.com/vi/SHc2ByE4V3I/default.jpg)
![Power BI Masterclass: Data Modeling 101](https://i.ytimg.com/vi/YUWLsoIH8mo/default.jpg)
![How to use Microsoft Excel for ETL, Data Modelling and Analytics - Full Tutorial under 30 minutes!](https://i.ytimg.com/vi/6wSwqY6H8oI/default.jpg)
![Dual Learn | SQL & Python Part #2 | Nested SubQueries](https://i.ytimg.com/vi/F3XosaZTTfc/default.jpg)
![Power Query Power BI: Transform 2 Fact Tables to Star Schema Data Model (Invoice Data) EMT 1498](https://i.ytimg.com/vi/iK0uKo2G8tA/default.jpg)
![Measures vs. calculated columns in DAX and Power BI](https://i.ytimg.com/vi/ePPi1LLX0sA/default.jpg)
![How to Design a Data Model in Power BI? | | DA -100 Tutorials Episode 6 | Bi Consulting Pro | 4K](https://i.ytimg.com/vi/IS016_g9THU/default.jpg)