Power BI - Data Modeling (2024)

Focused View

Bigger Brains

30:40

0 View

1 - Connect to Data

1 - Course-Description-Power-BI-Data-Modeling-2024.docx

1 - Introduction.mp4

01:45

1 - Power-BI-Data-Modeling-Data-Files.zip

2 - Options for Data Connections.mp4

04:49

3 - Connecting to Data.mp4

04:53

2 - Clean and Transform Data

4 - Cleaning Data with Power Query Editor.mp4

06:30

5 - Transforming Data with Power Query Editor.mp4

05:31

3 - Model Data with Relationships

6 - Creating OneToMany Relationships.mp4

07:12

Description

Learn the essentials of building an effective data model

What You'll Learn?

Identify which data sources are available for connection
Explain the difference between a direct query and importing data
Determine Data Load settings before importing data
Connect to Excel and CSV files and to data stored in a SharePoint list
Enter data to load as a data source
Determine the integrity of the data by previewing the column quality, distribution, and profile
Change data types and work with applied steps
Merge tables
Split columns by a delimiter

Who is this for?

Participants who have a basic understanding of Power BI and relational data and want to learn the essentials of building data models.

What You Need to Know?

Basics knowledge in data model will be helpful

More details

Description
Learn to use Power BI to design and build a well-structured data model.
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
Who this course is for:
Participants who have a basic understanding of Power BI and relational data and want to learn the essentials of building data models.

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Bigger Brains

Instructor's Courses

Let's face it, no online training courses are "fun." But some (like Bigger Brains) are engaging and better to spend time on than others! Bigger Brains courses are built in a unique Teacher/Learner style, featuring two people on camera to recreate some of the interactivity and physiological benefits of classroom training, including dialogue, humor, and practical use case examples. This uniquely engaging video-based format is more enjoyable and, more importantly, more effective than traditional eLearning formats. Bigger Brains courses are popular with both learners and training professionals around the world. Because we use experienced teachers and subject matter experts with real-world experience, we have the most realistic and comprehensive online training courses possible.There are also resources to help you learn along with the way. Most Bigger Brains courses include handouts and practice files. Some even include free post-training reinforcement through the BrainBot learning retention app.Join the hundreds of thousands of learners around the world and upskill, reskill, and stay in the know with Bigger Brains!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.