Ayan Bajwa
Power BI Expert | Messy Data to Interactive Dashboards
New to Contra
Ayan is building their profile!
$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.
0
39
$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.
0
53