In this project, we are using a bike shop dataset from Kaggle that contains 6 years of data. The main objectives are to clean the data, perform exploratory analysis to understand the business and uncover key insights, and then propose analytical business solutions, including two interactive dashboards and one custom app. This will help the bike shop make better-informed decisions and improve overall business performance.

The bike shop is unsure how to utilize the data collected over the past few years and seeks a way to easily access and understand it.

• Conduct Exploratory Data Analysis (EDA): Uncover key insights from the data.
• Create Two Interactive Dashboards: Provide real-time data visualization.
• Develop a Custom App: Facilitate ongoing data monitoring and decision support.

Act as business analyst consultants to analyze the data and propose solutions for better business understanding and data-driven decision-making. The aim is to enhance the bike shop's ability to make informed decisions and improve overall business performance.

Columns:

• Date: The date of the sale.
• Day: The day of the month when the sale occurred.
• Month: The month when the sale occurred.
• Year: The year when the sale occurred.
• Customer_Age: Age of the customer.
• Age_Group: Age group classification of the customer.
• Customer_Gender: Gender of the customer.
• Country: Country where the sale took place.
• State: State where the sale took place.
• Product_Category: Category of the product sold.
• Sub_Category: Sub-category of the product sold.
• Product: Specific product sold.
• Order_Quantity: Number of units ordered.
• Unit_Cost: Cost per unit of the product.
• Unit_Price: Selling price per unit of the product.
• Profit: Profit from the sale.
• Cost: Total cost of the sale.
• Revenue: Total revenue from the sale.

• 🚴‍♂️ Bikes (Road, Mountain, Touring)
• ⚙️ Accessories (Tubes, Tires, Helmets, Bike Racks, Bottles, etc.)
• 👕 Clothing (Shorts, Vests, Caps, Gloves, Jerseys, etc.)

• 70% of revenue comes from bike sales.
• Road bikes account for 54% of bike revenue.

• Total Revenue (2011-2016): $84.8M.
• Compound Annual Growth Rate (CAGR): 13.2%, showing strong growth.

• Peak Sales: June & December (pre-summer, holiday demand).
• Lowest Sales: July.
• Top Export Markets: U.S., Australia, UK, Germany, France.