English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 28m | 188 MB
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.
Table of Contents
1 Optimizing your data with Power BI dataflows
2 What you should know
3 Navigating the Power BI ecosystem
4 Comparing Power BI versions
5 Utilizing a dataflow
6 Utilizing Azure Data Lake
7 Setting up gateways
8 Organizing data sources
9 Connecting to databases
10 Setting up web connections
11 Querying API data
12 Connecting to Excel
13 Updating dataflows
14 Utilizing Power Query Online applied steps
15 Translating from Power BI Desktop
16 Setting up a Common Data Model
17 Connecting to dataflows
18 Comparing dataflows to data sets
19 Sharing dataflows
20 Scheduling data refreshing
21 Representing dataflow structures with JSON files
22 Next steps with Power BI dataflows
Resolve the captcha to access the links!