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

In this module, you will explore the foundational concepts of data modeling in Power BI, including different schema types and their applications. You will learn how to create and manage relationships within data models, understand cardinality and cross-filtering, and apply Star schema design principles. By the end of this module, you will be able to structure efficient and scalable data models for analysis.

Using Data Analysis Expressions (DAX) in Power BI

This module focuses on building analytical capabilities using DAX in Power BI. You will learn how to write calculations, create calculated columns and measures, and apply context-aware logic for analysis. Additionally, you will explore time intelligence functions to perform period-based comparisons and business analysis. By the end, you will be able to use DAX effectively to enhance data models and generate insights.

Optimize a model for performance in Power BI

In this module, you will learn how to improve the performance of Power BI data models by identifying inefficiencies and applying optimization techniques. You will explore methods such as reducing cardinality, optimizing metadata, improving DirectQuery performance, and managing aggregations. By the end, you will be able to enhance model efficiency and ensure faster, scalable data processing.

Final project and assessment: Modeling data in Power BI

In this module, you will apply your knowledge of data modeling, DAX, and performance optimization to complete a comprehensive project. You will build and refine a data model, demonstrating your ability to design, analyze, and optimize it effectively. This module reinforces your learning through practical application and prepares you for real-world data analysis tasks.