Power BI Data Methods

Get a comprehensive overview of the data end of Power BI—also known as Power Query—and learn how to use it to automate the data querying process and restructuring of data sets.

Introduction

• The data at the core of Power BI
• What you should know
• Course project overview

1. Extracting Data from Files

• Working with Power Query
• The extract, transform, load (ETL) framework
• Power Query objects

2. Extracting Data from Files

• Connecting to text files
• Connecting to CSV files
• Connecting to Excel files
• Connecting to online Excel files
• Connecting to PDF files
• Connecting to images as data
• Setting up folder connection
• Connecting to HTML and XML
• Connecting to JSON data
• Connecting to APIs
• Connecting to ODATA feeds
• Connecting to GitHub
• Using an R script connector
• Using a Python script connector
• Challenge: Getting data
• Solution: Getting data

3. Transforming Data with Cleaning Operations

• Cleaning text fields
• Removing or replacing values
• Splitting and concatenating fields
• Text formulas
• Filtering or removing duplicates
• Filling up and filling down
• Transforming numerical fields
• Challenge: Add a new column
• Solution: Add a new column

4. Working with Dates and Times

• Dates functions
• Creating a dates table
• Working with different time zones
• Challenge: Add a Date field
• Solution: Add a Date field

5. Data Functions

• Using conditional functions
• Transposing tables
• Grouping fields and values
• Merging and appending data
• Pivoting and unpivoting data
• Parameters
• Custom functions
• Adding data types in M code

6. Relational Databases and Queries

• Working with relational databases
• Query folding
• Working with multidimensional databases

7. Loading Data

• Loading data
• Managing errors
• Refreshing data

Conclusion

• Continuing on with Power BI