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
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.
UDACITY40
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
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
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
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 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
Here are nine courses similar to
Preparing and Modeling Data with Power BI.
Preparing and Modeling Data with Power BI Fluency
OpenCourser.com/course/yogf60/preparing
Preparing and Modeling Data with Power BI Fluency
Most relevant
Modeling Data in Power BI
OpenCourser.com/course/dtehdb/modeling
Modeling Data in Power BI
Most relevant
Extract, Transform and Load Data in Power BI
OpenCourser.com/course/usomlh/extract
Extract, Transform and Load Data in Power BI
Most relevant
Data Preparation and Modeling
OpenCourser.com/course/9o4r5e/data
Data Preparation and Modeling
Most relevant
Power BI Essentials
OpenCourser.com/course/xv2r86/power
Power BI Essentials
Most relevant
Business Intelligence Workflow with Excel 2019
OpenCourser.com/course/k5wk3m/business
Business Intelligence Workflow with Excel 2019
Build and deploy a stroke prediction model using R
OpenCourser.com/course/gbqntb/build
Build and deploy a stroke prediction model using R
Cleaning Data with Pandas
OpenCourser.com/course/zo6085/cleaning
Cleaning Data with Pandas
Analytical Solutions to Common Healthcare Problems
OpenCourser.com/course/ua6umi/analytical
Analytical Solutions to Common Healthcare Problems
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
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