Google Data Analytics case studies
Google Data Analytics · Put your knowledge to work in context.
The Google Data Analytics Certificate is a self-paced, fully online professional certificate delivered on Coursera. It is a foundational credential for people who want to prepare, process, analyze, and visualize data in an entry-level analytics role. The Google Data Analytics case studies are 5 cases and about 4,005 words.
1The Dashboard Request That Wasn't a Question
You are the analyst for a 14-store regional grocery co-op. On Monday the operations director says: "Build me a dashboard showing everything about our loyalty program by end of month - the board wants to know if it's working." You have three weeks, one part-time data engineer, and loyalty data sitting in a POS export of 210,000 member rows.
840 words, about 4 min2The 12% Null Column Two Days Before Deadline
You are cleaning a 480,000-row bike-share trip file two days before a deadline. The schema is ride id, start time, end time, start station, end station, member casual, and ride length sec.
784 words, about 4 min3The Chart That Manufactured a Trend
You are finalising slides for a $200,000 campaign decision. Monthly active users for the last 12 months are 10.0k, 10.2k, 10.1k, 10.4k, 10.3k, 10.6k, 10.5k, 10.8k, 10.7k, 11.0k, 10.9k, 11.1k.
735 words, about 4 min4The Groupby That Disagreed With Finance
You inherit a pandas notebook on orders.csv: 250,000 rows, 11 columns. The amount column is dtype object because values look like " 1,204.50" and a handful follow the European convention, "1.204,50".
800 words, about 4 min5The Capstone Question That Outran Its Data
For your capstone you are analysing 96,000 municipal 311 service requests from a mid-sized city's open data portal, covering 18 months. You want to answer: "Do residents in some neighbourhoods wait longer for pothole repairs?" You have request category, created at, closed at, neighbourhood name, and status.
846 words, about 4 min