PowerBI
Topics for this course
PowerBI
-
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
Description
This Power BI course offers a complete, hands-on introduction to data analysis, transformation, and visualization using Microsoft Power BI. Learners start by installing Power BI Desktop and connecting to multiple data sources including CSV, SQL, folders, and XML files. The course covers data cleaning and transformation using Power Query Editor, data modeling with relationships and schemas, and building interactive visuals. Students learn DAX fundamentals to create calculated columns and measures. The course also focuses on report design, slicers, drill-through, bookmarks, and best practices, enabling learners to create professional, interactive business intelligence dashboards.
