01 Power BI
-
01 Data Analytics using Power BI Part1 (63:49)
-
02 Data Analytics using Power BI Part2 (59:02)
-
03 Data Analytics using Power BI Part3 (63:04)
-
04 Install SQL Server and Power BI (67:56)
-
05 Power BI Components (67:07)
-
06 Power BI - Create My First PBI Report (49:15)
-
07 Power BI - Deploy a Report (48:59)
-
08 Power BI - Building Blocks (42:59)
-
09 Power BI - SDLC Process (51:38)
02 Power Query
-
01 Power Query - Data Types (49:52)
-
02 Power Query - Filters (63:27)
-
03 Power Query - Column Transformations (43:11)
-
04 Power Query - Pivot, UnPivot, Transpose and Replace Nulls (38:44)
-
05 Power Query - Row Transformations (42:03)
-
06 Power Query - Joins (58:33)
-
07 Power Query - Joins Qns and Ans (17:30)
-
08 Power Query - Self Join (36:47)
-
09 Power Query - Union Vs Union All (46:18)
-
10 Power Query - Load Multiple Excel Sheets (20:20)
-
11 Power Query - Paramaters, Indexes, Fill, Cond Statements (53:50)
-
12 Power Query - Query Options (33:47)
03 SQL Interview Q & A
-
01 SQL Server Interview Questions Part1 - Date and Time Related (40:30)
-
02 SQL Server Interview Questions Part2 - Date and Time Related (31:52)
-
03 SQL Server Interview Questions Part3 - String Functions (19:18)
-
04 SQL Server Interview Questions Part4 - Complex Questions (32:40)
-
05 SQL Server Interview Questions Part5 - Complex Questions (18:43)
-
06 SQL Server Interview Questions Part6 - Complex Questions (30:42)
04 Power BI Service
-
01 PBI Cloud Service - Intro (51:22)
-
02 PBI Cloud Service - Create Dataset Part1 and Restore Database (50:13)
-
03 PBI Cloud Service - Create Dataset using SQL Server Part1 (47:04)
-
04 PBI Cloud Service - Create Dataset using SQL Server Part2 (53:15)
-
05 PBI Cloud Service - Create Dashboards (30:30)
-
06 PBI Cloud Service - Data Gateways Part1 (51:41)
-
07 PBI Cloud Service - Data Gateways Part2 (32:12)
-
08 PBI Cloud Service - Data Gateways Part3 (21:04)
-
09 PBI Cloud Service - Data Connectivity Modes (49:55)
-
10 PBI Cloud Service - SQL with Direct Query (49:09)
-
11 PBI Cloud Service - SQL, Flat File and Excel with Import (40:57)
-
12 PBI Cloud Service - SQL with Direct Query and Excel with Import (44:59)
-
13 PBI Cloud Service - Foundation, Magic and Acceleration (14:09)
-
14 PBI Cloud Service - Team Collaboration (41:28)
-
15 PBI Cloud Service - Share Content with End Users and Subscriptions (31:19)
-
16 PBI Service - IT Env and Row Level Security Part-01 (52:40)
-
17 Power BI Service - Dynamic Row Level Security Part-02 (55:23)
05 Power View
-
01 Power View - Intro and Edit Interactions (53:03)
-
02 Power View - Filters (35:49)
-
03 Power View - Drill Thru Filters (46:46)
-
04 Power View - Hierarchies and Drill Down Reports Part1 (41:48)
-
05 Power View - Hierarchies and Drill Down Reports Part2 (25:23)
-
06 Power View - Slicer Visualization Part1 (37:56)
-
07 Power View - Slicer Visualization Part2 (24:19)
-
08 Power View - Categorical Data Visualizations, Pie and Donut (51:58)
-
09 Power View - Topics to Prepare and Tree Map, Bar and Column Charts (44:43)
-
10 Power View - Bar Vs Column Charts, 100% Bar and Column and Scatter Charts (41:14)
-
11 Power View - Trend Data Visualizations Part1 (37:06)
-
12 Power View - Trend Data Visualizations Part2 (26:22)
-
13 Power View - KPI Data Visualizations (55:00)
-
14 Power View - Paginated Reports and Map Visualization (51:08)
-
15 Power View - Map and Filled Map Charts and Road Map to Interview Preparation (63:52)
-
16 Power View - Table and Matrix Visualizations (43:03)
-
17 Power View - Grouping and Binning and Sorting (33:47)
06 Power Pivot
07 DAX
-
01 DAX - Intro to DAX (51:12)
-
02 DAX - New Column Vs New Measure (53:34)
-
03 DAX - Operators (30:47)
-
04 DAX - Logical Functions (48:41)
-
05 DAX - String Functions Part1 (50:51)
-
06 DAX - String Functions Part2 (32:51)
-
07 DAX - Date and Time Functions Part1 (55:02)
-
08 DAX - Date and Time Functions Part2 (48:59)
-
09 DAX - Math Functions (44:50)
-
10 DAX - Statistical Functions (62:59)
-
11 DAX - Query Folding (17:26)
-
12 DAX - Filter Functions Part1 (44:06)
-
13 DAX - Filter Functions Part2 (55:44)
-
14 DAX - Filter Functions Part3 (73:18)
-
15 DAX - Time Intelligence Functions Part1 (41:23)
-
16 DAX - Time Intelligence Functions Part2 (60:18)
08 Bandhan Bank Project
-
02 Bandhan Bank Project - Data Modeling Solution (34:20)
-
01 Bandhan Bank Project - Table Design and Data Modeling (36:53)
-
03 Bandhan Bank Project - Create SQL Scripts (43:36)
-
04 Bandhan Bank Project - Create Database using SQL Scripts and Create PBI Reports (54:40)
-
05 Bandhan Bank Project - Create PBI Reports and DAX for INR Calculation (39:08)
-
06 Bandhan Bank Project - Assignments on PBI Reports (31:15)
-
07 Bandhan Bank Files and Scripts
DWH
-
02 DWH - Top Down vs Bottm Up Approach (44:53)
-
01 DWH - Intro (49:52)
-
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:29)
-
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
-
Incr Loading Vs Full Loading
-
ODS
SSAS Tabular Model Cubes
