Course Content
PowerBI
0/63
Installing and setting up Power BI desktop
04:19
About the data and way forward
10:19
Getting data from a CSV file
09:44
Getting data from SQL DB
07:45
Getting data from all files in a folder
06:10
Getting data from XML file
03:27
Introduction to Power Query Editor
06:59
Important checks before we transform data
09:26
Merging and Appending Queries Theory
05:31
Appending queries
11:00
Merging queries
09:30
Manage rows and columns
11:30
Split columns
08:59
Replace Values option
04:05
Group By
05:17
Pivoting and unpivoting theory
03:01
Pivoting and Unpivoting
04:10
Extract Tool
06:13
Format text options
08:18
Number Transformations
06:26
Date Time Transformations
08:11
Add column – Column from examples
06:18
Add a custom column
06:03
Conditional and index column
05:12
Introduction to Model View
04:12
Creating and Modifying Relationships
08:06
Cardinality and Cross filter direction
11:19
Fact and Dimensions tables
03:30
Star and Snowflake Schemas
03:18
Data Pane and the Properties Pane
08:55
Bar chart and Column chart in Power BI
06:38
Clustered bar chart and stacked bar chart
11:07
Formatting options in a chart
14:47
General formatting options
04:30
Small multiples, Tooltips and Drill Through
14:13
Line and Area Chart
09:54
Combination chart or Combo chart
07:00
Pie and Donut chart
05:13
Scatter chart and Bubble chart
08:55
Filters
12:13
Add further analysis tab
05:17
Table and Matrix Visuals
04:52
Card and Multi-row card
03:41
Hierarchies in Power BI
07:21
Tree map
06:48
Map charts in Power BI
05:06
Conditional formatting of charts
04:14
Introduction to DAX
08:53
DAX syntax and Row and filter context
05:55
Types of operators and functions
06:40
Demonstration of new columns and new measures
11:30
Using explicit measures to create new measures
06:06
IF function with logical operators
04:12
Count and Distinct count functions
03:49
RELATED function
03:57
CALCULATE function
06:00
Introduction to reports
05:36
Formatting report page and creating a page template
08:45
Slicers on report page
05:46
Drill-through for report pages
05:11
Page navigator
02:58
Bookmarks
05:33
PowerBI Quiz
PowerBI
Previous
Next
0% Complete