Course Content
Subtitle Guide – Hướng dẫn thêm phụ đề
0/1
Set up subtitle for video – Hướng dẫn thêm phụ đề
01 Introduction
0/6
Download Resource Files
001 Introduction
02:26
003 The Udemy Interface
02:00
005 What are we going to learn_part1
03:48
005 What are we going to learn_part2
03:48
006 Installing Power BI Desktop
04:14
02 Part 1 Level 1 Creating and formatting a table visualization
0/10
Download Resource Files
001 Welcome to Part 1 Visualizations
01:51
002 Importing from Excel, and Creating our first visualization
06:04
003 Exploring Power BI Desktop – Report view
07:34
004 Exploring Power BI Desktop – Data view
04:20
005 Focus mode and Different visualizations
04:00
006 Why do I need a Work email address And how can I get one, if I don’t have it_part1
04:18
006 Why do I need a Work email address And how can I get one, if I don’t have it_part2
04:18
007 Saving visualization to the Desktop and to the Power BI service
05:09
009 Practice Activity Number 1 – The Solution
07:31
03 Part 1 Level 2 Formatting our first visualization
0/16
Download Resource Files
001 Opening the Format Pane – for older versions of Power BI
01:22
002 Exploring the Format Pane (for all versions of Power BI)
03:57
003 Formatting using On-object Interaction
07:33
004 Formatting font and font size
04:29
005 Formatting colors
05:20
006 Stylistic options
06:39
007 Position visuals
06:26
008 Align visuals
04:34
009 Format Painter
02:45
010 Configuring summarization, both default and in a specific visualization_part1
05:40
010 Configuring summarization, both default and in a specific visualization_part2
05:40
011 Changing number and date formatting
06:54
012 Custom number and date formatting
05:25
014 Practice Activity Number 2 – The Solution_part1
04:11
014 Practice Activity Number 2 – The Solution_part2
04:11
04 Part 1 Level 3 Creating different visualizations Matrices and bar charts
0/14
Download Resource Files
001 Matrix
07:10
002 Drill down data, see data and records, and export data_part1
04:12
002 Drill down data, see data and records, and export data_part2
04:12
003 Stacked bar charts and switch theme for reports_part1
03:42
003 Stacked bar charts and switch theme for reports_part2
03:41
004 Bar Chart formatting, including continuous versus categorical axes
05:36
005 Configure interactions between visual (Edit interactions)_part1
04:16
005 Configure interactions between visual (Edit interactions)_part2
04:16
006 Clustered and 100% Stacked bar charts_part1
02:54
006 Clustered and 100% Stacked bar charts_part2
02:54
007 Line and area charts, including 8b Configure duplicate pages
06:39
008 Combo charts (Line and column charts)
08:28
010 Practice Activity Number 3 – The Solution
07:18
05 Part 1 Level 4 Adding more control to your visualizations
0/23
Download Resource Files
001 Adding Text boxes, Images and Shapes_part1
04:36
001 Adding Text boxes, Images and Shapes_part2
04:35
002 Visual level, page level and report level filters – basic filters_part1
03:29
002 Visual level, page level and report level filters – basic filters_part2
03:29
003 Advanced Filtering
10:40
004 Filter Top N Items
05:29
005 Slicer
07:22
006 Synchronizing slicers to multiple pages
05:18
007 Slicer Warning
03:16
008 Sort visuals
06:54
009 Configure small multiples
08:22
010 Use Bookmarks for reports
06:12
011 Group and layer visuals by using the Selection pane
03:48
012 Drillthrough_part1
05:39
012 Drillthrough_part2
05:39
013 Buttons and Actions
06:01
014 Page Navigation and Drill through actions
06:38
015 Enable Natural Language Queries (Ask A Question) and Page Formatting_part1
03:58
015 Enable Natural Language Queries (Ask A Question) and Page Formatting_part2
03:58
016 Tooltip Pages
09:38
017 Page and Bookmark Navigator
06:14
019 Practice Activity Number 4 – The Solution
10:03
06 Part 1 Level 5 Other visualizations
0/10
Download Resource Files
001 Ribbon charts
06:31
002 Waterfall charts
08:04
003 Scatter, bubble and dot charts_part1
05:05
003 Scatter, bubble and dot charts_part2
05:05
004 Pie charts and donut charts
04:54
005 Treemaps
02:26
006 Funnel charts
02:45
007 Adding Marketplace visualizations (Import a Custom Visual)
03:05
009 Practice Activity Number 5 – The Solution
07:26
07 Part 1 Level 6 Mapping
0/16
Download Resource Files
002 Maps_part1
03:49
002 Maps_part2
03:49
003 Formatting maps
04:46
004 Adding Data Categories_part1
03:38
004 Adding Data Categories_part2
03:38
005 Filled Maps,Conditional Formatting, and color blindness_part1
04:46
005 Filled Maps,Conditional Formatting, and color blindness_part2
04:46
006 Creating hierarchies_part1
04:20
006 Creating hierarchies_part2
04:20
007 ArcGIS Maps for Power BI_part1
05:16
007 ArcGIS Maps for Power BI_part2
05:16
009 Practice Activity Number 6 – The Solution_part1
04:14
009 Practice Activity Number 6 – The Solution_part2_part1
02:07
009 Practice Activity Number 6 – The Solution_part2_part2
02:07
009 Practice Activity Number 6 – The Solution_part3
04:14
08 Part 1 Level 7 Measure performance by using KPIs, gauges and cards
0/8
Download Resource Files
001 Gauges
05:39
002 Cards and Multi-row cards
04:45
003 More conditional formatting
07:43
004 KPIs
04:05
006 Practice Activity Number 7 – The Solution_part1
05:09
006 Practice Activity Number 7 – The Solution_part2
05:09
006 Practice Activity Number 7 – The Solution_part3
05:09
09 Part 1 Level 8 Identify patterns and trends and Other Visualization Items
0/16
Download Resource Files
001 Define quick measures
07:23
002 Export report data
03:56
003 Create reference lines by using Analytics pane, including the Forecast feature_part1
04:49
003 Create reference lines by using Analytics pane, including the Forecast feature_part2
04:49
004 Use error bars
06:07
005 Identify outliers
03:23
006 Use clustering
03:44
007 Use Anomaly Detection
05:11
008 Add a Smart Narrative visual
06:18
009 Use groupings and binnings
06:42
010 Use the AI Visual Key Influencers to explore dimensional variances
08:44
011 Use the Analyze feature in Power BI
05:40
012 Use the AI Visual decomposition tree visual to break down a measure
06:04
013 Creating a paginated report
06:00
014 Exploring Power BI Report Builder
06:33
10 Additional videos – Visualize and Analyze the Data
0/4
Download Resource Files
002 Design and configure for accessibility
05:45
003 R and Python Visualizations
04:18
004 Use or create a PBIDS file
03:03
11 End of Part 1
0/2
Download Resource Files
001 End of Part 1
01:06
12 Part 2 Get and Transform Data Level 1 – Home Part 1
0/13
Download Resource Files
001 Welcome to Part 2 Get and Transform Data
01:49
002 Introduction – let’s Get some more Data
05:00
003 Exploring the Power Query Editor interface_part1
04:33
003 Exploring the Power Query Editor interface_part2
04:33
004 Introducing the M language_part1
04:38
004 Introducing the M language_part2
04:38
005 Let’s start look at the Home tab
04:19
006 Home menu – Manage Columns
06:05
007 Home menu – Reduce Rows and Use First Row as Headers_part1
03:43
007 Home menu – Reduce Rows and Use First Row as Headers_part2
03:43
009 Practice Activity Number 8 – The Solution_part1
03:38
009 Practice Activity Number 8 – The Solution_part2
03:38
13 Part 2 Level 1 – Get Data – Home
0/7
Download Resource Files
001 Sort and Filter
05:52
002 Split Column_part1
03:37
002 Split Column_part2
03:37
003 Other Transform activities_part1
04:53
003 Other Transform activities_part2
04:53
005 Practice Activity Number 9 – The Solution
06:10
14 Part 2 Level 2 – Getting Multiple files
0/11
Download Resource Files
001 Merge Queries and Expand Table_part1
03:05
001 Merge Queries and Expand Table_part2
03:05
002 Merge Queries with Group By, and different types of Joins_part1
03:27
002 Merge Queries with Group By, and different types of Joins_part2
03:27
004 Appending two queries together
04:34
005 Appending three or more queries together + resolving a problem with data types
06:25
006 Combine Files (getting information from a folder)
08:50
008 Practice Activity Number 10 – The Solution_part1
05:03
008 Practice Activity Number 10 – The Solution_part2
05:03
008 Practice Activity Number 10 – The Solution_part3
05:03
15 Part 2 Level 3 – Transform Menu
0/12
Download Resource Files
001 Transform – Table and Any Column
05:27
002 Pivot Column_part1
03:18
002 Pivot Column_part2
03:18
002 Pivot Column_part3
03:18
003 Unpivot_part1
05:15
003 Unpivot_part2
05:15
005 Practice Activity 11 – The Solution_part1
03:33
005 Practice Activity 11 – The Solution_part2
03:33
006 Unpivot in conjunction with other Transform features
10:05
008 Practice Activity 12 – The Solution_part1
04:07
008 Practice Activity 12 – The Solution_part2
04:07
16 Part 2 Level 4 – Transform – Text and Numbers
0/12
Download Resource Files
001 TransformAdd Column – Text – Format
06:02
002 TransformAdd Column – Text – Merge Columns
07:41
003 TransformAdd Column – Text – Extract
06:53
004 TransformAdd Column – Text – Parse_part1
05:19
004 TransformAdd Column – Text – Parse_part2
05:18
005 TransformAdd Column – Number Column – Statistics and Standard_part1
03:05
005 TransformAdd Column – Number Column – Statistics and Standard_part2
03:05
006 TransformAdd Column – Other Number Column functions
05:00
008 Practice Activity Number 13 – The Solution_part1
04:19
008 Practice Activity Number 13 – The Solution_part2
04:19
008 Practice Activity Number 13 – The Solution_part3
04:19
17 Part 2 Level 5 – Transform – Dates and Time
0/10
Download Resource Files
001 Creating a list of dates
08:00
002 TransformAdd Column – Date_part1
04:17
002 TransformAdd Column – Date_part2
04:17
003 TransformAdd Column – Dates in other cultureslanguages_part1
05:26
003 TransformAdd Column – Dates in other cultureslanguages_part2
05:26
004 TransformAdd Column – Time
06:27
005 TransformAdd column – Duration
03:15
007 Practice Activity Number 14 – The Solution_part1
03:44
007 Practice Activity Number 14 – The Solution_part2
03:44
18 Part 2 Level 6 – Add Columns, View and Help Menus
0/12
Download Resource Files
001 Column from examples – dates and numbers
07:11
002 Column from examples – text
06:18
003 Importing CSVtext files and Extract Tables Using Examples
03:38
004 Conditional Column
10:25
005 Resolving Errors from Conditional Columns
04:08
006 Index Column and Duplicate Column
03:42
007 Custom Column – If Then Else_part1
04:30
007 Custom Column – If Then Else_part2
04:30
008 Converting text from a different locale to a number
04:24
010 Practice Activity Number 15 – The Solution_part1
04:53
010 Practice Activity Number 15 – The Solution_part2
04:53
19 Part 2 Level 7 – View and Help menus and advanced functionality
0/10
Download Resource Files
001 Other M Functions
05:41
002 View and Help menus, including Column Properties
05:26
003 Profile the data
02:22
004 Advanced Editor
04:18
005 Functions and Parameters_part1
05:52
005 Functions and Parameters_part2
05:52
006 DateTimeZone date type and M functions
04:46
007 Worked Practice Activity Number 16 – Dividing Annual data into Months_part1
05:32
007 Worked Practice Activity Number 16 – Dividing Annual data into Months_part2
05:32
20 Part 2 Level 8 – Get other types of data
0/12
Download Resource Files
002 Introduction to SQL Server
05:26
003 Importing database data into Power BI, and Query Folding
07:19
004 Expanding multiple tables in SQL Server
06:32
005 Select a storage mode
04:54
006 Importing data from SQL Server Analysis Services (SSAS)
05:49
007 Setting up Azure SQL Database_part1
03:42
007 Setting up Azure SQL Database_part2
03:42
008 Using Azure SQL Database in Power BI_part1
04:17
008 Using Azure SQL Database in Power BI_part2
04:17
009 Use the Microsoft Dataverse
03:59
010 Configure data loading
04:40
21 Additional videos – Get and Transform
0/6
Download Resource Files
002 Automatic page refresh
05:17
003 Using Big Data
06:17
004 Resolve problems
05:29
005 Identify query performance issues, including Query Diagnostics
04:37
006 Apply AI Insights
05:21
22 End of Part 2
0/2
Download Resource Files
001 End of Part 2
01:15
23 Part 3 Level 1 Creating a Data Model
0/7
Download Resource Files
001 Welcome to Part 3 – Modeling and DAX functions
02:43
002 Get multiple data sets, and connecting them together
07:26
003 The problems with direction of relationships between data sets_part1
05:16
003 The problems with direction of relationships between data sets_part2
05:16
005 Practice Activity Number 17 – The Solution_part1
04:50
005 Practice Activity Number 17 – The Solution_part2
04:50
24 Part 3 Level 2 – An introduction to DAX functions, including Logical functions
0/12
Download Resource Files
001 DAX functions – A useful Resource
02:17
002 Calculated columns – an introduction
03:38
003 Basic operators
04:53
004 IF, BLANK and ISBLANK_part1
04:16
004 IF, BLANK and ISBLANK_part2
04:16
005 AND, OR and NOT
04:31
006 SWITCH
04:23
007 Other functions
02:46
009 Practice Activity Number 18 – The Solution_part1
04:22
009 Practice Activity Number 18 – The Solution_part2
04:22
009 Practice Activity Number 18 – The Solution_part3
04:22
25 Part 3 Level 3 – Statistical functions
0/8
Download Resource Files
001 Measures – an introduction, with standard aggregations including Countblank_part1
04:30
001 Measures – an introduction, with standard aggregations including Countblank_part2
04:30
002 Aggregation of calculations
05:57
003 Other statistical functions_part1
02:59
003 Other statistical functions_part2
02:59
005 Practice Activity Number 19 – The Solution_part1
03:40
005 Practice Activity Number 19 – The Solution_part2
03:40
26 Part 3 Level 4 – Mathematical functions
0/9
Download Resource Files
002 Rounding functions_part1
04:14
002 Rounding functions_part2
04:14
003 Division functions – MOD and QUOTIENT
02:56
004 SIGN (and use with SWITCH) and ABS_part1
03:08
004 SIGN (and use with SWITCH) and ABS_part2
03:08
005 Exponential functions
02:32
006 Other mathematical functions
03:08
008 Practice Activity Number 20 – The Solution
05:31
27 Part 3 Level 5 – Text functions
0/9
Download Resource Files
001 Text searching_part1
03:54
001 Text searching_part2
03:54
002 Text extraction and substitution_part1
03:38
002 Text extraction and substitution_part2
03:38
003 Text conversion_part1
04:03
003 Text conversion_part2
04:03
004 Other text functions
02:18
006 Practice Activity Number 21 – The Solution
05:42
28 Part 3 Level 6 – Information Functions
0/4
Download Resource Files
001 ISERROR and LOOKUPVALUE
05:22
002 Other information functions
02:11
004 Practice Activity Number 22 – The Solution
04:09
29 Part 3 Level 7 – Filter and Value Functions
0/14
Download Resource Files
001 RELATED – Flatten out a parent-child hierarchy
04:37
002 Design a data model that uses a star schema_part1
05:29
002 Design a data model that uses a star schema_part2
05:29
003 RELATEDTABLE and COUNTROWS
06:30
004 Context
04:21
005 ALL
05:46
006 FILTER
03:12
007 CALCULATE
03:08
008 ALLEXCEPT
06:02
009 ALLSELECTED_part1
04:30
009 ALLSELECTED_part2
04:30
010 Other filter and value functions
02:12
012 Practice Activity Number 23 – The Solution
08:30
30 Part 3 Level 8 – Time Intelligence Functions
0/14
Download Resource Files
001 Date and Time Functions
04:08
002 FIRSTDATE, LASTDATE
03:07
003 Start of and End of_part1
02:59
003 Start of and End of_part2
02:59
004 Previous and Next
05:03
005 DATESINPERIOD
04:09
006 DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD
02:51
007 Opening Balance and Closing Balance
02:02
008 Semi-additive Measures
02:36
009 SAMEPERIODLASTYEAR and PARALLELPERIOD
03:17
010 Other Time Intelligence Functions
02:12
012 Practice Activity Number 24 – The Solution_part1
05:03
012 Practice Activity Number 24 – The Solution_part2
05:03
31 Part 3 Level 9 – Other Modeling and DAX Topics for the exam
0/10
Download Resource Files
001 Create calculated tables
06:09
002 Create a common date table
06:57
003 Define role-playing dimensions
06:11
004 Resolve many-to-many relationships – Joint Bank Accounts
06:06
005 Resolve many-to-many relationships – Different types of granularity
06:25
006 Improve cardinality levels through summarization and by changing data types
08:55
007 Identify poorly performing measures, relationships, and visuals
06:11
008 The Optimize menu
08:33
009 End of Part 3
00:57
32 Part 4 Section 1 – An Introduction to the Power BI Service
0/10
Download Resource Files
001 Welcome to Part 4 The Power BI Service
01:58
002 Introducing The Power BI Service
03:57
003 Logging into Power BI Service and a quick look around
05:52
005 Power BI Terminology
11:11
006 Datasets and Reports in the Power BI Service
09:58
008 Get Data – Importing Your Data as a Semantic Model (Dataset)
08:43
010 Get Data – Importing your data as a Workbook
07:32
011 Other ways to Get Data
03:45
012 The Navigation Pane, including Add a Quick Insights result to a report
07:30
33 Part 4 Section 2 – Power BI Pro, adding users and sharing reports and visuals
0/8
Download Resource Files
001 Signing up for Power BI Pro
05:47
002 Adding new users
08:28
003 Creating a new report_part1
04:10
003 Creating a new report_part2
04:10
004 Sharing my new report
06:17
005 Sharing reports and visuals to PowerPoint
05:44
006 Using exported reports and visuals in PowerPoint
06:14
34 Part 4 Section 3 – Row Level Security
0/4
Download Resource Files
001 Adding role-based Row Level Security
07:50
002 Adding Dynamic Row Level Security
10:09
003 Testing Dynamic Row Level Security in the Power BI Service
06:54
35 Part 4 Section 4 – Dashboards
0/10
Download Resource Files
001 Differences between dashboards and reports
05:04
002 Manage Tiles on a Dashboard and other Tiles options
05:01
003 Dashboards Options including Set Mobile View
04:31
004 Configure Subscriptions
04:12
005 Pin a Live Report Page to a Dashboard
04:17
006 Use the QA Feature
02:56
007 Add a Dashboard Theme
06:25
008 Apply or Change Sensitivity Labels
06:34
009 Configure Data Alerts
04:54
36 Part 4 Section 5 – Manage datasets
0/8
Download Resource Files
001 Analyze in Excel
05:53
002 Promote or Certify (Endorse) a Dataset
05:49
003 Manually Refreshing data in the Power BI Service
04:22
004 Data Gateways; Providing Access to Datasets
09:38
006 Configure a Dataset Scheduled Refresh
07:18
007 Configure Incremental Refresh Settings – Step 1
06:40
008 Configure Incremental Refresh Settings – Step 2
07:44
37 Part 4 Section 6 – Create and manage workspaces
0/8
Download Resource Files
001 Create and Configure a Workspace
04:53
002 Assign Workspace Roles
05:23
003 Providing Access to Datasets
05:17
004 Configure and Update a Workspace App
13:18
005 Promote or certify Power BI report or app
02:18
006 Publish, Import or Update Assets in a Workspace – Publish securely
05:43
007 Publish reports on the web, so the public can see
07:27
38 Part 4 Section 7 – Other Power BI Service Topics
0/6
Download Resource Files
001 Create a PivotTable from a Power BI dataset in Excel
04:38
002 Use or create a dataflow
07:56
003 Creating Scorecards and Metrics
07:41
004 Sharing Scorecards and Metrics
04:45
005 Using Scorecards and Metrics
05:25
39 Not needed for the PL-300 exam
0/13
Download Resource Files
002 Implement Object-Level Security
06:41
003 Drillthrough from another report_part1
03:29
003 Drillthrough from another report_part2
03:29
004 Export Data
06:08
005 Recommend a Development Lifecycle Strategy
05:24
006 Identify downstream dataset dependencies
04:15
007 Personalize visuals_part1
04:17
007 Personalize visuals_part2
04:16
008 Dataflow Scheduled Refresh and Endorsement
01:30
009 Connect to a dataset using the XMLA endpoint
04:22
010 Configure large dataset format
02:09
011 Dashboard Data Classifications
05:24
40 End of Part 4
0/2
Download Resource Files
001 End of Part 4
00:55
41 Well done
0/2
Download Resource Files
002 Congratulations for finishing the course!
01:19
42 Bonus Lecture
0/1
Download Resource Files
PL-300 certification: Microsoft Power BI Data Analyst
Join the conversation
Previous
Next

Please contact me via telegram

DMCA.com Protection Status