From the course: Power BI for Finance
Join today to access over 25,000 courses taught by industry experts.
Loading data - Power BI Tutorial
From the course: Power BI for Finance
Loading data
- [Instructor] Power BI models perform best when we take advantage of its powerful semantic modeling capabilities. This includes the data that we load into Power BI from Power Query. We can then connect the tables in the Model View and add DAX calculations to our semantic model as well. Fact tables contain data. They're often large tables containing many rows of transactional data. Dimension tables, on the other hand, are key tables that store attributes about the data, like categories or dates. It's a good practice in Power BI to have at least a data table as a dimension table within the model. When we're building the semantic model in Power BI, I recommend putting the tables into a star schema with the dimension tables toward the top of the page and the fact tables toward the bottom. We want to use one-to-many joins to connect these tables together on their unique dimension key and their corresponding key for the matching field in the fact tables. Remember when updating your data to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.