#DatabaseBasics #DataModeling #PowerPivot

Learning Power Pivot is a Muscle – Struggle is Part of the Process

Name: Learning Power Pivot is a Muscle – Struggle is Part of the Process
Uploaded: 2026-09-11T16:07:47
Duration: 2 min 15 s
Description: Stephen Yoss breaks down the real learning curve of database work—and why the struggle is essential. He walks through connecting to a live database using Power Pivot, importing tables, and seeing how your data model takes shape. The mechanics are tough at first, but once you grasp the syntax, it clicks. Watch to see exactly how to set up your first connection and load data like a pro.

2:15 · A clip from Database Basics for Financial Professionals, taught by Stephen Yoss

Stephen Yoss breaks down the real learning curve of database work—and why the struggle is essential. He walks through connecting to a live database using Power Pivot, importing tables, and seeing how your data model takes shape. The mechanics are tough at first, but once you grasp the syntax, it clicks. Watch to see exactly how to set up your first connection and load data like a pro. From the course “Database Basics for Financial Professionals” (4 CPE credits, Information Technology, Basic): https://www.cpetoday.com/course/database-basics-for-financial-professionals-24c00961 Taught by Stephen Yoss — Speaker & Author, CPE Today. More from Stephen Yoss: https://www.cpetoday.com/instructor/stephen-yoss 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/ #DatabaseBasics #DataModeling #PowerPivot

More from this course

3:43 Why GROUP BY Matters: From Thousands of Rows to Four

1:36 SQL Has No Undo: The Permanent Mistake Risk

3:02 A Database Is Just an Advanced Spreadsheet