A properly built data model is the foundation of analytics, so the topic of data modeling is one of the most important. In most Power BI trainings, data modeling issues are considered superficially, since this topic is too voluminous and requires a separate study. This training is completely devoted to data modeling.
The training is practical - all the concepts and methods of the training participants will immediately be embodied in the data model. Thus, after training, in addition to knowledge, skills and abilities, students will have all practical cases with solved problems.
The training raises the overall level of “data culture”.
8 academic hours
After completing this course, students will be able to:
They will understand that data modeling is a separate activity of an analyst and carry it out as a separate stage of data analysis.
They will be able to create links between tables of the model and manage them, using numerous nuances and subtleties of link settings.
Will be able to create in Power BI Desktop data models of the "star" and "snowflake" types.
Will be able to use Power functionality for modeling Query and DAX expressions
Analysts who create Power BI Desktop reports
Analysts who design data models in Excel using Power Pivot
Excel users whose work is in one way or another related to data analysis
Experts familiar with data modeling (will be able to structure existing knowledge)
Before attending this course, students must have:
knowledge of Power BI Desktop, Power Query and DAX at a basic level.
The concept of data modeling.
Conceptual, logical, physical modeling.
Modeling Toolkit in Power BI Desktop.
Power data model BI Desktop, the stages of its construction.