We may earn an affiliate commission when you visit our partners.
Mihaela Danci

Data models are the core of data analysis in Power BI. This course will teach you how to create data models that help you author simpler DAX queries and better reports.

Read more

Data models are the core of data analysis in Power BI. This course will teach you how to create data models that help you author simpler DAX queries and better reports.

Data modeling enables the advanced analytical capabilities required to provide meaningful insights, while reducing the complexity of DAX queries. In this course, Design and Build Tabular Models - DP-500, you’ll learn to solve business problems by leveraging the data modeling capabilities of Power BI. First, you’ll learn when to use Direct Query and external tools. Next, you’ll discover how to reduce the number of redundant measures by creating calculation groups. Finally, you’ll explore how to build composite models and implement security.

When you’re finished with this course, you’ll have the skills and knowledge of data modeling needed to design and build robust data models while enforcing security.

Enroll now

Here's a deal for you

We found an offer that may be relevant to this course.
Save money when you learn. All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

What's inside

Syllabus

Course Overview
Getting Started with Tabular Models
Using DAX
Working with Calculation Groups
Read more
Building Composite Models and Aggregations
Enforcing Security

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Teaches advanced analytical capabilities of Power BI for data modeling
Helps create simpler DAX queries and better reports
Taught by instructor Mihaela Danci
Learn how to solve business problems with Power BI modeling
Reduce complexities of DAX queries with data modeling

Save this course

Save Design and Build Tabular Models - DP-500 to your list so you can find it easily later:
Save

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 Design and Build Tabular Models - DP-500 with these activities:
Practice SQL
Refreshing your SQL skills will help you prepare for the course and make it easier to understand the data modeling concepts.
Browse courses on SQL
Show steps
  • Review the basics of SQL syntax.
  • Write practice SQL queries.
  • Test your queries on sample data.
Read "Data Modeling for Power BI"
This book provides a comprehensive overview of data modeling concepts and techniques in Power BI.
Show steps
  • Read the book and take notes.
  • Complete the practice exercises in the book.
Create a study guide
Creating a study guide will help you organize your notes and review the key concepts of the course.
Show steps
  • Review your notes from the course.
  • Organize your notes into a logical structure.
  • Add additional information from the textbook or other resources.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Join a study group
Joining a study group will provide you with an opportunity to collaborate with other students and discuss course concepts.
Show steps
  • Find other students who are taking the course.
  • Meet up regularly to discuss the course material.
Review DAX formulas
Practicing DAX formulas will strengthen your understanding of how to use them effectively in your data models.
Show steps
  • Create a list of common DAX formulas and their uses.
  • Write practice queries using DAX formulas.
  • Test your queries on sample data.
Create sample data models
Creating data models will help you apply the concepts you learn in the course and develop your data modeling skills.
Browse courses on Data Modeling
Show steps
  • Follow a tutorial to create a simple data model.
  • Create your own data model based on a real-world scenario.
Build a dashboard using your data model
Creating a dashboard based on your data model will allow you to visualize your data and communicate insights effectively.
Browse courses on Dashboard
Show steps
  • Design the layout of your dashboard.
  • Add visualizations to your dashboard.
  • Publish your dashboard and share it with others.
Participate in a data analysis competition
Participating in a data analysis competition will test your skills and knowledge of data modeling and Power BI.
Browse courses on Data Analysis
Show steps
  • Find a data analysis competition that you are interested in.
  • Prepare for the competition by practicing your skills.
  • Participate in the competition and do your best!

Career center

Learners who complete Design and Build Tabular Models - DP-500 will develop knowledge and skills that may be useful to these careers:
Data Analyst
Data Analysts who will be working with Power BI to design and query data models will benefit from the knowledge and skills taught in the Design and Build Tabular Models - DP-500 course. By learning how to create efficient and effective data models, Data Analysts will be able to improve the performance of their reports and analysis, and gain insights more quickly and easily.
Business Intelligence Analyst
Business Intelligence Analysts use data modeling to create reports and visualizations that help businesses make better decisions. The Design and Build Tabular Models - DP-500 course can teach Business Intelligence Analysts how to create data models that are efficient, effective, and secure, which will enable them to produce more accurate and insightful reports.
Data Architect
Data Architects design and build data models that support the business intelligence and analytics needs of an organization. The Design and Build Tabular Models - DP-500 course can teach Data Architects how to create data models that are scalable, maintainable, and secure.
Database Administrator
Database Administrators manage and maintain the databases that store the data used by business intelligence and analytics applications. The Design and Build Tabular Models - DP-500 course can teach Database Administrators how to create data models that are efficient, effective, and secure.
Data Engineer
Data Engineers build and maintain the data infrastructure that supports the business intelligence and analytics needs of an organization. The Design and Build Tabular Models - DP-500 course can teach Data Engineers how to create data models that are efficient, effective, and scalable.
Software Engineer
Software Engineers who are working on developing business intelligence and analytics applications will benefit from the knowledge and skills taught in the Design and Build Tabular Models - DP-500 course. By learning how to create efficient and effective data models, Software Engineers will be able to develop applications that are more performant and scalable.
Statistician
Statisticians use data to draw conclusions about the world. The Design and Build Tabular Models - DP-500 course can teach Statisticians how to create data models that are efficient, effective, and scalable.
Data Scientist
Data Scientists use data to build models that can predict future events or outcomes. The Design and Build Tabular Models - DP-500 course can teach Data Scientists how to create data models that are efficient, effective, and scalable.
Market Research Analyst
Market Research Analysts use data to understand the needs and wants of consumers. The Design and Build Tabular Models - DP-500 course can teach Market Research Analysts how to create data models that are efficient, effective, and scalable.
Operations Research Analyst
Operations Research Analysts use data to solve business problems. The Design and Build Tabular Models - DP-500 course can teach Operations Research Analysts how to create data models that are efficient, effective, and scalable.
Financial Analyst
Financial Analysts use data to make investment decisions. The Design and Build Tabular Models - DP-500 course can teach Financial Analysts how to create data models that are efficient, effective, and scalable.
Risk Analyst
Risk Analysts use data to identify and assess risks. The Design and Build Tabular Models - DP-500 course can teach Risk Analysts how to create data models that are efficient, effective, and scalable.
Consultant
Consultants use data to help businesses solve problems and improve performance. The Design and Build Tabular Models - DP-500 course can teach Consultants how to create data models that are efficient, effective, and scalable.
Product Manager
Product Managers use data to make decisions about the development and marketing of products. The Design and Build Tabular Models - DP-500 course can teach Product Managers how to create data models that are efficient, effective, and scalable.
Project Manager
Project Managers use data to plan and manage projects. The Design and Build Tabular Models - DP-500 course can teach Project Managers how to create data models that are efficient, effective, and scalable.

Reading list

We've selected nine books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Design and Build Tabular Models - DP-500.
Provides a deep dive into DAX, the formula language used in Power BI, and will greatly benefit learners who wish to take their DAX skills to the next level.
Provides a collection of DAX patterns that can be used to solve common data modeling and analysis problems.
Provides a comprehensive guide to data modeling and visualization in Power BI, covering topics such as data modeling techniques, DAX measures and calculations, and creating interactive reports.

Share

Help others find this course page by sharing it with your friends and followers:
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser