Power BI Demos
-
01 Power BI Demo Part1 - May 1st 2024 (51:22)
-
02 Power BI Demo Part2 - May 2nd 2024 (56:14)
-
03 Power BI Demo Part3 - May 3rd 2024 (56:14)
-
04 Power BI and SQL Server Installation (38:52)
-
05 Power BI - Components (56:36)
-
06 Power BI - Create My First Report (66:11)
-
07 Power BI - Deploy a Report (50:32)
Power Query
-
01 Power Query - Data Types (52:35)
-
02 Power Query - Filters (36:26)
-
03 Power Query - SDLC Process (51:38)
-
04 Power Query - Column Transformations (35:09)
-
05 Power Query - Pivot and Un Pivot and Transpose (39:31)
-
06 Power Query - Row Transformations (41:58)
-
07 Power Query - Joins (57:58)
-
08 Power Query - Self Join, Union Vs Union All (47:42)
-
09 Power Query - Union All (28:31)
-
10 Power Query - Append Excel Sheets (18:09)
-
11 Power Query - Parameters (32:22)
-
12 Power Query -Parameters, Fill and Conditional Statement (42:25)
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 (52:28)
-
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
SSAS Tabular Model Cubes
Power BI Service
-
01 Power BI Service - Intro (59:23)
-
02 Power BI Service - Intro to DWH and BigData and Create a Dataset using SQL Part1 (74:10)
-
03 Power BI Service - Create a Dataset using SQL Part2 (78:26)
-
04 Power BI Service - Create a Dashboard (54:02)
-
05 Power BI Service - Data Gateways Part1 (69:53)
-
06 Power BI Service - Data Gateways Part2 (52:10)
-
07 Power BI Service - Data Connectivity Modes and Why SSAS or Cubes (72:39)
-
08 Power BI Service - Data Gateways with SQL Import (53:18)
-
09 Power BI Service - Data Gateways with SQL Import Part2 (19:21)
-
10 Power BI Service - Data Gateways with SQL With Direct Query (43:39)
-
11 Power BI Service - Team Collaboration and IT Env (49:11)
-
12 Power BI Service - Share Content (44:24)
-
13 Power BI - Interview Preparation and more (50:21)
-
14 Power BI Service - Row Level Security (17:34)
-
15 Power BI Service - Demo Row Level Security (55:23)
-
New Lesson (19:03)
Power Pivot
DAX
-
01 DAX - Intro on DWH, Big Data and DAX (62:21)
-
02 DAX - New Column Vs New Measure (49:43)
-
03 DAX - New Column Vs New Measure Part2 (24:03)
-
04 DAX - Operators (39:05)
-
05 DAX - Logical Functions (53:09)
-
06 DAX - Logical Functions Part2 (24:48)
-
07 DAX - String Function Part1 (17:46)
-
08 DAX - String Function Part2 (58:17)
-
09 DAX - Data and Time Functions, DWH and Hadoop and Databricks Intro (49:52)
-
10 DAX - Data and Time Functions Part2 (55:06)
-
11 DAX - Data and Time Functions Part3 (41:19)
-
12 DAX - Math and Statistical Functions (75:12)
-
13 DAX - Query Folding (17:26)
-
14 DAX - Filter Functions Part1 (49:47)
-
15 DAX - Filter Functions Part2 (63:25)
-
16 DAX - Filter Functions Part3 (27:06)
-
17 DAX - Time Intelligence Functions (59:33)
-
18 Power BI - Interview Preparation (39:45)
Power BI Project
-
01 Power BI - Assignments and Project Part1 (16:35)
-
02 Power BI - Assignments and Project Part2 (53:09)
-
03 Power BI - Assignments and Project Part3 (52:45)
-
04 Power BI - Assignments and Project Part4 (43:25)
-
05 Power BI - Assignments and Project Part5 (36:26)
-
Go Online Trainings Students Enquiry Sheet
-
06 Power BI - Assignments and Project Part6 (44:59)
-
Go Online Trainings Students Enquiry Sheet
-
TechSpec_GoOnlineTrainings
Power BI Service
-
01 PBI Service - Intro (76:45)
-
02 PBI Service - Columnar Database, Batch Vs Streaming Data (1) (66:23)
-
03 PBI Service - Create Dataset Using SQL Tables and Queries (72:41)
-
04 PBI Service - Create Dataset using SP and Views (23:50)
-
05 PBI Service - Deploy a Dataset and Create Reports (42:38)
-
06 PBI Service - Reports and Dashboards (41:05)
-
07 PBI Service - Data Gateways Part1 (49:05)
-
08 PBI Service - Data Gateways Part2 (49:37)
-
09 PBI Service - Data Gateways Part3 (46:11)
-
10 PBI Service - Incr Refresh (57:44)
-
11 PBI Service - Team Collaboration and IT Environments (53:21)
-
12 PBI Service - Share Content and Pagenated Reports (52:03)
-
13 PBI Service - Row Level Security (17:32)
-
14 PBI Service - Demo Row Level Security (55:21)
Power View
-
01 Power View - Intro and Edit Interactions (54:27)
-
02 Power View - Filters and Drill Thru Report (55:09)
-
03 Power View - Hierarchy and Drill Down Reports (58:14)
-
04 Power View - IT Env and Intro to Visualizations (51:50)
-
05 Power View - Grouping and Binning and Sorting (36:31)
-
06 Power View - Bookmarks and Selection Pane (21:49)
-
07 Power View - Slicer Visualizations (47:15)
-
08 Power View - Hierarchy Slicer, Pie and Donut Visualizations (45:33)
-
09 Power View - Tree Map and Column and Bar Visualizations. (46:55)
-
10 Power View - 100% Col and Bar, Scattered Visualizations (33:10)
-
11 Power View - Trend Visualizations Part1. (45:52)
-
12 Power View - Trend Visualizations Part2. (36:11)
-
13 Power View - KPI Visualizations. (47:19)
-
14 Power View - Map and Paginated Reports. (38:58)
-
15 Power View - Map Visualizations. (27:49)
-
16 Power View - Tabular Data Visualizations. (42:47)
-
01 SQL Server Interview Questions Part1 - Date and Time Related. (41:13)
-
02 SQL Server Interview Questions Part2 - Date and Time Related. (31:58)
-
03 SQL Server Interview Questions Part3 - String Functions. (19:03)
-
04 SQL Server Interview Questions Part4 - Complex Questions. (32:42)
-
05 SQL Server Interview Questions Part5 - Complex Questions (18:33)
