XafsaCiise/somalia-food-security-ipc-2026

End-to-end humanitarian data analysis of Somalia's food security crisis using PostgreSQL and Power BI — IPC 2026 # Somalia Food Security Crisis — IPC 2026 Analysis **Tools:** PostgreSQL · Power BI · DAX · Excel **Data Source:** WFP / FSNAU IPC Somalia 2026 **Author:** Hafsa Isa --- ## Somali Summary Mashruucani wuxuu baarayaa xaaladda amniga cuntada ee Soomaaliya sanadka 2026, xogta waxaan ka keenay WFP iyo IPC. Xogta asalka ah waxaa ku jiray khaladaad keenaya in isku darka tira koobku dhawr jeer labo jibbaarmo . Waxaan nadiifiyay xogta anigoo adeegsanaya "PostgreSQL", ka dibna ku dhisay dashboard Power BI ah oo muujinaya xaaladda 107(zone) aag ee degmo walba. Aag kasta wuxuu leeyahay ilaa 7 ROW oo ku saabsan heerarka IPC — Phase 1 ilaa Phase 5 — sidaas darteed 749 saf(ROW) ayaa xogta ku jira oo idil. **Natiijooyink muhiimka ah ee aan heelay :** - 1 ka mid ah 3-dii Soomaali ah ayaa ku jira xaalad amni cunto oo khatar ah ama ka sii dareysa. - 6 milyan oo qof ayaa ku jira Phase 3 iyo wixii ka sareeya. - 1.9 milyan ayaa ku jira xaalad degdega oo in cunto lala gaaro ay tahay (Emergency/Famine) - Degmada ugu daran, xaga tirooyinka: Banadir Urban IDPs, Muqdisho — 166,391 kun oo qof - Degmada ugu daran , xaga boqolleyda : Sanaag iyo Sool — 65% dadkooda ayaa xaalad khatar ah ku jira ## Project Overview This project analyses the WFP Somalia IPC 2026 food security dataset to identify where food insecurity is most severe across Somalia's 107 livelihood zones. The raw data contained structural issues causing double counting in aggregations. I cleaned the dataset using PostgreSQL, validated findings against SQL analytical queries, and rebuilt an interactive Power BI dashboard from the clean data. **The central question:** Where are Somalis most at risk, and how severe is the crisis? --- ## Key Findings | Finding | Value | |---------|-------| | Total population assessed | 19 million | | People in Crisis or worse (Phase 3+) | 6 million (31%) | | People in Emergency or Famine (Phase 4+5) | 1.9 million (10%) | | Worst affected area by absolute numbers | Banadir Urban IDPs, Moga …