Completed
) Sort Count Category Column by Upper Value Column so categories sort correctly in PivotTable
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Data Model & DAX Formulas - Quantity Frequency Distribution by Year & Country
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Build CountCategory Table in Excel. Learn about Table Formula Nomenclature in Excel Table.
- 3 ) Build DAX Measure in Measure Grid to Calculate MAX Quantity
- 4 ) Import CountCategory Table into Data Model
- 5 ) Create Automatic dCalendar Table in Power Pivot
- 6 ) Build Relationships Between Tables. Discussion “Filter Context” and of how Criteria from PivotTable filters Lookup Tables and how the “filter” flows across the Relationship to “filter the Fact tabl…
- 7 ) Build DAX Calculated Column in Fact Table to use in Relationship to CountCategory Table. Discussion of Columnar Database and how columns with a small number of unique values do not take up much RAM…
- 8 ) Build PivotTable based on Data Model
- 9 ) Sort Count Category Column by Upper Value Column so categories sort correctly in PivotTable
- 10 ) Build DAX Measure Frequency Formula to count # transactions with specified quantity. Description of How Data Model and DAX Formulas calculate when criteria is applied in a PivotTable. See the COUNT…
- 11 ) Finish Building PivotTable.
- 12 ) Add Slicer to PivotTable
- 13 ) Add Conditional Formatting to PivotTable
- 14 ) Add Formatting to Dashboard
- 15 ) Summary
