Back to Showcase
ABC Bank Customer Churn Analysis
nastka Stadnyk
pythonsqlbruinbigquerylooker-studiokaggle
An end-to-end churn analysis pipeline for ABC Bank, proving that 80% of churned customers are actually 'Above Market' high-earners. Built with a Medallion-like structure (Staging → Benchmarks → Facts) using Bruin's asset-based approach. The pipeline ingests data from the Kaggle API, stores it in GCS, transforms it in BigQuery with clustering and optimization, and visualizes results in Looker Studio. Features include full DAG dependency resolution, not_null and unique quality checks embedded directly in assets, and automated trust through Bruin's validation system.