We may earn an affiliate commission when you visit our partners.
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
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/2uxt30/preparing
Here's a deal for you
Save money when you learn with a deal that may be relevant to this course.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
OPENCOURSER
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
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
Traffic lights
Traffic lights
Read about what's good
what should give you pause 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
Create your own learning path.
Save this course to your list so you can find it easily later.
Save
Save
Reviews summary
Practical power bi data preparation & modeling
According to learners, 'Preparing and Modeling Data with Power BI' is a largely positive and highly practical course for those looking to master data preparation and modeling. Students particularly praise the clear explanations from the instructor and the emphasis on hands-on activities, culminating in a valuable capstone project. The course excels at teaching Power Query (M language) and data transformations, providing a strong foundation for aspiring business analysts. While many find the pacing excellent for beginners, a few intermediate learners suggest that some DAX concepts could be explored in greater depth or that the course might feel too basic if they already have prior experience. Overall, it's considered highly relevant for professional skill development.
Course content aligns well with current industry needs, especially for business analysts.
"The content is very relevant for business analysts."
"I learned how to use practical tools and strategies that I could apply immediately to my work."
"The emphasis on cleaning and transforming data before visualization was very helpful for my reporting needs."
Excellent for mastering data cleaning, transformation, and modeling in Power BI.
"This course was exactly what I needed to get started with Power BI data modeling."
"The modules on Power Query (M language) and data transformations were incredibly useful."
"I learned a ton about preparing data for Power BI reports. The emphasis on cleaning and transforming data before visualization was very helpful."
"I've been struggling with messy data, and this course provided clear strategies."
Instructor effectively breaks down complex Power BI and DAX concepts.
"The instructor's explanations of DAX were so clear, and the project at the end really tied everything together."
"The explanations were easy to follow, and the exercises reinforced the concepts well."
"The instructor breaks down complex topics like relationships and filters into understandable chunks."
"This course clarified so many concepts I struggled with, especially how to split data into fact and dimension tables."
Emphasizes real-world application through exercises and a capstone project.
"The project at the end really tied everything together. I feel much more confident preparing data now. Highly recommend for anyone new to Power BI!"
"I liked the hands-on approach and the focus on practical applications."
"The practical project at the end was invaluable. It allowed me to apply everything I learned."
"The examples were very practical and relatable to real-world business scenarios, making learning effective."
Excellent for beginners, but some find it too basic or slow for intermediate users.
"Sometimes the pace felt a bit slow for me, as I had some prior Excel experience..."
"I found some of the DAX concepts rushed. I had to do a lot of external research to fully grasp them."
"Too basic for me. I was expecting more advanced data modeling techniques and DAX formulas."
"It covers the fundamentals well, but felt it stopped short of truly advanced modeling."
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 Preparing and Modeling Data with Power BI with these
activities:
Practice Using Different Data Transformation Functions
Show steps
This activity will allow you to practice using different data transformation functions, such as filtering, sorting, and merging, which will help you become more proficient in using Power BI.
Browse courses on
Data Transformation
Show steps
-
Import a dataset into Power BI.
-
Explore the different data transformation functions available in Power BI.
-
Practice using the different data transformation functions to clean and prepare your data.
-
Create a report based on your transformed data.
Follow Tutorials on Advanced Data Modeling Techniques
Show steps
This activity will allow you to learn about advanced data modeling techniques, such as using DAX and creating hierarchies, which will help you build more complex and powerful data models.
Browse courses on
Data Modeling
Show steps
-
Find tutorials on advanced data modeling techniques.
-
Follow the tutorials and practice using the techniques.
-
Apply the techniques to your own data models.
Build a Data Model for a Real-World Dataset
Show steps
This activity will allow you to apply the skills you have learned in the course to a real-world dataset, which will help you gain experience in building data models.
Browse courses on
Data Modeling
Show steps
-
Choose a real-world dataset to work with.
-
Import the dataset into Power BI.
-
Create a data model for the dataset.
-
Create a report based on your data model.
Show all three activities
Practice Using Different Data Transformation Functions
Show steps
This activity will allow you to practice using different data transformation functions, such as filtering, sorting, and merging, which will help you become more proficient in using Power BI.
Browse courses on
Data Transformation
Show steps
Show steps
Show steps
- Import a dataset into Power BI.
- Explore the different data transformation functions available in Power BI.
- Practice using the different data transformation functions to clean and prepare your data.
- Create a report based on your transformed data.
Follow Tutorials on Advanced Data Modeling Techniques
Show steps
This activity will allow you to learn about advanced data modeling techniques, such as using DAX and creating hierarchies, which will help you build more complex and powerful data models.
Browse courses on
Data Modeling
Show steps
Show steps
Show steps
- Find tutorials on advanced data modeling techniques.
- Follow the tutorials and practice using the techniques.
- Apply the techniques to your own data models.
Build a Data Model for a Real-World Dataset
Show steps
This activity will allow you to apply the skills you have learned in the course to a real-world dataset, which will help you gain experience in building data models.
Browse courses on
Data Modeling
Show steps
Show steps
Show steps
- Choose a real-world dataset to work with.
- Import the dataset into Power BI.
- Create a data model for the dataset.
- Create a report based on your data model.
Show all three activities
Career center
Learners who complete Preparing and Modeling Data with Power BI will develop knowledge and skills
that may be useful to these careers:
For more career information including salaries, visit:
OpenCourser.com/course/2uxt30/preparing
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.
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.
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.
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.
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.
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.
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.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/2uxt30/preparing
Share
Similar courses
Similar courses are unavailable at this time. Please try again later.
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 - 2025 OpenCourser