🛒 AI-Powered E-commerce Customer Intelligence Platform

Overview: End-to-end modern data platform that transforms raw e-commerce data into AI-powered customer intelligence using analytics engineering and Generative AI.

Tech Stack: Python, SQL, Pandas, Google BigQuery, dbt Core, Gemini LLM, LangChain, Chroma Vector Database, Vector Search, RAG, Streamlit

Architecture: Data Sources → BigQuery Raw Layer → dbt Transformations → Customer Intelligence Marts → Gemini Embeddings → Vector Database → RAG Engine → Streamlit AI Copilot

Key Features:

• Built BigQuery data warehouse models with dbt staging, intermediate, and mart layers
• Created Customer 360 analytics for customer behavior, engagement, and segmentation
• Implemented Customer Lifetime Value (LTV) analysis to identify high-value customers
• Developed churn prediction insights to identify customers at risk
• Created AI Marketing Copilot using Gemini, LangChain, Vector Search, and RAG pipeline
• Enabled natural-language analytics for customer insights and marketing recommendations
• Built an interactive Streamlit application for business users

Business Impact: Delivered AI-driven customer intelligence, improved retention analysis, supported personalized marketing, and enabled conversational access to business analytics.

View Project

🚴 Bike Sales Analysis Dashboard (Tableau)

Description: Built an interactive Tableau dashboard analyzing bike sales performance, revenue, profit, customer demographics, product categories, and geographic business trends.

Tools: Tableau, Excel

Business Objective: Evaluate sales performance and identify profitable products, customer segments, and revenue growth opportunities.

Key Insights:

• Generated approximately $5.86M profit analysis with YoY tracking
• Identified adults (35–64 age group) as the highest-value customer segment
• Analyzed bike category as the strongest revenue contributor
• Discovered top-performing products and customer buying patterns
• Analyzed sales distribution across North America and Europe

Dashboard Features:

• KPI tracking for revenue, profit, and growth
• Product performance analysis
• Revenue trend visualization
• Customer segmentation dashboard
• Geographic sales analysis
• Interactive Tableau filters

View Dashboard