Data Modeling in Power BI from 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.

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.

What's inside

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.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Develops knowledge and skills beneficial for a career in data analytics

Examines foundational concepts of data modeling

Provides hands-on practice in creating and maintaining relationships in a data model

Teaches the basics of DAX, the expression language of Power BI

Trains learners to create calculated columns and measures in a model

Helps learners optimize the performance of Power BI models

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Data Modeling in Power BI with these activities:

Review your notes from previous data analysis courses

Show steps

Strengthen your foundation by revisiting key concepts from previous data analysis courses.

Browse courses on Data Analysis

Show steps

Gather your notes and materials from previous data analysis courses
Review the notes and refresh your understanding of fundamental concepts

Follow a tutorial on optimizing a Power BI model

Show steps

Gain practical insights into optimizing Power BI models for improved performance by following a guided tutorial.

Browse courses on Performance Tuning

Show steps

Search for a tutorial on optimizing Power BI models
Follow the steps outlined in the tutorial
Apply the optimization techniques to your own Power BI model

Practice creating and maintaining relationships in a data model

Show steps

Reinforce your understanding of the concepts of data modeling and practice creating and maintaining relationships in a data model.

Browse courses on Data Modeling

Show steps

Review the module on data modeling
Create a simple data model with multiple tables
Establish relationships between the tables
Test the relationships by creating a query

Five other activities

Expand to see all activities and additional details

Show all eight activities

Discuss data modeling best practices with peers

Show steps

Expand your knowledge and gain different perspectives on data modeling best practices by discussing with peers.

Show steps

Join a peer study group or online forum
Engage in discussions on data modeling techniques
Share and compare your experiences with others

Create a DAX expression to calculate a new measure

Show steps

Enhance your understanding of DAX by creating a custom measure using DAX expressions.

Browse courses on DAX

Show steps

Review the module on DAX
Identify a business requirement for a new measure
Write a DAX expression to calculate the measure
Add the measure to a report

Build a Power BI dashboard to track key performance indicators (KPIs)

Show steps

Apply your knowledge to a practical project by building a Power BI dashboard to track key performance indicators (KPIs).

Show steps

Define the KPIs you want to track
Gather the necessary data
Design and create the Power BI dashboard
Configure alerts and notifications
Share the dashboard with stakeholders

Volunteer to create data visualizations for a non-profit organization

Show steps

Apply your Power BI skills to make a positive impact by creating data visualizations to support the mission of a non-profit organization.

Browse courses on Data Visualization

Show steps

Research non-profit organizations that align with your interests
Contact the organization and offer your services
Understand the organization's data and storytelling needs
Use Power BI to create visualizations that communicate insights effectively

Contribute to an open-source data analysis project on GitHub

Show steps

Enhance your skills and learn from others by contributing to an open-source data analysis project on GitHub.

Show steps

Find an open-source data analysis project on GitHub
Review the project's documentation and codebase
Identify an area where you can contribute
Submit a pull request with your contributions

Career center

Learners who complete Data Modeling in Power BI will develop knowledge and skills that may be useful to these careers:

Power BI Developer

**Power BI Developers** develop and implement Power BI solutions. They use Power BI to create reports, dashboards, and visualizations. This course is essential for Power BI Developers who want to learn how to create and maintain data models in Power BI. The course will teach Power BI Developers the skills they need to be successful in this role.

See salaries and explore the career path for Power BI Developer

Business Analyst

**Business Analysts** use data to improve business processes. They analyze data to identify areas for improvement and develop and implement solutions. This course may be useful for Business Analysts who want to learn how to use Power BI to create and maintain data models. The course can help Business Analysts build a foundation in data modeling and DAX, which are essential skills for success in this role.

See salaries and explore the career path for Business Analyst

Data Architect

**Data Architects** design and build data architectures. They use data architectures to ensure that data is available, reliable, and secure. This course may be useful for Data Architects who want to learn how to use Power BI to create and maintain data models. The course can help Data Architects build a foundation in data modeling and DAX, which are essential skills for success in this role.

See salaries and explore the career path for Data Architect

Software Engineer

**Software Engineers** design and develop software applications. They use software applications to solve problems and improve efficiency. This course may be useful for Software Engineers who want to learn how to use Power BI to create and maintain data models. The course can help Software Engineers build a foundation in data modeling and DAX, which are essential skills for success in this role.

See salaries and explore the career path for Software Engineer

Data Analyst

**Data Analysts** use data to solve business problems. They analyze data to identify trends and patterns. They also develop and implement data-driven solutions. This course may be useful for Data Analysts who want to learn how to use Power BI to create and maintain data models. The course can help Data Analysts build a foundation in data modeling and DAX, which are essential skills for success in this role.

See salaries and explore the career path for Data Analyst

Database Administrator

**Database Administrators** manage and maintain databases. They ensure that databases are available, reliable, and secure. This course may be useful for Database Administrators who want to learn how to use Power BI to create and maintain data models. The course can help Database Administrators build a foundation in data modeling and DAX, which are essential skills for success in this role.

See salaries and explore the career path for Database Administrator

Financial Analyst

**Financial Analysts** use data to analyze financial performance. They use data to identify trends and patterns and develop and implement financial plans. This course may be useful for Financial Analysts who want to learn how to use Power BI to create and maintain data models. The course can help Financial Analysts build a foundation in data modeling and DAX, which are essential skills for success in this role.

See salaries and explore the career path for Financial Analyst

Data Scientist

**Data Scientists** use data to build predictive models. They use these models to identify risks and opportunities and develop data-driven solutions. This course may be useful for Data Scientists who want to learn how to use Power BI to create and maintain data models. The course can help Data Scientists build a foundation in data modeling and DAX, which are essential skills for success in this role.

See salaries and explore the career path for Data Scientist

Operations Analyst

**Operations Analysts** use data to analyze operational performance. They use data to identify trends and patterns and develop and implement operational improvements. This course may be useful for Operations Analysts who want to learn how to use Power BI to create and maintain data models. The course can help Operations Analysts build a foundation in data modeling and DAX, which are essential skills for success in this role.

See salaries and explore the career path for Operations Analyst

Data Engineer

**Data Engineers** design and build data pipelines. They use data pipelines to collect, clean, and store data. This course may be useful for Data Engineers who want to learn how to use Power BI to create and maintain data models. The course can help Data Engineers build a foundation in data modeling and DAX, which are essential skills for success in this role.

See salaries and explore the career path for Data Engineer

Web Analyst

**Web Analysts** use data to analyze website performance. They use data to identify trends and patterns and develop and implement website improvements. This course may be useful for Web Analysts who want to learn how to use Power BI to create and maintain data models. The course can help Web Analysts build a foundation in data modeling and DAX, which are essential skills for success in this role.

See salaries and explore the career path for Web Analyst

Data Visualization Analyst

**Data Visualization Analysts** use data visualization to communicate data insights. They create charts, graphs, and other visuals to help people understand data. This course may be useful for Data Visualization Analysts who want to learn how to use Power BI to create and maintain data models. The course can help Data Visualization Analysts build a foundation in data modeling and DAX, which are essential skills for success in this role.

See salaries and explore the career path for Data Visualization Analyst

Sales Analyst

**Sales Analysts** use data to analyze sales performance. They use data to identify trends and patterns and develop and implement sales strategies. This course may be useful for Sales Analysts who want to learn how to use Power BI to create and maintain data models. The course can help Sales Analysts build a foundation in data modeling and DAX, which are essential skills for success in this role.

See salaries and explore the career path for Sales Analyst

Product Analyst

**Product Analysts** use data to analyze product performance. They use data to identify trends and patterns and develop and implement product improvements. This course may be useful for Product Analysts who want to learn how to use Power BI to create and maintain data models. The course can help Product Analysts build a foundation in data modeling and DAX, which are essential skills for success in this role.

See salaries and explore the career path for Product Analyst

Marketing Analyst

**Marketing Analysts** use data to analyze marketing performance. They use data to identify trends and patterns and develop and implement marketing campaigns. This course may be useful for Marketing Analysts who want to learn how to use Power BI to create and maintain data models. The course can help Marketing Analysts build a foundation in data modeling and DAX, which are essential skills for success in this role.

See salaries and explore the career path for Marketing Analyst

Data Modeling in Power BI

What's inside

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses