Power BI Demo
-
01 Power BI Demo Part1 - Dec 1st 2023 (51:38)
-
02 Power BI Demo Part2 - Dec 2nd 2023 (65:36)
-
03 Power BI Demo Part3 - Dec 4th 2023 (64:35)
-
04 Power BI - Installation (49:42)
-
05 Power BI - Intro (53:56)
-
06 Power BI - Create My First Report Part1 (23:51)
-
07 Power BI - Create My First Report Part2 (53:41)
-
08 Power BI - Deploy a Report (57:31)
-
09 Power BI - Building Blocks (45:38)
Power Query
-
01 Power Query - Intro and Data Types (63:19)
-
02 Power Query - Filters (42:01)
-
03 Power Query - SDLC Process (51:38)
-
04 Power Query - Column Transformations (52:05)
-
05 Power Query - Str Vs UnStr Data and Pivot, Unpivot, Transpose, Replace (66:30)
-
06 Power Query - Row Transformations (41:58)
-
07 Power Query - Joins Part1 (50:48)
-
08 Power Query - Joins Part2 (63:06)
-
09 Power Query - Union Vs Union All and Combine Data from Multiple Files (47:16)
-
10 Power Query - Append Excel Sheets (18:09)
-
11 Power Query - Parameters, Index Column and Condition Column and Invoke Function (49:12)
-
12 Power Query - Query Options (33:47)
Power BI Service
-
01 Power BI Service - Intro (34:59)
-
02 Power BI Service - Create Dataset Part1 (51:51)
-
03 Power BI Service - DWH vs DB and Connectivity Modes and SSAS Intro (62:26)
-
04 Power BI Service - Create Dataset using SQL Tables, Views and SPs Part1 (70:10)
-
05 Power BI Service - Create Dataset using SQL Tables, Views and SPs Part2 (41:29)
-
06 Power BI Service - SQL Schemas and Intro to Dashboards (45:11)
-
07 Power BI Service - Create Dashboards (29:36)
-
08 Power BI Service - Env in IT and Data Gateways (43:49)
-
09 Power BI Service - Install Data Gateway and Use (40:52)
-
10 Power BI Service - Data Connectivity Modes and Gateway and Use (41:16)
-
11 Power BI Service -Demos on Direct Query using SQL (40:13)
-
12 Power BI Service-Team Collaboration Part 01 (26:01)
-
13 Power BI Service-Team Collaboration Part 02 (10:45)
-
14 Power BI Service- Sharing Content (19:35)
-
15 Power BI Service - Dynamic Row Level Security (55:23)
DWH
-
01 DWH - Intro (49:52)
-
02 DWH - Top Down vs Bottm Up Approach (44:53)
-
03 DWH - ODS Vs DWH (43:28)
-
04 DWH - Convert OLTP Data to OLAP Data (43:15)
-
05 DWH - Intro to Dim Modeling (56:13)
-
06 DWH - Designing Stage and DWH (49:54)
-
07 DWH - Normalization Vs De-Normalization and Designing DWH (57:03)
-
08 DWH - Schemas (52:28)
-
09 DWH - Load Data to DWH using SSIS (72:37)
-
10 DWH - Dims and Facts (17:18)
-
11 DWH - Types of Dimensions (61:25)
-
12 DWH - Types of Dimensions SCD and Inferred Dim (54:04)
-
13 DWH - Types of Facts (51:03)
-
Amazon Project Scripts
SSAS Tabular Model Cubes
Power Pivot
-
01 Power Pivot-Intro and Colnar Database (42:10)
-
02 Power Pivot -Pivot and Unpivot and Transpose (48:37)
-
03 Power Pivot-Intro to DAX (51:31)
-
04 Power Pivot-New Column Vs New Measure in DAX (18:46)
-
05 Power Pivot-DAX Operators (36:33)
-
06 PBI - Project Intro (21:11)
-
07 Power Pivot- Dax Logical Functions Part 1 (59:29)
-
07 Power Pivot -DAX String Functions Part 1 (26:37)
-
08 Power Pivot -DAX Logical Functions Part 2 (24:48)
-
09 Power Pivot -DAX String Functions (39:17)
-
10 Power Pivot -DAX Date and Time Functions Part 1 (54:36)
-
11 Power Pivot -DAX Date and Time Functions Part 2 (41:58)
-
12 DAX - Math and Statistical Functions (75:12)
-
13 DAX - Query Folding (17:26)
-
14 DAX - Logical Functions Part1 (36:05)
-
15 DAX - Filter Functions Part2 (50:23)
-
16 DAX - Filter Functions Part3 (14:12)
-
17 DAX - Time Intelligence Functions (59:34)
-
18 Power BI - Interview Prepation (39:47)
Power View
-
01 Power View - Intro (42:09)
-
02 Power View - Filters (49:39)
-
03 Power View - Drill Down and Hierarchy Reports (50:07)
-
04 Power View - Slicer Visualization (50:21)
-
05 Power View - Slicer Visualization - Part2 (10:56)
-
06 Power View - Pie Chart (22:22)
-
07 Power View - Pie, Dounut and Tree Map Charts (41:10)
-
08 Power View - Bar and Column Charts and Intro to ML and AI (43:44)
-
09 Power View - 100% Column, Scatter Charts (31:25)
-
10 Power BI - Interview Preparation (18:29)
-
11 Power BI - Trend Visualizations (45:36)
-
12 Power View - Bookmarks and Selection Pane (21:49)
-
13 Power View - Grouping and Binning and Sorting (36:31)
-
14 Power View - KPI Visualizations (46:42)
-
15 Power View - Map Visualizations (57:57)
-
16 Power View - Table and Matrix Visualizations (58:12)
Power BI Service
-
01 Power BI Service - Intro and DWH and Data Lake (55:42)
-
02 Power BI Service - Create Dataset Part1 (67:24)
-
03 Power BI Service - Create Dataset Part2 and Deploy and Data Engineering (67:22)
-
04 Power BI Service - Intro to Dashboards and Create Pagenated Reports (29:40)
-
05 Power BI Service - Create Dashboards (29:31)
-
06 Power BI Service - Investments (44:06)
-
07. Power BI Service - Data Gateways Part1 (19:48)
-
08 Power BI Service - Data Gateways Part2 (55:28)
-
09 Power BI Service - Data Connectivity Modes and Why SSAS (56:30)
-
10 Power BI Service - Data Gateways SQL with Direct Query (42:52)
-
11 Power BI Service - Data Gateways Excel With Import and SQL with Direct Query (36:40)
-
12 Power BI Service - Team Collaboration (27:36)
-
13 Power BI Service - Share the Reports and Dashboards (24:30)
-
14 Success Story of Manohar (44:03)
-
15 Power BI - Interview Preparation (35:32)
-
16 Power BI Service - Env in IT and Row Level Security (52:40)
-
17 Power BI Service - Dynamic Row Level Security (55:23)
Data Modeling
DAX
