Business Analyst Intern Assignment
Submitted by: Ranjithkumar R
Jar – Assignment Submission
Page 1
Question 1 – Sales Analysis
Part 1: Sales and Profitability Analysis
I merged the order datasets using Order ID and calculated total sales, profit, average profit per order,
and profit margin for each category. Clothing performed the best, Electronics stayed in the middle, and
Furniture showed the weakest margin despite decent sales. This suggests reviewing Furniture costs
and giving more attention to the Clothing category.
Category Summary Table
Category total_sales total_profit avg_profit_per_order profit_margin_pct
Clothing 139054 11163 11.76290832455 2168.027816531707106
Electronics 165267 10494 34.07142857142 8576.349724990469967
Furniture 127181 2298 9.456790123456 791.806873668236608
Part 2: Target Achievement Analysis (Furniture)
I analysed month to month target changes for the Furniture category. The targets fluctuated instead of
increasing gradually, which makes planning a bit difficult. A smoother target setting approach, based on
recent performance, would help the team plan better.
Page 2
Furniture MoM Target Summary
Month of Order ateCategory Target MoM_Change_%
D
2025-01-19 Furniture 11500 nan
2025-02-19 Furniture 11600 0.8695652173912993
2025-03-19 Furniture 11800 1.724137931034475
2025-04-18 Furniture 10400 -11.86440677966102
2025-05-18 Furniture 10500 0.961538461538458
2025-06-18 Furniture 10600 0.952380952380949
2025-07-18 Furniture 10800 1.8867924528301885
2025-08-18 Furniture 10900 0.92592592592593
2025-09-18 Furniture 11000 0.917431192660545
2025-10-18 Furniture 11100 0.9090909090909038
2025-11-18 Furniture 11300 1.8018018018018056
2025-12-18 Furniture 11400 0.8849557522123908
Part 3: Regional Performance Insights
I identified the top five states by order count and calculated their sales and average profit. Some states
consistently performed well while others had lower averages. Supporting strong regions and reviewing
pricing/logistics in weaker regions can help improve results.
Top 5 States Summary
State total_sales avg_profit order_count
Gujarat 21058 5.34482758620689727
Madhya Pradesh 105140 16.326470588235296101
Maharashtra 95348 21.2965517241379390
Page 3
Punjab 16786 -10.15 25
Rajasthan 21149 16.98648648648648832
Question 2 – App Exploration
I explored the Jar app to understand the experience from a user's point of view. The overall interface is
simple and well organized. What I liked: 1. The onboarding process is quick and smooth. 2. Saving
options like daily, weekly, and monthly are easy to use. 3. The home dashboard is clean and shows the
most important information. 4. Quick Save and Instant Save work smoothly without many steps. 5.
Rewards, streaks, and quests make the app more engaging. What can be improved: 1. Popups appear
often and interrupt the flow. 2. A short explanation of gold pricing would be helpful for new users. 3.
Users should have better control over notification frequency. 4. Some features could use small one line
descriptions. 5. Slight improvements in loading speed would improve the experience. Overall, the app
feels simple and helps users build a saving habit easily, with a few small areas that could be refined.
Page 4