Certification Based
Data Science

PL-300: Microsoft Power BI Data Analyst

Intermediate
19h

By: Krystle Delcambre

Overview

In this online training course, students will learn the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

Exam: PL-300: Microsoft Power BI Data Analyst

Modules

1. Power BI Introduction

1.1 Overview of Power BI9 min
1.2 Installation6 min
1.3 Settings5 min

2. Building Blocks of Power BI

2.1 Basics8 min
2.2 Reports14 min
2.3 Workspaces18 min
2.4 Using the Power BI Service15 min

3. Get Data

3.1 Parts of the Desktop36 min
3.2 Data Sources7 min
3.3 Connecting to Data9 min
3.4 Performance22 min
3.5 Power Query53 min

4. Semantic Models

4.1 Tables23 min
4.2 Challenges7 min

5. Visualize the Data

5.1 Design the Report15 min
5.2 Setup Pages9 min
5.3 Visualization Types20 min

6. Filter the Report

6.1 Levels of Filtering18 min
6.2 Applying Filters3 min
6.3 Slicers6 min
6.4 Other Ways to Filter11 min
6.5 Tips and Best Practices7 min

7. Publishing and Sharing

7.1 Publish to Workspace5 min
7.2 Creating Workspaces25 min
7.3 Building an App13 min
7.4 Power BI Mobile4 min

8. Power BI Desktop Models

8.1 Star Schema7 min
8.2 Queries19 min
8.3 Report Visuals25 min

9. Choosing a Model Frame

9.1 Fundamentals5 min
9.2 Import Model7 min
9.3 DirectQuery10 min
9.4 Composite5 min

10. Semantic Model

10.1 Tables11 min
10.2 Challenges4 min

11. Measures, Calculations, & DAX

11.1 Introduction15 min
11.2 Formulas14 min
11.3 Types of Data15 min
11.4 Measures14 min
11.5 Calculated Tables and Columns9 min
11.6 Time Intelligence14 min
11.7 Iterator and Aggregations11 min
11.8 Dax Filters44 min

12. Analytics Features

12.1 Intro7 min
12.2 Statistical Summary6 min
12.3 Outliers6 min
12.4 Time Series25 min
12.5 Analyze Features6 min
12.6 What Ifs13 min
12.7 Specialized Visuals17 min

13. Optimize Performance

13.1 Review Performance Measures16 min
13.2 Use Variables to Improve Performance16 min
13.3 Troubleshooting18 min
13.4 Optimizing Direct Query11 min

14. Model Security

14.1 Restricting Access39 min

15. Enhancing the Report for the User

15.1 Report Details14 min
15.2 Design for the End User35 min

16. Managing the Data and Workspaces

16.1 Managing the Workspaces46 min
16.2 Managing the Semantic Models42 min

17. Building a Dashboard

17.1 Configure the Dashboard33 min
17.2 Q & A Features13 min
17.3 Displaying Visuals and Tiles in Full Screen8 min
17.4 Edit Tile Details6 min

18. Intro to Paginated Reporting

18.1 Download6 min
18.2 Parts of Paginated Reports33 min
18.3 Create a Report32 min
18.4 Publish55 min

19. Power BI Mobile Apps

19.1 Intro11 min
19.2 Finding the Data7 min
19.3 App Settings6 min

Ready to Elevate Your Team's Learning?

Talk with our sales team to see how StormWind can transform the way your organization trains and grows.

CONTACT SALES