Completed
) Download Files
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Data Modeling - VLOOKUP, Power Query or Power Pivot?
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) What is Data Modeling?
- 3 ) Download Files
- 4 ) Topics Hyperlink List
- 5 ) When to use VLOOKUP, Power Query or Power Pivot Relationships for Data Modeling
- 6 ) When to use VLOOKUP, Power Query or Power Pivot Relationships for Data Modeling when you have Multiple Tables
- 7 ) Spreadsheet Formulas and VLOOKUP Function to create a Data Model for Standard PivotTable Reports. See VLOOKUP, Table Formula Nomenclature and PivotTables.
- 8 ) Power Query to import Data from an Access Database
- 9 0 Power Query and the Merge Feature
- 10 ) Power Query to Add Columns
- 11 ) Load Power Query Transformation to Standard PivotTable Cache and create PivotTable
- 12 ) Power Pivot Relationships for Multiple Tables for a Standard PivotTable Report
- 13 ) Create Data Model PivotTable
- 14 ) Power Pivot Com Add-in. Show Power Pivot Ribbon Tab in Excel.
- 15 ) Look at Power Pivot Data Model
- 16 ) Implicit vs. Explicit DAX Measures
- 17 ) Summary
