Data Analyst Tasks, Challenges & GCP Tools

Workflow (Ingest → Transform → Store → Analyze → Visualize)

Step	Key challenges (문제)	What GCP gives you (해결)
Ingest	Volume/Variety/Velocity	Petabyte-scale ingest, streaming/Batch 옵션
Transform	Slow exploration/processing, unclear logic	Serverless pipelines, SQL-first transform (빠르게 시도/되돌리기)
Store	Cost, scaling pain, latency	Cheap durable storage, compute/스토리지 분리
Analyze	Slow queries, huge data, data silos	MPP SQL, cross-dataset/project JOIN, no 서버 관리
Visualize	Large datasets, tool latency	Interactive queries → dashboards/BI로 바로 연결

Denormalized tables + nested/repeated fields OK.
Standard SQL, intuitive Web UI.
No required indexes/keys/partitions*
- Not required, but partitioning & clustering are recommended for cost/perf.