Marketing Analytics Projects in IndiaMarketing Analytics Projects in IndiaSales, Customer & Marketing Analytics in Power BI
I built a complete 3-page Power BI dashboard to analyze Sales performance, Customer behavior, and Marketing ROI—all in one place.
🔍 Sales Overview
Revenue trends & top product categories
Total Sales, Orders & Average Order Value
Region-wise and payment method analysis
👥 Customer Insights
New vs Returning customers
Customer Lifetime Value (LTV) by region
Purchase frequency & repeat behavior using DAX
📈 Marketing Performance
Spend vs Revenue across Paid Ads, Social, Referral, Influencer/UGC, Email & Offline
Clear ROI comparison to identify winning and underperforming channels
🛠 Tools Used: Power BI, SQL, DAX, CSV
💡 Outcome:
This project shows how combining Sales, Customer, and Marketing data helps businesses make faster, smarter decisions. The objective of this project was to scale revenue for a Shopify-based eCommerce brand while maintaining a healthy conversion rate and average order value. I managed end-to-end performance marketing, focusing on traffic quality, funnel optimization, and data-driven ad scaling.
Through structured campaign testing, audience segmentation, and conversion rate optimization, the store achieved $175,459.31 in total sales within 30 days. Traffic increased to 76,029 online store sessions, resulting in 1,412 total orders, a 1.76% conversion rate, and a strong $106.19 average order value.
![Cover image for [Case Studies] How I helped startups with product growth](https://media.contra.com/image/upload/q_auto,w_800/uxiibfbxkk1up1hgpv6k.avif)
