🚴‍♂️ Adventure Works Cycle | Data Analytics Project

This project focuses on analyzing the sales and performance data of Adventure Works Cycle, a fictional bicycle company. The goal was to extract meaningful business insights that help in strategic decision-making using four key tools.

---

🛠️ Tools Used

Tool	Purpose
MySQL	Data extraction and transformation
Excel	Data cleaning, pivot tables, and EDA
Power BI	Dashboard creation and insights
Tableau	Advanced data visualization

---

🎯 Problem Statement

Adventure Works wants to:

• Understand regional and product-based sales performance
• Identify high-performing product categories and customer segments
• Track profit margins and sales trends over time
• Discover potential areas for business growth

---

🔍 Project Objectives

• Perform sales trend analysis across years
• Analyze profit and cost variations by product
• Segment customer demographics and purchasing behavior
• Create interactive dashboards for decision-making

---

📊 Key Insights

• Top Regions: North America contributes ~60% of total revenue.
• Bestselling Category: Mountain Bikes lead with the highest sales and profit margins.
• Customer Segment: Majority of high-value purchases are made by professionals aged 35–50.
• Seasonality: Sales spike in Q4 due to holiday demand.

---

📈 Approach

1. Data Collection: Extracted Adventure Works dataset from SQL Server
2. Cleaning & Preprocessing: Used Excel and MySQL to clean missing or inconsistent data
3. Exploratory Analysis:
   • Pivot tables & charts in Excel
   • SQL queries for deep-dive analytics
4. Visualization:
   • Created dashboards in Power BI and Tableau
   • Used slicers, filters, and DAX in Power BI for interactivity

---

📎 Project Structure

📁 AdventureWorks-Analytics/

│

├── 📂 MySQL Queries/

│ └── sales_analysis_queries.sql

├── 📂 Excel EDA/

│ └── sales_eda.xlsx

├── 📂 Power BI/

│ └── AdventureWorksDashboard.pbix

├── 📂 Tableau/

│ └── AdventureWorks.twb

└── README.md

---

🔗 Dashboard Links

• 🔗 Power BI Dashboard
• 🔗 Power BI Dashboard
• 🔗 Tableau Visualization
• 🔗 Tableau Visualization

---

📌 Conclusion

This project provided a complete end-to-end analysis pipeline — from raw data to dashboards. By leveraging multiple tools, we delivered actionable insights that would help Adventure Works optimize product strategies, marketing campaigns, and supply chain decisions.

“Turning data into insights, and insights into action.”

---

📫 Let's Connect

✍ Author

• ✍ Aman Banothe
• 📧 Email: [email protected]
• 💼 LinkedIn: Aman Banothe