Data Analyst | SQL | Power BI
My Portfolio
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Demand Forecasting Model
Predict future demand based on historical sales.
Regional Sales Performance Dashboard
Compare sales by geography or distributor.
Sales Forecasting (Time Series)
Predict future monthly sales for better inventory & planning.
Sales Data Analysis & Insights
Multi-channel sales tracking (Website, Amazon, Flipkart, Offline) + KPIs for revenue & performance.
Ad Spend vs Conversion Analysis
Measure how ad budget impacts conversions.
Lead Qualification Dashboard
Visualize leads → qualified → converted funnel.
Marketing Mix Modeling (MMM)
Quantify which channel (Social, Search, Referral, etc.) gives the highest ROI.
Marketing Campaign Performance Tracker
Analyze Google, Meta, and IndiaMart campaign ROI.
Recommendation System
Suggest products based on purchase history.
Price Optimization Model
Predict optimal selling price for max profit.
Churn Prediction Model
Identify customers likely to stop buying.
Customer Lifetime Value (CLV) Prediction
Predict future revenue per customer.
Customer Segmentation (Clustering)
Group customers by buying behavior & spending pattern.
Interactive KPI Tracker (Power BI)
Dynamic visualization with filters for region, time, and category.
E-commerce Analytics Dashboard
Track website traffic, product performance, and conversions.
Executive Dashboard (Looker Studio)
Real-time visualization of sales, leads, and conversions.
LinkedIn Page Analytics
A fully automated LinkedIn Analytics Dashboard powered by Looker Studio. Shows daily engagement, impressions, clicks, and audience growth with real-time Google Sheets updates.
Python Automation for Report Generation
Automatically generate marketing reports weekly.
Google Sheets Automation (Apps Script)
Auto-updating dashboards via form submissions.
SQL Query Case Studies
Business questions answered via SQL (Top customers, products, etc.)
Data Cleaning & Transformation in Python
Handle missing values, outliers, and inconsistent formats.
Website Design - Word Press
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Store Design - Amazon
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Store Design - Shopify
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Support Website Design - WP
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Business & Sales Analytics
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Marketing Analytics & Performance
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Digital Marketing & Branding
Skills: WordPressWooCommerce, Shopify, Canva, SEO, Amazon Seller Central
Amazon Store Design
Responsibilities included creating product listings, designing images using Canva, developing front store layouts, and implementing A+ content to improve the overall shopping experience.
Shopify Store Design
Developed a fully functional Shopify e-commerce store for Tuchware to streamline online sales of smart locks and access control products. The goal was to create a clean, user-friendly, and mobile-responsive shopping experience with an emphasis on brand consistency and product presentation.
Tuchware Support Website Design
Designed and developed a dedicated Support Website for Tuchware to streamline customer service, ticket management, and product query resolution.
AB Testing Simulation
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Interactive Executive Dashboard (Looker Studio + SQL)
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Marketing Mix Modeling (MMM)
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Price Optimization Model
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Recommendation System
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Sentiment Analysis on Product Reviews
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Churn Prediction Model
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Customer Lifetime Value (CLV) Prediction
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Lead Qualification Dashboard
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Marketing ROI Optimization
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Sales Forecasting (Time Series Model)
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Customer Segmentation (Clustering Analysis)
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
E-commerce Data Cleaning & Analysis
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Marketing Analytics & Performance
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Marketing Campaign Performance Tracker
Skills: WordPressWooCommerce, Shopify, Canva, SEO, Amazon Seller Central
Sales Data Dashboard
Skills: WordPressWooCommerce, Shopify, Canva, SEO, Amazon Seller Central
E-Commerce Store Design & Develop
Skills: WordPressWooCommerce, Shopify, Canva, SEO, Amazon Seller Central
Website Design & Development
Skills: WordPressWooCommerce, Shopify, Canva, SEO, Amazon Seller Central
Amazon Store Design
Responsibilities included creating product listings, designing images using Canva, developing front store layouts, and implementing A+ content to improve the overall shopping experience.
Shopify Store Design
Developed a fully functional Shopify e-commerce store for Tuchware to streamline online sales of smart locks and access control products. The goal was to create a clean, user-friendly, and mobile-responsive shopping experience with an emphasis on brand consistency and product presentation.
Tuchware Support Website Design
Designed and developed a dedicated Support Website for Tuchware to streamline customer service, ticket management, and product query resolution.
Lead Generation
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Website SEO
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Social Media Analytics
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.