Business Intelligence, Data Warehouse and Data Lake

SQW01 When it Makes Sense to Incorporate Datamarts and Data flows in Power BI

11/15/2023

8:00am - 9:15am

Level: Introductory to Intermediate

Ginger Grant

Principal Data Geek

Desert Isle Group

Datamarts were added in 2023 and data flows have been around since 2019 and both can be used to improve the quality and consistency of data models within the organization. In this session we will examine how to create dataflows and datamarts. More importantly this session will describe how they interact with workspaces, how to incorporate them into Power BI Models and when doing so would be a good choice. Of course, we will review when you can use the features of each depending upon your Power BI license as the functionality differs between Premium and Pro. Gaining a good understanding of these different data storage options will provide the information you need incorporate these features into your organization.

You will learn:

  • To differentiate when you should use dataflows and datamarts in your organization and what benefits they provide to the data model
  • How to create a dataflow and how to incorporate it into Power BI models
  • What a datamart can provide and the use cases when it makes sense to create