Power BI Data Methods
Focused View
Helen Wall
3:12:18
1,418 View
01 - The data at the core of Power BI.mp4
00:38
02 - What you should know.mp4
01:01
03 - Course project overview.mp4
05:50
01 - Working with Power Query.mp4
02:09
02 - The extract, transform, load (ETL) framework.mp4
02:29
03 - Power Query objects.mp4
02:42
01 - Connecting to text files.mp4
06:57
02 - Connecting to CSV files.mp4
05:30
03 - Connecting to Excel files.mp4
03:32
04 - Connecting to online Excel files.mp4
03:45
05 - Connecting to PDF files.mp4
04:42
06 - Connecting to images as data.mp4
04:32
07 - Setting up folder connection.mp4
07:10
08 - Connecting to HTML and XML.mp4
04:30
09 - Connecting to JSON data.mp4
04:11
10 - Connecting to APIs.mp4
04:20
11 - Connecting to ODATA feeds.mp4
02:07
12 - Connecting to GitHub.mp4
04:06
13 - Using an R script connector.mp4
03:44
14 - Using a Python script connector.mp4
02:42
15 - Challenge Getting data.mp4
00:58
16 - Solution Getting data.mp4
03:09
01 - Cleaning text fields.mp4
02:58
02 - Removing or replacing values.mp4
02:49
03 - Splitting and concatenating fields.mp4
04:11
04 - Text formulas.mp4
04:22
05 - Filtering or removing duplicates.mp4
05:04
06 - Filling up and filling down.mp4
01:26
07 - Transforming numerical fields.mp4
02:48
08 - Challenge Add a new column.mp4
00:22
09 - Solution Add a new column.mp4
01:32
01 - Dates functions.mp4
07:32
02 - Creating a dates table.mp4
04:43
03 - Working with different time zones.mp4
03:28
04 - Challenge Add a Date field.mp4
00:26
05 - Solution Add a Date field.mp4
01:36
01 - Using conditional functions.mp4
06:28
02 - Transposing tables.mp4
02:50
03 - Grouping fields and values.mp4
03:46
04 - Merging and appending data.mp4
05:02
05 - Pivoting and unpivoting data.mp4
05:36
06 - Parameters.mp4
05:26
07 - Custom functions.mp4
06:38
08 - Adding data types in M code.mp4
04:25
01 - Working with relational databases.mp4
04:35
02 - Query folding.mp4
04:47
03 - Working with multidimensional databases.mp4
04:03
01 - Loading data.mp4
04:43
02 - Managing errors.mp4
04:23
03 - Refreshing data.mp4
05:05
01 - Continuing on with Power BI.mp4
00:30
Description
Power BI is a powerful business intelligence tool designed to help users create dynamic interactive data visualizations and help you monitor data, analyze trends, and make smarter decisions. Before you can create any visuals though, you need to get your data into Power BI to use in the modeling process. In this course, Helen Wall helps you handle, import, and transform your data more efficiently, using the built-in power of Power Query. Helen shows you how to create ETL frameworks and use Power Query to extract data from multiple data sources, transform it through functionalities like grouping and pivoting, and load it into the Power BI model.
More details
User Reviews
Rating
average 0
Focused display
Category
Helen Wall
Instructor's CoursesFollow me to see my latest published content on data science, analytics, and visualization! Aficionado of Power BI, AWS, Tableau, and Excel (including Power Query), and currently diving deep into the world of Python, R, and AI (including machine learning). Designer and developer of business intelligence dashboards and visualizations supporting many business functions and industries.
Linkedin Learning
View courses Linkedin LearningLinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications.
It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.
- language english
- Training sessions 51
- duration 3:12:18
- English subtitles has
- Release Date 2024/05/24
