This project presents an advanced interactive Excel dashboard built to analyze and visualize key sales and operational KPIs for Telecom Egypt across seven major regional brands. The solution provides deep insights into brand-level performance segmented by product category, region, and achievement against sales targets.

Objective
To deliver a dynamic and visual data representation of Telecom Egypt's regional sales performance using Excel dashboards and advanced DAX functions.

Dashboard Features

• 📍 Regional store evaluation

• 📶 Product-wise segmentation: Mobile, ADSL, Postpaid, and Fixed

• 📈 Target vs. Achievement breakdown

• 🎯 Interactive slicers for filtering KPIs

• 📌 Centralized overview in the Main Dashboard

• 📄 Separate detailed analysis for each region (7 individual sheets)

  ---

Telecom Egypt operates across diverse regions with varied performance metrics. This dashboard enables:

• Strategic decision-making at the regional and store level
• Easy tracking of achievement vs. targets across key service lines
• Visual identification of high-performing vs. underperforming areas

The central dashboard gives a consolidated view of the following seven key brands:

1. ميدان الخضروات - المصريين
2. حي الكويت
3. من دمياط - دمينس
4. قنا - جنوب سيناء
5. الزقازيق الشرقي
6. التل الكبير
7. ميدان المنصورة - المصريين

Each brand/region has a dedicated visual page for deep analysis.

• 📊 KPIs Tracked:
  • Fixed Line Achievements (Fixed ACH vs TGT)
  • ADSL Achievements (ADSL ACH vs TGT)
  • Postpaid (Post ACH & TGT)
  • Mobile Achievements (ACH & TGT)

• Aggregated sales and operational KPIs by brand, region, and product category.
• Data sources include store-level reports and regional sales sheets.

• Removed duplicates and null entries
• Standardized brand names and formats
• Converted target/achievement values to consistent numerical formats
• Mapped product category labels across sheets

• Used formulas like SUMIFS, IFERROR, and VLOOKUP for consolidation
• Created derived columns for Achievement Rate = (ACH / TGT)
• Structured Excel tables for slicer compatibility

• Designed individual dashboards for each brand/region
• Centralized the core KPIs in a Main Dashboard
• Interactive slicers for dynamic filtering
• Conditional formatting to highlight performance gaps

✅ Region-wise brand performance
✅ Product-level segmentation
✅ Achievement vs. Target variance
✅ Interactive slicers by product & region
✅ Drill-down dashboards for detailed analysis
✅ Heat indicators using color-coded visuals
✅ Side-by-side comparison across multiple zones

• IF, VLOOKUP, SUMIFS, INDEX-MATCH
• Dynamic slicers using Excel Tables
• Conditional formatting for KPI indicators
• Pivot Charts with slicer integration
• Custom DAX measures in Power Pivot

📦 telecom-egypt-brand-performance-dashboard/
├── 📊 Dashboard.png           # Main consolidated dashboard (7 brands)
├── 📄 Sheet 3.png             # Brand Dashboard - حي الكويت
├── 📄 Sheet 5.png             # Brand Dashboard - من دمياط - دمينس
├── 📄 Sheet 6.png             # Brand Dashboard - قنا - جنوب سيناء
├── 📄 Sheet X.png             # (Additional sheets for remaining brands)
├── 📈 Excel_File.xlsx         # Full interactive dashboard (optional upload)
├── 📜 README.md               # Project overview and documentation
# 📊 Telecom Egypt Brand Performance Dashboard

---
This project presents an advanced **interactive Excel dashboard** built to analyze and visualize key sales and operational KPIs for **Telecom Egypt** across **seven major regional brands**. The solution provides deep insights into brand-level performance segmented by product category, region, and achievement against sales targets.