Franchised Store Stats

Context

• Sales analysis across three cities: Mandalay, Naypyitaw, and Yangon

• Focus on product lines, customer visits, income, and gender behavior

Problem Statement

• Identify which cities and product lines drive sales and profit

• Understand customer behavior differences to support better decisions

Objective

• Measure total sales, visits, and gross income by city

• Identify best-selling product lines

• Analyze purchasing behavior by gender

Visual Insights

• Naypyitaw and Yangon outperform Mandalay in total sales

• Fashion accessories and Home & lifestyle are the top product lines

• Female customers generate higher income than male customers

• Naypyitaw has the highest share of customer visits

Quantitative Metrics

• Total sales income: $322.97K

• Highest number of bills: Naypyitaw (1,780)

• Top product line sales: Fashion accessories (~$56K)

• Visit distribution:

  • Naypyitaw: 34.7%

  • Yangon: 33.8%

  • Mandalay: 31.5%

• Income by gender:

  • Female: 5.4M

  • Male: 4.0M

Conclusion

• Naypyitaw is the strongest city in overall performance

• Fashion accessories and Home & lifestyle should be the main focus

• Female customers are the primary revenue drivers

• Sales and marketing strategies should be optimized by city and gender