Business Analyst Project

Problem Statment

1. Walmart Sales Analysis:

• A. Analyze the performance of sales and revenue at the city and branch level
• B. What is the average price of an item sold at each branch of the city
• C. Analyze the performance of sales and revenue, Month over Month across the Product line, Gender, and Payment Method, and identify the focus areas to get better sales for April 2019.

2. App Exploration:

Explore the features and user experience of the Jar app. Identify two aspects that you think could be significantly improved and explain your reasoning behind each suggestion.

3. Product Optimisation:

The Jar app has an engagement feature called 'Spin to Win'. Right now, if 100 people come to the app each day, only 23 of them try out this spinning game. But, we know that people who spin are more likely to retain on the app and do transactions. Now, we want to get more people to play the game. So, the question is, how can we make sure that at least 50 people out of every 100 who visit the app each day will play 'Spin to Win'? What can we do to get more people interested in spinning the wheel?

Project Overview

This repository contains three key projects demonstrating business analysis skills:

1. Walmart Sales Analysis
2. Jar App Feature Exploration
3. Spin to Win Engagement Optimization

1. Walmart Sales Analysis

Objectives

• Analyze sales and revenue performance across cities and branches
• Calculate average item prices
• Perform month-over-month sales analysis

Key Findings

Revenue Performance

• Top Performing Branch: Branch B (107,567.19 Kyat total revenue)
• City Insights:
  • Mandalay: Branch B highest (37,215.93 Kyat)
  • Naypyitaw: Branch A highest (35,985.64 Kyat)
  • Yangon: Branch B highest (35,193.51 Kyat)

Product Pricing Highlights

• Electronic Accessories: Up to 60 Kyat (Branch C, Naypyitaw)
• Fashion Accessories: Peak at 68 Kyat (Branch B, Naypyitaw)
• Home and Lifestyle: Highest at 61 Kyat (Branch B, Yangon)

Recommendations

1. Targeted promotions for underperforming categories
2. Branch-specific marketing strategies
3. Optimize inventory based on sales trends

2. Jar App Feature Exploration

Identified Improvement Areas

1. Rewards Claiming Experience

Current Challenge: Complicated reward redemption process

Proposed Solution: Jar Wallet

• Centralized point storage
• Usable for:
  • Buying gold
  • Shopping at Nek
• Tagline: "Spin, Save, and Shine!"

2. Savings Objective Setting

Current Challenge: Users struggle to set clear savings goals

Proposed Solution: Enhanced Goal Setting Feature

• Detailed savings targets
• Milestone notifications
• Motivational messaging
• Example: Save ₹1,00,000 for a bicycle

3. Savings Allocation Control

Current Challenge: Automatic fund allocation during transactions

Proposed Solution: Flexible Spending Control

• Percentage-based savings allocation slider
• Mandatory confirmation for fund usage
• Prevents unintended full balance spending

4. Real-time Gold Price Updates

Current Challenge: Limited price movement insights

Proposed Solution: Proactive Investment Alerts

• Daily gold price drop notifications
• Investment timing recommendations
• Example Notification: "Gold prices dropped by ₹200! Invest today!"

3. Spin to Win Engagement Optimization

Current Scenario

• 100 daily app visitors
• Only 23 users engage with 'Spin to Win'
• Goal: Increase engagement to 50+ users

Proposed Wheel Design Strategy

Wheel Concept: "Spin, Earn Points and Buy Gold"

Key Features

• Mystery '?' reward slots
• Clear gold conversion rates
  • ₹10 = 0.01g of Gold
  • ₹50 = 0.05g of Gold

Engagement Drivers

• Transparent gold acquisition
• Exciting reward potential
• Clear value proposition

Engagement Improvement Tactics

1. Gamification elements
2. Visible gold conversion
3. Mystery reward slots
4. Clear, motivational messaging

Technical Implementation

Tools and Technologies

• Data Analysis: Excel, Python, PowerBI
• Visualization: PowerBI Dashboard