An end-to-end data analysis pipeline evaluating transaction history, customer retention curves, and RFM segments with interactive Power BI dashboards.
Raw multi-category e-commerce transaction logs frequently contain data anomalies, cancelled orders, and unstandardized dates, preventing management from gaining clear visibility into repeat customer lifetime value and retention trends.
Constructed an end-to-end Python and SQL transformation pipeline, extracted cohort retention matrices, computed RFM (Recency, Frequency, Monetary) behavioral scores, modeled a star-schema relational database in PostgreSQL, and built an executive Power BI dashboard with interactive slicers.
| Component Layer | Role & Implementation |
|---|---|
| Raw Data Ingestion | CSV ingestion into staging schema with automated type verification |
| Transformation Scripts | Pandas & SQL scripts standardizing timestamps, currency fields, and filtering returns |
| Dimensional Data Model | Star-schema relational database modeled in PostgreSQL with fact and dimension tables |
| BI Visualization | Multi-page Power BI dashboard with interactive filtering and drill-down |
Get in Touch
Tell me about your agency challenge, spreadsheet bottlenecks, or workflow needs. I will review the details and suggest a practical approach.
Prefer direct communication over the form? Send an email or connect via WhatsApp: