MP4 | Video: AVC, 1280x720 30 fps | Audio: AAC, 48 KHz, 2 Ch | Duration: 3h 56m
Skill Level: Intermediate | Genre: eLearning | Language: English + Subtitles | Size: 1.25 GB
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.
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