Shopping Cart

No products in the basket.
Course Content
Introduction
0/10
DOWNLOAD COURSE MATERIAL !
Course Objectives
01:53
What is Power BI
01:51
Why you Should Learn Power BI
02:42
Fundamentals of Power BI
02:59
Power BI Architechture
03:25
Power BI vs Excel
03:05
Pillars of Power BI Solution
02:14
Downloading Power BI
01:52
Understanding the Interface and features of Power BI
14:36
Query and Transforming Data
This module includes files for the course.
0/21
Accompanying Files – DOWNLOAD !
Overview of Query Editor
01:24
Effective Ways to Source Data
05:58
Understanding Data Type and When to Use Them
04:12
Profile The Data
02:34
Deleting Previous Steps
03:02
Filter Columns with Data
01:45
Naming Conventions to Column and Queries
02:24
Column Transformation
11:57
Row Transformation
07:27
Grouping Queries
01:13
Duplicate vs Reference
02:52
Append Queries
07:33
Merge Queries
04:27
Understanding M
02:14
Causes of Errors in Query Editor
04:17
Change of Data Source Settings
02:31
Significance of Date Table
04:39
Unpivot Columns
06:26
Data Connectivity Modes
01:27
Cleaning and Automating Raw Data
16:03
1st Quiz
0/1
1st Quiz
Data Modeling and Relationship
0/13
Overview of Data Modeling
01:19
Significance of Data Modeling
00:59
Benefits of a Good Data Model
00:54
Understanding Granularity
01:20
Increasing Model Analytical Power
00:53
Leveraging Data Model
02:07
Understanding Fact and Dimension Tables
01:53
Things to Note About Fact and Dimension Tables
04:25
Helper Columns and Tables
00:45
Types of Relationship
04:14
Understanding Star Schema
02:08
Understanding Snowflakes
03:46
Creating Relationships
11:02
DAX Calculations
0/37
Overview of Data Analysis Expression (DAX)
02:21
Primary Calculation Using DAX
00:31
Calculated Columns and Measures
12:38
Aggregation Functions
09:05
X-Aggregation Functions
08:26
Counting Values
04:09
Conditional Functions
05:13
Switch Functions
04:38
Handling Errors
03:59
Using Variables
08:25
Mathematical and Other Functions
03:12
Relational Functions
08:20
Table Functions
01:02
Filter Functions
08:58
Ignoring Filters
07:47
Combining Filters
02:04
Distinct and Values
01:36
ALLSELECTED
04:14
RELATEDTABLE
06:01
Evaluation Context
01:01
Filter Context
06:28
Row Context
03:58
Context Errors
03:11
Filtering a Table
04:16
Evaluation Context and Relationship
01:40
Filter and Relationship
01:09
CALCULATE
04:16
CALCULATE – Example
09:52
CALCULATE Modifiers
01:07
User Relationship
04:17
Cross Filter
04:26
KeepFilters
02:33
Context Transitions
08:12
Context Transitions and Iterators
01:55
RANKX
06:04
ISINSCOPE
03:50
Time Intelligence Functions
16:24
Report and Data Visualizations
0/4
Overview of Reports and Visualization
01:27
How to Pick the Right Charts
00:35
Four Types of Charts
02:46
Design Best Practices
01:49
2nd Quiz
0/1
2nd Quiz
Sales Insights Dashboard
0/9
Overview of Dashboard and Dataset
03:36
Bringing Data into Model
01:10
Transformation and Cleaning of Data
06:31
Data Modeling
03:35
Writing of DAX Measures
11:01
Creating Best Fit Visuals
13:56
Data Visualization and Report Formatting
21:46
Creating Tooltips
08:51
Managing Interaction Between Visuals
04:15
Performance Insights Dashboard
0/7
Overview of Dashboard and Dataset
03:16
Bringing Data into Model
02:32
Transforming and Cleaning Data
03:36
Data Modeling
03:05
Writing of DAX Measures
12:30
Creating Best Fit Visuals
15:53
Data Visualization and Report Formatting
21:43
Employee Insights Dashboard
0/8
Overview of Dashboard and Dataset
02:05
Bringing Data into Model
01:55
Transforming and Cleaning Data
04:34
Data Modeling
02:03
Writing of DAX Measures
10:12
Creating Best Fit Visuals
09:01
Data Visualization and Report Formatting
18:22
Publishing Report to Power BI Online Service
06:54
Financial Insights Dashboard
0/7
Overview of Dashboard and Dataset
04:28
Bringing Data into Power Query
02:10
Transforming and Cleaning Data
04:18
Data Modeling
03:33
Writing of DAX Measures
18:40
Creating Best Fit Visuals
08:58
Data Visualization and Report Formatting
17:53
CAPSTONE PROJECT
Create a Power BI Dashboard using the provided "Consumer Goods Sales.xlsx" dataset. Refer to the capstone project instructions titled "Sales Data Insight - Instructions" for detailed guidance. Once you've followed the task instruction outlined in the capstone project, save your completed dashboard in ".pbix" format and upload it for evaluation. Successful completion of this project requires achieving a minimum score of 60%. If you reach or exceed this score, you will pass the course and be eligible to download your certificate. Students who do not attain a score of 60% will need to redesign their dashboard and submit the revised version. If you have any questions or need further clarification, please refer to the project instructions or seek assistance from your instructor. Good luck with your project!
0/2
Human Resource Insights Dashboard
Sales Insights Dashboard
Power BI for Data Analysis
Previous
Next
0% Complete