Power BI Demo
Power Query
-
01 Power BI - Intro (52:46)
-
02 Power BI - Create My First PBI Report (61:28)
-
03 Power BI - Deploy My First PBI Report (59:02)
-
04 Power BI - Building Blocks (39:10)
-
05 Power BI - SDLC Process (51:38)
-
06 Power BI - Data Types (47:22)
-
07 Power BI - Filters (51:03)
-
08 Power BI - Column Transformations (47:45)
-
09 Power BI - Pivot, UnPivot, Transpose (50:29)
-
10 Power Query - Row Transformations (41:58)
-
11 Power Query - PBI Joins Part1 (43:08)
-
12 Power Query - PBI Joins Part2 (38:18)
-
13 Power Query - PBI Joins Part3 and Union Vs Union All (62:49)
-
14 Power Query - Append Excel Sheets (18:09)
-
15 Power Query - Parameter, Fill and Index Number (38:27)
-
16 Power Query - Conditional Stmt and Creaate Function (13:56)
-
17 Power Query - Query Options (33:47)
Power BI Service.
-
01 Power BI Service - Intro (41:48)
-
02 Power BI Service - Create Dataset using SQL Part1 (48:36)
-
03 Power BI Service - Create Dataset using SQL Part2 (56:18)
-
04 Power BI Service - Create Dataset using SQL Part3 (57:36)
-
05 Power BI Service - Create Dataset using SQL and Deploy Part4 (48:47)
-
06 Power BI Service - Create Dashboard (52:25)
-
07 Power BI Service - Data Gateways Part1 (59:08)
-
08 Power BI Service - Data Connectivity Modes in PBI (49:16)
-
09 Power BI Service - Diff between Personal and Standard Data Gateways (46:46)
-
10 Power BI Service - Team Collaboration (38:11)
-
11 Power BI Service - Share Content and Create Email Subscription (44:16)
-
12 Power BI Service - Interview Preparation (32:44)
-
13 Power BI Service - Env in IT and Row Level Security (52:40)
-
14 Power BI Service - Dynamic Row Level Security (55:23)
DWH
-
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:19)
-
11 DWH - Types of Dimensions (61:28)
-
12 DWH - Types of Dimensions SCD and Inferred Dim (54:06)
-
13 DWH - Types of Facts (51:06)
-
Amazon Project Scripts
-
Incr Loading Vs Full Loading
-
ODS
SSAS Tabular Model Cubes
Power Pivot
DAX
-
01 DAX - Intro (52:09)
-
02 DAX - New Col Vs New Measure (49:39)
-
03 DAX - Operators (28:51)
-
04 PBI - Project Intro (21:11)
-
05 DAX - Logical Functions Part1 (48:08)
-
06 DAX - Logical Functions Part2 (11:51)
-
07 DAX - String Functions Part1 (19:02)
-
08 DAX - String Functions Part2 (45:57)
-
09 DAX - Math and Statistical Functions (75:12)
-
10 DAX - Query Folding (17:26)
-
11 DAX - Date and Time Functions Part1 (55:14)
-
11 DAX - Date and Time Functions Part1 (55:14)
-
12 DAX - Date and Time Functions Part2 (49:44)
-
13 DAX - Filter Functions Part1 (35:54)
-
14 DAX - Filter Functions Part2 (60:41)
-
15 DAX - Filter Functions Part3 (18:21)
-
16 DAX - Time Intelligence Functions (59:34)
-
17 Power BI - Interview Preparation (39: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 - Bookmarks and Selection Pane (21:49)
-
09 Power View - Grouping and Binning and Sorting (36:31)
-
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)
DataWarehouse
-
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
SSAS Tabular Model Cubes
