Data Analyst
Transforming data into actionable insights with precision and clarity.
View My WorkAn end-to-end analytics pipeline shifting traditional RFM Analysis from customer behavior to Product Segment Health across 74 categories. Engineered in Google Cloud BigQuery using advanced SQL, including CTEs, Aggregate Functions, and Window Functions (NTILE) for score stratification. Developed an interactive, cost-optimized Looker Studio Dashboard via a Google Sheets caching layer, delivering actionable insights on revenue drivers and inventory red flags (Dead Stock).
Read Case Study & View Dashboard →An in-depth EDA of the Online Retail Dataset using R. Investigated 10 analytical dimensions and implemented RFM Feature Engineering to segment customers by behavior. Using Tidyverse, I transformed raw data into insights to optimize marketing and purchasing patterns.
Read Case Study →Strategic analysis of the Sample Superstore Dataset using Python. Focused on Profit Margin analysis and operational inefficiencies. Provided data-driven recommendations to optimize supply chain logistics and enhance regional sales strategies for business profitability.
Read Case Study →An end-to-end database simulation developed using SQLite and Python (Pandas). I designed a comprehensive relational schema covering staff, menus, customers, and transactions. The project showcases advanced SQL techniques like CTEs and Aggregate Functions to analyze customer behavior and sales performance across four primary tables.
View Code on GitHub →