https://www.youtube.com/watch?v=lH7HfwUFnYA

00:00 — Series intro and scope. Sponsor

01:00 — What are Pivot Tables? Dataset intro

02:00 — Open dataset and column overview

03:00 — Revenue focus and Insert Pivot Table

04:00 — Create a Pivot Table on a new worksheet

05:00 — Add Country and State to Rows

06:00 — Expand/Collapse and drill down by State

07:00 — Sum of Revenue by Country and State

08:00 — Format currency, show as %, sort

09:00 — Rename fields and sort by % of total

10:00 — Add Cost and Profit measures

11:00 — Revenue vs Cost vs Profit explained

12:00 — Create a Calculated Field

13:00 — Verify profit with the calculated field

14:00 — Use Filters: example with Customer Gender

15:00 — Quick insight from gender filter. New pivot setup

16:00 — Year in columns, revenue measure, format