Learn essential data modeling techniques for Excel in this comprehensive 45-minute video tutorial. Explore when and how to use VLOOKUP, Power Query, and Power Pivot relationships for efficient data analysis and business intelligence. Follow along with downloadable files as the instructor demonstrates spreadsheet formulas, PivotTables, data importing from Access databases, and advanced features like Power Query's Merge and Add Columns. Discover the power of Data Model PivotTables, the Power Pivot COM Add-in, and the differences between implicit and explicit DAX measures. Perfect for Excel users looking to enhance their data analysis skills and leverage Microsoft's powerful Excel tools.
Overview
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.
Taught by
ExcelIsFun
