Who is this program for?

<text variant="body1">This program is for you: <text variant="body1">● If you want to switch or start a career in the field of data analytics. ● If you are interested in the field of data analytics, just beginning to work with business intelligence and data analysis solutions and services, or new to Microsoft Power BI.

What background knowledge is necessary?

You don’t need any background knowledge to take this Professional Certificate. Whether you’re just starting out or a professional in a relevant field, this program can be the right fit for you.

How long does it take to complete the Professional Certificate?

<text variant="body1">It typically takes 5 months to complete the 8 courses. But some learners may go through the content faster.

What is the main benefit of a Professional Certificate?

Whether you’re looking to start a new career or change your current one, Professional Certificates help you become job ready. Apply your new skills on hands-on projects that showcase your expertise to potential employers and earn a career credential to kickstart your new career.

What will I be able to do upon completing the Professional Certificate?

<text variant="body1">Once you have completed this Professional Certificate, you’ll have built a foundational knowledge of the key concepts and tools in Power BI and how they apply to a business environment including: <text variant="body1">• The ability to implement best practices when conducting Data Analysis. <text variant="body1">• The skills to use the visualization and report capabilities of Power BI to create compelling reports and dashboards. • The ability to provide valuable data insights that help to inform business decisions.

What does a Power BI analyst do?

Power BI Data Analysts design, develop, and deploy business analytics dashboards using Microsoft Power BI. Data analysts are essential in helping organizations gain valuable insights into the expanse of data that they have, and they work closely with others in the organization to help reveal valuable information.

Data Analyst, Business Intelligence Analyst and Power BI Analyst: What’s the Difference?

Data analysts and business intelligence analysts both help drive data-driven decision-making in their organizations. Data analysts tend to work more closely with the data itself, while business intelligence analysts tend to be more involved in using the results of data analysis to address business needs and recommend solutions. The Power BI data analyst is a combination of both of these roles. They work closely with business stakeholders to identify business requirements and collaborate with enterprise data analysts and data engineers to identify and acquire data. They also transform the data, create data models, visualize data, and share assets by using Power BI. These are all highly sort after roles.

What jobs can I get with Power BI data analytics skills?

<text variant="body1">Prepare for a career as a data analyst using Power BI. The Power BI skills you learn in this program prepare you for an entry-level role as a data analyst. An entry-level role as a data analyst is a great starting point and can be the first step towards building a career as a business intelligence analyst, data scientist or data engineer.

Will I be able to complete this course online?

This course is completely online. You can access your lessons, readings, and assignments anytime and anywhere via the web or your mobile device.

Do I need to take the courses in specific order?

<text variant="body1">We highly recommend taking the courses of each certificate program in the order they are presented. The content in the courses builds on information from earlier courses. The final course contains a practice exam that assesses your knowledge of the content covered in the previous courses. As such, it makes the most sense to take the courses in the order they are presented.

When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Specialization?

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Modeling Data in Power BI

This course is part of Microsoft Power BI and Power Platform for Productivity Specialization

Instructor: Microsoft

2,610 already enrolled

Included with

Learn more

4 modules

Gain insight into a topic and learn the fundamentals.

13 reviews

Beginner level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

13 reviews

Beginner level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

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.

Skills you'll gain

Tools you'll learn

Power BI

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

24 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Microsoft Power BI and Power Platform for Productivity Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 4 modules in this course

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.

Module details

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

What's included

13 videos20 readings6 assignments2 discussion prompts

13 videosTotal 68 minutes

Course introduction4 minutes
Introduction to data models5 minutes
Introduction to schemas6 minutes
Setting up a Flat schema in Power BI5 minutes
Understanding fact and dimension tables4 minutes
Introduction to cardinality5 minutes
Introduction to cross-filter direction5 minutes
Defining data granularity6 minutes
Setting up a Star schema in Power BI6 minutes
Setting up a Snowflake schema6 minutes
Why it is important to use Snowflake schema4 minutes
Resolving challenges in data models5 minutes
Module summary: Concepts for data modeling6 minutes

20 readingsTotal 225 minutes

Course syllabus10 minutes
How to be successful in this course10 minutes
How to open an image in a new tab10 minutes
Setting up your Power BI environment10 minutes
Additional resources: Concepts for data modeling5 minutes
Model view in Power BI10 minutes
Schemas cheatsheet10 minutes
Table and column properties cheatsheet10 minutes
Exercise: Configuring a Flat schema30 minutes
Exemplar: Configuring a Flat schema10 minutes
Activity: Configure a Flat schema with multiple sources10 minutes
Additional resources: Introduction to data models10 minutes
Normalization and denormalization10 minutes
Managing model relationships10 minutes
Model relationships cheatsheet10 minutes
Additional resources: Introduction to cardinality and cross-filter direction5 minutes
Exercise: Configuring a Star schema30 minutes
Exemplar: Configuring a Star schema10 minutes
Activity: Changing your Star schema into a Snowflake schema10 minutes
Additional resources: Working with advanced data models5 minutes

6 assignmentsTotal 95 minutes

Self-review: Configuring a Flat schema10 minutes
Knowledge check: Introduction to data models15 minutes
Knowledge check: Introduction to cardinality and cross-filter direction15 minutes
Self-review: Configuring a Star schema10 minutes
Knowledge check: Working with advanced data models15 minutes
Module quiz: Concepts for data modeling30 minutes

2 discussion promptsTotal 20 minutes

Discussion prompt: What do you hope to learn?10 minutes
Why is data modeling important in the data analysis process?10 minutes

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.

What's included

23 videos20 readings10 assignments1 discussion prompt

23 videosTotal 113 minutes

Introduction to Data Analysis Expressions (DAX)6 minutes
Row context and filter context6 minutes
Formulas and functions in DAX5 minutes
Introduction to calculated tables5 minutes
Creating calculated columns5 minutes
Introduction to measures5 minutes
Types of measures5 minutes
Basic statistical functions5 minutes
Context and DAX measures4 minutes
Creating quick measures6 minutes
Creating custom measures with DAX4 minutes
Introduction to the CROSSFILTER function5 minutes
Using CALCULATE with filters5 minutes
Introduction to role-playing dimensions6 minutes
Introduction to the USERELATIONSHIP function5 minutes
Configuring role-playing dimensions3 minutes
The importance of time intelligence5 minutes
Using DAX for summarization over time6 minutes
Using DAX for comparison over time5 minutes
Setting up a common date table5 minutes
Setting up a common date table with M and Power Query4 minutes
Time intelligence in business3 minutes
Module summary: Using DAX in Power BI7 minutes

20 readingsTotal 255 minutes

DAX cheatsheet10 minutes
Cloning and calculating tables10 minutes
Exercise: Adding a calculated table and column30 minutes
Exemplar: Adding a calculated table and column10 minutes
Additional resources: Introduction to DAX5 minutes
Statistical functions cheatsheet10 minutes
Additional resources: Introduction to measures5 minutes
Exercise: Adding a measure30 minutes
Exemplar: Adding a measure10 minutes
Filter functions in CALCULATE10 minutes
Activity: Using the CALCULATE function10 minutes
Additional resources: Working with measures5 minutes
Exercise: Adding a role-playing dimension30 minutes
Exemplar: Adding a role-playing dimension10 minutes
Additional resources: DAX and table relationships5 minutes
Additional time intelligence functions10 minutes
Exercise: Using time intelligence to compare to previous year30 minutes
Exemplar: Using time intelligence to compare to previous year10 minutes
Activity: Set up a common date table10 minutes
Additional resources: Time intelligence and calculations in DAX5 minutes

10 assignmentsTotal 145 minutes

Self-review: Adding a calculated table and column10 minutes
Knowledge check: Using Data Analysis Expressions (DAX) in Power BI15 minutes
Knowledge check: Introduction to measures15 minutes
Self-review: Adding a measure10 minutes
Knowledge check: Working with measures15 minutes
Self-review: Adding a role-playing dimension10 minutes
Knowledge check: DAX and table relationships15 minutes
Self-review: Using time intelligence to compare to previous year10 minutes
Knowledge check: Time intelligence calculations in DAX15 minutes
Module quiz: Using DAX in Power BI30 minutes

1 discussion promptTotal 10 minutes

Which DAX features did you find most useful?10 minutes

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.

What's included

10 videos12 readings6 assignments1 discussion prompt

10 videosTotal 59 minutes

What is optimization and why is it necessary?7 minutes
Optimization by example7 minutes
Resolving performance issues in the data model5 minutes
Identifying and reducing cardinality levels6 minutes
Behavior and limitations of DirectQuery connections7 minutes
Optimizing DirectQuery performance with query reductions4 minutes
Optimizing DirectQuery performance with table storage6 minutes
What are aggregations and why use them?6 minutes
Creating an aggregation6 minutes
Module summary: Optimize a model for performance in Power BI8 minutes

12 readingsTotal 145 minutes

Exercise: Improving data model performance30 minutes
Exemplar: Improving data model performance10 minutes
Optimizing columns and metadata10 minutes
Optimizing the Auto date/time feature10 minutes
Activity: Optimizing the columns and Auto date/time10 minutes
Additional resources: Optimize performance in a Power BI model5 minutes
Walk-through: Optimizing a DirectQuery model10 minutes
Additional resources: Optimize DirectQuery models5 minutes
Exercise: Adding an aggregation30 minutes
Exemplar: Adding an aggregation10 minutes
How to manage aggregations step-by-step 10 minutes
Additional resources: Create and manage aggregations5 minutes

6 assignmentsTotal 95 minutes

Self-Review: Improving data model performance10 minutes
Knowledge check: Optimize a model for performance in Power BI15 minutes
Knowledge check: Optimize DirectQuery models15 minutes
Self-review: Adding an aggregation10 minutes
Knowledge check: Create and manage aggregations15 minutes
Module quiz: Optimize a model for performance in Power BI30 minutes

1 discussion promptTotal 10 minutes

How would performance and optimization impact different stakeholders?10 minutes

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.