Power BI Dataflows Essential Training
1h 28mIntermediate2020-03-12
Authors

Helen Wall
Data analytics and business analysis expert
Course details
Power BI offers a wide variety of capabilities, ranging from custom data connectors to custom dashboard visuals. In this course, instructor Helen Wall shines a spotlight on one of its most powerful and practical features: dataflows. Using dataflows in Power BI, you can easily ingest, transform, integrate, and enrich data from a wide variety of sources. Using practical examples, Helen explains how to boost efficiency and eliminate duplicate work by using dataflows to scale the extract, transform, and load (ETL) process across many users of Power BI data and dashboards. She demonstrates how to connect to various data sources within the Power BI cloud platform; leverage Power Query Online to transform data into useable data sets accessible to users; connect a Power BI Desktop file to a Power BI dataflow in the cloud; share dataflows to ensure that several users can connect to the same ETL process; schedule refresh schedules for those dataflows; and more.
Skills covered
Power BI for Office 365Power BIBusiness AnalyticsBusiness IntelligenceData AnalysisEssential TrainingData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoft
Concepts
0. Introduction
- 01 - Optimizing your data with Power BI dataflows
- 02 - What you should know
1. Working with Data in Power BI
- 03 - Navigating the Power BI ecosystem
- 04 - Comparing Power BI versions
- 05 - Utilizing a dataflow
- 06 - Utilizing Azure Data Lake
2. Extracting Data
- 07 - Setting up gateways
- 08 - Organizing data sources
- 09 - Connecting to databases
- 10 - Setting up web connections
- 11 - Querying API data
- 12 - Connecting to Excel
3. Transforming Data Connections
- 13 - Updating dataflows
- 14 - Utilizing Power Query Online applied steps
- 15 - Translating from Power BI Desktop
- 16 - Setting up a Common Data Model
4. Loading and Connecting to Dataflows
- 17 - Connecting to dataflows
- 18 - Comparing dataflows to data sets
- 19 - Sharing dataflows
- 20 - Scheduling data refreshing
- 21 - Representing dataflow structures with JSON files
Conclusion
- 22 - Next steps with Power BI dataflows