From the course: Power BI Dataflows Essential Training
Navigating the Power BI ecosystem
From the course: Power BI Dataflows Essential Training
Navigating the Power BI ecosystem
- [Instructor] Power BI allows you to create scalable, visually-interactive dashboards, or what Microsoft officially calls reports, that you can share with a large group of end users. Power BI gives them the capability to monitor, analyze and make decisions from multiple views of data without having to understand the business-intelligence technology on the back end. Applications that roll into Power BI include Microsoft's Access, Power Query, PowerPivot and Excel. Power BI also leverages rapidly-developing new technologies such as cloud computing, advanced analytics and machine learning. Power BI automates processes like connecting to and refreshing data. When you create a dashboard, you want to not only think about the end users leveraging the front end and the dashboards, but also think about how to configure efficient data processes on the back end. When an organization starts building out their Power BI Cloud Service, they may have a dashboard and its corresponding data set. However, as the number of users and dashboards and their corresponding data sets in the Power Bi Cloud Service increase, efficiently managing these dashboards and data sets becomes increasingly more difficult. This is where dataflows come in. Our focus for this course is on creating reusable data tables called Power BI Dataflows. Dataflows move much of the ETL framework into the shared cloud to reduce unnecessary duplicated data processes. They create a scalable and shareable process for working with your organization's data. ETL stands for extract, transform and load. It allows us to first connect to numerous types of data sources. We can then clean the data, create formulas and manipulate the data table shape. Finally, we load or share the dataflow to enable many other users to access the same data table. Because this is an essential course on Power BI Dataflows, we will not discuss much about the ETL Framework semantics. If you would like to learn more about the Power Query Editor capabilities in Power BI, please check out my Power BI Data Methods Course in the library.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.