Overview

Visualise the network of financial institutions that a fin-tech company engages with overlaid with physical geography at the Nielsen DMA level. Through combining SSIS ETL packages with Vertica columnar-storage data table and custom SQL in a Tableau report, I delivered a flexible solution that created work-arounds for gaps in technology at the time the dashboard was built. The underlying data of this report combines nearly 6 billion spend data points with a custom GIS shapefile to translate the spend and network geography of this business into a visual story anchored in relevant spatial visualisations and KPIs.

Analytical Concepts

• Acquisition Rate
• Attrition Rate
• Churn Rate
• Population Penetration
• Customer Segmentation

Data Stack

• Vertica
• SSIS
• SQL
• Tableau