Modeling & DAX fundamentals
Is this course relevant and interesting for more managers within your company? We organize this course in-company. Ask about the possibilities.
A Power BI data model, or analytical model, is the core of a Power BI solution. Each Power BI report is based on a data model that combines data and provides aggregations and all sorts of calculated results. The concepts of Power BI data models may seem easy and familiar, but make no mistake: building a well-performing data model requires a different way of thinking from working with relational databases or Excel. In this course, you’ll learn about building Power BI data models and how to use the DAX language.
The concepts and techniques of Power BI data models are identically available in other tools like Power Pivot in Excel, SQL Server Analysis Services Tabular, and Azure Analysis Services. So, the knowledge acquired through this course can be applied in many ways.
The aim of this course is to let you build powerful analytical models and enrich these with DAX functions. After this course:
- You have the knowledge to build efficient analytical models with different types of tables.
- You understand and can create and use relationships between tables.
- You know how to add calculations to models with DAX.
- Bonus: you know the best practices to develop models that are fast and easy to maintain.
We start by discussing the fundamental concepts of the Power BI data model. We explore the features of the Power BI Desktop tool, but spend most of our time on data modeling and DAX.
- Basics of Power BI data modeling: tables, relationships, data types, metadata.
- Analytical model design.
- Introduction to DAX: calculated columns and measures.
- Basic DAX functions.
- DAX context and filtering.
- Time Intelligence functions, like year-to-date and rolling total