Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
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

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

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
Zarinpal
Zibal