Power BI
-
01 Data Analytics Using Power BI Demo Part1 (58:17)
-
02 Data Analytics Using Power BI Demo Part2 (56:48)
-
03 Data Analytics Using Power BI Demo Part3 (72:13)
-
04 Power BI and SQL Server Installation (54:19)
-
05 Power BI Intro and Components (56:37)
-
06 Create My First Report in Power BI (60:18)
-
07 Power BI - Intro to Cloud and Deploy a Report (40:58)
-
08 Power BI - Deploy a PBI Report (47:12)
-
09 Power BI - Building Blocks (31:14)
-
10 Power BI - SDLC Process (51:38)
Power Query
-
01 Power Query - Data Types and Filters (44:05)
-
02 Power Query - Column Transformations (54:44)
-
03 Power Query - Pivot, UnPivot, Transpose, Replace Null (39:04)
-
04 Power Query - Row Transformations (41:58)
-
05 Power Query - Joins (63:54)
-
06 Power Query - Qns and Answers (16:26)
-
07 Power Query - Self Joins (21:41)
-
08 Power Query - Union Vs Union All (46:21)
-
09 Power Query - Append Excel Sheets (18:09)
-
10 Power Query - Parameters, Fill, Row Number (42:53)
-
11 Power Query - Query Options (33:47)
Power BI Service
-
01 Power BI Service - Intro (76:43)
-
02 PBI Service - Columnar Database, Batch Vs Streaming Data (64:06)
-
03 PBI Service - Create Dataset Using SQL Tables and Queries Part1 (42:32)
-
04 PBI Service - Create Dataset Using SQL Tables and Queries Part2 (41:51)
-
05 PBI Service - Create Dataset using SP and Views (24:02)
-
06 PBI Service - Deploy a Dataset and Create Reports (42:51)
-
07 PBI Service - Reports and Dashboards (40:03)
-
08 PBI Service - Team Collaboration and IT Environments (52:02)
-
09 PBI Service - Share Content and Pagenated Reports (36:52)
-
10 PBI Service - Data Gateways Part1 (34:21)
-
11 PBI Service - Data Gateways Part2 (33:21)
-
12 PBI Service - Data Gateways Part3 (49:01)
-
13 PBI Service - Data Gateways Part4 (51:37)
-
14 PBI Service - Data Gateways Part5 (44:57)
-
15 PBI Service - Share Content with End Users (38:01)
-
16 PBI Service - IT Env and Row Level Security (52:51)
-
17 Power BI Service - Dynamic Row Level Security (54:11)
-
18 Power BI - Interview Preparation (37:28)
Power View
-
01 Power View - Intro and Edit Interactions (46:41)
-
02 Power View - Filters and Drill Thru Report (53:43)
-
03 Power View - Hierarchy and Drill Down Reports (53:46)
-
04 Power View - IT Env and Intro to Visualizations (52:06)
-
05 Power View - Grouping and Binning and Sorting (36:31)
-
06 Power View - Bookmarks and Selection Pane (21:49)
-
07 Power View - Slicer Visualizations (46:21)
-
08 Power View - Hierarchy Slicer, Pie and Donut Visualizations (43:51)
-
09 Power View - Tree Map and Column and Bar Visualizations (47:02)
-
10 Power View - 100% Col and Bar, Scattered Visualizations (32:43)
-
11 Power View - Trend Visualizations Part1 (44:35)
-
12 Power View - Trend Visualizations Part2 (36:11)
-
13 Power View - KPI Visualizations (47:00)
-
14 Power View - Map and Paginated Reports (38:58)
-
15 Power View - Map Visualizations (27:49)
-
16 Power View - Tabular Data Visualizations (42:47)
-
17 Power BI - Interview Preparation (41:19)
Power Pivot
-
01 Power Pivot - Intro and Columnar Database (37:10)
-
02 Power Pivot - Intro to Data Modeling (44:58)
-
03 Power Pivot - 1 to 1 Data Modeling (38:15)
-
04 Power Pivot - 1 to m and m to m Data Modeling (63:57)
-
05 Power Pivot - M to M and Cross Filter Direction Demos (25:21)
-
06 Bandhan Bank Project - Table Design and Data Modeling (36:53)
-
07 Bandhan Bank Project - Data Modeling Solution (34:20)
-
08 Bandhan Bank Project - Create SQL Scripts (43:36)
-
09 Bandhan Bank Project - Create Database using SQL Scripts and Create PBI Reports (54:40)
-
10 Bandhan Bank Project - Create PBI Reports and DAX for INR Calculation (39:08)
-
11 Bandhan Bank Project - Assignments on PBI Reports (31:15)
DAX
-
01 DAX - Intro (43:13)
-
02 DAX - New Column Vs New Measure (42:55)
-
03 DAX - Operators (36:52)
-
04 DAX - Logical Functions Part1 (50:18)
-
05 DAX - Logical Functions Part2 (21:25)
-
06 DAX - String Functions Part1 (17:00)
-
07 DAX - String Functions Part2 (57:07)
-
08 DAX - Date and Time Functions, DWH and Hadoop and Databricks Intro (45:29)
-
09 DAX - Date and Time Functions Part2 (48:17)
-
10 DAX - Date and Time Functions Part3 (11:36)
-
11 DAX - Date and Time Functions Part4 (44:37)
-
12 DAX - Math and Statistical Functions (75:10)
-
13 DAX - Query Folding (17:26)
-
14 DAX - Filter Functions Part1 (47:09)
-
15 DAX - Filter Functions Part2 (60:40)
-
16 DAX - Filter Functions Part3 (28:37)
-
17 DAX - Time Intelligence Functions (59:34)
-
18 Power BI - Interview Preparation (39:47)
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
Bandhan Bank Project
-
01 Bandhan Bank Project - Table Design and Data Modeling (36:53)
-
02 Bandhan Bank Project - Data Modeling Solution (34:20)
-
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 Docs
