01 Power BI
-
01 Data Analytics using Power BI Demo Part1 (48:52)
-
02 Data Analytics using Power BI Demo Part2 (47:10)
-
03 Data Analytics using Power BI Demo Part3 (59:53)
-
04 Install SQL Server and Power BI (48:37)
-
05 Power BI Components (67:12)
-
06 Power BI - Create My First PBI Report (49:08)
-
07 Power BI - Deploy a Report (48:53)
-
08 Power BI - Building Blocks (43:01)
-
09 Power BI - SDLC Process (51:38)
02 Power Query
-
01 Power Query - Data Types (49:45)
-
02 Power Query - Filters (63:19)
-
03 Power Query - Column Transformations (42:46)
-
04 Power Query - Pivot, UnPivot, Transpose and Replace Nulls (38:23)
-
05 Power Query - Row Transformations (42:04)
-
06 Power Query - Joins (58:29)
-
07 Power Query - Joins Qns and Ans (17:30)
-
08 Power Query - Self Join (36:46)
-
09 Power Query - Union Vs Union All (46:16)
-
10 Power Query - Load Multiple Excel Sheets (20:38)
-
11 Power Query - Paramaters, Indexes, Fill, Cond Statements (53:51)
-
12 Power Query - Query Options (33:53)
03 Power Pivot
04 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
05 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)
06 Power BI Service
-
01 PBI Service - Intro (75:55)
-
02 PBI Service - Columnar Database, Batch Vs Streaming Data (63:57)
-
03 PBI Service - Create Dataset Using SQL Tables and Queries (70:14)
-
04 PBI Service - Create Dataset using SP and Views (22:56)
-
05 PBI Service - Deploy a Dataset and Create Reports (42:43)
-
06 PBI Service - Reports and Dashboards (40:04)
-
07 PBI Service - Team Collaboration and IT Environments (52:06)
-
08 PBI Service - Share Content and Pagenated Reports (51:42)
-
9 PBI Service - Data Gateways Part1 (34:10)
-
10 PBI Service - Data Gateways Part2 (34:18)
-
11 PBI Service - Data Gateways Part3 (48:49)
-
12 PBI Service - Data Gateways Part4 (51:26)
-
13 PBI Service - Data Gateways Part5 (44:24)
-
14 PBI Service - Share Content with End Users (37:57)
-
15 PBI Service - IT Env and Row Level Security (52:37)
-
16 Power BI Service - Dynamic Row Level Security (55:23)
-
17 Power BI - Interview Preparation Part1 (37:28)
-
18 Power BI - Interview Preparation Part2 (25:47)
SQL Server Interview Questions
