Data Modeling - VLOOKUP, Power Query or Power Pivot?

This course explains how to model data from multiple tables for analysis and reporting in Excel. It compares VLOOKUP, Power Query, and Power Pivot, including Access imports, table relationships, transformations, PivotTables, and implicit DAX measures.

Syllabus

) Introduction.
) What is Data Modeling?.
) Download Files.
) Topics Hyperlink List.
) When to use VLOOKUP, Power Query or Power Pivot Relationships for Data Modeling.
) When to use VLOOKUP, Power Query or Power Pivot Relationships for Data Modeling when you have Multiple Tables.
) Spreadsheet Formulas and VLOOKUP Function to create a Data Model for Standard PivotTable Reports. See VLOOKUP, Table Formula Nomenclature and PivotTables..
) Power Query to import Data from an Access Database.
0 Power Query and the Merge Feature.
) Power Query to Add Columns.
) Load Power Query Transformation to Standard PivotTable Cache and create PivotTable.
) Power Pivot Relationships for Multiple Tables for a Standard PivotTable Report.
) Create Data Model PivotTable.
) Power Pivot Com Add-in. Show Power Pivot Ribbon Tab in Excel..
) Look at Power Pivot Data Model.
) Implicit vs. Explicit DAX Measures.
) Summary.