Video Course
BEST SELLER

PL-300: Microsoft Power BI Data Analyst Certification Video Training Course

Looking for studying for PL-300: Microsoft Power BI Data Analyst certification training course. Our PL-300 certification video training course training course is your number one assistant. Pass with our PL-300: Microsoft Power BI Data Analyst certification training course on the first try and become a certified professional in no time.

  • 120 Students Enrolled
  • 266 Lectures
  • 3 Hours
  • 5.0 Rating
$38.49
$34.99

Curriculum For This Course

  • Introduction

    Video Name Time
    1. What are we going to learn? 4:42
    2. Installing Power BI Desktop 5:21

  • Part 1 Level 1: Creating and formatting a table visualization

    Video Name Time
    1. Welcome to Part 1: Visualizations 0:58
    2. Importing from Excel, and Creating our first visualization 5:07
    3. Viewing data 5:36
    4. Focus mode and Different visualizations 3:06
    5. Why do I need a Work email address? And how can I get one, if I don't have it? 6:10
    6. Saving visualization to the Desktop and to the Power BI service 5:09
    7. Practice Activity Number 1 - The Solution 07:23

  • Part 1 Level 2: Formatting our first visualization

    Video Name Time
    1. The New Format Pane 2:45
    2. Formatting font and font size 4:53
    3. Formatting colors 5:20
    4. Stylistic options 6:47
    5. Position visuals 5:45
    6. Align visuals 4:34
    7. Format Painter 2:45
    8. Configuring summarization, both default and in a specific visualization 10:01
    9. Changing number and date formatting 7:07
    10. Custom number and date formatting 5:25
    11. Practice Activity Number 2 - The Solution 7:59

  • Part 1 Level 3: Creating different visualizations: Martices and bar charts

    Video Name Time
    1. Matrix 7:01
    2. Drill down data, see data and records, and export data 8:24
    3. Stacked bar charts and switch theme for reports 6:52
    4. Bar Chart formatting, including continuous versus categorical axes 4:47
    5. Configure interactions between visual (Edit interactions) 8:32
    6. Clustered and 100% Stacked bar charts 5:47
    7. Line and area charts, including 8b. Configure duplicate pages 6:08
    8. Combo charts (Line and column charts) 8:28
    9. Practice Activity Number 3 - The Solution 7:42

  • Part 1 Level 4: Adding more control to your visualizations

    Video Name Time
    1. Adding Text boxes, Images and Shapes 9:02
    2. Visual level, page level and report level filters - basic filters 6:58
    3. Advanced Filtering 10:40
    4. Filter Top N Items 5:28
    5. Slicer 7:21
    6. Synchronizing slicers to multiple pages 5:17
    7. Slicer Warning 3:16
    8. Sort visuals 7:25
    9. Configure small multiples 8:22
    10. Use Bookmarks for reports 6:11
    11. ** Group and layer visuals by using the Selection pane 3:48
    12. Drillthrough 10:59
    13. Buttons and Actions 13:20
    14. Enable Natural Language Queries (Ask A Question) and Page Formatting 8:14
    15. Tooltip Pages 9:00
    16. Page and Bookmark Navigator 6:14
    17. Practice Activity Number 4 - The Solution 10:18

  • Part 1 Level 5: Other virtualizations

    Video Name Time
    1. Ribbon charts 6:22
    2. Waterfall charts 8:03
    3. Scatter, bubble and dot charts 10:08
    4. Pie charts and donut charts 4:55
    5. Treemaps 2:26
    6. Funnel charts 2:44
    7. Adding Marketplace visualizations (Import a Custom Visual) 3:05
    8. Practice Activity Number 5 - The Solution 7:27

  • Part 1 Level 6: Mapping

    Video Name Time
    1. Maps 7:30
    2. Formatting maps 4:46
    3. Adding Data Categories 7:16
    4. Filled Maps,Conditional Formatting, and color blindness 10:09
    5. Creating hierarchies 8:24
    6. ArcGIS Maps for Power BI 10:32
    7. Practice Activity Number 6 - The Solution 12:45

  • Part 1 Level 7: Measure performance by using KPIs, gauges and cards

    Video Name Time
    1. Gauges 5:50
    2. Cards and Multi-row cards 4:44
    3. More conditional formatting 7:55
    4. KPIs 4:14
    5. Practice Activity Number 7 - The Solution 16:01

  • Part 1 Level 8: Other Visualization Items for the exam

    Video Name Time
    1. Define quick measures 7:16
    2. Export report data 3:57
    3. Create reference lines by using Analytics pane, including the Forecast feature 9:37
    4. Use error bars 6:05
    5. Identify outliers 3:23
    6. ** Use clustering 3:40
    7. Use Anomaly Detection 5:10
    8. Use groupings and binnings 6:47
    9. Use the AI Visual Key Influencers to explore dimensional variances 8:44
    10. ** Use the Analyze feature in Power BI 5:39
    11. Use the AI Visual decomposition tree visual to break down a measure 6:04
    12. Creating a paginated report 6:00
    13. Exploring Power BI Report Builder 6:53

  • Additional videos - Visualize and Analyze the data

    Video Name Time
    1. Design and configure for accessibility 5:45
    2. Add a Smart Narrative visual 6:18
    3. R and Python Visualizations 4:17
    4. Use or create a PBIDS file 3:06

  • End of Part 1

    Video Name Time
    1. End of Part 1 1:05

  • Part 2 Get and Transform Data: Level 1- Home Part 1

    Video Name Time
    1. Welcome to Part 2: Get and Transform Data 1:48
    2. Introduction - let's Get some more Data 4:51
    3. Exploring the Power Query Editor interface 9:05
    4. Introducing the M language 9:15
    5. Let's start look at the Home tab 4:18
    6. Home menu - Manage Columns 06:05
    7. Home menu - Reduce Rows and Use First Row as Headers 07:26
    8. Practice Activity Number 8 - The Solution 7:16

  • Part 2 Level 1- Get Data - Home

    Video Name Time
    1. Sort and Filter 5:52
    2. Split Column 7:13
    3. Other Transform activities 9:50
    4. Practice Activity Number 9 - The Solution 6:10

  • Part 2 Level 2 - Getting Multiple files

    Video Name Time
    1. Merge Queries and Expand Table 6:07
    2. Merge Queries with Group By, and different types of Joins 6:54
    3. Appending two queries together 4:33
    4. Appending three or more queries together + resolving a problem with data types 6:30
    5. Combine Files (getting information from a folder) 9:17
    6. Practice Activity Number 10 - The Solution 15:44

  • Part 2 Level 3 - Transform Menu

    Video Name Time
    1. Transform - Table and Any Column 5:27
    2. Pivot Column 9:54
    3. Unpivot 10:30
    4. Practice Activity 11 - The Solution 7:07
    5. Unpivot in conjunction with other Transform features 9:57
    6. Practice Activity 12 - The Solution 5:39

  • Part 2 Level 4 - Transform - Text and Numbers

    Video Name Time
    1. Transform/Add Column - Text - Format 5:53
    2. Transform/Add Column - Text - Merge Columns 7:40
    3. Transform/Add Column - Text - Extract 6:53
    4. Transform/Add Column - Text - Parse 10:57
    5. Transform/Add Column - Number Column - Statistics and Standard 6:10
    6. Transform/Add Column - Other Number Column functions 4:59
    7. Practice Activity Number 13 - The Solution 12:58

  • Part2 Level 5 - Transform - Dates and Time

    Video Name Time
    1. Creating a list of dates 7:50
    2. Transform/Add Column - Date 8:34
    3. Transform/Add Column - Dates in other cultures/languages 8:45
    4. Transform/Add Column - Time 6:26
    5. Transform/Add column - Duration 3:14
    6. Practice Activity Number 14 - The Solution 7:27

  • Part2 Level 6 - Add Colums, View and Help Menus

    Video Name Time
    1. Column from examples 13:19
    2. Conditional Column 10:25
    3. Resolving Errors from Conditional Columns 4:07
    4. Index Column and Duplicate Column 3:42
    5. Custom Column - If Then Else 9:00
    6. Converting text from a different locale to a number 3:27
    7. Practice Activity Number 15 - The Solution 9:46

  • Part2 Level 7 - View and Help menus and advanced functionality

    Video Name Time
    1. Other M Functions 5:40
    2. View and Help menus, including Column Properties 5:24
    3. Profile the data 02:22
    4. Advanced Editor 4:17
    5. Functions and Parameters 11:45
    6. DateTimeZone date type and Functions 4:45
    7. Worked Practice Activity Number 16 - Dividing Annual data into Months 11:03

  • Part2 Level 8 - Get other types of data

    Video Name Time
    1. Introduction to SQL Server 5:51
    2. Importing database data into Power BI, and Query Folding 5:41
    3. Select a storage mode 5:07
    4. Expanding multiple tables in SQL Server 6:30
    5. Importing data from SQL Server Analysis Services (SSAS) 5:49
    6. Setting up Azure SQL Database 7:24
    7. Using Azure SQL Database in Power BI 8:34
    8. Use the Microsoft Dataverse 4:49
    9. Configure data loading 4:24

  • Additional videos - Get and Transform

    Video Name Time
    1. * Automatic page refresh 5:17
    2. * Using Big Data 6:16
    3. * Resolve problems 5:28
    4. * Identify query performance issues, including Query Diagnostics 4:37
    5. * Apply AI Insights 5:20

  • End of Part2

    Video Name Time
    1. End of Part2 1:14

  • Part 3 Level 1: Creating a Data Model

    Video Name Time
    1. Welcome to Part 3 - Modeling and DAX functions 1:34
    2. Get multiple data sets, and connecting them together 7:25
    3. The problems with direction of relationships between data sets 10:42
    4. Practice Activity Number 17 - The Solution 9:40

  • Part 3 Level 2: An introduction to DAX functions, including Logical functions

    Video Name Time
    1. DAX functions - A useful Resource 2:08
    2. Calculated columns - an introduction 3:38
    3. Basic operators 4:53
    4. IF, BLANK and ISBLANK 8:32
    5. AND, OR and NOT 4:10
    6. SWITCH 4:21
    7. Other functions 2:45
    8. Practice Activity Number 18 - The Solution 13:09

  • Part 3 Level 3 -Statistical functions

    Video Name Time
    1. Measures - an introduction, with standard aggregations including Countblank 9:00
    2. Aggregation of calculations 5:56
    3. Other statistical functions 5:58
    4. Practice Activity Number 19 - The Solution 7:34

  • Part 3 Level 4 - Mathematical functions

    Video Name Time
    1. Rounding functions 8:19
    2. Division functions - MOD and QUOTIENT 2:55
    3. SIGN (and use with SWITCH) and ABS 6:15
    4. Exponential functions 2:31
    5. Other functions 3:15
    6. Practice Activity Number 20 - The Solution 5:30

  • Part 3 Level 5 - Text Functions

    Video Name Time
    1. Text searching 7:48
    2. Text extraction and substitution 7:17
    3. Text conversion 8:06
    4. Other functions 2:17
    5. Practice Activity Number 21 - The Solution 5:42

  • Part 3 Level 6 - Information Functions

    Video Name Time
    1. ISERROR and LOOKUPVALUE 5:22
    2. Other functions 2:09
    3. Practice Activity Number 22 - The Solution 4:08

  • Part 3 Level 7 - Filter and Value Functions

    Video Name Time
    1. RELATED - Flatten out a parent-child hierarchy 4:56
    2. Design a data model that uses a star schema 10:58
    3. RELATEDTABLE and COUNTROWS 6:29
    4. Context 4:20
    5. ALL 5:45
    6. FILTER 3:11
    7. CALCULATE 3:08
    8. ALLEXCEPT 6:01
    9. ALLSELECTED 9:01
    10. Other functions 2:11
    11. Practice Activity Number 23 - The Solution 8:30

  • Part 3 Level 8 - Time Intelligence Functions

    Video Name Time
    1. Date and Time Functions 2:50
    2. FIRSTDATE, LASTDATE 3:06
    3. Start of... and End of... 6:07
    4. Previous... and Next... 5:36
    5. DATESINPERIOD 4:08
    6. DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD 2:51
    7. Opening Balance and Closing Balance 1:38
    8. Semi-additive Measures 2:35
    9. SAMEPERIODLASTYEAR and PARALLELPERIOD 3:16
    10. Other Time Intelligence Functions 2:12
    11. Practice Activity Number 24 - The Solution 10:06

  • Part 3 Level 9 - Other Modeling and DAX Topics for the exam

    Video Name Time
    1. Create calculated tables 6:00
    2. Create a common date table 6:57
    3. Define role-playing dimensions 6:45
    4. Resolve many-to-many relationships - Joint Bank Accounts 6:05
    5. Resolve many-to-many relationships - Different types of granularity 6:24
    6. Improve cardinality levels through summarization and by changing data types 8:54
    7. Identify poorly performing measures, relationships, and visuals 6:10
    8. End of Part 3 0:56

  • Part 4 Section 1 - An Introduction to the Power BI Service

    Video Name Time
    1. Welcome to Part 4: The Power BI Service 0:22
    2. Introducing The Power BI Service 3:56
    3. Logging into Power BI Service and a quick look around 5:51
    4. Power BI Terminology 11:11
    5. Datasets and Reports in the Power BI Service 10:03
    6. Get Data - Importing Your Data as a Dataset 8:42
    7. Get Data - Importing your data as a Workbook 7:31
    8. Other ways to Get Data 3:44
    9. The Navigation Pane, including Add a Quick Insights result to a report 7:30

  • Part 4 Section 2 - Power BI Pro and adding users

    Video Name Time
    1. Signing up for Power BI Pro 5:47
    2. Adding new users 8:27
    3. Creating a new report 8:20
    4. Sharing my new report 6:16

  • Part 4 Section 3 - Row Level Security

    Video Name Time
    1. Adding role-based Row Level Security 7:49
    2. Adding Dynamic Row Level Security 10:08
    3. Testing Dynamic Row Level Security in the Power BI Service 6:53

  • Part 4 Section 4 - Dashboards

    Video Name Time
    1. Differences between dashboards and reports 5:07
    2. Manage Tiles on a Dashboard, Set Mobile View, and other Tiles options 5:00
    3. Dashboards: Options 4:31
    4. Configure Subscriptions 4:12
    5. Pin a Live Report Page to a Dashboard 4:17
    6. Use the Q&A Feature 2:56
    7. Add a Dashboard Theme 6:24
    8. Apply or Change Sensitivity Labels 6:34
    9. Configure Data Alerts 4:53

  • Part 4 Section 5 - Manage datasets

    Video Name Time
    1. Analyze in Excel 5:52
    2. Promote or Certify (Endorse) a Dataset 5:49
    3. Manually Refreshing data in the Power BI Service 4:21
    4. Data Gateways; Providing Access to Datasets 9:38
    5. Configure a Dataset Scheduled Refresh 7:17
    6. Configure Incremental Refresh Settings - Step 1 6:40
    7. Configure Incremental Refresh Settings - Step 2 7:43

  • Part 4 Section 6 - Create and manage workspaces

    Video Name Time
    1. Create and Configure a Workspace 4:53
    2. Assign Workspace Roles 5:23
    3. Providing Access to Datasets 5:17
    4. Configure and Update a Workspace App 13:17
    5. Promote or certify Power BI report or app 2:18
    6. Publish, Import or Update Assets in a Workspace - Publish securely 5:43
    7. Publish reports on the web, so the public can see 7:27

  • Part 4 Section 7 - Other Power BI Service Topics

    Video Name Time
    1. Create a PivotTable from a Power BI dataset in Excel 4:38
    2. Use or create a dataflow 7:56
    3. Creating Scorecards and Metrics 7:40
    4. Sharing Scorecards and Metrics 4:45
    5. Using Scorecards and Metrics 5:24

  • Not needed for the PL-300 exam

    Video Name Time
    1. Implement Object-Level Security 6:41
    2. Drillthrough from another report 6:57
    3. Export Data 6:08
    4. Recommend a Development Lifecycle Strategy 5:24
    5. Identify downstream dataset dependencies 4:14
    6. Personalize visuals 8:33
    7. Dataflow Scheduled Refresh and Endorsement 1:28
    8. Connect to a dataset using the XMLA endpoint 4:22
    9. Configure large dataset format 2:09
    10. Dashboard Data Classifications 5:23

  • End of Part 4

    Video Name Time
    1. End of Part 4 00:54

  • Well done

    Video Name Time
    1. That's almost it for the Power BI Service 1:27

Student Feedback

  1. 43%
  2. 57%
  3. 0%
  4. 0%
  5. 0%

Excellent Overall Rating

5.0

Add Comment

Rate Course *

Secure Code
Please enter security code exactly as shown

Log into your CertBolt Account

* Only Registered Members can Download Exam Questions & Answers

Create New CertBolt Account

or Login