Takaitaccen Bayani game da Aiki

Manufa

Don samar da fahimtar yanayi a lokaci guda game da tasirin rudewar kudade ta duniya na 2025 ga ma'aikatan bangaren agaji. Wannan aikin ya wuce shaidar baka, yana amfani da bayanai don bin diddigin yadda rage kudade da umarnin "USAID na dakatar da aiki" ke haifar da dakatarwar daukar ma'aikata da kuma raguwar kasuwa.

Mafita

Wani Metabase dashboard da aka sanya a kan sabobin mu (self-hosted) wanda ke gudanar da tattarawa da nuna bayanai game da kasuwar ayyuka ta atomatik. Ta hanyar kiyaye tsarin bayanai mai zaman kansa, aikin yana tabbatar da cewa ana adana bayanan tarihi duk da canje-canjen dandamali na waje, wanda ke ba da damar yin nazarin dogon lokaci na "Babban Rudewar Agaji."

Manufafi Masu Muhimmanci

• Auna Gibin Kudi: Danganta raguwar sanarwar ayyuka a ReliefWeb da manyan matakan kudade na 2025 (misali, dakatarwar biyan kuɗi ta USAID a watan Fabrairu 2025).
• Bayyanuwar Aiki: Samar da ma'ajin buɗe ido na duk tambayoyin SQL da aka yi amfani da su don sarrafa bayanan, yana gayyaci bita daga al'ummar IM ta bangaren agaji.
• Alhakin Jama'a: Sanya sassan Metabase na jama'a wanda ke ba da damar masu ruwa da tsaki su ga farashin da rage kasafin kudi ke haifarwa ga mutane a lokaci guda.

Babban Fahimta da Fassarar Su

1. Tsarin "Rage Aiki" Bayanai sun nuna raguwa daidai gwargwado a duk nau'ikan mukamai. Ayyuka masu mahimmanci kamar Gudanar da Ayyuka da Aikeci suna kiyaye matsayinsu na dangi duk da raguwar lambobi. Wannan yana nuna cewa kungiyoyi suna aiwatar da rage aiki mai faɗi wanda ba na dabaru ba maimakon canje-canjen tsari—suna amfani da ƙwarewarsu a "dabarun fita" a kan nasu ayyuka.
2. Canji Zuwa Shawarwari (Consultancies) Yayin da sanarwar ayyuka na dindindin suka kasance a cikin raguwa mai ci gaba tun daga Fabrairu 2025, shawarwari na gajeren lokaci sun kasance kwanciyar hankali. Wannan yana nuna canjin kasuwa: kungiyoyi suna rage haɗari ta hanyar fifikon kwangiloli masu sassauci da ƙananan kuɗaɗen gudanarwa akan alƙawarin ma'aikata na dogon lokaci.

Aiwarewar Fasaha

Tsarin Fasaha (The Stack)

• Tushen Bayanai: Shigarwa ta atomatik daga ReliefWeb API (karshen /jobs).
• Gudanarwa: n8n (An sanya a kan sabobin mu) yana gudanar da tsarin ETL (Cirewa, Canzawa, Saka) na yau da kullum.
• Bincike: Metabase (An sanya a kan sabobin mu) don nuna bayanai da dashboard na jama'a.
• Tushen Bayanai: PostgreSQL don adanawa mai saurin gudu da tambayoyin SQL masu sarƙaƙiya.

Babban Abin Fasaha: Magance Gurɓataccen Bayanai

Kalubale: Tambayoyin kalanda na yau da kullum na "Makon Jiya" ko "Wannan Mako" suna gurɓata alkiblar trends a farkon mako. Misali, gudanar da rahoto a ranar Talata yana nuna "faduwa" na ƙarya a lambobi saboda makon kalanda ya fara kawai.

Magani: An aiwatar da dabarar Jimlar Kwanaki 7 Masu Ninkawa a cikin SQL. Wannan yana watsar da makonni na kalanda don samar da layin alkibla mai santsi da inganci na saurin kasuwa bisa ga awanni 168 na ƙarshe, yana tabbatar da inganci ba komai lokacin da mai amfani ya kalli dashboard.

Lokaci da Abubuwan Da Za A Kai

Manyan Matakan

• Mataki na 1: Haɗin API da ƙirar Schema (Danganta career_categories na ReliefWeb da tushen bayanai).
• Mataki na 2: Haɓaka Logik na SQL (Gina tambayoyin Jimlar Kwanaki 7 Masu Ninkawa da rabon Shawarwari-da-Ma'aikata).
• Mataki na 3: Dashboard na Metabase (Ƙirƙirar labarin gani na rudewar kudade ta 2025).
• Mataki na 4: Sanya Buɗe Ido (Bugawa da takaddun bayanai da rubutun SQL a GitHub).

Abubuwan Karshe Da Za A Kai

• Dashboard na Metabase Mai Aiki: Hanyar haɗi ta jama'a zuwa alkiblar daukar ma'aikata ta lokaci guda.
• Tsarin SQL: Ma'ajin GitHub da ke ɗauke da logik na aikin.
• Jagorar Fasaha: Takaddun bayanai game da sanya wannan tsarin IM na agaji mai zaman kansa ta hanyar Docker.