Power BI Data Methods

English | 3h 56m | Video 720p | Subtitles

Power BI is a powerful data analytics and visualization tool that helps users monitor data, analyze trends, and make smarter decisions. The breadth of the tool's capabilities is quite wide across the entire application, ranging from custom data connectors to custom dashboard visuals. This course focuses on the data end of Power BI, also known as Power Query (the same Power Query found in Excel), and how this part of the application can automate the data querying process and restructuring of data sets. Instructor Helen Wall goes over the array of Power BI data connection options, from static files to Python scripts; shares key techniques for transforming unusable data; explains how to use the M formula language to improve efficiency and create custom queries; and more.

Topics include

 

Data connection options, including files and databases

Connecting to web tables

Running Python scripts in Power BI

Cleaning and integrating data in Power BI

Query folding and native queries 

Leveraging the M formula language

 

Homepage:

https://www.lynda.com/Power-BI-tutorials/Power-BI-Data-Methods/2211318-2.html