The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
$769M Motorola Sales - India Regional Dashboard
CLIENT PROBLEM: No city-wise visibility, which mobile model sells where.
WHAT I BUILT:
✓ $769.20M Total Sales + 19K Quantity tracking
✓ India map with Total Sales by City (Mumbai, Delhi, Bangalore)
✓ Top 3 Models: iPhone SE, OnePlus Nord, Galaxy Note 20
✓ Payment Method split: UPI, Debit, Cash, Credit
✓ Customer Ratings funnel (1488 to 309)
✓ Monthly slicer (Jan-Dec) + Day-wise sales trend
✓ Brand & City filters
TOOLS: Power BI, DAX, Maps, India market data
RESULT: Sales manager can see which city buys which model and best day to run offers.
DM for live demo of interactive map.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
Built an n8n CRM automation system that captures leads, creates and updates CRM records, assigns tasks, sends team notifications, automates follow-ups and generates reports.
$4.18M Shopify Store - Regional Sales, Customer Value & Retention Dashboard
CLIENT PROBLEM: No visibility on where sales come from, who are repeat customers, LTV.
WHAT I BUILT:
✓ $4.18M Net Sales tracking with Trend over Time
✓ 4431 Customers analyzed - 2039 Repeat (46% Repeat Rate)
✓ $943 Lifetime Value per customer
✓ Regional breakdown - Top cities: Washington, Houston, New York
✓ Payment gateway analysis (Shopify Payments 58%)
✓ Product Type performance
✓ Purchase Frequency 1.68x
TOOLS: Power BI, DAX, Power Query, Shopify, Maps
RESULT: Client now knows exactly which city, product and payment method brings highest LTV customers.
Want same for yourself? Message me for live demo.
E-Commerce Sales & Profit Analysis | Power BI Dashboard
Project Description
An end-to-end e-commerce analytics project focused on understanding sales performance, profitability, customer behavior, and regional trends.
I analyzed 5,000+ orders to identify key business trends and performance drivers.
Key Areas Analyzed:
📈 Total Sales & Profit
📅 Monthly Sales Trends
👥 Customer Segment Performance
🌍 Regional Sales Analysis
📦 Product Performance
💰 Profit Margin by Category
💳 Payment Method Analysis
What I did:
• Cleaned and prepared the dataset using Excel
• Performed SQL-based analysis using PostgreSQL
• Built an interactive Power BI dashboard
• Created KPIs and visualizations to track business performance
• Analyzed sales, profit, customers, products, and regional performance
• Generated business insights from the analyzed data
Tools:
Excel • PostgreSQL • SQL • Power BI
Workflow:
Raw Data → Excel → PostgreSQL → SQL Analysis → Power BI → Business Insights
Outcome:
The dashboard provides a clear view of e-commerce performance and helps identify sales trends, profitable categories, customer segments, and areas for business improvement.
