mohmaednasser/Egypt-Car-Accidents-Analysis

This project analyzes car accidents in Egypt using Excel and Power BI, with Python used for prediction and forecasting. It focuses on understanding injuries, deaths, and trends to provide insights for road safety. # 🚗 Egypt Car Accidents Analysis (2022 – 2024) ### Power BI • Excel • Python • SQL • VS --- # 📌 Project Description This project analyzes car accidents in Egypt from **2022 to 2024** using real datasets collected from the official website of the **Central Agency for Public Mobilization and Statistics (CAPMAS)**. The project focuses on analyzing: - Accident trends - Injuries and deaths - Emergency statistics - Road safety patterns The project also includes forecasting models using Python to predict future accident trends and support data-driven decision-making. --- # 🎯 Project Objective - Analyze car accident statistics in Egypt between 2022 and 2024 - Identify trends in injuries and deaths - Compare accident categories and patterns - Discover insights related to: - Gender - Age groups - Vehicle types - Road types - Monthly statistics - Build interactive dashboards for storytelling and visualization - Predict future accident trends using Machine Learning --- # 📂 Project Resources | Resource | Link | |---|---| | Google Drive Folder | Open Project Files | --- # 🛠️ Tools & Technologies | Tool | Purpose | |---|---| | Excel | Data storage and organization | | Power BI | Data cleaning, transformation, analysis, and dashboards | | Python | Forecasting & Machine Learning | | SQL | Database Implementation | | VS | Application Development | | Figma | Dashboard UI/UX Design | | Adobe Photoshop | Editing icons and dashboard assets | | PowerPoint | Presentation & Storytelling | --- # ⚙️ Project Workflow ```mermaid graph TD A[📥 Data Collection] --> B[🔍 Data Understanding] B --> C[🧹 Data Cleaning & ETL] C --> D[🔗 Data Merging] D --> E[📐 Data Preparation & Analysis] E --> F[🎨 Dashboard Design] F --> G[📊 Dashboard Development] G --> H[🤖 Forecasting & Machine Learning] H --> I[📖 Presentation & Storytelling] ``` --- # 📥 Data Collection - Collected datasets from the official CAPMAS website - Gathered: - 3 PDF reports (2022, 2023, 2024) - Population datasets for t …