Data Modeling in Power BI

Overview

This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI. In this course, you'll learn how to use Power BI to create and maintain relationships in a data model and form a model using multiple Schemas. You'll explore the basics of DAX, Power BI's expression language, and add calculations to your model to create elements and analysis in Power BI. You'll discover how to configure the model to support Power BI features for insightful visualizations, analysis, and optimization. After completing this course you'll be able to: ● Create and maintain relationships in a data model. ● Form a model using a Star Schema ● Write calculations DAX to create elements and analysis in Power BI ● Create calculated columns and measures in a model ● Perform useful time intelligence calculations in DAX ● Optimize performance in a Power BI model This is also a great way to prepare for the Microsoft PL-300 exam. By passing the PL-300 exam, you’ll earn the Microsoft Power BI Data Analyst certification.

Syllabus

Concepts for data modeling

This module introduces data modeling and the schemas used to create them.

Using Data Analysis Expressions (DAX) in Power BI

This module introduces the learner to the DAX (Data Analysis Expressions) language. The module explores the syntax of DAX using multiple business use cases. The module also integrates DAX with previous lessons on database tables and their use and introduces the concept of time intelligence.

Optimize a model for performance in Power BI

This module explores the optimization process and examines the tools and methods to achieve this in Power BI, including using performance analyzer and DirectQuery features. This module also dives deeper into DAX and its use in the real world.

Final project and assessment: Modeling data in Power BI

In this module, you will be assessed on the key skills covered in the course. This module summarizes the course and reflects on the primary learning objectives. The module also contains the project for the course, which encapsulates the learning into a practical whole.