Monthly Subscription Starting at AED 99 + VAT

Data Modeling in Power BI
  • Level Foundation
  • Course by Microsoft
  • Offered by

About

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.

Modules

Welcome to the course

    • 1 Videos
    • 7 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Discussion prompt: What do you hope to learn?

1 Videos

  • Course introduction

7 Readings

  • Course syllabus
  • How to be successful in this course
  • How to open an image in a new tab
  • Setting up your Power BI environment
  • New name for Power BI datasets
  • How to locate your downloaded files
  • Additional resources: Concepts for data modeling

Introduction to data models

    • 3 Videos
    • 7 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Self-review: Configuring a Flat schema
  • Knowledge check: Introduction to data models

3 Videos

  • Introduction to data models
  • Introduction to schemas
  • Setting up a Flat schema in Power BI

7 Readings

  • Model view in Power BI
  • Schemas cheatsheet
  • Table and column properties cheatsheet
  • Exercise: Configuring a Flat schema
  • Exemplar: Configuring a Flat schema
  • Activity: Configure a Flat schema with multiple sources
  • Additional resources: Introduction to data models

Introduction to cardinality and cross-filter direction

    • 4 Videos
    • 4 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Knowledge check: Introduction to cardinality and cross-filter direction

4 Videos

  • Understanding fact and dimension tables
  • Introduction to cardinality
  • Introduction to cross-filter direction
  • Defining data granularity

4 Readings

  • Normalization and denormalization
  • Managing model relationships
  • Model relationships cheatsheet
  • Additional resources: Introduction to cardinality and cross-filter direction

Working with advanced data models

    • 5 Videos
    • 5 Readings
    • 1 Discussion
    • 3 Assignment
Show info about module content

3 Assignment

  • Self-review: Configuring a Star schema
  • Knowledge check: Working with advanced data models
  • Module quiz: Concepts for data modeling

1 Discussions

  • Why is data modeling important in the data analysis process?

5 Videos

  • Setting up a Star schema in Power BI
  • Setting up a Snowflake schema
  • Why it is important to use Snowflake schema
  • Resolving challenges in data models
  • Module summary: Concepts for data modeling

5 Readings

  • Exercise: Configuring a Star schema
  • Exemplar: Configuring a Star schema
  • Activity: Changing your Star schema into a Snowflake schema
  • Data View in Power BI
  • Additional resources: Working with advanced data models

Introduction to DAX

    • 5 Videos
    • 6 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Self-review: Adding a calculated table and column
  • Knowledge check: Using Data Analysis Expressions (DAX) in Power BI

5 Videos

  • Introduction to Data Analysis Expressions (DAX)
  • Formulas and functions in DAX
  • Row context and filter context
  • Introduction to calculated tables
  • Creating calculated columns

6 Readings

  • DAX cheatsheet
  • Cloning and calculating tables
  • DAX table functions
  • Exercise: Adding a calculated table and column
  • Exemplar: Adding a calculated table and column
  • Additional resources: Introduction to DAX

Introduction to measures

    • 4 Videos
    • 2 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Knowledge check: Introduction to measures

4 Videos

  • Introduction to measures
  • Types of measures
  • Basic statistical functions
  • DAX measures and context in business

2 Readings

  • Statistical functions cheatsheet
  • Additional resources: Introduction to measures

Working with measures

    • 4 Videos
    • 5 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Self-review: Adding a measure
  • Knowledge check: Working with measures

4 Videos

  • Creating quick measures
  • Creating custom measures with DAX
  • Introduction to the CROSSFILTER function
  • Using CALCULATE with filters

5 Readings

  • Exercise: Adding a measure
  • Exemplar: Adding a measure
  • Filter functions in CALCULATE
  • Activity: Using the CALCULATE function
  • Additional resources: Working with measures

DAX and table relationships

    • 3 Videos
    • 3 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Self-review: Adding a role-playing dimension
  • Knowledge check: DAX and table relationships

3 Videos

  • Introduction to role-playing dimensions
  • Introduction to the USERELATIONSHIP function
  • Configuring role-playing dimensions

3 Readings

  • Exercise: Adding a role-playing dimension
  • Exemplar: Adding a role-playing dimension
  • Additional resources: DAX and table relationships

Time intelligence calculations in DAX

    • 7 Videos
    • 5 Readings
    • 1 Discussion
    • 3 Assignment
Show info about module content

3 Assignment

  • Self-review: Using time intelligence to compare to previous year
  • Knowledge check: Time intelligence calculations in DAX
  • Module quiz: Using DAX in Power BI

1 Discussions

  • Which DAX features did you find most useful?

7 Videos

  • The importance of time intelligence
  • Using DAX for summarization over time
  • Using DAX for comparison over time
  • Setting up a common date table using DAX
  • Setting up a common date table with M and Power Query
  • Time intelligence in business
  • Module summary: Using DAX in Power BI

5 Readings

  • Additional time intelligence functions
  • Exercise: Using time intelligence to compare to previous year
  • Exemplar: Using time intelligence to compare to previous year
  • Activity: Set up a common date table
  • Additional resources: Time intelligence and calculations in DAX

Optimize performance in a Power BI model

    • 4 Videos
    • 6 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Self-Review: Improving data model performance
  • Knowledge check: Optimize a model for performance in Power BI

4 Videos

  • What is optimization and why is it necessary?
  • Optimization by example
  • Identifying and reducing cardinality levels
  • Resolving performance issues in the data model

6 Readings

  • Exercise: Improving data model performance
  • Exemplar: Improving data model performance
  • Optimizing columns and metadata
  • Optimizing the Auto date/time feature
  • Activity: Optimizing the columns and Auto date/time
  • Additional resources: Optimize performance in a Power BI model

Optimize DirectQuery models

    • 3 Videos
    • 2 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Knowledge check: Optimize DirectQuery models

3 Videos

  • Behavior and limitations of DirectQuery connections
  • Optimizing DirectQuery performance with query reductions
  • Optimizing DirectQuery performance with table storage

2 Readings

  • Walk-through: Optimizing a DirectQuery model
  • Additional resources: Optimize DirectQuery models

Create and manage aggregations

    • 3 Videos
    • 4 Readings
    • 1 Discussion
    • 3 Assignment
Show info about module content

3 Assignment

  • Self-review: Adding an aggregation
  • Knowledge check: Create and manage aggregations
  • Module quiz: Optimize a model for performance in Power BI

1 Discussions

  • How would performance and optimization impact different stakeholders?

3 Videos

  • What are aggregations and why use them?
  • Creating an aggregation
  • Module summary: Optimize a model for performance in Power BI

4 Readings

  • Exercise: Adding an aggregation
  • Exemplar: Adding an aggregation
  • How to manage aggregations step-by-step
  • Additional resources: Create and manage aggregations

Final project and assessment: Modeling data in Power BI

    • 1 Videos
    • 3 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Self-review: Building and optimizing a data model
  • Course quiz: Modeling data in Power BI

1 Videos

  • Course recap: Modeling data in Power BI

3 Readings

  • About the final project and assessment: Modeling data in Power BI
  • Exercise: Building and optimizing a data model
  • Exemplar: Building and optimizing a data model

Course wrap-up: Data modeling in Power BI

    • 1 Videos
    • 1 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Reflect on learning

1 Videos

  • Congratulations!

1 Readings

  • Next steps

Auto Summary

Embark on a journey to master data modeling with Power BI through this foundational course, perfect for those aiming to excel in data analysis. As part of the comprehensive Microsoft Power BI Analyst Professional Certificate, this course focuses on creating and maintaining robust data models using Power BI. Guided by expert instructors, you will delve into the essentials of Power BI's expression language, DAX, and learn to perform advanced calculations and time intelligence functions. The course also covers the creation of calculated columns and measures, optimizing model performance, and using schemas like the Star Schema for effective data modeling. Ideal for beginners, this course not only equips you with the skills to build insightful visualizations and analyses but also prepares you for the Microsoft PL-300 exam. Successfully passing this exam will earn you the Microsoft Power BI Data Analyst certification, a valuable credential for your career in big data and analytics. Available through Coursera, this course offers flexible subscription options, including a Starter package, making it accessible for everyone eager to enhance their data modeling expertise. Join now and take the first step towards becoming a proficient Power BI analyst!

Microsoft
Instructor

Microsoft