AmrHashem607/Vodafone-Egypt-SQL-Power-BI

Vodafone Egypt # Vodafone Egypt Data Analytics Project ## Project Overview A complete Data Analytics and Business Intelligence project based on a Vodafone Egypt-inspired telecom dataset. The project focuses on transforming raw data into meaningful business insights using SQL Server and Power BI. ## Project Objectives - Analyze customer behavior - Monitor revenue performance - Analyze data, voice and SMS usage - Evaluate network performance - Analyze customer churn - Identify business opportunities - Provide actionable recommendations ## Dashboard Pages ### 1. Executive Overview Provides a high-level overview of business performance including: - Total Revenue - Total Customers - ARPU - Churn Rate - Total Transactions - Revenue by Channel - Revenue by Plan - Revenue by Governorate ### 2. Customer Insights Analyzes: - Active Customers - New Customers - Customer Growth - Customer Tenure - Customer Gender - Plan Type - Top Customers by Revenue ### 3. Revenue & Usage Analysis Analyzes: - Revenue - Data Usage - Voice Minutes - SMS - Usage by Plan - Revenue vs Customer Count - Revenue & Usage relationships ### 4. Network Performance Analyzes: - Network Rating - Downtime - Dropped Calls - Network Availability - Network Rating by Governorate - Network Performance by Technology - Site Performance ### 5. Business Insights Converts analytical findings into: - Key Business Insights - Customer Retention Opportunities - Network Optimization Opportunities - Revenue Opportunities - Business Recommendations ## Tools & Technologies - SQL Server - Power BI - DAX - Power Query - Data Modeling ## Project Workflow Raw Data ↓ Data Cleaning ↓ SQL Analysis ↓ Data Modeling ↓ Power BI ↓ DAX Measures ↓ Dashboard ↓ Business Insights ## Key Skills Demonstrated - Data Cleaning - SQL Analysis - Data Modeling - DAX - Power BI - Data Visualization - Business Intelligence - Business Analysis - Data Storytelling