Power BI – Data Modeling (2024)
Course details
- No. of Lessons: 6
- Duration: 30:40
- Skill level: Everyone
- Captions: Not Captioned
- Also included: Practice Files, Knowledge Check, High-quality HD content in the “Uniquely Engaging™” Bigger Brains Teacher-Learner style!
Power BI is a powerful tool for analyzing and reporting data. In Power BI Data Modeling, Microsoft Trainer Kathy Snizaski demonstrates how to use Power BI for building and transforming working data models. You’ll learn how to connect to various data sources, transform data, and build relationships between tables.
Kathy will show you how to identify which data sources are available for connection and how to determine Data Load settings before importing data. You’ll see how to connect to Excel files, CSV files, and SharePoint list data and how to manually enter data to load as a data source.
You’ll learn how to clean data by first determining the data integrity and then changing the data types and working with applied steps. You’ll also learn how to transform the data using multiple tools as well as how to manage relationships between tables and determine cardinality. By the end of this course, you will have the information you need to effectively use Power BI to build your data models.
Topics covered include:
- Identifying which data sources are available for connection
- Explaining the difference between a direct query and importing data
- Determining Data Load settings before importing data
- Connecting to Excel and CSV files and to data stored in a SharePoint list
- Entering data to load as a data source
- Determining the integrity of the data by previewing the column quality, distribution, and profile
- Changing data types and working with applied steps
- Merging tables
- Splitting columns by a delimiter
- Unpivoting fields within a query
- Managing relationships between tables
- Determining cardinality
Enjoy award winning HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!
Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives, and include captions and transcripts in 29 languages, downloadable handouts, and optional LinkedIn digital badges on course completion.
Course Contents:
| # | Lesson | Length |
| 1 | Introduction | 1:45 |
| 2 | Options for Data Connections | 4:49 |
| 3 | Connecting to Data | 4:53 |
| 4 | Cleaning Data with Power Query Editor | 6:30 |
| 5 | Transforming Data with Power Query Editor | 5:31 |
| 6 | Creating One-To-Many Relationships | 7:12 |
