Power BI Data Methods

Course details

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.

Concepts

0. Introduction

01 - The data at the core of Power BI
02 - What you should know
03 - Course project overview

1. Extracting Data from Files

04 - Working with Power Query
05 - The extract, transform, load (ETL) framework
06 - Power Query objects

2. Extracting Data from Files

07 - Connecting to text files
08 - Connecting to CSV files
09 - Connecting to Excel files
10 - Connecting to online Excel files
11 - Connecting to PDF files
12 - Connecting to images as data
13 - Setting up folder connection
14 - Connecting to HTML and XML
15 - Connecting to JSON data
16 - Connecting to APIs
17 - Connecting to ODATA feeds
18 - Connecting to GitHub
19 - Using an R script connector
20 - Using a Python script connector
21 - Challenge - Getting data
22 - Solution - Getting data

3. Transforming Data with Cleaning Operations

23 - Cleaning text fields
24 - Removing or replacing values
25 - Splitting and concatenating fields
26 - Text formulas
27 - Filtering or removing duplicates
28 - Filling up and filling down
29 - Transforming numerical fields
30 - Challenge - Add a new column
31 - Solution - Add a new column

4. Working with Dates and Times

32 - Dates functions
33 - Creating a dates table
34 - Working with different time zones
35 - Challenge - Add a Date field
36 - Solution - Add a Date field

5. Data Functions

37 - Using conditional functions
38 - Transposing tables
39 - Grouping fields and values
40 - Merging and appending data
41 - Pivoting and unpivoting data
42 - Parameters
43 - Custom functions
44 - Adding data types in M code

6. Relational Databases and Queries

45 - Working with relational databases
46 - Query folding
47 - Working with multidimensional databases

7. Loading Data

48 - Loading data
49 - Managing errors
50 - Refreshing data

Conclusion

51 - Continuing on with Power BI