DASHBOARD ANALYTICAL INTELLIGENCE

Power BI Dashboard Deep-Dive

Examine the core analysis and actual data distributions behind the three main pages of our waste management framework.

76.3k
Avg Governorate MSW

Average Municipal Solid Waste generated per month in tons per governorate.

Cairo
Highest MSW Producer

Cairo Governorate generates the largest waste volume at 279.7k tons monthly.

55.8%
Organic Waste Fraction

Organic matter remains the single largest constituent of municipal waste in Egypt.

15.96%
Mean Recycling Rate

The historical baseline average recycling rate recorded in observational datasets.

Interactive Egypt Governorate Map

Click any governorate to view its waste analytics

Mediterranean Sea Matrouh Alexandria Beheira K.Sheikh Gharbia Damietta Dakahlia Monufia Qalyubia Sharqia P.Said Ismailia N. Sinai Cairo Giza Suez S. Sinai Faiyum B.Suef Red Sea New Valley Minya Asyut Sohag Qena Luxor Aswan RECYCLING RATE Low (8-11%) Mid (12-16%) High (17-19%)
Cairo Greater Cairo
Monthly Waste
279.8k tons
Recycling Rate
17.8%
Coverage
66.3%
Population
10.1M

Top 10 Governorates by Monthly MSW Generation

Aggregated mean municipal solid waste generation rate (Tons/Month)

Municipal Solid Waste Composition

National average fractions based on observational waste studies

66.3%
Cairo Coverage Peak

Greater Cairo features the highest collection coverage rate in Egypt.

36.0%
Lowest Regional Coverage

The Delta Region exhibits the lowest waste collection coverage at 36.01%.

12.9%
Plastic Fraction

Plastics form the second-largest portion, presenting high-ROI sorting potential.

High
Investment Priority

Assessing high-volume, low-coverage regions for commercial sorting plants.

Targeting Strategic Investments

This dashboard sheet prioritizes commercial viability, focusing on where collection infrastructure and dry recyclable volumes overlap to maximize potential recycling ROI.

Key Investment Insights:

  • Dry Recyclable Volume: Cairo and Giza generate over 500k tons of waste combined monthly, making them the priority locations for modern material recovery facilities (MRFs).
  • Infrastructure Gap: Delta and Upper Egypt regions have huge generation volumes but suffer from low collection coverage (~36%). Investing in municipal collection networks here provides the largest social and environmental returns.

Waste Collection Coverage by Region

Average collection coverage rate (%) across major Egyptian planning regions

Strong
Coverage-Recycling Link

Regions with higher collection coverage rates exhibit direct increases in recycling success.

$3.7k
Avg GDP per Capita

Economic metrics strongly correlate with plastic and paper ratios in urban centers.

1,620
Data Points Analyzed

5-year time series across 27 governorates processed via Power Query.

Star
Data Schema Model

Uses relationships between Governorates, Regions, and Time dimensions.

Bivariate & Statistical Modeling

The final dashboard sheet investigates causal relationships. Our star schema model links economic development, municipal infrastructure, and recycling performance.

Key Research Discoveries:

  • The Collection Trap: Regions with low collection coverage face depressed formal recycling rates because raw materials never enter formal waste processing facilities.
  • Income Effects: Areas with higher GDP per capita yield significantly higher plastic and packaging fractions, shifting processing requirements from composting toward material sorting and recovery.

Recycling Rate vs. Waste Collection Coverage

Regional alignment showing the impact of collection infrastructure on recycling outcomes