Power BI
-
01 Power BI Demo Part1 - Nov 1st 2023 (60:56)
-
02 Power BI Demo Part2 - Nov 2nd 2023 (61:56)
-
03 Power BI Demo Part3 - Nov 3rd 2023 (66:08)
-
04 Power BI and SQL Installation (53:54)
-
05 Power BI - Create My First PBI Report Part1 (23:59)
-
06 Power BI - Create My First PBI Report Part2 (45:11)
-
07 Power BI - Cloud Intro and Report Deployment (52:35)
-
08 Power BI - PBI Componenets (53:26)
-
09 Power BI - Building Blocks (34:01)
-
10 Power BI - SDLC Process (51:38)
Power Query
-
01 Power Query - Intro, Data Types and Filters (60:36)
-
02 Power Query - Column Tranformations (40:42)
-
03 Power Query - Pivot, UnPivot, Transpose, Replace (52:34)
-
04 Power Query - Row Transformations (41:58)
-
05 Power Query - Joins Part1 (46:49)
-
06 Power Query - Joins Part2 (41:12)
-
07 Power Query - Union Vs Union All (42:49)
-
08 Power Query - Append Excel Sheets (18:09)
-
09 Power Query - Parameters and Cond Statement, Fill (52:50)
-
10 Power Query - Query Options (33:47)
Power View
-
01 Power View - Intro and Edit Interactions (42:57)
-
02 Power View - Filters (19:04)
-
03 Power View - Drill Through Filters (30:48)
-
04 Power View - Hierarchy and Down Reports Part1 (19:48)
-
05 Power View - Hierarchy and Down Reports Part2 (42:34)
-
06 Power View - Slicer Visualization Part1 (43:51)
-
07 Power View - Slicer Visualization Part2 (34:29)
-
08. Power View - Grouping and Binning and Sorting (36:31)
-
09. Power View - Bookmarks and Selection Pane (21:49)
-
10 Power View - Pie and Donut Charts (42:16)
-
11 Power View - Tree Map, Bar and Column Charts (31:45)
-
12 Power View - Bar Vs Col and Scatter Charts (45:04)
-
13 Power View - Line, Area and Stacked Area Charts (37:46)
-
14 Power View - Combo Charts and Water Fall Charts (31:37)
-
15 Power View - KPI Visualizations Part1 (9:24)
-
16 Power View - KPI Visualizations Part2 (18:49)
-
17 Power View - Funnel Chart and Customize Tooltip (20:35)
-
18 Data Analytics Vs Data Science Interview Preparation (27:00)
-
19 Power View - Map Visualization (55:38)
-
20 Power View - Table and Matrix Visualizations (58:12)
SSAS Tabular Model Cubes
Data warehouse
-
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)
-
14.Amazon Project Scripts
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)
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)
-
Clarifications and Interview Questions - Jan 27th 2024
-
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)
