Design and Build Tabular Models - DP-500

Data models are the core of data analysis in Power BI. This course will teach you how to create data models that help you author simpler DAX queries and better reports.

Data modeling enables the advanced analytical capabilities required to provide meaningful insights, while reducing the complexity of DAX queries. In this course, Design and Build Tabular Models - DP-500, you’ll learn to solve business problems by leveraging the data modeling capabilities of Power BI. First, you’ll learn when to use Direct Query and external tools. Next, you’ll discover how to reduce the number of redundant measures by creating calculation groups. Finally, you’ll explore how to build composite models and implement security. When you’re finished with this course, you’ll have the skills and knowledge of data modeling needed to design and build robust data models while enforcing security.

• Course Overview 1min
• Getting Started with Tabular Models 15mins
• Using DAX 19mins
• Working with Calculation Groups 11mins
• Building Composite Models and Aggregations 14mins
• Enforcing Security 9mins