Autoplay
Autocomplete
Previous Lesson
Complete and Continue
AA Nov 2024 PBI
Power BI
01 Power BI Demo Part1 - Nov 1st 2024 (58:22)
02 Power BI Demo Part2 - Nov 2nd 2024 (70:44)
03 Power BI Demo Part3 - Nov 4th 2024 (70:47)
04 Power BI and SQL Server Installation (60:57)
05 Power BI Intro and Compenents (51:56)
06 Power BI - Create My First PBI Report (69:32)
07 Power BI - Intro to Cloud and Deploy a Report (55:51)
08 Power BI - Building Blocks (31:10)
09 Power BI - SDLC Process (51:38)
Power Query
01 Power Query - Intro and Data Types (42:14)
02 Power Query - Filters (49:57)
03 Power Query - Column Transformations (41:58)
04 Power Query - Pivot and UnPivot, Transpose (46:59)
05 Power Query - Row Transformations (42:04)
06 Power Query - Joins Part1 (63:07)
07 Power Query - Joins Part2 Solutions and Self Joins (33:00)
08 Power Query - Union Vs Union All (46:23)
09 Power Query - Append Excel Sheets (18:09)
10 Power Query - Parameters, Fill, Row Number (42:58)
11 Power Query - Query Options (33:47)
Power Pivot
01 Power Pivot - Intro and Columnar Database (53:01)
02 Power Pivot - Intro to Data Modeling (47:54)
03 Power Pivot - 1 to 1 Data Modeling (53:28)
04 Power Pivot - 1 to m and M to M Data Modeling (53:12)
05 Power Pivot - M to M and Cross Filter Direction Demos (25:21)
Power View
01 Power View - Intro and Visual Interactions (47:59)
02 Power View - Filters and Drill Through Reports (53:12)
03 Power View - Hierachies and Drill Down Reports (54:00)
04 Power View - Env in IT and Intro to Visualizations (50:56)
05 Power View - Grouping and Binning and Sorting (36:31)
06 Power View - Bookmarks and Selection Pane (21:49)
07 Power View - Slicer Visualization (47:12)
08 Power View - Hierarchy Slicer and Pie and Donut Visualization (44:17)
09 Power View - Tree Map and Column and Bar Visualizations (47:12)
10 Power View - 100% Col and Bar, Scattered Visualizations (32:57)
11 Power View - Trend Visualizations Part1 (40:03)
12 Power View - Trend Visualizations Part2 (31:50)
13 Power View - KPI Visualizations (47:06)
14 Power View - Map Data Visualizations and Paginated Reports (41:47)
15 Power View - Map Data Visualizations Part2 (20:24)
16 Power View - Tabular Data Visualizations (42:47)
DAX
01 DAX - Intro on DAX (43:32)
02 DAX - New Column Vs New Measure (42:05)
03 DAX - DAX Operators (39:13)
04 DAX - Logical Functions Part1 (50:48)
05 DAX - Logical Functions Part2 (21:55)
06 DAX - String Functions Part1 (17:10)
07 DAX - String Functions Part2 (57:16)
08 DAX - Data and Time Functions Part1 and DWH vs Apache Spark (52:21)
09 DAX - Date and Time Functions Part2 (55:14)
10 DAX - Date and Time Functions Part3 (41:24)
11 DAX - Math and Statistical Functions (75:12)
12 DAX - Query Folding (17:26)
13 DAX - Filter Functions Part1 (47:21)
14 DAX - Filter Functions Part2 (60:53)
15 DAX - Filter Functions Part3 (57:44)
16 DAX - Time Intelligence Functions (59:34)
17 Power BI - Interview Preparation (39:47)
Power BI Service
01 Power BI Service - Intro (60:26)
02 PBI Service - Columnar Database, Batch Vs Streaming Data (64:25)
03 PBI Service - Create Dataset Using SQL Tables and Queries (68:47)
04 PBI Service - Create Dataset using SP and Views (27:06)
05 PBI Service - Deploy a Dataset and Create Reports (39:35)
06 PBI Service - Create Dashboards (32:41)
07 PBI Service - Data Gateway Part1 (57:28)
08 PBI Service - Data Gateway Part2 (41:26)
09 Power BI Service - Data Connectivity Modes and Why SSAS or Cubes (59:02)
10 Power BI Service - Data Gateways with SQL Import (53:18)
11 Power BI Service - Data Gateways with SQL Import Part2 (19:21)
12 Power BI Service - Data Gateways with SQL With Direct Query (43:39)
13 PBI Service - Incr Refresh (57:44)
14 PBI Service - Team Collaboration and IT Environments (53:21)
15 PBI Service - Share Content and Pagenated Reports (52:03)
16 PBI Service - Row Level Security (17:34)
17 PBI Service - Demo Row Level Security (55:23)
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: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)
Amazon Project Scripts
Incr Loading Vs Full Loading
ODS
SSAS Tabular Model Cubes
01 SSAS - Intro to Tabular Model (52:19)
02 SSAS - Multi Dim Vs Tabular Model Cube (60:32)
03 SSAS - Create My Tabular Model Cube Part1 (65:49)
04 SSAS - Create My Tabular Model Cube Part2 (79:25)
Teach online with
07 Power Query - Joins Part2 Solutions and Self Joins
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock