Data Modeling - VLOOKUP, Power Query or Power Pivot?
Offered By: ExcelIsFun via YouTube
Course Description
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
Related Courses
Organizational AnalysisStanford University via Coursera Introduction to Business in Asia
Griffith University via Open2Study Introduction to Enterprise Architecture
Enterprise Architects via Open2Study Business Processes: Modeling, Simulation, Execution
openHPI BI 4 Platform Innovation and Implementation
SAP Learning