MSPTDA 13: Power Pivot Introduction #1: Relationships rather than VLOOKUP for PivotTable Report

Поделиться
HTML-код
  • Опубликовано: 10 фев 2025
  • Download Excel START File: people.highlin...
    Download Excel FINISHED File: people.highlin...
    Download Example of Large File Size using VLOOKUP: people.highlin...
    Download pdf Notes: people.highlin...
    Assigned Homework:
    Download Excel file and complete the homework:
    people.highlin...
    Examples of Finished Homework:
    people.highlin...
    This video introduces Excel Power Pivot and shows how to use the Relationship feature rather than VLOOKUP Function to reduce file size and allow user to pull fields for a PivotTable Report from Multiple Tables.
    Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
    Topics:
    1. (00:15) Introduction
    2. (01:43) Look at VLOOKUP solution
    3. (02:49) Introduction to What Is Power Pivot? Discuss what a Data Model is.
    4. (05:46) Relationship feature
    5. (09:16) Create PivotTable Report
    6. (11:45) First Look at Implicit Measures
    7. (13:02) Enable the Power Pivot Ribbon Tab
    8. (13:37) First Look at Power Pivot Window and Data Model
    9. (20:30) Summary

Комментарии • 163

Следующие
Автовоспроизведение
MSPTDA 14: Power Pivot Intro #2: Amazing Columnar Database Importing Millions of Rows Data to Excel19:09MSPTDA 14: Power Pivot Intro #2: Amazing Columnar Database Importing Millions of Rows Data to Excel
MSPTDA 14: Power Pivot Intro #2: Amazing Columnar Database Importing Millions of Rows Data to Excelexcelisfun
Просмотров 43 тыс.
Диаграмма Ганта в Power Query13:09Диаграмма Ганта в Power Query
Диаграмма Ганта в Power QueryNikolay Pavlov
Просмотров 42 тыс.
Excel Basics 21: Relationships Rather than VLOOKUP for PivotTable Reports (Excel 2016 Data Model)21:35Excel Basics 21: Relationships Rather than VLOOKUP for PivotTable Reports (Excel 2016 Data Model)
Excel Basics 21: Relationships Rather than VLOOKUP for PivotTable Reports (Excel 2016 Data Model)excelisfun
Просмотров 157 тыс.
World's Newest Overwater Villas (Saudi Arabia)35:35World's Newest Overwater Villas (Saudi Arabia)
World's Newest Overwater Villas (Saudi Arabia)Kara and Nate
Просмотров 985 тыс.
The Simplest World That Can Farm Every Item20:18The Simplest World That Can Farm Every Item
The Simplest World That Can Farm Every ItemKenadian
Просмотров 741 тыс.
Our Altima Race is Happening (80 Altimas) Here's Mine!15:47Our Altima Race is Happening (80 Altimas) Here's Mine!
Our Altima Race is Happening (80 Altimas) Here's Mine!Cleetus2 McFarland
Просмотров 847 тыс.
ChatGPT | The Intelligence Age01:01ChatGPT | The Intelligence Age
ChatGPT | The Intelligence AgeOpenAI
Просмотров 425 тыс.
Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 MINUTES (project files included!)17:29Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 MINUTES (project files included!)
Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 MINUTES (project files included!)Maven Analytics
Просмотров 294 тыс.
MSPTDA 06: Power Query: Merge, Append, & UnPivot - 3 Important Transformations23:39MSPTDA 06: Power Query: Merge, Append, & UnPivot – 3 Important Transformations
MSPTDA 06: Power Query: Merge, Append, & UnPivot - 3 Important Transformationsexcelisfun
Просмотров 96 тыс.
Excel GROUPBY & PIVOTBY Functions - All You Need to Know (do they BEAT Pivot Tables? 🤔)16:37Excel GROUPBY & PIVOTBY Functions - All You Need to Know (do they BEAT Pivot Tables? 🤔)
Excel GROUPBY & PIVOTBY Functions - All You Need to Know (do they BEAT Pivot Tables? 🤔)Leila Gharani
Просмотров 441 тыс.
MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship17:28MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship
MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationshipexcelisfun
Просмотров 45 тыс.
The Excel Tool That Does What PivotTables Can’t (File Included)13:59The Excel Tool That Does What PivotTables Can’t (File Included)
The Excel Tool That Does What PivotTables Can’t (File Included)MyOnlineTrainingHub
Просмотров 307 тыс.
E-DAB 07: Data Modeling: VLOOKUP, Power Query or Power Pivot?45:21E-DAB 07: Data Modeling: VLOOKUP, Power Query or Power Pivot?
E-DAB 07: Data Modeling: VLOOKUP, Power Query or Power Pivot?excelisfun
Просмотров 63 тыс.
Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)19:04Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)
Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)Maven Analytics
Просмотров 139 тыс.
Try The DGET Function Instead of INDEXMATCH & XLOOKUP12:29Try The DGET Function Instead of INDEXMATCH & XLOOKUP
Try The DGET Function Instead of INDEXMATCH & XLOOKUPKenji Explains
Просмотров 154 тыс.
MSPTDA 04: Power Query: Import Multiple Excel Files & Combine (Append) into Proper Data Set32:04MSPTDA 04: Power Query: Import Multiple Excel Files & Combine (Append) into Proper Data Set
MSPTDA 04: Power Query: Import Multiple Excel Files & Combine (Append) into Proper Data Setexcelisfun
Просмотров 188 тыс.
Фильм В тылу врага : боевик, триллер, драма (2022)1:25:50Фильм В тылу врага : боевик, триллер, драма (2022)
Фильм В тылу врага : боевик, триллер, драма (2022)Кино Онлайн
Просмотров 751 тыс.
SPLASH BALLOON00:44SPLASH BALLOON
SPLASH BALLOONNatan por Aí
Просмотров 27 млн
Arc Warden с РЕЖИМОМ БОГА против КОМАНДЫ ПРО ИГРОКОВ! ТРИ ТРОНА!😰46:02Arc Warden с РЕЖИМОМ БОГА против КОМАНДЫ ПРО ИГРОКОВ! ТРИ ТРОНА!😰
Arc Warden с РЕЖИМОМ БОГА против КОМАНДЫ ПРО ИГРОКОВ! ТРИ ТРОНА!😰Meeponegeroi
Просмотров 249 тыс.
The First Kiss in Brawl Stars!?02:45The First Kiss in Brawl Stars!?
The First Kiss in Brawl Stars!?Brawl Stars
Просмотров 8 млн
ОБЗОР UFC 312 | ВСЕ БОИ | Дрикус Дю Плесси, Шон Стрикланд, Вейли Жанг, Татьяна Суарез16:18ОБЗОР UFC 312 | ВСЕ БОИ | Дрикус Дю Плесси, Шон Стрикланд, Вейли Жанг, Татьяна Суарез
ОБЗОР UFC 312 | ВСЕ БОИ | Дрикус Дю Плесси, Шон Стрикланд, Вейли Жанг, Татьяна СуарезДикий бой
Просмотров 126 тыс.
БИТВА БЛОГЕРОВ - В 20:30 СТАРТ РИСКОВАННОЙ АТАКИ! [БЫТЬ ВСЕМ]11:54:58БИТВА БЛОГЕРОВ - В 20:30 СТАРТ РИСКОВАННОЙ АТАКИ! [БЫТЬ ВСЕМ]
БИТВА БЛОГЕРОВ - В 20:30 СТАРТ РИСКОВАННОЙ АТАКИ! [БЫТЬ ВСЕМ]Near_You
Просмотров 126 тыс.
LIVE: Team Vitality vs. Team Spirit - IEM Katowice 2025 - Grand Final5:10:23LIVE: Team Vitality vs. Team Spirit - IEM Katowice 2025 - Grand Final
LIVE: Team Vitality vs. Team Spirit - IEM Katowice 2025 - Grand FinalESL Counter-Strike
Просмотров 1,4 млн
Улетели ДЕЛАТЬ детей с Настей Туман НЕСТАНДАРТНЫМ способом.42:12Улетели ДЕЛАТЬ детей с Настей Туман НЕСТАНДАРТНЫМ способом.
Улетели ДЕЛАТЬ детей с Настей Туман НЕСТАНДАРТНЫМ способом.Саша Туман
Просмотров 232 тыс.