All   >   Power BI – Data Modeling (2024)

Power BI – Data Modeling (2024)

Learn to use Power BI to design and build a well-structured data model.
Power Bi - Data Modeling (2024)

Course details

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 

Course details

Related Course Recommendations

Microsoft Teams Shifts (2024)

Microsoft Teams Shifts (2024)

Power BI – Using Visuals (2024)

Power BI - Using Visuals (2024)

Microsoft Teams Fundamentals (2024)

Microsoft Teams Fundamentals (2024)

Windows 11 Essentials (2024)

Windows 11 Essentials

Bigger Brains Course Catalog and Pricing

Fill out the information below to receive a download link for our latest course catalog.

I am getting training for…