03 DAX - Operators | Bhaskar Jogi School

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Power BI Sept'2023

Power BI Demo

01 Power BI Demo Part1 - Sep 1st 2023 (62:22)
02 Power BI Demo Part2 - Sep 2nd 2023 (64:07)
03 Power BI Demo Part3 - Sep 4th 2023 (69:32)
04 Power BI and SQL Server Installation (45:36)

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

01 SSAS - Intro to Tabular Model (52:22)
02 SSAS - Multi Dim Vs Tabular Model Cube (60:35)
03 SSAS - Create My Tabular Model Cube Part1 (65:51)
04 SSAS - Create My Tabular Model Cube Part2 (79:28)

Power Pivot

01 Power Pivot - Intro (33:52)
02 Power Pivot - Data Modeling Intro (37:27)
03 Power Pivot - Data Modeling 1to 1 Intro (54:06)
04 Power Pivot - Data Modeling 1 to m (48:21)
05 Power Pivot - Data Modeling m to m (56:29)
06 Power Pivot - Data Modeling m to m Demos (25:21)

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

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:24)

Teach online with

03 DAX - Operators

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock