Simple play icon Course
Skills Expanded

Create Dataflows in Power BI

by Andrew McSwiggan

This course will teach you how to create a Gen1 analytical dataflow that can be made available as a self-service semantic layer.

What you'll learn

Developers need to prepare data for self-service consumption. Some analysts and power users are creating reports that take data from the same data source, some are transforming the data using a SQL query, some are using Power Query, and others are taking raw data and transforming it using DAX. Business logic is being distributed and applied at the report level, but it would be better to apply the business logic once and make the results available to be consumed by all of the reports.

In this course, Create Dataflows in Power BI, you’ll gain the ability to develop self-service dataflows.

First, you’ll explore the capabilities of the dataflow component and how this differs from a Power Query data transformation. Next, you’ll discover how to create a Power BI dataflow, capture the data incrementally, transform the data inside the dataflow, and store the results. Finally, you’ll learn how to consume data from a Power BI dataflow. When you’re finished with this course, you’ll have the skills and knowledge of Power BI dataflows needed to produce self-service data interfaces with Power BI.

About the author

Passionate about Business Intelligence and delivering knowledge and insight to support better decisions. An advocate of Self-Service Reporting and Analytics and a Data Visualisation evangelist. Andi has delivered face to face Business Intelligence training to many industries, covering topics such as Report Design, Semantic Layer, Dimensional modeling and Data Visualisation. Andi has led many Data Warehouse and Business Intelligence development projects and is well versed in taking complex an... more

Ready to upskill? Get started