#PivotTable #Excel #DataModeling

Building an Enterprise Pivot Table from 2.2M Rows

Name: Building an Enterprise Pivot Table from 2.2M Rows
Uploaded: 2026-10-27T18:19:28+00:00
Duration: 3 min 54 s
Description: Watch how to create a fully related data model by linking multiple tables together, then build a powerful pivot table from 2.2 million rows of sales data. Tommy Stephens walks through dragging fields into rows, filters, and values to generate meaningful reports in minutes. Learn how Power Query prepares your data so your pivot tables actually tell a story.

3:54 · A clip from Eight Awesome PivotTable Features, taught by Tommy Stephens

Watch how to create a fully related data model by linking multiple tables together, then build a powerful pivot table from 2.2 million rows of sales data. Tommy Stephens walks through dragging fields into rows, filters, and values to generate meaningful reports in minutes. Learn how Power Query prepares your data so your pivot tables actually tell a story. From the course “Eight Awesome PivotTable Features” (4 CPE credits, Computer Software and Applications, Intermediate): https://www.cpetoday.com/course/eight-awesome-pivottable-features-22c-8ptf Taught by Tommy Stephens — Partner, K2 Enterprises. More from Tommy Stephens: https://www.cpetoday.com/instructor/tommy-stephens CPE Today offers live webinars, Live Replays and self-study for CPAs and accounting professionals. NASBA-sponsored (ID 167619) and an IRS-approved CE provider. https://www.cpetoday.com/ #PivotTable #Excel #DataModeling

More from this course

3:59 Why Slicer Colors Matter More Than You Think

3:25 Calculated Fields in Pivot Tables: The Feature Most People Miss

4:00 Convert Data to a Table Before Building Pivot Tables