Google Data Analytics Professional Certificate Capstone Case Study In Excel
What if you only had 15 minutes to throw together an analysis?
What if that analysis was one of the Google Data Analytics Professional Certificate program's Capstone Case Studies?
In this video I give myself fifteen minutes to complete the Cyclistic Bike Share Analysis, and it was every bit as exciting as you'd imagine. (data here: https://divvy-tripdata.s3.amazonaws.c...)
📢 NEW! Want my FREE Excel Daily Most Ultimate Guide? Grab it here: https://tmbanalytics.com/resources
🫵 Ready to take on the 7 Days to Excel Challenge?
👉 Click here if you dare: https://tmbanalytics.com/courses/7-da...
👉 Connect with me on social!
Linkedin: / mattbrattin
Tiktok: / mattbrattin
VIDEO TOPICS:
0:00 - Intro and Background
4:00 - Review the case
6:20 - Timer Starts
11:00 - Data Cleaning
16:30 - Analysis
21:20 - Pencils Down and Discussion
LEARN MORE ABOUT USING EXCEL FOR ANALYSIS:
Excel for Analytics - Portfolio Project Series Video 1 - Quick Excel Tips • Excel for Analytics - Portfolio Project Se...
Excel for Analytics - Portfolio Project Series Video 2 - Data Cleaning in Excel
• Excel for Analytics - Portfolio Project Se...
Excel for Analytics - Portfolio Project Series Video 3 - Data Exploration and Analysis in Excel
• Excel for Analytics - Portfolio Project Se...
Excel for Analytics - Portfolio Project Series Video 4 - Data Presenting in Excel
• Excel for Analytics - Portfolio Project Se...
OTHER EXCEL TOPICS:
The MOST Ultimate Excel LOOKUP Guide | Can you guess which is my favorite?
• Why I Never Use VLOOKUP Anymore (And What ...
How to easily combine data into one cell in Excel (and why I stopped using CONCATENATE)
• The Best Way to Combine Text in Excel (It’...
#excel #pivottable #exceltips #spreadsheet