🚲 Citi Bike Data Analysis — Internship Project

A data analysis project exploring Citi Bike ridership patterns, conducted as part of a data analysis internship. This repository contains the raw analysis workbook and the final presentation summarizing key findings.

---

📁 Repository Contents

File	Description
Data analysis.xlsx	Excel workbook containing raw data, cleaned datasets, pivot tables, and charts used in the analysis
Citi Bike Final Presentation.pptx	PowerPoint presentation summarizing insights, visualizations, and recommendations

---

📊 Project Overview

This project analyzes Citi Bike trip data to uncover trends and patterns in urban bike-sharing usage. The analysis aims to provide actionable insights into:

• Ridership trends — peak usage hours, days, and seasons
• Station performance — most and least popular start/end stations
• User behavior — trip duration, frequency, and subscriber vs. casual rider comparisons
• Operational insights — data-driven recommendations for fleet and station management

---

🛠️ Tools Used

• Microsoft Excel — data cleaning, pivot tables, and charts
• Microsoft PowerPoint — final presentation and data storytelling

---

🔍 Key Findings

(Summary of highlights from the analysis — update with your actual findings)

• Identified peak commuting hours and high-demand stations
• Compared usage patterns between annual subscribers and casual riders
• Highlighted seasonal ridership fluctuations
• Proposed station rebalancing and expansion recommendations based on the data

---

🚀 How to Use

1. Clone the repository:

   git clone https://github.com/mdsajid2003/Data-Analysis.git

2. Open Data analysis.xlsx in Microsoft Excel (2016 or later recommended) to explore the data and charts.
3. Open Citi Bike Final Presentation.pptx in PowerPoint or Google Slides to view the final report.

📄 License

This project is for educational and internship purposes.