SQL and

Databases
P R O J E C T R E P O RT

New Wheels
Quarterly business report
NEW WHEELS MANAGEMENT INFORMATION REPORT BY : MANGAIYARKARASI . V
 Business Overview

% of Good
Feedback

82 %

NEW WHEELS MANAGEMENT INFORMATION REPORT BY : MANGAIYARKARASI . V

 Customer Metrics

NEW WHEELS MANAGEMENT INFORMATION REPORT BY : MANGAIYARKARASI . V

 Distribution of customer across States

Observations / Findings
• The 36.7 % of Customer distribution seem to be concentrated in the top 3 states California,
Texas and Florida
• The 55.7% of customer distribution are with Moderate customer dense state, they hold less
than 30 customers each state but they do have effective contribution to customer base.
• Low density customer state are with less than 10 customer They contribute 9 % of total Customer density plot, on state with
customer base high, moderate and low density

NEW WHEELS MANAGEMENT INFORMATION REPORT BY : MANGAIYARKARASI . V

 Average customer rating by quarter
Customer 1st 2nd 3rd 4th Grand
Feedback Quarter Quarter Quarter Quarter Total
Very Good 93 75 38 20 226
Good 89 58 48 20 215
Okay 59 53 50 40 202
Bad 35 37 52 58 182
Very Bad 34 39 41 61 175
Grand
Total 310 262 229 199 1000

Observations / Findings

• The Average rating was max at 3.5 which was in the first quarter of the year
• There is clear trend of decrease in average rating of customer in 2 nd, 3rd, and 4th quarter
• Decrease in customer count is also evident from 1 st to 4th quarter - reduced from 310 to 199 in customer count
• 30% of customer's : 93 out of 310 customer had rated VERY GOOD in 1 st Quarter
• 31% of customers : 61 out of 199 customer had rated VERY BAD in 4 th Quarter

NEW WHEELS MANAGEMENT INFORMATION REPORT BY : MANGAIYARKARASI . V

 Trend of customer satisfaction

1st 2nd 3rd 4th

Customer Quarte Quarte Quarte Quarte
Rating r r r r
Very
Good 30% 29% 17% 10%
Good 29% 22% 21% 10%
Okay 19% 20% 22% 20%
Bad 11% 14% 23% 29%
Very Bad 11% 15% 18% 31%
Observations / Findings
• Customer rating wise stacked bar for each quarter is shown – yearly overall customer satisfaction is good to 85%, and equally bad to 74%
• The blue stack for 1st Quarter shows VERY GOOD 30% is max feedback and VERY BAD 11% is minimal
• The red stack for 2nd Quarter shows a decreasing trend good feedback and increased trend in bad feed backs compared to 1 st quarter
• The yellow stack for 3rd quarter show drastic decrease in VERY GOOD , drastic increase in BAD feedback compared to 2 nd quarter
• The green stack for 4th quarter shows a drastic decrease in good feedback and Sharpe increase in BAD feedbacks compared to 3 rd quarter.
• This explicitly shows the customer drop is not reason for the good feedback drop. There is actual noticeable customer dis-satisfaction which gradually
happened in 2nd and 3rd quarter and much high in the 4th quarter

NEW WHEELS MANAGEMENT INFORMATION REPORT BY : MANGAIYARKARASI . V

 Top vehicle makers preferred
by customers

Observations / Findings
• CHEVROLET, FORD & TOYOTA are best car brands preferred by customers
• DODGE, PONTIAC, MERCEDES_BENZ and MAZDA are the 2 nd set of TOP brands
• VOLVO, AUDI, SUZUKI, SUBARU & HONDA are only 1/3 preference compared to TOP 3 brands

NEW WHEELS MANAGEMENT INFORMATION REPORT BY : MANGAIYARKARASI . V

 Most Preferred vehicle makers in each
state

Observations / Findings
• There are 49 states in customer base and for each state the best vehicle maker in each state is shown in table above
• Please note there are states with equal sales of one or many vehicle makers ,in such case - only one vehicle maker is displayed for
each state.

NEW WHEELS MANAGEMENT INFORMATION REPORT BY : MANGAIYARKARASI . V

 Revenue Metrics

NEW WHEELS MANAGEMENT INFORMATION REPORT BY : MANGAIYARKARASI . V

 Trend of Purchases by Quarter
of the year

Observations / Findings
• Number of orders had decreased from 310 to 199 from 1st to 4th quarter
• Number of vehicles purchased had decreased from 464 to 306 from 1 st to 4th quarter

NEW WHEELS MANAGEMENT INFORMATION REPORT BY : MANGAIYARKARASI . V

 Quarter on Quarter % change in
Revenue Quarter of QoQ Growth
Year Percentage Trend 🔻🔺
2nd Quarter -17.01% 🔻
3rd Quarter -10.66% 🔻
4th Quarter -20.13% 🔻

Observations / Findings
• The total annual revenue 124.74 million is contributed max at the 1 st quarter if the year with 39.42 million
• In the 2nd quarter the revenue had reduced by 6.7 Million which is reflecting as negative QoQ growth percentage as -17 %
• In the 3rd quarter the revenue had reduced by 3.5 Million which is reflecting as negative QoQ growth percentage as -10.6 %
• In the 4th quarter the revenue had reduced by 5.8 Million which is reflecting as negative QoQ growth percentage as -20 %
• On over all from 1st to last quarter there is 40.7 % drop in growth percentage

NEW WHEELS MANAGEMENT INFORMATION REPORT BY : MANGAIYARKARASI . V

 Trend of Purchases by Quarter
of the year

Total Number of Order

Revenue in Million

Observations / Findings
• The order revenue had dropped form 39.4 M to 23.35 M in 4th quarter as compared to the 1st quarter
• The reason is clearly evident shown by the order trend also had reduced gradually to low from 1 st to 4th quarter

NEW WHEELS MANAGEMENT INFORMATION REPORT BY : MANGAIYARKARASI . V

 Shipping Metrics

NEW WHEELS MANAGEMENT INFORMATION REPORT BY : MANGAIYARKARASI . V

 Average discount offered by
credit card type
Observations / Findings

• LASER card type had highest

discount of 0.644%
• The DINERS-
CLUB_INTERNATIONAL card has
the least discount of 0.584%
• 16 Credit card types can avail
discount price during vehicle
purchase

NEW WHEELS MANAGEMENT INFORMATION REPORT BY : MANGAIYARKARASI . V

 Time taken to ship order by every
Quarter of the year
Observations / Findings

• The shipping time in the first

quarter was super good with in
57 days on average
• But by 4th quarter the shipping
time has been more than triple
the 57 days, which is 174 solid
days
• There seem to be drastic delay
average shipping time during 3rd
quarter of the year

NEW WHEELS MANAGEMENT INFORMATION REPORT BY : MANGAIYARKARASI . V

 CONCLUSIONS
&
RECOMMENDATIONS

NEW WHEELS MANAGEMENT INFORMATION REPORT BY : MANGAIYARKARASI . V

 Insights and Recommendations
REVENUE related insights :
CUSTOMER base related insights :
• Revenue had shown gradual declined trend through the
year from start to end.
• The customer base is not evenly distributed among
• There is heavy drop in portfolio to 20% which may be
the states.
due to loss in customer retentions, customer dis-
• Moderate and Low dense customer - states need
satisfaction and shipping delays.
better marketing strategy to improve Clientele.
• This trend should be watched to avoid risk of loss and
• The trend in customer rating has shown clear
sustainable revenue returns.
decrease which is much sensitive and need
immediate investigate for customer retention.
• The customer rating decline factors should be Shipping related insights :
identified and restored to betterment at the earliest.
• The Shipping delay had gone very high in 4th quarter,
with gradual delay trend in 2nd and 3rd quarter.
• The shipping delay need early fix, with new strategy
and planning to delivery to the best early possible.

NEW WHEELS MANAGEMENT INFORMATION REPORT BY : MANGAIYARKARASI . V