i
isai_vazquez

Isaí V

@isai_vazquez

E commerce Data Analyst, SQL, Looker Studio and Python Expert

Messico
Spagnolo, Inglese
Alcune informazioni sono riportate in lingua inglese.
Chi sono
Hi! I'm Isaí, a data analyst with a solid background in Physics and quantitative problem-solving. I specialize in bridging the gap between raw data and strategic business decisions. I help e-commerce businesses and companies clean, model, and visualize their data to uncover hidden growth opportunities. My core expertise includes advanced SQL querying, Python automation scripts, and building executive, interactive dashboards in Looker Studio and Tableau. Let’s turn your data chaos into actionable strategies!... Continua a leggere

Competenze

i
isai_vazquez
Isaí V
offline • 

Consulta i miei servizi

Dashboard dati
I will design a looker studio dashboard and rfm customer segmentation

Esperienza lavorativa

Independent_Home Lending

E-commerce RFM Customer Segmentation & Interactive BI Dashboard

Independent Home Lending • Lavoratore autonomo

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.