-
Course
- Data
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, Analytics Data Visualisation. Andi has delivered face to face Business Intelligence training covering topics such as Report Design, Dimensional modeling, and Data Visualisation. Andi is a keen cyclist and amateur cook and lives with his wife in Southern Spain.
More Courses by Andrew