What Will I Learn?
- Build professional looking dashboards from scratch
- Transform raw data into powerful visualisations
- Master visualisations to help take meaningful business decisions
- 1 additional project to level up !
Curriculum For This Course
96 Lessons
09:28:39 Hours
Course files
11 Lessons
00:00:00 Hours
- DiscountRetail_Calendar
- DiscountRetail_Customers
- DiscountRetail_Product_Categories
- DiscountRetail_Product_Subcategories
- DiscountRetail_Products
- DiscountRetail_Returns
- DiscountRetail_Territories
- DiscountRetail_Sales_2018
- Discountretail_Sales_2019
- DiscountRetail_Sales_2020
- DiscountRetail_Logo
Module 1 - Connecting and Transforming Data
15 Lessons
01:57:40 Hours
- Video 1 - Types of data connectors 00:04:41
- Video 2 - Query editor and basic transformations 00:17:10
- Video 3 - Text based transformations 00:15:09
- Video 4 - Numeric transformations 00:07:48
- Video 5 - Date and time transformations 00:09:46
- Video 6 - Index and conditional columns 00:08:45
- Video 7 - Grouping and aggregating 00:06:00
- Video 8 - Pivoting Unpivoting 00:04:32
- Video 9 - Merge queries 00:06:24
- Video 10 - Appending queries 00:06:08
- Video 11 - Appending files through folder 00:09:50
- Video 12 - Change data source settings 00:04:24
- Video 13 - Refresh settings 00:03:08
- Video 14 - Additional data types and categories 00:08:59
- Video 15 - Creating hierarchies 00:04:56
Module 1 - Practice Questions
2 Lessons
00:19:10 Hours
- Module 1 - Practice questions
- Homework solutions 00:19:10
Module 2 - Data Modelling
13 Lessons
01:21:31 Hours
- Video 1 - What is data model 00:06:46
- Video 2 - Database Normalisation 00:06:15
- Video 3 - Filter context 00:06:47
- Video 4 - Data table vs Lookup table 00:09:54
- Video 5 - Creating relationships 00:09:48
- Video 6 - Snowflake Chemas 00:03:30
- Video 7 - managing and editing relationships 00:03:02
- Video 8 - Active vs Inactive Relationship 00:04:02
- Video 9 - Relationship cardinality 00:03:44
- Video 10 - Connecting multiple data tables 00:07:55
- Video 11 - Two way filters 00:06:56
- Video 12 - Hiding from report view 00:04:26
- Video 13 - Model view 00:08:26
Module 2 - Practice Questions
2 Lessons
00:15:51 Hours
- Practice Questions
- Homework solutions 00:15:51
Module 3 - DAX Calculations
20 Lessons
03:26:30 Hours
- Video 1 - Introduction to DAX 00:06:09
- Video 2 - Introduction to DAX Calculated Columns 00:13:19
- Video 3 - Introduction to DAX measures 00:03:34
- Video 4 - Adding columns and measures 00:03:00
- Video 5 - Implicit vs Explicit measures 00:08:08
- Video 6 - Filter context in DAX 00:04:50
- Video 7 - DAX syntax and operators 00:14:32
- Video 8 - Common DAX function categories 00:04:02
- Video 9 - Basic date and time functions 00:15:46
- Video 10 -IF OR 00:11:22
- Video 11 - Text Functions 00:08:39
- Video 12 - Related function 00:12:53
- Video 13 - Basic math and stats functions 00:17:45
- Video 14 - Count functions 00:11:27
- Video 15 - Order line items 00:04:55
- Video 16 - Calculate function 00:16:36
- Video 17 - Calculate and All 00:13:42
- Video 18 - Calculate and filter 00:09:19
- Video 19 - Iterator functions 00:12:10
- Video 20 - Time intelligence functions 00:14:22
Module 3 - Practice Questions
3 Lessons
00:24:05 Hours
- Practice Questions
- Homework solutions - 1 00:10:05
- Homework solutions - 2 00:14:00
Module 4 - Creating data visualisations
16 Lessons
01:43:52 Hours
- Video 1 - Report View 00:04:19
- Video 2 - Basic charts and visualisations 00:04:25
- Video 3 - Formatting options 00:06:21
- Video 4 - Matrix visualisation 00:07:58
- Video 5 - Date slicers 00:08:08
- Video 6 - Key metrics with KPIs 00:09:33
- Video 7 - Text Cards 00:08:17
- Video 8 - Geospatial Data with Maps 00:06:20
- Video 9 - Treemap visualisation 00:02:19
- Video 10 - Line and Area chart 00:06:37
- Video 11 - Trendlines and forecasts 00:05:13
- Video 12 - Gauge charts 00:09:46
- Video 13 - Edit interactions among visuals 00:03:15
- Video 14 - Drillthrough Filters 00:04:41
- Video 15 - Linking Bookmarks 00:04:13
- Video 16 - What-If Analysis 00:12:27
Module 4 - Practice Questions
1 Lessons
00:00:00 Hours
- Practice Questions
Bonus Case Study
13 Lessons
00:00:00 Hours
- Section 1 - Bonus Case Study
- Section 2
- Section 3
- Section 4
- SuperMarket_Calendar
- SuperMarket_Customer
- SuperMarket_Products
- SuperMarket_Regions
- SuperMarket_Returns_97-98
- SuperMarket_Stores
- SuperMarket_Transactions - 97
- SuperMarket_Transactions - 98
- SuperMarket_Logo
Requirements
- Microsoft Power BI Desktop (Free version)
- Windows (currently Power BI is not accessible on Mac)
- Knowledge about Excel function (recommended but not mandatory)
+ View More
Description
+ View More
Other Related Courses
About The Instructor
- 13 Reviews
- 14 Students
- 13 Courses
+ View More
Created by highly qualified professionals, AR Finance Room works with the motive of helping students and professionals learn and grow with customized courses.
.
Student Feedback
Reviews
-
Mon, 23-Aug-2021Hrishikesh S
-
Sat, 28-Aug-2021Abhishek Gautam
Write A Public Review