Introduction
• Course Promo Video!
• What You Can Expect To Get Out Of This Course
• Meet The Instructor (Former Googler; Now Data Skills Bootcamp Founder)
• Why I’m Confident You’ll Enjoy This Course
• Real World Examples Using Pivot Tables To Surface Data Insights
• Glossary Of Data Terms We'll Be Using In The Course
• What Is A Pivot Table?
• Questions? Feedback? => Message me or see the the course Q&A
Pivot Table Data Insights Process
• Overview: 5 Key Steps To Generate A Pivot Table
• Ideal Input Data Structure To Make Generating Pivot Tables Easier
• Step 2: Orient & Trust Your Input Data
• Orient & Trust Your Input Data
• Step 3: Draw Your Goal Output Table
• Draw Your Goal Output Table
• Step 4: Use The Pivot Table Editor To Configure Goal Output
• Pivot Table Configuration
• Step 5: Iterate On Pivot Table Configuration
• Iterate On Pivot Table Configuration
• Friendly Reminder! Questions or Feedback? Message the instructor
Applying The Pivot Table Data Insights Process
• Dataset We’ll Be Using For The Exercises & Lecture Examples
• Titanic Dataset Questions
• Calculate An Average For A Dataset Variable
• Basic Summary Statistics For A Dataset Variable
• Splitting Metrics By A Dataset Category
• Filter Stats For Only A Segment Of A Dataset
• Grouping Stats By Multiple Dataset Categories
• Customer Metrics
• Adjusting Table Appearance (number formats, sorting, showing totals)
Practice Exercises: Set 1 (Titanic Dataset)
• Titanic Dataset Link (in case you missed it)
• Titanic Pivot Table Exercises Quiz
Solution Videos for Practice Exercises: Set 1 (Titanic Dataset)
• Exercise 1 Solution (Titanic Dataset Exercises)
• Exercise 2 Solution (Titanic Dataset Exercises)
• Exercise 3 Solution (Titanic Dataset Exercises)
• Exercise 4 Solution (Titanic Dataset Exercises)
• Exercise 5 Solution (Titanic Dataset Exercises)
• Exercise 6 Solution (Titanic Dataset Exercises)
• Exercise 7 Solution (Titanic Dataset Exercises)
Practice Exercises Set 2 (Red Wine Dataset)
• Red Wine Dataset Link for Exercises Set 2
• Red Wine Pivot Table Exercises Quiz
Solution Videos for Practice Exercises: Set2 (Red Wine Dataset)
• Exercise 1 Solution (Red Wine Dataset Exercises)
• Exercise 2 Solution (Red Wine Dataset Exercises)
• Exercise 3 Solution (Red Wine Dataset Exercises)
• Exercise 4 Solution (Red Wine Dataset Exercises)
• Exercise 5 Solution (Red Wine Dataset Exercises)
Course Conclusion
• Combing Pivot Tables with Charts / Graphs in Google Sheets
• Using Pivot Tables To Power An Executive Reporting Dashboard
• Course Wrap Up