GCP Data Practitioner case studies
GCP Data Practitioner · Put your knowledge to work in context.
The Associate Data Practitioner is Google Cloud's foundational data certification. The source describes the credential holder as someone who "secures and manages data on Google Cloud" and who has experience using Google Cloud data services for data ingestion, transformation, pipeline management, analysis, machine learning, and visualization. The GCP Data Practitioner case studies are 5 cases and about 3,082 words.
1Nightly depot files with retries, drift, and late arrivals
Northwind Freight receives 14 CSV files each night, one per regional depot, on an on-premises SFTP server. Files arrive between 22:00 and 03:00, but at least twice a month one depot uploads after 06:00.
642 words, about 3 min2Looker Studio spend spike after self-service launch
Meridian Retail opened BigQuery and Looker Studio to 300 analysts six weeks ago. Before that, monthly BigQuery on-demand spend was about 2,000.
642 words, about 3 min3Green DAG for three days while partitions were missing
Atlas Media runs a Cloud Composer 2 environment with a single hourly DAG. The DAG has four tasks: extract from a Cloud SQL Postgres replica to Cloud Storage using a Python operator, load into a partitioned BigQuery table, run a SQL transformation that overwrites a daily aggregate, and send a Slack message.
605 words, about 3 min4PII, retention, and cost split in a shared marketing dataset
Helios Health has a BigQuery dataset named marketing with 40 tables and 120 users across six teams. One table, customer contacts, contains email, phone, and postal address alongside customer id and region.
602 words, about 3 min5Meter events with duplicates, late gateways, and 900 TB of raw JSON
PulseGrid operates 80,000 smart meters that publish readings to Pub/Sub at up to 50,000 messages per second during peak. Each message is JSON with meter id, reading kwh, event ts, and a device-generated message id.
591 words, about 3 min