Projects

Selected projects across business intelligence, analytics, and data automation—focused on turning data into actionable business decisions.

Business Performance Dashboard

Built business performance dashboards by integrating sales, marketing, and operational data to provide a centralized view of key business metrics and performance trends.

What I did:

SQL-based data extraction and transformation
Dashboard development using Looker Studio / Google Data Studio
Performance monitoring across sales and marketing
Translated data findings into actionable business recommendations

Data Pipeline & Automation

Designed an automated data pipeline to consolidate e-commerce, order, fulfillment, and marketing data from multiple sources into a centralized analytical environment.

What I did

Extracted data through APIs
Automated data ingestion and transformation using n8n
Consolidated operational data into BigQuery
Structured datasets for reporting and analysis
Reduced dependency on manual data preparation

Flow: API → n8n → BigQuery → Dashboard

Tools: API · n8n · BigQuery · SQL · Python

E-commerce Customer & Retention Analytics

Analyzed customer purchase behavior and cohort retention using SQL and BigQuery to understand repeat-purchase patterns and customer lifecycle performance.

The analysis provided visibility into retention trends and highlighted areas where further customer retention initiatives could be explored.

Market Basket Analysis

Identified frequently purchased beauty-product combinations using association rule mining to support cross-selling and product bundling opportunities.

Tools: Python

Data Scientist Salary Projection

Project from RevoU
(Group Final Project, see here)

Analyzed U.S. data-science job market patterns to identify salary drivers and geographic opportunities using regression and clustering techniques.

Tools: Python · Tableau · Regression · Clustering