01 Power BI
-
01 Data Analytics using Power BI Demo Part1 (85:37)
-
02 Data Analytics using Power BI Demo Part2 (61:27)
-
03 Data Analytics using Power BI Demo Part3 (70:05)
-
04 Install SQL Server and Power BI (53:06)
-
05 Power BI Components (67:09)
-
06 Power BI - Create My First PBI Report (49:16)
-
07 Power BI - Deploy a Report (49:07)
-
08 Power BI - Building Blocks (43:01)
-
09 Power BI - SDLC Process (51:38)
02 Power Query
-
01 Power Query - Data Types (49:53)
-
02 Power Query - Filters (63:29)
-
03 Power Query - Column Transformations (43:11)
-
04 Power Query - Pivot, UnPivot, Transpose and Replace Nulls (38:46)
-
05 Power Query - Row Transformations (42:04)
-
06 Power Query - Joins (58:37)
-
07 Power Query - Joins Qns and Ans (17:30)
-
08 Power Query - Self Join (36:51)
-
09 Power Query - Union Vs Union All (46:42)
-
10 Power Query - Load Multiple Excel Sheets (20:38)
-
11 Power Query - Paramaters, Indexes, Fill, Cond Statements (53:56)
-
12 Power Query - Query Options (33:47)
03 Power View
-
01 Power View - Intro and Edit Interactions (49:32)
-
02 Power View - Filters and Drill Thru Report (53:34)
-
03 Power View - Hierarchy and Drill Down Reports (53:38)
-
04 Power View - IT Env and Intro to Visualizations (51:44)
-
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:28)
-
08 Power View - Hierarchy Slicer, Pie and Donut Visualizations (44:06)
-
09 Power View - Tree Map and Column and Bar Visualizations (44:49)
-
10 Power View - 100% Col and Bar, Scattered Visualizations (32:51)
-
11 Power View - Trend Visualizations Part1 (39:25)
-
12 Power View - Trend Visualizations Part2 (30:33)
-
13 Power View - KPI Visualizations (47:01)
-
14 Power View - Map and Paginated Reports (38:56)
-
15 Power View - Map Visualizations (20:29)
-
16 Power View - Tabular Data Visualizations (42:47)
-
17 Power BI - Interview Preparation (41:19)
04 Power BI Service
-
01 PBI Service - Intro (76:32)
-
02 PBI Service - Columnar Database, Batch Vs Streaming Data (64:06)
-
03 PBI Service - Create Dataset Using SQL Tables and Queries Part1 (70:09)
-
04 PBI Service - Create Dataset using SP and Views (22:20)
-
05 PBI Service- Deploy Dataset and Create reports (42:52)
-
06 PBI Service- Reports and Dash Boards. (40:10)
-
07 PBI Service - Team Collaboration and IT Environments (52:11)
-
08 PBI Service - Share Content and Pagenated Reports (52:09)
-
9 PBI Service - Data Gateways Part1 (34:17)
-
10 PBI Service - Data Gateways Part2 (30:58)
-
11 PBI Service - Data Gateways Part3 (47:56)
-
12 PBI Service - Data Gateways Part4 (51:40)
-
13 PBI Service - Data Gateways Part5 (44:26)
-
14 PBI Service - Share Content with End Users (37:58)
-
15 PBI Service - IT Env and Row Level Security (52:47)
-
16 Power BI Service - Dynamic Row Level Security (53:57)
-
17 Power BI - Interview Preparation (37:28)
05 Bandhan Bank Project
-
01 Bandhan Bank Project - Table Design and Data Modeling (36:57)
-
02 Bandhan Bank Project - Data Modeling Solution (34:27)
-
03 Bandhan Bank Project - Create SQL Scripts (43:39)
-
04 Bandhan Bank Project - Create Database using SQL Scripts and Create PBI Reports (54:42)
-
05 Bandhan Bank Project - Create PBI Reports and DAX for INR Calculation (39:13)
-
06 Bandhan Bank Project - Assignments on PBI Reports (30:35)
-
07 Bandhan Bank Docs
06 Power Pivot
07 DAX
-
01 DAX - Intro to DAX (50:58)
-
02 DAX - New Column Vs New Measure (53:35)
-
03 DAX - Operators (30:44)
-
04 DAX - Logical Functions (48:37)
-
05 DAX - String Functions Part1 (50:51)
-
06 DAX - String Functions Part2 (32:59)
-
07 DAX - Date and Time Functions Part1 (55:06)
-
08 DAX - Date and Time Functions Part2 (49:04)
-
09 DAX - Math Functions (44:53)
-
10 DAX - Query Folding (17:26)
-
11 DAX - Filter Functions Part1 (44:07)
-
12 DAX - Filter Functions Part2 (55:48)
-
13 DAX - Filter Functions Part3 (73:11)
-
14 DAX - Time Intelligence Functions Part1 (41:22)
-
15 DAX - Time Intelligence Functions Part2 (60:22)
-
16 DAX - Math and Statistical Functions (75:12)
08 SQL Interview Q & A
-
01 SQL Server Interview Questions Part1 - Date and Time Related (40:33)
-
02 SQL Server Interview Questions Part2 - Date and Time Related (31:57)
-
03 SQL Server Interview Questions Part3 - String Functions (19:17)
-
04 SQL Server Interview Questions Part4 - Complex Questions (32:41)
-
05 SQL Server Interview Questions Part5 - Complex Questions (18:49)
-
06 SQL Server Interview Questions Part6 - Complex Questions (30:47)
Power BI PPTs
