PL-300: Microsoft Power BI Data Analyst

Curriculum For This Course

Introduction

2Lectures

Time 00:10:03

Part 1 Level 1: Creating and formatting a table visualization

7Lectures

Time 00:33:29

Part 1 Level 2: Formatting our first visualization

11Lectures

Time 01:03:21

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

9Lectures

Time 01:03:41

Part 1 Level 4: Adding more control to your visualizations

17Lectures

Time 02:11:53

Part 1 Level 5: Other virtualizations

8Lectures

Time 00:45:10

Part 1 Level 6: Mapping

7Lectures

Time 01:01:22

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

5Lectures

Time 00:38:44

Part 1 Level 8: Other Visualization Items for the exam

13Lectures

Time 01:19:15

Additional videos - Visualize and Analyze the data

4Lectures

Time 00:19:26

End of Part 1

1Lectures

Time 00:01:05

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

8Lectures

Time 00:50:04

Part 2 Level 1- Get Data - Home

4Lectures

Time 00:29:05

Part 2 Level 2 - Getting Multiple files

6Lectures

Time 00:49:05

Part 2 Level 3 - Transform Menu

6Lectures

Time 00:48:34

Part 2 Level 4 - Transform - Text and Numbers

7Lectures

Time 00:55:30

Part2 Level 5 - Transform - Dates and Time

6Lectures

Time 00:42:16

Part2 Level 6 - Add Colums, View and Help Menus

7Lectures

Time 00:53:46

Part2 Level 7 - View and Help menus and advanced functionality

7Lectures

Time 00:45:16

Part2 Level 8 - Get other types of data

9Lectures

Time 00:54:09

Additional videos - Get and Transform

5Lectures

Time 00:26:58

End of Part2

1Lectures

Time 00:01:14

Part 3 Level 1: Creating a Data Model

4Lectures

Time 00:29:21

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

8Lectures

Time 00:43:36

Part 3 Level 3 -Statistical functions

4Lectures

Time 00:28:28

Part 3 Level 4 - Mathematical functions

6Lectures

Time 00:28:45

Part 3 Level 5 - Text Functions

5Lectures

Time 00:31:10

Part 3 Level 6 - Information Functions

3Lectures

Time 00:11:39

Part 3 Level 7 - Filter and Value Functions

11Lectures

Time 01:04:30

Part 3 Level 8 - Time Intelligence Functions

11Lectures

Time 00:44:25

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

8Lectures

Time 00:48:11

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

9Lectures

Time 00:58:50

Part 4 Section 2 - Power BI Pro and adding users

4Lectures

Time 00:28:50

Part 4 Section 3 - Row Level Security

3Lectures

Time 00:24:50

Part 4 Section 4 - Dashboards

9Lectures

Time 00:43:54

Part 4 Section 5 - Manage datasets

7Lectures

Time 00:47:20

Part 4 Section 6 - Create and manage workspaces

7Lectures

Time 00:44:18

Part 4 Section 7 - Other Power BI Service Topics

5Lectures

Time 00:30:23

Not needed for the PL-300 exam

10Lectures

Time 00:51:19

End of Part 4

1Lectures

Time 00:00:54

Well done

1Lectures

Time 00:01:27

Introduction
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	1. End of Part 1	1:05

Part 2 Get and Transform Data: Level 1- Home Part 1
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	1. End of Part2	1:14

Part 3 Level 1: Creating a Data Model
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	1. End of Part 4	00:54

Well done
	1. That's almost it for the Power BI Service	1:27

Free PL-300 Exam Questions & Microsoft PL-300 Dumps
	Downloads: 57	Size: 1.19 MB

Student Feedback

5.0

Excellent

48%

52 %

Add Comments

Name:^*

E-mail:^*

Comment:^* Comment will be moderated and published within 1-4 hours

Verification:^*

Type the characters from the picture.

Rate Course:^*

Curriculum For This Course

Free PL-300 Exam Questions & Microsoft PL-300 Dumps

Student Feedback

Add Comments

Get Premium Membership