i
isai_vazquez

Isaí V

@isai_vazquez

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

Mexico
Spanish, English
About me
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!... Read more

Skills

i
isai_vazquez
Isaí V
Offline • 

See my services

Data Dashboards
I will design a looker studio dashboard and rfm customer segmentation

Work experience

Independent_Home Lending

E-commerce RFM Customer Segmentation & Interactive BI Dashboard

Independent Home Lending • Self-employed

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.