Introduction to Modern Analytics
-
Introduction (4:25)
-
Modern analytics ecosystem
-
What is Power Query? (5:51)
-
Introduction to Data Transformation (7:54)
-
Import Data from Web (6:25)
-
Generate List of Dates with M Code (8:02)
-
What is Power Pivot? (3:41)
-
Modern Analytics in Action
-
Import Data from Databases with PowerPivot (4:35)
-
Import Data from a Range/Table (3:56)
-
Creating and Managing relationship (5:41)
-
Introduction to DAX (7:09)
-
Introduction to Measures (5:24)
-
Visualize Data with PowerPivot and Charts (9:40)
-
Power Query Vs Power Pivot
Design Dashboard in Excel and Power BI
Data Cleaning and Cleaning w/ Power Query
Data Modeling w/ PowerPivot and DAX
Data Analysis with PivotTables
Dashboard Design
-
Dashboard Preview (1:09)
-
Trend analysis and insights (18:01)
-
Campaign Analysis (6:43)
-
Product Analysis (6:17)
-
Geography Analysis (8:54)
-
KPIs (12:51)
-
Insert Slicers (5:50)
-
Formatting Slicers (6:06)
-
Formula clean up and Conditional Formatting (7:14)
-
Total Customers YoY (3:32)
-
Dashboard 2 (12:50)
-
Finalizing your Dashboard (7:08)
Excel and Power BI Together
-
Power BI Dashboard Introduction (0:34)
-
Power BI Data Model (0:49)
-
Data Model Import (5:26)
-
Data Visualization: Trend Analysis (12:49)
-
Data Visualization: Products and Campaign (10:49)
-
Data Visualization: Geography Analysis and Slicers (8:14)
-
Data Visualization: KPIs (8:58)
-
Dashboard Final (1:28)
-
Power BI Background Design (5:43)
