Robbin's Bikes & Accessories

Hi DataFam,

It's been a while since I posted about my data analytics progress. I just concluded another sales report of a fictitious company called "Robbin's Bikes & Accessories".

Tools used: Power BI and Excel

SUMMARY:

Robbin's Bikes and Accessories is the world’s largest manufacturer and distributor of Bikes, clothing, and accessories, with over 2,000 retail stores across different countries worldwide.

As a global leader, it is looking towards a more customer-centric approach in order to increase sales and remain profitable in a competitive market.

The report gives insight into the company's customers and its sales over a 3-year period (2015 -2017).

KEY FINDINGS:

1. Most of the revenue generated in Robbin's Bike & Accessories came from customers who:

a. Were female ($149.96 million) b. Lived in the United States ($101.74 million), c. Worked in a professional capacity ($103.6 million), d. Had a Bachelor's degree ($98.6 million)

2. The highest revenue was generated from the sale of Bikes ($215.4 million), followed by accessories ($76.69 million).

3. Within the 3 year period (2015 - 2017), the company's revenue steadily increased over time from $43.2 million in 2015 to $129.9 million in 2017.

4. Highest revenue was generated in the 2nd quarter of the year ($97.8 million), with June being the most profitable month within that quarter ($16.7 million).

5. The company had some products returned (especially bikes) to the tune of $765.27 thousand, but this did not adversely affect sales or profit.

6. The overall profit margin was above average (58.8%)

7. The least revenue was generated by Canada ($26.58 million), followed by France ($28.45 million).

8. Even though the company has 4 product categories (Bikes, Accessories, Clothing, and Components), it did not sell component parts within the period under review.

9. The lowest revenue was generated by customers with a high school degree ($673.65), followed by those with a partial college degree ($4,355.88)

RECOMMENDATIONS:

1. The company should conduct further research into the drivers of low sales in Canada and France and replicate the marketing/sales strategies that have been found to be successful in the US, in these low-revenue generating countries.

2. Product education and promotion campaigns and marketing efforts should be focused on customers with low educational levels (e.g. partial college and high school degree holders).

3. Customer review and satisfaction surveys should be carried out to find out the reason(s) why some products were returned. Findings from this survey could prove beneficial to improving sales.

4. The company should set up an incentive-based loyalty system to reward top-revenue-generating customers. Social media channels could be used to promote this loyalty system. This would encourage healthy competition among customers and boost overall sales in the long run.

Feel free to interact with the live report here: http://bit.ly/40nlDgh

#welupdigital