OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Course image
Udacity logo

Preparing and Modeling Data with Power BI

Lenore R Flower

Prepare and model data from multiple sources with Udacity's online Data Modeling Training Course. Learn how to combine, clean, restructure, and harmonize data.

Prerequisite details

Read more

Prepare and model data from multiple sources with Udacity's online Data Modeling Training Course. Learn how to combine, clean, restructure, and harmonize data.

Prerequisite details

To optimize your success in this program, we've created a list of prerequisites and recommendations to help you prepare for the curriculum. Prior to enrolling, you should have the following knowledge:

  • Intermediate spreadsheet use

You will also need to be able to communicate fluently and professionally in written and spoken English.

Enroll now

What's inside

Syllabus

Meet your instructor, get an overview of the course, and learn some fundamental concepts about how Power BI is used to prepare data and generate easy-to-understand visual reports.
Read more
Learn core concepts of data modeling in Power BI, including how to make your data model more efficient by splitting it into fact tables and dimension tables.
Learn how to gather your data using the Get Data feature and tidy it up using basic transformations, so that it is ready for more advance transformations and data modeling.
Learn different ways we can take the data we have at our fingertips and use bigger transformations to morph it into what we need for our data model and, ultimately, our reporting.
This lesson is all about relationships and filters. We'll cover relationship cardinality and direction, filter direction, implicit DAX, quick measure, and custom DAX functions that rely on filters.
Go into greater depth on reports and DAX that is specifically helpful for reporting, including how to add basic components to your report and group the data using measures and calculated columns.
Create a data model to help Seven Sages Brewing Company better understand their sales and profitability.

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Introduces fundamental Power BI concepts and techniques, building a strong foundation for beginners
Covers core data modeling concepts in Power BI, which are essential for building efficient and effective data models
Provides hands-on practice with data gathering and transformation using Power BI's Get Data feature, enabling learners to prepare data for further analysis
Delves into advanced data transformations to help learners manipulate data and prepare it for data modeling and reporting
Explores relationships and filters in Power BI, providing a comprehensive understanding of how to connect and filter data for effective analysis
Develops reporting skills using Power BI, including adding report components, grouping data, and creating measures and calculated columns

Save this course

Save Preparing and Modeling Data with Power BI to your list so you can find it easily later:
Save

Activities

Coming soon We're preparing activities for Preparing and Modeling Data with Power BI. These are activities you can do either before, during, or after a course.

Career center

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

Reading list

We've selected six 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 Preparing and Modeling Data with Power BI.
Cover image
Expert Cube Development with SSAS Multidimensional...
Save
Provides a comprehensive overview of data modeling with Power BI, covering topics such as data sources, data transformation, and data visualization. It would be a valuable resource for learners who want to learn more about the fundamentals of data modeling.
Expert Cube Development with SSAS Multidimensional...
Kindle Edition
$$
Cover image
Optimizing DAX
Save
Focuses on the practical aspects of data modeling with Power BI, providing step-by-step instructions on how to create and use data models. It would be a great choice for learners who want to get hands-on experience with Power BI.
Optimizing DAX: Improving DAX performance in...
Paperback
$$$
Optimizing DAX: Improving DAX performance in...
Kindle Edition
$$$
Cover image
Pro Power BI Dashboard Creation
Save
Provides a comprehensive overview of Power BI, covering topics such as data modeling, data visualization, and data analysis. It would be a valuable resource for learners who want to learn about all aspects of Power BI.
Pro Power BI Dashboard Creation
Paperback
Check
Pro Power BI Dashboard Creation
Kindle Edition
Check
Cover image
The Definitive Guide to DAX
Save
Provides a quick and easy introduction to Power BI. It covers the basics of data modeling, data visualization, and data analysis, and would be a good choice for learners who want to get started with Power BI quickly.
The Definitive Guide to DAX: Business Intelligence...
Paperback
$$
The Definitive Guide to Dax (Business Skills)
Paperback
$$$
Definitive Guide to DAX, The: Business intelligence...
Kindle Edition
$$
Cover image
Microsoft SQL Server 2014 Unleashed
Save
Provides a comprehensive guide to optimizing the performance of Power BI data models. It covers topics such as identifying performance bottlenecks, optimizing data queries, and using performance optimization tools.
Microsoft SQL Server 2014 Unleashed
Kindle Edition
$$
Cover image
The Definitive Guide to DAX
Save
Provides a guide to using Power BI with Azure data services. It covers topics such as connecting to Azure data services from Power BI, using Azure data services to enhance Power BI reports, and deploying Power BI reports to Azure.
The Definitive Guide to DAX: Business Intelligence...
Paperback
$$
The Definitive Guide to Dax (Business Skills)
Paperback
$$$
Definitive Guide to DAX, The: Business intelligence...
Kindle Edition
$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to Preparing and Modeling Data with Power BI.
Preparing and Modeling Data with Power BI Fluency
Most relevant
Modeling Data in Power BI
Most relevant
Extract, Transform and Load Data in Power BI
Most relevant
Data Preparation and Modeling
Most relevant
Power BI Essentials
Most relevant
Business Intelligence Workflow with Excel 2019
Build and deploy a stroke prediction model using R
Cleaning Data with Pandas
Analytical Solutions to Common Healthcare Problems
Course image
Effort
4 weeks
Via
Udacity
Instructor
Lenore R Flower
Language
English
Good to know
Introduces fundamental Power BI concepts and techniques, building a strong foundation for beginners
Covers core data modeling concepts in Power BI, which are essential for building efficient and effective data models
Provides hands-on practice with data gathering and transformation using Power BI's Get Data feature, enabling learners to prepare data for further analysis
Delves into advanced data transformations to help learners manipulate data and prepare it for data modeling and reporting
Explores relationships and filters in Power BI, providing a comprehensive understanding of how to connect and filter data for effective analysis
Develops reporting skills using Power BI, including adding report components, grouping data, and creating measures and calculated columns
Share and help others discover this course
Facebook LinkedIn X Reddit Link Email
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