PL-300: Microsoft Power BI Data Analyst Certification Video Training Course
The complete solution to prepare for for your exam with PL-300: Microsoft Power BI Data Analyst certification video training course. The PL-300: Microsoft Power BI Data Analyst certification video training course contains a complete set of videos that will provide you with thorough knowledge to understand the key concepts. Top notch prep including Microsoft PL-300 exam dumps, study guide & practice test questions and answers.
PL-300: Microsoft Power BI Data Analyst Certification Video Training Course Exam Curriculum
Introduction
-
1. What are we going to learn?4:42
-
2. Installing Power BI Desktop5:21
Part 1 Level 1: Creating and formatting a table visualization
-
1. Welcome to Part 1: Visualizations0:58
-
2. Importing from Excel, and Creating our first visualization5:07
-
3. Viewing data5:36
-
4. Focus mode and Different visualizations3: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 service5:09
-
7. Practice Activity Number 1 - The Solution07:23
Part 1 Level 2: Formatting our first visualization
-
1. The New Format Pane2:45
-
2. Formatting font and font size4:53
-
3. Formatting colors5:20
-
4. Stylistic options6:47
-
5. Position visuals5:45
-
6. Align visuals4:34
-
7. Format Painter2:45
-
8. Configuring summarization, both default and in a specific visualization10:01
-
9. Changing number and date formatting7:07
-
10. Custom number and date formatting5:25
-
11. Practice Activity Number 2 - The Solution7:59
Part 1 Level 3: Creating different visualizations: Martices and bar charts
-
1. Matrix7:01
-
2. Drill down data, see data and records, and export data8:24
-
3. Stacked bar charts and switch theme for reports6:52
-
4. Bar Chart formatting, including continuous versus categorical axes4:47
-
5. Configure interactions between visual (Edit interactions)8:32
-
6. Clustered and 100% Stacked bar charts5:47
-
7. Line and area charts, including 8b. Configure duplicate pages6:08
-
8. Combo charts (Line and column charts)8:28
-
9. Practice Activity Number 3 - The Solution7:42
Part 1 Level 4: Adding more control to your visualizations
-
1. Adding Text boxes, Images and Shapes9:02
-
2. Visual level, page level and report level filters - basic filters6:58
-
3. Advanced Filtering10:40
-
4. Filter Top N Items5:28
-
5. Slicer7:21
-
6. Synchronizing slicers to multiple pages5:17
-
7. Slicer Warning3:16
-
8. Sort visuals7:25
-
9. Configure small multiples8:22
-
10. Use Bookmarks for reports6:11
-
11. ** Group and layer visuals by using the Selection pane3:48
-
12. Drillthrough10:59
-
13. Buttons and Actions13:20
-
14. Enable Natural Language Queries (Ask A Question) and Page Formatting8:14
-
15. Tooltip Pages9:00
-
16. Page and Bookmark Navigator6:14
-
17. Practice Activity Number 4 - The Solution10:18
Part 1 Level 5: Other virtualizations
-
1. Ribbon charts6:22
-
2. Waterfall charts8:03
-
3. Scatter, bubble and dot charts10:08
-
4. Pie charts and donut charts4:55
-
5. Treemaps2:26
-
6. Funnel charts2:44
-
7. Adding Marketplace visualizations (Import a Custom Visual)3:05
-
8. Practice Activity Number 5 - The Solution7:27
Part 1 Level 6: Mapping
-
1. Maps7:30
-
2. Formatting maps4:46
-
3. Adding Data Categories7:16
-
4. Filled Maps,Conditional Formatting, and color blindness10:09
-
5. Creating hierarchies8:24
-
6. ArcGIS Maps for Power BI10:32
-
7. Practice Activity Number 6 - The Solution12:45
Part 1 Level 7: Measure performance by using KPIs, gauges and cards
-
1. Gauges5:50
-
2. Cards and Multi-row cards4:44
-
3. More conditional formatting7:55
-
4. KPIs4:14
-
5. Practice Activity Number 7 - The Solution16:01
Part 1 Level 8: Other Visualization Items for the exam
-
1. Define quick measures7:16
-
2. Export report data3:57
-
3. Create reference lines by using Analytics pane, including the Forecast feature9:37
-
4. Use error bars6:05
-
5. Identify outliers3:23
-
6. ** Use clustering3:40
-
7. Use Anomaly Detection5:10
-
8. Use groupings and binnings6:47
-
9. Use the AI Visual Key Influencers to explore dimensional variances8:44
-
10. ** Use the Analyze feature in Power BI5:39
-
11. Use the AI Visual decomposition tree visual to break down a measure6:04
-
12. Creating a paginated report6:00
-
13. Exploring Power BI Report Builder6:53
Additional videos - Visualize and Analyze the data
-
1. Design and configure for accessibility5:45
-
2. Add a Smart Narrative visual6:18
-
3. R and Python Visualizations4:17
-
4. Use or create a PBIDS file3:06
End of Part 1
-
1. End of Part 11:05
Part 2 Get and Transform Data: Level 1- Home Part 1
-
1. Welcome to Part 2: Get and Transform Data1:48
-
2. Introduction - let's Get some more Data4:51
-
3. Exploring the Power Query Editor interface9:05
-
4. Introducing the M language9:15
-
5. Let's start look at the Home tab4:18
-
6. Home menu - Manage Columns06:05
-
7. Home menu - Reduce Rows and Use First Row as Headers07:26
-
8. Practice Activity Number 8 - The Solution7:16
Part 2 Level 1- Get Data - Home
-
1. Sort and Filter5:52
-
2. Split Column7:13
-
3. Other Transform activities9:50
-
4. Practice Activity Number 9 - The Solution6:10
Part 2 Level 2 - Getting Multiple files
-
1. Merge Queries and Expand Table6:07
-
2. Merge Queries with Group By, and different types of Joins6:54
-
3. Appending two queries together4:33
-
4. Appending three or more queries together + resolving a problem with data types6:30
-
5. Combine Files (getting information from a folder)9:17
-
6. Practice Activity Number 10 - The Solution15:44
Part 2 Level 3 - Transform Menu
-
1. Transform - Table and Any Column5:27
-
2. Pivot Column9:54
-
3. Unpivot10:30
-
4. Practice Activity 11 - The Solution7:07
-
5. Unpivot in conjunction with other Transform features9:57
-
6. Practice Activity 12 - The Solution5:39
Part 2 Level 4 - Transform - Text and Numbers
-
1. Transform/Add Column - Text - Format5:53
-
2. Transform/Add Column - Text - Merge Columns7:40
-
3. Transform/Add Column - Text - Extract6:53
-
4. Transform/Add Column - Text - Parse10:57
-
5. Transform/Add Column - Number Column - Statistics and Standard6:10
-
6. Transform/Add Column - Other Number Column functions4:59
-
7. Practice Activity Number 13 - The Solution12:58
Part2 Level 5 - Transform - Dates and Time
-
1. Creating a list of dates7:50
-
2. Transform/Add Column - Date8:34
-
3. Transform/Add Column - Dates in other cultures/languages8:45
-
4. Transform/Add Column - Time6:26
-
5. Transform/Add column - Duration3:14
-
6. Practice Activity Number 14 - The Solution7:27
Part2 Level 6 - Add Colums, View and Help Menus
-
1. Column from examples13:19
-
2. Conditional Column10:25
-
3. Resolving Errors from Conditional Columns4:07
-
4. Index Column and Duplicate Column3:42
-
5. Custom Column - If Then Else9:00
-
6. Converting text from a different locale to a number3:27
-
7. Practice Activity Number 15 - The Solution9:46
Part2 Level 7 - View and Help menus and advanced functionality
-
1. Other M Functions5:40
-
2. View and Help menus, including Column Properties5:24
-
3. Profile the data02:22
-
4. Advanced Editor4:17
-
5. Functions and Parameters11:45
-
6. DateTimeZone date type and Functions4:45
-
7. Worked Practice Activity Number 16 - Dividing Annual data into Months11:03
Part2 Level 8 - Get other types of data
-
1. Introduction to SQL Server5:51
-
2. Importing database data into Power BI, and Query Folding5:41
-
3. Select a storage mode5:07
-
4. Expanding multiple tables in SQL Server6:30
-
5. Importing data from SQL Server Analysis Services (SSAS)5:49
-
6. Setting up Azure SQL Database7:24
-
7. Using Azure SQL Database in Power BI8:34
-
8. Use the Microsoft Dataverse4:49
-
9. Configure data loading4:24
Additional videos - Get and Transform
-
1. * Automatic page refresh5:17
-
2. * Using Big Data6:16
-
3. * Resolve problems5:28
-
4. * Identify query performance issues, including Query Diagnostics4:37
-
5. * Apply AI Insights5:20
End of Part2
-
1. End of Part21:14
Part 3 Level 1: Creating a Data Model
-
1. Welcome to Part 3 - Modeling and DAX functions1:34
-
2. Get multiple data sets, and connecting them together7:25
-
3. The problems with direction of relationships between data sets10:42
-
4. Practice Activity Number 17 - The Solution9:40
Part 3 Level 2: An introduction to DAX functions, including Logical functions
-
1. DAX functions - A useful Resource2:08
-
2. Calculated columns - an introduction3:38
-
3. Basic operators4:53
-
4. IF, BLANK and ISBLANK8:32
-
5. AND, OR and NOT4:10
-
6. SWITCH4:21
-
7. Other functions2:45
-
8. Practice Activity Number 18 - The Solution13:09
Part 3 Level 3 -Statistical functions
-
1. Measures - an introduction, with standard aggregations including Countblank9:00
-
2. Aggregation of calculations5:56
-
3. Other statistical functions5:58
-
4. Practice Activity Number 19 - The Solution7:34
Part 3 Level 4 - Mathematical functions
-
1. Rounding functions8:19
-
2. Division functions - MOD and QUOTIENT2:55
-
3. SIGN (and use with SWITCH) and ABS6:15
-
4. Exponential functions2:31
-
5. Other functions3:15
-
6. Practice Activity Number 20 - The Solution5:30
Part 3 Level 5 - Text Functions
-
1. Text searching7:48
-
2. Text extraction and substitution7:17
-
3. Text conversion8:06
-
4. Other functions2:17
-
5. Practice Activity Number 21 - The Solution5:42
Part 3 Level 6 - Information Functions
-
1. ISERROR and LOOKUPVALUE5:22
-
2. Other functions2:09
-
3. Practice Activity Number 22 - The Solution4:08
Part 3 Level 7 - Filter and Value Functions
-
1. RELATED - Flatten out a parent-child hierarchy4:56
-
2. Design a data model that uses a star schema10:58
-
3. RELATEDTABLE and COUNTROWS6:29
-
4. Context4:20
-
5. ALL5:45
-
6. FILTER3:11
-
7. CALCULATE3:08
-
8. ALLEXCEPT6:01
-
9. ALLSELECTED9:01
-
10. Other functions2:11
-
11. Practice Activity Number 23 - The Solution8:30
Part 3 Level 8 - Time Intelligence Functions
-
1. Date and Time Functions2:50
-
2. FIRSTDATE, LASTDATE3:06
-
3. Start of... and End of...6:07
-
4. Previous... and Next...5:36
-
5. DATESINPERIOD4:08
-
6. DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD2:51
-
7. Opening Balance and Closing Balance1:38
-
8. Semi-additive Measures2:35
-
9. SAMEPERIODLASTYEAR and PARALLELPERIOD3:16
-
10. Other Time Intelligence Functions2:12
-
11. Practice Activity Number 24 - The Solution10:06
Part 3 Level 9 - Other Modeling and DAX Topics for the exam
-
1. Create calculated tables6:00
-
2. Create a common date table6:57
-
3. Define role-playing dimensions6:45
-
4. Resolve many-to-many relationships - Joint Bank Accounts6:05
-
5. Resolve many-to-many relationships - Different types of granularity6:24
-
6. Improve cardinality levels through summarization and by changing data types8:54
-
7. Identify poorly performing measures, relationships, and visuals6:10
-
8. End of Part 30:56
Part 4 Section 1 - An Introduction to the Power BI Service
-
1. Welcome to Part 4: The Power BI Service0:22
-
2. Introducing The Power BI Service3:56
-
3. Logging into Power BI Service and a quick look around5:51
-
4. Power BI Terminology11:11
-
5. Datasets and Reports in the Power BI Service10:03
-
6. Get Data - Importing Your Data as a Dataset8:42
-
7. Get Data - Importing your data as a Workbook7:31
-
8. Other ways to Get Data3:44
-
9. The Navigation Pane, including Add a Quick Insights result to a report7:30
Part 4 Section 2 - Power BI Pro and adding users
-
1. Signing up for Power BI Pro5:47
-
2. Adding new users8:27
-
3. Creating a new report8:20
-
4. Sharing my new report6:16
Part 4 Section 3 - Row Level Security
-
1. Adding role-based Row Level Security7:49
-
2. Adding Dynamic Row Level Security10:08
-
3. Testing Dynamic Row Level Security in the Power BI Service6:53
Part 4 Section 4 - Dashboards
-
1. Differences between dashboards and reports5:07
-
2. Manage Tiles on a Dashboard, Set Mobile View, and other Tiles options5:00
-
3. Dashboards: Options4:31
-
4. Configure Subscriptions4:12
-
5. Pin a Live Report Page to a Dashboard4:17
-
6. Use the Q&A Feature2:56
-
7. Add a Dashboard Theme6:24
-
8. Apply or Change Sensitivity Labels6:34
-
9. Configure Data Alerts4:53
Part 4 Section 5 - Manage datasets
-
1. Analyze in Excel5:52
-
2. Promote or Certify (Endorse) a Dataset5:49
-
3. Manually Refreshing data in the Power BI Service4:21
-
4. Data Gateways; Providing Access to Datasets9:38
-
5. Configure a Dataset Scheduled Refresh7:17
-
6. Configure Incremental Refresh Settings - Step 16:40
-
7. Configure Incremental Refresh Settings - Step 27:43
Part 4 Section 6 - Create and manage workspaces
-
1. Create and Configure a Workspace4:53
-
2. Assign Workspace Roles5:23
-
3. Providing Access to Datasets5:17
-
4. Configure and Update a Workspace App13:17
-
5. Promote or certify Power BI report or app2:18
-
6. Publish, Import or Update Assets in a Workspace - Publish securely5:43
-
7. Publish reports on the web, so the public can see7:27
Part 4 Section 7 - Other Power BI Service Topics
-
1. Create a PivotTable from a Power BI dataset in Excel4:38
-
2. Use or create a dataflow7:56
-
3. Creating Scorecards and Metrics7:40
-
4. Sharing Scorecards and Metrics4:45
-
5. Using Scorecards and Metrics5:24
Not needed for the PL-300 exam
-
1. Implement Object-Level Security6:41
-
2. Drillthrough from another report6:57
-
3. Export Data6:08
-
4. Recommend a Development Lifecycle Strategy5:24
-
5. Identify downstream dataset dependencies4:14
-
6. Personalize visuals8:33
-
7. Dataflow Scheduled Refresh and Endorsement1:28
-
8. Connect to a dataset using the XMLA endpoint4:22
-
9. Configure large dataset format2:09
-
10. Dashboard Data Classifications5:23
End of Part 4
-
1. End of Part 400:54
Well done
-
1. That's almost it for the Power BI Service1:27
About PL-300: Microsoft Power BI Data Analyst Certification Video Training Course
PL-300: Microsoft Power BI Data Analyst certification video training course by prepaway along with practice test questions and answers, study guide and exam dumps provides the ultimate training package to help you pass.
Prepaway's PL-300: Microsoft Power BI Data Analyst video training course for passing certification exams is the only solution which you need.
Pass Microsoft PL-300 Exam in First Attempt Guaranteed!
Get 100% Latest Exam Questions, Accurate & Verified Answers As Seen in the Actual Exam!
30 Days Free Updates, Instant Download!
PL-300 Premium Bundle
- Premium File 301 Questions & Answers. Last update: Nov 14, 2024
- Training Course 266 Video Lectures
- Study Guide 452 Pages
Free PL-300 Exam Questions & Microsoft PL-300 Dumps | ||
---|---|---|
Microsoft.realtests.pl-300.v2024-09-01.by.ollie.10q.ete |
Views: 0
Downloads: 759
|
Size: 1.19 MB
|
Student Feedback
Can View Online Video Courses
Please fill out your email address below in order to view Online Courses.
Registration is Free and Easy, You Simply need to provide an email address.
- Trusted By 1.2M IT Certification Candidates Every Month
- Hundreds Hours of Videos
- Instant download After Registration
A confirmation link will be sent to this email address to verify your login.
Please Log In to view Online Course
Registration is free and easy - just provide your E-mail address.
Click Here to Register