Xogta iyo database-yada

Waxa guddiyadu raadiyaan

• Excel waqti cidhiidhi ah: nadiifi xaashi qasan, samee pivot table, isticmaal XLOOKUP ama VLOOKUP, oo hubi wadarrada.
• Taxaddar tayada xogta: waxaad aragtaa xogta labanlaaban, meelaha bannaan, taariikhaha khaldan iyo qiimayaasha aan suurtoobin ka hor intaadan waxba falanqayn.
• Xirfadaha xogta sahanka: foom KoboToolbox ama ODK ah oo leh xaddidaad (constraints) iyo skip logic, iyo nadiifinta xogta ka soo laabata goobaha.
• In tirooyinka loo beddelo fariin cad: jaantus fudud iyo laba jumladood oo maareeyuhu ku dhaqmi karo.
• Ilaalinta xogta: xogta shakhsiga ah ee ka faa'iidaystayaasha, macaamiisha ama bukaannada oo la badbaadiyo, la wadaago oo keliya marka la oggol yahay, lagana saaro warbixinnada.
• Daacadnimo tirooyinka: waxaad sheegtaa waxa xogtu muujinayso, xitaa marka ay barnaamijka niyad-jabiso.

Su'aalaha ay weydiiyaan

1. 1“Xogta sahanka ee shan degmo kuma habboona wadarrada warbixinnada goobaha. Maxaad samaynaysaa?”

   Sababta ay u weydiiyaan: Waxay tijaabinaysaa habkaaga tayada xogta, iyo inaad hesho sababta halkii aad tirooyinka wax ka beddeli lahayd si ay isugu ekaadaan.

   Sida looga jawaabo

   • Weligaa tirooyinka ha beddelin si ay isugu ekaadaan; hel meesha farqigu ka yimid.
   • Hubi xogta labanlaaban, gelinta tijaabada, foomamka aan la soo dirin (unsynced), koodhadhka degmada ee khaldan iyo muddada taariikhda.
   • Isbeddel kasta ku qor diiwaanka nadiifinta (cleaning log) oo la wadaag madaxa M&E.

   I wouldn't change any numbers to make them match. First I check for duplicates using the submission ID, and remove test entries made before the start date. Then I compare the forms per enumerator with what each team leader reported, because the gap is often forms still saved on a phone that hasn't synced. I also check district codes, since one wrong code moves a whole village. Every change goes in a cleaning log, which I share with the M&E lead.

2. 2“Maxay ku kala duwan yihiin VLOOKUP iyo XLOOKUP, maxaase lookup mararka qaar u soo celiyaa #N/A?”

   Sababta ay u weydiiyaan: Lookup-yadu waxay ku jiraan imtixaan xogeed kasta ku dhow. Waxay hubinayaan inaad fahantay oo aad hagaajin karto khaladaadka caadiga ah.

   Sida looga jawaabo

   • VLOOKUP wuxuu raadiyaa tiirka koowaad, wuxuuna soo celiyaa qiime midig ka xiga; isticmaal FALSE si uu u noqdo mid sax ah (exact match).
   • XLOOKUP jiho kasta wuu eegaa, si caadi ah wuxuu raadiyaa mid sax ah, wuxuuna muujin karaa fariin marka aan waxba la helin.
   • #N/A badanaa waxay ka dhigan tahay meelo bannaan oo dheeraad ah, higaad kala duwan, ama tirooyin qoraal ahaan loo kaydiyey.

3. 3“Sidee u naqshadayn lahayd foom KoboToolbox ama ODK ah si khaladaadka looga yareeyo meesha ay ka bilaabmaan?”

   Sababta ay u weydiiyaan: Foomam wanaagsan waxay badbaadiyaan maalmo nadiifin ah. Waxay hubinayaan inaad ka fikirto xog-ururiyaha goobta jooga, ee aanad falanqaynta oo keliya eegin.

   Sida looga jawaabo

   • Liisas doorasho ah halkii qoraal xor ah, iyo xaddidaad sida da' macquul ah.
   • Meelo qasab ah su'aalaha muhiimka ah iyo skip logic si dadku u arkaan oo keliya su'aalaha khuseeya.
   • Taariikh iyo GPS si toos ah loo qaado, iyo tijaabo goobeed oo xog-ururiyeyaasha lala sameeyo ka hor bilowga.

   I'd make most questions choice lists instead of free text, so we don't get ten spellings of one district. I add constraints, like age between 0 and 120, and make the key questions required. Skip logic hides questions that don't apply, so a household with no children never sees the school questions. The form records the date and GPS automatically. Before launch, I test it with two enumerators in the field for a day and fix whatever confuses them.

4. 4“Nooga sheekee dashboard ama warbixin aad dhistay. Yaa isticmaalay, go'aankee ayuuse taageeray?”

   Sababta ay u weydiiyaan: Waxay rabaan inay arkaan inaad wax u dhisto isticmaale iyo go'aan, ee aanad jaantusyo u samayn iyaga dartood.

   Sida looga jawaabo

   • Magacaw isticmaalaha iyo su'aasha uu dashboard-ku ka jawaabay.
   • Sheeg meesha xogtu ka timid iyo inta jeer ee la cusboonaysiin jiray.
   • Sheeg hal go'aan oo uu beddelay, iyo hal doorasho naqshadeed oo aad isticmaalaha u samaysay.

   At an INGO in Garowe I built a Power BI dashboard for the WASH team's monthly water-point monitoring. The data came from a KoboToolbox form and refreshed weekly. The main page showed which water points were not working, by district, and for how long. The programme manager used it in the monthly meeting to decide where to send the repair team first, instead of going by who called loudest. I kept it to one page, because the managers did not scroll.

5. 5“SQL-kee ayaad qori kartaa? Nala mari query tirinaya macaamiisha gobol kasta ee sannadkan.”

   Sababta ay u weydiiyaan: Shirkadaha isgaarsiinta, bangiyada iyo NGO-yada waaweyn xogta waxay ku hayaan database-yo. Waxay hubinayaan inaad adigu xogtaada soo saari karto caawimaad la'aan.

   Sida looga jawaabo

   • Tallaabo tallaabo u dhis: SELECT region iyo COUNT(*), FROM jadwalka macaamiisha.
   • WHERE taariikhda diiwaangelintu tahay sannadkan, GROUP BY region, ORDER BY tirada.
   • Xus JOIN haddii magaca gobolku jadwal kale ku jiro, oo si daacad ah u sheeg inta aad SQL isticmaashay.

6. 6“Maareeye ayaa kaa codsaday inaad liiska ka faa'iidaystayaasha, oo leh magacyo iyo lambarro taleefan, WhatsApp ugu dirto hay'ad la-shaqeeye ah. Maxaad samaynaysaa?”

   Sababta ay u weydiiyaan: Xogta ka faa'iidaystayaasha waxay dadka gelin kartaa khatar. Waxay hubinayaan garashadaada: heshiisyada, oggolaanshaha, xogta ugu yar ee loo baahan yahay iyo jid ammaan ah.

   Sida looga jawaabo

   • Hubi inuu jiro heshiis xog-wadaag ah iyo in dadku oggolaadeen in xogtooda la wadaago.
   • La wadaag oo keliya meelaha xogta ee la-shaqeeyuhu u baahan yahay, adigoo maraya jid la oggolaaday oo ilaalsan, ee ma aha WhatsApp.
   • Hel oggolaansho qoraal ah, haddii wax maqan yihiinna si edeb leh u sharax khatarta.

   I'd first check whether we have a data sharing agreement with that partner, and whether people agreed to their details being shared. If so, I'd send only the fields the partner needs, perhaps names and phone numbers for one district, not the household details. I'd use our organisation's approved file sharing with a password, not WhatsApp, and ask the manager to approve it in writing. If there is no agreement, I'd explain the risk politely and suggest we set one up first.

7. 7“Falanqayntaadu waxay muujinaysaa in barnaamijku gaadhin bartilmaameedkiisa. Sidee u soo sheegaysaa?”

   Sababta ay u weydiiyaan: Daacadnimada tirooyinka ayaa ka muhiimsan war wanaagsan. Waxay hubinayaan inaad saxnaan ku sii jirto oo aad weli kooxda ka caawiso inay fahmaan sababta.

   Sida looga jawaabo

   • Marka hore hubi xogta, si aad u hubiso in farqigu dhab yahay.
   • Tirada si sax ah u soo sheeg, adigoo raacinaya qaybiyaha (denominator) iyo muddada.
   • Ku dar waxa xogtu u malaynayso inay sababtu tahay, oo la wadaag madaxaaga ka hor warbixinta ballaadhan.

Tusaalooyinka jawaabaha waa English, luqadda guddiyada badankoodu isticmaalaan. Adigu erayadaada ku sheeg.

Mawduucyada dib u eeg

• Pivot tablesPivot table wuxuu kumanaan saf ku soo koobaa qaybo ilbiriqsiyo gudahood: tirin, isu-geyn iyo celcelis degmo, jinsi ama bil kasta. Ogow rows, columns, values iyo filters, oo dib u cusboonaysii (refresh) marka xogtu isbeddesho. Hawl caadi ah: tirada qoysaska degmo kasta iyo jinsiga madaxa qoyska.
• VLOOKUP, XLOOKUP and INDEX/MATCHLookup-yadu waxay qiime ka keenaan jadwal kale iyagoo adeegsanaya fure la wadaago, sida aqoonsiga ka faa'iidaystaha (ID). VLOOKUP wuxuu u baahan yahay FALSE si uu sax u noqdo, midig oo keliyana wuu eegaa; XLOOKUP waa ka dabacsan yahay; INDEX/MATCH-na wuxuu ka shaqeeyaa Excel-ka hore. Ogow sababta #N/A u soo baxdo iyo sida IFERROR si ammaan ah u qariso.
• Data cleaning in Excel and Power QueryMeelaha bannaan ee dheeraadka ah ku saar TRIM, xarfaha waaweyn ku hagaaji PROPER, tirtir xogta labanlaaban, kala qaybi tiirarka, oo hagaaji taariikhaha iyo tirooyinka qoraal ahaan loo kaydiyey. Xogta asalka ah (raw) ku hay xaashi gooni ah oo aan la taabanin, isbeddelladana ku qor diiwaanka nadiifinta. Power Query wuxuu bil kasta ku celiyaa isla nadiifintaas hal gujin.
• COUNTIFS, SUMIFS and IFCOUNTIFS wuxuu tiriyaa safafka buuxiya shuruudo dhawr ah, sida haweenka ka weyn 18 ee hal degmo. SUMIFS sidaas oo kale ayuu qiimayaasha isugu geeyaa. IF wuxuu safafka u kala qaybiyaa kooxo, tusaale “ka yar 5” ama “5 iyo ka weyn”. Filo su'aal isku daraysa laba ka mid ah.
• KoboToolbox and ODK (XLSForm)Foomamka waxaa Excel lagu qoraa qaab XLSForm ah: xaashida survey (type, name, label), xaashida choices, iyo tiirar sida constraint, relevant (skip logic), required iyo calculation. Xogta waxaa lagu ururiyaa taleefannada iyadoo internet la'aan ah, kadibna la soo diraa (sync), kadib Excel ama CSV loo dhoofiyaa. Waxay ku weydiin karaan waxa tiirka relevant qabto.
• SQL basics (SELECT, WHERE, GROUP BY, JOIN)SELECT wuxuu doortaa tiirarka, WHERE wuxuu shaandheeyaa safafka, GROUP BY oo la socda COUNT ama SUM ayaa soo koobaa, ORDER BY wuu kala horreysiiyaa, JOIN-na wuxuu jadwallada ku xidhaa fure la wadaago. INNER JOIN wuxuu hayaa kuwa isku beegan oo keliya; LEFT JOIN wuxuu hayaa saf kasta oo jadwalka koowaad ah. Imtixaannadu badanaa waxay bixiyaan laba jadwal oo yaryar oo waxay codsadaan hal query.
• Power BI (Power Query, relationships, DAX)Power Query wuxuu soo rara oo nadiifiyaa xogta, model-ku wuxuu jadwallada ku xidhaa fure, DAX measures-na sida SUM, COUNTROWS iyo CALCULATE ayaa xisaabta qabta. Slicers waxay isticmaalayaasha u oggolaadaan inay shaandheeyaan. Ogow sida xogtu isu cusboonaysiiso iyo cidda arki karta warbixinta la daabacay.
• Dashboard designHal su'aal oo muhiim ah bog kasta, tirooyinka muhiimka ah xagga sare, jaantusyo tiirar ah (bar) halkii kuwo goobaabin ah (pie) marka la isbarbar dhigayo, isla midab isla shay, iyo cinwaan sheegaya fariinta. Muuji taariikhda cusboonaysiintii ugu dambaysay. U naqshadee qofka isticmaali doona, shaashadda uu isticmaalo.
• Mean, median and percentagesMedian-ku waa ka fiican yahay celceliska (mean) marka qiimayaal yari aad u kala fog yihiin, sida dakhliga qoyska. Boqolley kastaa waxay u baahan tahay qaybiyaheeda: 40% yaa laga yahay? Natiijooyinka u kala qaybi jinsi, da' iyo degmo, oo ha sheegin in shay kale keenay adigoon caddayn haysan.
• Data protection and anonymisationXogta shakhsiga ah waxaa ka mid ah magacyada, lambarrada taleefanka, lambarrada aqoonsiga iyo meelaha GPS-ka; kiisaska caafimaadka iyo ilaalinta (protection) si gaar ah ayay xasaasi u yihiin. Ururi waxa aad u baahan tahay oo keliya, xaddid cidda furi karta, fayl-yada ku ilaali password, oo ka saar calaamadaha lagu garto ka hor intaadan wadaagin. Tirooyin yaryar oo tuulo yar ah weli qof ayay garan karaan.

Hawlaha la sameeyo ee laga yaabo in lagu siiyo

1. 1Imtixaan Excel oo waqti leh (45 ilaa 90 daqiiqo): fayl qasan oo ka faa'iidaystayaal ama iib ah oo aad nadiifinayso, ka saarayso xogta labanlaaban, ku soo koobayso pivot table iyo lookup, jaantus ka samaynayso, oo dhawr jumladood ku sharxayso. Xogta asalka ah ku hay xaashi gooni ah, wax walba magac u yeel oo hubi wadarrada. Ku tababar xog dadweyne adigoo saacad socota haysta.
2. 2Hawl foom sahan: dhis foom gaaban oo KoboToolbox ama ODK ah oo leh liisas doorasho, xaddidaad iyo skip logic, ama ka hel khaladaadka XLSForm. Ku tababar adigoo dhisaya foom qoys oo 15 su'aalood ah akoon KoboToolbox oo bilaash ah, oo ku tijaabi taleefankaaga.
3. 3Imtixaan SQL: ku qor query-yo database yar si aad u shaandheyso, kooxo u tiriso oo laba jadwal isugu xidho. Ku tababar SQLite ama bog bilaash ah oo SQL lagu barto ilaa aad qori karto adigoon qaabka qorista (syntax) raadin.
4. 4Dashboard iyo soo bandhigid: xog lagu siiyey ka dhis dashboard hal bog ah oo Power BI ama Excel ah, kadibna saddex natiijo shan daqiiqo ugu soo bandhig xubin guddiga ka mid ah oo aan farsamo aqoon. Ku tababar inaad jaantus kasta ku sharaxdo laba jumladood: waxa uu muujinayo iyo waxa laga yeelayo.

Su'aalaha portfolio-ga

• Keen laba ama saddex tusaale: dashboard, xog la nadiifiyey oo leh diiwaankeeda nadiifinta, ama warbixin falanqayn oo gaaban. Isticmaal xog dadweyne ama mid aad adigu samaysay, weligaana ha isticmaalin xog shakhsi ah oo dhab ah oo shaqo-bixiye leeyahay.
• Tusaale kasta, diyaar u ahow inaad sheegto su'aasha uu ka jawaabay, halka xogtu ka timid, tallaabooyinkaaga iyo go'aanka uu taageeray.
• Daabac hal dashboard oo lagu dhisay xog bini'aadamnimo ama tirakoob qaran oo furan, si guddigu maalinta u furi karo.
• Filo “Sidee ku hubisay in tirooyinku sax ahaayeen?” Muuji sidaad wadarradaada ula barbar dhigtay xogta asalka ah.

Khaladaadka ka fogow

• Inaad si toos ah u nadiifiso xogta asalka ah adigoo aan nuqul iyo diiwaan midna haysan, sidaa darteed cidina ma hubin karto mana ku celin karto shaqada.
• Jaantusyo leh midabyo badan, muuqaal 3D ah, ama jaantus goobaabin ah oo laba iyo toban qaybood leh.
• Inaad fayl-yo leh magacyo iyo lambarro taleefan ku dirto email ama WhatsApp adigoon oggolaansho haysan.
• Inaad bixiso tirooyin aan qaybiye iyo taariikh lahayn: “300 ayaa la gaadhay” immisa ka mid ah, oo ilaa goorma?
• Inaad tirooyinka beddesho ama qariso si barnaamijku ugu muuqdo inuu gaadhay bartilmaameedkiisa.
• Inaad sheegato Power BI ama SQL kadib hal fiidiyow. Imtixaanka waqtiga leh ayaa daqiiqado gudahood runta muujinaya.

Hubin degdeg ah

5 su'aalood. Mid kasta ka jawaab si aad u aragto sharaxaadda.