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.
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/t3mfb5/design
What's inside
Syllabus
Course Overview
Getting Started with Tabular Models
Using DAX
Working with Calculation Groups
Read more
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
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
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
Show steps
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"
Show steps
This book provides a comprehensive overview of data modeling concepts and techniques in Power BI.
View
Optimizing DAX: Improving DAX performance in...
on Amazon
Show steps
-
Read the book and take notes.
-
Complete the practice exercises in the book.
Create a study guide
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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!
Practice SQL
Show steps
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
Show steps
Show steps
- Review the basics of SQL syntax.
- Write practice SQL queries.
- Test your queries on sample data.
Read "Data Modeling for Power BI"
Show steps
This book provides a comprehensive overview of data modeling concepts and techniques in Power BI.
View
Optimizing DAX: Improving DAX performance in...
on Amazon
Show steps
Show steps
Show steps
- Read the book and take notes.
- Complete the practice exercises in the book.
Create a study guide
Show steps
Creating a study guide will help you organize your notes and review the key concepts of the course.
Show steps
Show steps
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
Show steps
Joining a study group will provide you with an opportunity to collaborate with other students and discuss course concepts.
Show steps
Show steps
Show steps
- Find other students who are taking the course.
- Meet up regularly to discuss the course material.
Review DAX formulas
Show steps
Practicing DAX formulas will strengthen your understanding of how to use them effectively in your data models.
Show steps
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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 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 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 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 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 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 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
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 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 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 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 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 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
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 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 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.
For more career information including salaries, visit:
OpenCourser.com/course/t3mfb5/design
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.
Is written by the original architects of dimensional data modeling and classic text on the subject.
Save
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.
Provides a thorough overview of data modeling in Power BI.
Provides a collection of recipes for solving common data modeling and analysis problems in Power BI.
Provides a comprehensive guide to deploying and managing Power BI in an enterprise environment.
Provides a comprehensive guide to data modeling in SQL Server.
Save
Provides a comprehensive guide to security in Power BI.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/t3mfb5/design
Share
Similar courses
Here are nine courses similar to
Design and Build Tabular Models - DP-500.
Modeling Data in Power BI
OpenCourser.com/course/dtehdb/modeling
Modeling Data in Power BI
Most relevant
Create Measures by Using DAX with Power BI
OpenCourser.com/course/qkgzbm/create
Create Measures by Using DAX with Power BI
Most relevant
Create Model Calculations by Using DAX
OpenCourser.com/course/obj45j/create
Create Model Calculations by Using DAX
Most relevant
Intermediate DAX & Time Intelligence
OpenCourser.com/course/fp0b5v/intermediate
Intermediate DAX & Time Intelligence
Most relevant
Power BI Data Analyst Associate Prep
OpenCourser.com/course/yzev0k/power
Power BI Data Analyst Associate Prep
Most relevant
Advanced DAX for Power BI
OpenCourser.com/course/kecbln/advanced
Advanced DAX for Power BI
Most relevant
Power BI Fundamentals
OpenCourser.com/course/63sou1/power
Power BI Fundamentals
Most relevant
Power BI Data Analyst Prep
OpenCourser.com/course/ij3blx/power
Power BI Data Analyst Prep
Most relevant
Common DAX Expressions and Scenarios Power BI Playbook
OpenCourser.com/course/64r5in/common
Common DAX Expressions and Scenarios Power BI Playbook
Most relevant
Time
72 hours
Level
Intermediate
Via
Pluralsight
Instructor
Mihaela Danci
Language
English
Good to know
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
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