Data Modeling in Power BI (Coursera)

Data Modeling in Power BI (Coursera)
Course Auditing
Categories
Effort
Certification
Languages
Previous data analysis experience is not necessary. You need to be familiar with using computers and it helps if you enjoy questioning information.
Misc

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Data Modeling in Power BI (Coursera)
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.

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

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.

This course is part of the Microsoft Power BI Data Analyst Professional Certificate.


What you'll learn

- How to form a model using a Star Schema.

- How to write calculations DAX to create elements and analysis in Power BI.

- How to optimize performance in a Power BI model.


Syllabus


Concepts for data modeling

Module 1

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


Using Data Analysis Expressions (DAX) in Power BI

Module 2

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

Module 3

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

Module 4

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.



MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Course Auditing
45.00 EUR/month
Previous data analysis experience is not necessary. You need to be familiar with using computers and it helps if you enjoy questioning information.

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.