Completed
) Introduction to Entire Project, including what type of start files we have and what the final report looks like.
Class Central Classrooms beta
YouTube playlists curated by Class Central.
Classroom Contents
How to Build Data Model and DAX Formulas in Power Pivot
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction to Entire Project, including what type of start files we have and what the final report looks like.
- 2 ) What is Data Modeling? Steps to creating a Data Model.
- 3 ) Data Modeling Step 1: Power Query to Clean, Transform & Import Fact Tables
- 4 ) Data Modeling Step 1: Import Dimension Tables from an Excel Sheet
- 5 ) What is a Calendar Table (Dimension Table)? Why a Calendar Table and not Group by Date?
- 6 ) Data Modeling Step 1: Create Calendar Table in Excel & Import to Data Model
- 7 ) Data Modeling Step 2: Create Relationships between Related Tables
- 8 ) Data Modeling Step 3: Create DAX Calculated Columns in Calendar Table. Dee the DAX functions: MONTH, FORMAT, YEAR, ROUNDUP, and IF. See how to calculate Calculated Columns for Month Number, Month N…
- 9 ) What is Row Context?
- 10 ) Data Modeling Step 3: Create DAX Calculated Columns in Fact Table for Revenue. See the functions ROUND, RELATED
- 11 ) Data Modeling Step 3: Create DAX Measures using SUM function n to add values from Calculated Column.
- 12 ) Data Modeling Step 3: Alternative Total Revenue Calculation: DAX Measure with SUMX. Learn how to perform Row Context in a DAX Measure. This formula calculates total revenue without a Helper Column.
- 13 ) DAX Calculated Column or DAX Measure to calculate Total Revenue?
- 14 ) Data Modeling Step 3: More DAX Measures. SUMX to calculate Total COGS. DAX Measure for Gross Profit.
- 15 ) Data Modeling Step 4: Hide Tables & Fields not used in PivotTables
- 16 ) Data Modeling Step 5: Create PivotTables and Pivot Charts and Final Dashboard
- 17 ) What is Filter Context?
- 18 ) Advantage of Power Pivot Data Model Columnar Database & Relationships & DAX Measures when you have Big Data.
- 19 ) Data Modeling Step 6: Refresh Data Model when Source Data Changes
- 20 ) Data Modeling Step 7: Fix Calendar Table
- 21 ) Data Modeling Step 7: Dashboard After Refreshing
- 22 ) Data Modeling Step 7: Create new DAX Formulas and create New Report.
