Creating a Power BI Datamart
You will learn what a Power BI Datamart is, how it works, and how to create one in the Power BI Service. Completing this course will provide you with the knowledge to integrate the Datamart into your self-service data solutions.
What you'll learn
In this course, Creating a Power BI Datamart, you’ll learn what a Power BI Datamart is, how it works, and how to create one in the Power BI Service. First, you'll explore the datamart features and tools that enable you to create and manage a datamart, and how the datamart feeds data into datasets, reports, and dashboards. Next, you'll discover how to connect to data sources, transform the incoming data, and use incremental loading to populate the datamart. Finally, you'll learn about security roles, how to configure row-level security, and how to provide users with direct access to the datamart to run queries from the Power BI service, Power BI desktop, and SQL Server Management Studio.
Table of contents
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