Google Sheets: Pivot Tables + Data Insights For Beginners!
Requirements
- Basic understanding of Google Sheets (if needed, you could learn along the way)
- High school math concepts (if needed, you could do a quick refresh during the course)
Description
Do you have data in Google Sheets and not sure how to make it useful? Then this course is for you!
Do you want to get on the path to being Data-Savvy? Then this course is for you!
Do you want to grow your Google Sheets data skills? Then this course is for you!
This course has been *designed by a former Google Analytical Lead* so that you can get comfortable going from rows and columns of data in a Google Sheet to useful insights via pivot tables.
This course includes numerous hands-on examples and practice exercises that will get you feeling data-savvy.
As a bonus, practice exercises and lecture examples are included in a spreadsheet that you can keep as part of the course.
This course is broken out into 8 key sections:
Section 1: Introduction (what are pivot tables and how they are used in the real-world to surface data insights)
Section 2: An Overview of the Data Insights Pivot Table Process
Section 3: Applying the Data Insights Pivot Table Process
Section 4: Practice Exercises: Set 1 (Titanic Dataset)
Section 5: Solution Videos for Practice Exercises: Set 1 (Titanic Dataset)
Section 6: Practice Exercises: Set 2 (Red Wine Dataset)
Section 7: Solution Videos for Practice Exercises: Set 2 (Red Wine Dataset)
Section 8: Course Wrap + Bonus Content
The content has intentionally been curated for practitioners who want to apply learnings right away.
This is NOT a long drawn out course that goes deep in the weeds on academic theory.
Make the transition from decisions based on gut feel to data informed decision making!
Use this efficiently designed course to level up your data skills. Get started today!
#AlwaysBeLearning
Who this course is for:
- Data insights beginner who wants to learn to further explore data and surface insights that can inform business decisions.
- Anyone not comfortable extracting insights from data using Google Sheets.
- Professionals who are not satisfied with their job and who want to get on the path to building a data analytics career.
- Any students in college who want to get started learning data skills.
- This course is not for those who are already doing advanced data analysis with Google Sheets pivot tables.
Course content
- 01:46Course Promo Video!
- 04:51What You Can Expect To Get Out Of This Course
- 05:01Meet The Instructor (Former Googler; Now Data Skills Bootcamp Founder)
- 03:00Why I’m Confident You’ll Enjoy This Course
- 08:51Real World Examples Using Pivot Tables To Surface Data Insights
- 00:05Glossary Of Data Terms We'll Be Using In The Course
- 2 questionsWhat Is A Pivot Table?
- 00:06Questions? Feedback? => Message me or see the the course Q&A
Instructor
Hello, my name is Brian Moore, welcome to my Udemy course page!
I enjoy using analytics/data insights to inform strategic business/product decisions. I’m an expert in generating and sharing data insights with senior technical and non-technical stakeholders.
I’m a practitioner of an apprenticeship + continuous learning approach. At Google, I worked with and studied under leading experts in data science and business. In addition to continuous learning from experts in the field, I strengthen my knowledge by applying skills on real-world projects and adhere to an ongoing self-study routine (using online resources, learning platforms, books, podcasts, YouTube channels, conferences, etc.).
More on my background and learning approach can be found on via my LinkedIn or website.
Feel free to send me a message for questions and/or feedback!
#AlwaysBeLearning
– Brian Moore