Interested in a private company training? Request it here.
When building a business intelligence solution, data has different modeling requirements than what is needed for operational applications. This module describes the challenges that can arise when storing data, and how good data models can overcome these. It presents the data model as an abstraction layer between the operational part and the analytical part of the corporate IT stack.
Dimensional modeling is based on the idea of splitting data in the things that are (dimensions) and the things that happen (facts). This module describes the properties of dimension tables: Keys, attributes, hierarchies, ... .
Dimensional modeling is based on the idea of splitting data in the things that are (dimensions) and the things that happen (facts). This module describes the most common types of fact tables
Everybody wants to analyze over time, so this is the most common dimension in data models. Based on the principles introduced in the previous module a date dimension is built.
Since the dimension tables describe the things that are, they don't change as often as fact tables. Yet also properties of products, customers and other dimensions change over time as well. The different ways to register this in the data warehouse are discussed in this module.
The previous chapters covered the regular, most common scenario of modeling data. In this module some of the more special scenarios are covered, such as data arriving out of chronological order, parent-child relationships etc.
When implementing a data model in Power BI, a few choices need to be made regarding the physical implementation of the model. These are discussed in this module.
Data modeling is an essential step in business intelligence, when data is stored centrally to be used by multiple reports and analytical tools. This becomes an essential skill when building Power BI data flows, Power BI data sets, Analysis tabular models or other analytical data storage solutions on top of a data warehouse. In this training you will learn how to design such models according to the popular dimensional modeling techniques of star schemas.
This course is intended for Business Intelligence developers responsible for designing Power BI data models. The course assumes participants are already familiar with Power BI Desktop, and have some familiarity with DAX.