Description
In this course, you will :
- Explains how to use dataflows to scale the extract, transform, and load (ETL) process across many users of Power BI data and dashboards to increase efficiency and eliminate duplicate work. She shows how to connect to various data sources within the Power BI cloud platform; how to use Power Query Online to transform data into usable data sets accessible to users; how to connect a Power BI Desktop file to a Power BI dataflow in the cloud; how to share dataflows so that multiple users can connect to the same ETL process; how to schedule refresh schedules for those dataflows; and more.
Syllabus :
1. Working with Data in Power BI
- Navigating the Power BI ecosystem
- Comparing Power BI versions
- Utilizing a dataflow
- Utilizing Azure Data Lake
2. Extracting Data
- Setting up gateways
- Organizing data sources
- Connecting to databases
- Setting up web connections
- Querying API data
- Connecting to Excel
3. Transforming Data Connections
- Updating dataflows
- Utilizing Power Query Online applied steps
- Translating from Power BI Desktop
- Setting up a Common Data Model
4. Loading and Connecting to Dataflows
- Connecting to dataflows
- Comparing dataflows to data sets
- Sharing dataflows
- Scheduling data refreshing
- Representing dataflow structures with JSON files