Power BI Dataflows Essential Training

Power BI Dataflows Essential Training

1h 28mIntermediate2020-03-12

Authors

Helen Wall

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

Introduction

  • Optimizing your data with Power BI dataflows
  • What you should know

Working with Data in Power BI

  • Navigating the Power BI ecosystem
  • Comparing Power BI versions
  • Utilizing a dataflow
  • Utilizing Azure Data Lake

Extracting Data

  • Setting up gateways
  • Organizing data sources
  • Connecting to databases
  • Setting up web connections
  • Querying API data
  • Connecting to Excel

Transforming Data Connections

  • Updating dataflows
  • Utilizing Power Query Online applied steps
  • Translating from Power BI Desktop
  • Setting up a Common Data Model

Loading and Connecting to Dataflows

  • Connecting to dataflows
  • Comparing dataflows to data sets
  • Sharing dataflows
  • Scheduling data refreshing
  • Representing dataflow structures with JSON files

Conclusion

  • Next steps with Power BI dataflows
40,000 Toman