
Isaí V
E commerce Data Analyst, SQL, Looker Studio and Python Expert
Skills

Bekijk mijn diensten

Werkervaring
E-commerce RFM Customer Segmentation & Interactive BI Dashboard
Independent Home Lending • ZZP
Jun 2026 - Jul 2026 • 1 mo
Many e-commerce businesses struggle to identify their most valuable customers and lose revenue by neglecting users who are about to leave. I built ApexMarket to solve this exact problem through automated data analysis. What I did:Data Engineering: Built a relational database structure using SQLite and processed 1,000+ transactional records using Python. Advanced Analytics: Wrote optimized SQL queries using CTEs and window functions (NTILE) to calculate Recency, Frequency, and Monetary (RFM) metrics to segment the customer base automatically. Business Intelligence: Designed a stunning, fully interactive Looker Studio dashboard featuring cross-filtering and heatmaps. The Business Impact:The dashboard automatically exposes the Pareto Principle (VIP customers driving the highest revenue) and flags 'At Risk' clients who haven't purchased in 210+ days, allowing marketing teams to launch hyper-targeted retention campaigns before customers are lost permanently.