Aliaa-Nasser/Egypt-Weather-Analytics

# 🌤️ Egypt Weather Analytics & Predictive System An interactive Power BI Dashboard and Predictive Analysis project evaluating weather patterns across 6 Egyptian Governorates (Cairo, Giza, Alexandria, Minya, Luxor, Aswan). Developed as part of the **National Telecommunication Institute (NTI)** training program, receiving full marks and top honors at the final defense. --- ## 📊 Dashboard Preview & Screenshots ### 1. Welcome Page (صفحة الترحيب) ### 2. Executive Climate Overview (نظرة عامة على المناخ) ### 3. Seasonal & Temporal Analysis (التحليل الموسمي والزمني) ### 4. Sector Impact Analysis (تحليل الأثر على القطاعات) ### 5. Machine Learning & Forecasting (التعلم الآلي والتنبؤات) --- ## 📌 Project Description ### 📝 Short Summary A comprehensive Weather Analytics and Forecasting System evaluating climate trends across **6 key Egyptian Governorates** (Cairo, Giza, Alexandria, Minya, Luxor, Aswan). The project integrates data collection, advanced SQL transformations, interactive Power BI visualizations, and Machine Learning predictive models to forecast environmental metrics and assess sector-specific impacts. --- ### 🔑 Key Features & Highlights * **Multi-Regional Climate Analysis:** Analyzed historical weather data across 6 diverse Egyptian governorates to identify regional climate variations and environmental trends. * **Predictive Forecasting (Machine Learning):** Built ML models using Python to forecast future weather metrics (temperature variations, precipitation patterns, and humidity levels) for actionable decision-making. * **Interactive Power BI Dashboards:** Designed a multi-page interactive dashboard (including Executive Summary, Temporal Trends, Sector Impact, and Regional Breakdown) featuring custom bookmarks, dynamic slicers, and seamless navigation. * **Data Engineering & ETL:** Automated data extraction, cleaned complex environmental datasets, and optimized database queries using SQL Server for smooth dashboard integration. * **Sector Imp …