Creating a Power BI Datamart

Focused View

Andrew McSwiggan

1:18:48

112 View

1. Course Overview

1. Course Overview.mp4

01:51

2. Creating a Datamart

1. Creation of a Datamart.mp4

05:08

2. Creating an Account and a Workspace.mp4

04:04

3. Creating a Datamart Demo.mp4

05:33

4. Review the Datamart Model.mp4

06:14

5. Create a Measure.mp4

03:40

6. Create a Visual Query.mp4

05:53

7. Create an SQL Query.mp4

04:15

3. Extract, Transform, and Load Data

1. Extend the Datamart.mp4

07:26

2. Transform the Data.mp4

03:55

3. Get Data from a Data Flow.mp4

05:28

4. Configure an Incremental Refresh.mp4

06:30

4. Security and Deployment

1. Security and Deployment.mp4

03:59

2. Sharing Datamart Content.mp4

03:20

3. Row Level Security.mp4

06:46

4. Connecting to the Datamart Endpoint.mp4

04:46

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Andrew McSwiggan

Instructor's Courses

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 and chaotic data and turning it into something simple and easy to understand. Andi is a keen cyclist and amateur cook and lives with his wife in Southern Spain.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.