Pivot Tables: Establishing Relationships – Part Three

Title and link: Pivot Tables: Establishing Relationships – Part Three

Video Host: YouTube

Presenter: Sam Suber

Presenting Institution: MVCC

Date Presented: 2020-11-20

Description: Pivot tables are a way to view and manipulate your data. Queries are ways to import data. Power Pivot is way to create a shared pivot table through multiple data sets. Measures are ways to create formulas based off a shared pivot table. The next step (next webinar) will highlight the limitations of a shared pivot table and solutions to fix this. Database relationship theory will be discussed and practiced through sample scenarios. No prior experience with database design is necessary.