Completed
) Create Running Total and Average Daily Revenue DAX Measures and Final Data Model PivotTable.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Power Pivot - Big Data, Data Modeling, DAX & Dashboards
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction & Over view of entire Big Data & DAX Project.
- 2 ) Download Files.
- 3 ) What is a Data Model PivotTable and why Power Pivot is called “Power Pivot”
- 4 ) Differences Between Standard PivotTable & Data Model PivotTable
- 5 ) Average Daily Reve Example and why DAX is Easier than Standard PivotTable.
- 6 ) Choice between: Standard PivotTable & Data Model PivotTable
- 7 ) What is a SQL Database?
- 8 ) Import Big Data from SQL Database using Power Query
- 9 ) Load SQL Tables into Columnar Database in Power Pivot’s Data Model
- 10 ) How to get into the Data Model. Into to Data Model.
- 11 ) Create Relationships in Design View
- 12 ) What is a Date Table? Create Date Table.
- 13 ) Hide Column From Client Tool
- 14 ) Overview of DAX Formulas
- 15 ) DAX Calculated Column for Line Revenue
- 16 ) Row Context
- 17 ) DAX Measure to add Calculated Column using SUM
- 18 ) SUMX DAX Measure to calculate Total Revenue without a Calculated Column.
- 19 ) Compare and contrast Calculated Column and Measures.
- 20 ) Create Data Model PivotTable
- 21 ) Filter Context
- 22 ) Create More DAX Formulas: Total COGS, Gross Profit and Percent Gross Profit.
- 23 ) Create Dashboard for Gross Profit.
- 24 ) Create Running Total and Average Daily Revenue DAX Measures and Final Data Model PivotTable.
- 25 ) Summary
