Home

DAD Cameroon User Manual

Contents

1. 81 DAD ANALYTICS USER MANUAL 6 1 INTRODUCTION The purpose of this document is to describe how the Development Assistance Database for Cameroon DAD Cameroon functions and to provide the necessary instructions which the user should follow to ensure successful work with the application The use of this document and the compliance with the standards specified herein is mandatory for anyone working with the mentioned application 2 OVERVIEW The Development Assistance Database for Cameroon DAD Cameroon is an automated information management system which is designed to improve efficiency and transparency of national development planning and coordination of reconstruction activities within the country It is also a powerful tool for tracking and analyzing aid flows The system serves as the main database and data collection and reporting system for the government of Cameroon donor and NGO community as it ensures effective access to development data The main objectives of the DAD Cameroon is to serve as a reliable and credible source of information on overall donor contributions to Cameroon s reconstruction economic recovery and socio economic development as well as to support the Government in effectively managing development assistance and promoting the accountable and transparent use of resources The DAD Cameroon is a powerful tool that allows the user to view project and development related data org
2. Ouest Nord Ouest Extr me Nord Whopze Nation Wide Sg glZ Figure 25 Sample Chart Report 1 8 5 2 Sample Chart Report 2 If you have selected the Funding Agency as a chart category and Agreement USD Disbursed USD Expended USD as values to be shown on the chart and click on the Pie chart button to specify the chart type and activates the Data Table and Legend options in the View window the following chart report will appear Figure 26 DAD CAMEROON ANALYTICS USER MANUAL 38 da Contact us Tej My Profile About Help DAD CAMEROON L My Portfolio Dashboard Project Main View Development Partner Profile Sector Profile Cateqory Funding Agency v ShowTop 10 5 Values Agreement USD Disbursed US M t d Series None v Show Top cres aale cot 15 15 Curiae astu Advanced Search am s nt USD o EUN Exim Bark china Funding Agency Agreement USD Disbursed L Remove Filters m IDA International Developement Association EximBank China 4 477 068 187 454 028 521 View Criteria or African Development Fund IDA International 1 965 459 892 212 145 116 mu E 7 Filter Ml D French Development Agency ADF African Devel 618 649 354 222 321 860 1st Level Implementer B European Union AFD French Devel 605 293 101 13 246 116 Implementation
3. ET DATES PTF PART FINANCEMENT PAR CTSE DSCE CONTRIBUTION HM E DGCOOP ETAT DU PORTE FEU niveau decaissemi Note Clicking Images button will show the images dad support minepat qov cm Contact 237 22 22 41 21 cc cc Map Sector Project Project Title Social Rural Infrastructures Industry and services Health Construction et quipement des h pitaux de district et centres de sant dans 4 provinces Fonds commun de pr vention contre la grippe Aviaire Renforcement des capacit s de services de sant des tablissements nationaux et des communaut s pour la gestion de syst amp me de sant Renforcement des capacit s des prestataires de services nationaux pour la sant de la reproduction Renforcement des capacit s nationales pour la r duction de la mortalit maternelle Renforcement des capacit s nationales pour I int gration de POP DEV dans les plans de d veloppement Programme Enfant VIH SIDA 2008 2012 Programme Education de Base 2008 2012 Programme Survie du jeune enfant 2008 2012 Programme Politiques Sociales et Partenariats 2008 2012 Cameroon Millenium Villages Program Phase I CMPV I Fonds d Expertise et de Renforcement des Capacit s 7 Projet d appui aux investissements dans le secteur de la sant PAISS CAM 000715 CAM 000698 CAM 000697 CAM 000696 CAM 000693 000689
4. 000688 000687 CAM 000686 CAM 000684 CAM 000679 CAM 000627 CAM 000620 Governance Education Unallocated Unspecified Total Results 1 13 of 13 Figure 15 Hiding I mages in the List My Profile of Projects Show Images Project Cost 15 35 51 13 29 10 142 About Help Log Off USD 132 776 763 754 584 331 8 444 525 876 42 294 549 107 524 490 9 090 000 4 864 850 5 093 244 521 581 3 252 799 740 000 12 362 500 12 362 500 19 312 500 4 565 000 8 519 250 1 840 266 25 000 000 181 063 504 126 335 016 0 79 632 386 9 721 621 494 ex gt Modify Current View on Project Cost XAF 73 178 763 125 625 803 587 412 2 272 474 298 245 20 707 463 948 58 066 109 114 12 802 816 863 2 633 498 007 2 455 595 543 251 468 804 1 568 265 476 369 880 860 6 179 259 638 5 614 318 113 8 770 598 063 2 073 153 665 3 947 557 205 895 694 377 10 504 002 500 120 930 160 292 147 586 357 733 0 37 423 587 597 3 287 932 694 440 E DAD ANALYTICS USER MANUAL 26 7 6 Modifying the Current View It is possible to modify the list that is currently displayed in the List module You can add new groupings to it or remove the selected ones un select columns re order them etc The steps described below provide for the necessary instructions for modifying the current view Click on the Mo
5. 71 12 2 1 HOWTO Save suu tau 71 12 2 2 How Save Copy of the Report nnn 72 12 35 REORGANISING REPORT ES eta win 72 12 3 1 Renaming Reports and Report 73 12 3 2 Deleting Reports or Report Groups 73 12 3 3 Addo a SUD RU Ie a 73 12 3 4 Re ordering Reports and lt nnns 74 12 3 5 Setting a Report as nnn 74 T2 EXPORTING REPORTS rM S MM 74 12 5 Peed aan wine usta wate 74 DAD ANALYTICS USER MANUAL 3 Se ee wR Ca xs 75 13 1 CREATING FILTERING CRITERIA ae aee eda 75 13 2 SAMPLE FILTERING CRITERIA vette ict eet tee 77 t SEARCHI Z u u m u ass 79 J4 1l 1 SEARCH ix ded ubt bal uyu saya 9 14 2 JADVANCED SEARB tui amc c ctae drei wean Ox d tea xatd RR A RR kc ws 79 14 3 SAMPLE
6. ANALYTICS USER MANUAL 71 12 2 Saving Reports After creating reports of different types you can save them as pre defined reports and include them either in the Public Reports group and make them available for all users who access application or in the My Reports group available to you only There are two ways of saving a report in DAD application You can save a newly created report or save a copy of an existing report with a different name in a different location or with a different content 12 2 1 How to Save New Reports From the List Chart Map and Report modules you can design an appropriate report and save it order to save the report created follow the steps below 1 Click on the aj Save button on the top right side of the screen A Memorize Report window Figure 54 will appear 2 Define the report name in the Memorized Name field Memorized Name My Report My Report Include under the following Group PUBLIC VIEWS Include currently selected filters Figure 54 Memorizing a Report 3 Specify the group the report will be included in by selecting the appropriate value from the Include under the Following Group combo box 4 Check the Include currently selected filters checkbox to save filtering defined along with the report 5 Click on the OK button to save the report for future reference or click Cancel to discard the changes made DAD ANALYTICS USER MANUAL 72 1
7. DAD CAMEROON L My Portfolio Dashboard gt Project Development Partner Profile Sector Profile Remove Filters View Criteria Filter by Implementation Status Sector Region Funding Agency 1st Level Implementer More Filters DGE DGB BIP Prevision DGE DPPP ETAT IMPLEMENT DGPAT PROJET LOCALITE PL CAA MONTANTS ET DATES PTF PART FINANCEMENT CTSE DSCE CONTRIBUTION M DGCOOP DU DGT niveau decaissem List Contact us My Profile About Help List Map Show Images S 59 Ssve em 7 Modify Current View Social 132 776 763 Rural 754 584 331 Infrastructures 8 444 525 876 Industry and services 42 294 549 Health 107 524 490 Governance 181 063 504 Education 126 335 016 Unallocated 0 Unspecified 79 632 386 Total 9 721 621 494 Results 1 9 of 9 7 7 2 Sample View 2 AL Figure 19 Sample View 1 Groupings Available Groups Funding Expenditure Category Co Financing Type Activity Activity Status Outcome Outcome Indicator Probability to Occur Risks Factor Causing Delay Selected Groups Region Commune Millennium Development Goals MDGs Paris Declaration Indicator 4 Paris Declaration Indicators 56 6 9 PDI 10a Mission Title PDI 10b Title of Analytical Work Figure 20 Defining List View Groupings
8. 25 MODIFYING THECURRENTP VIEW catus dose n taOs adr 26 7 6 1 Adding List Groups Columns Column Groupings 26 7 6 2 Re ordering Groups Columns Column Groupings 27 7 6 3 Removing Groups Columns Column Groupings 27 7 6 4 Setting a View as nnns 27 dad IVINS MIEUS 2 7 7 1 28 3 17 Sample View 2 0 cece cece cece eese n nhan aa aas aaa nnn naa aaa nnn 29 CHART MODULE osos 31 Sch IRE 31 6 2 ACCESSING THE CHART MODULE UE 31 8 3 MAIN SCREEN AND TS 32 8 4 VIEW SCREEN AND TS 5 35 CHART REPORT Soldiers E ET EE gie Bache ed Dunne ME de 36 DAD ANALYTICS USER MANUAL 2 8 5 1 Sample tua 36 8 5 2 Sample chart REDON 2 37 MO uuu aE 39
9. 000767 000766 CAM 000765 CAM 000764 CAM 000763 CAM 000762 CAM 000761 CAM 000760 CAM 000759 Project Title Programme national de lutte contre le Paludisme PNLP GEF SMALL GRANTS Program Construction de l usine de traitement d eau Ayatto adoss e sur le fleuve Moungo Am nagement hydro lectrique de Lom Pangar Project Title Accord de coop ration financi re 2010 Accord de coop ration technique 2010 Projet Code Dvision Multiple Access CDMA Construction d un Second Pont sur le Wouri Douala Fonds d Etudes et de Renforcement de Capacit N 10 Pr t consolid Appui au SWAP Sant Projet d Etablissement de la Strat gie pour la durabilit des sources de revenus et la gestion des ressources naturelles Projet de D veloppement de la Riziculture Pluviale de Plateaux en zone de For t Pluviom trie Bimodale Fonds d Etudes et de Renforcement de Capacit s n 9 FERC n 8 12345678910 Next gt gt Updated By Eric CHOU MINEPAT Eric CHOU MINEPAT Eric CHOU MINEPAT Eric CHOU MINEPAT Updated By Pierre Dynamo FOTSING MINEPAT Pierre Dynamo FOTSING MINEPAT Eric CHOUPE MINEPAT Pierre Dynamo F MINEPAT Pierre Dynamo F MINEPAT Pierre Dynamo F MINEPAT Pierre Dynamo F MINEPAT Guy GUEMALEU MINEPAT Guy GUEMALEU MINEPAT Pierre Dynamo FOTSING MINEPAT Updated On 29 Jun 2011 17 Jan 2011 09 Mar 2011 20 Aug 2011
10. 16 6 2 ACCESSING DASHBOARD MODULE I Hh hne erre 16 6 3 MAIN SCREEN AND 59 1 6 4 DASHBOARD MANAGEMENT ix ear is e dien uuu T S ex ie TT 18 6 4 1 Create a New Dashboard uei orte ER 18 6 4 2 Add an Item to a Dashboard i225 55 20052222 I Piu i2ke T TipSLdw 19 6 4 3 Dash sonst dt ba irat de hse d de 20 6 4 4 Save e DSSiRDO38rq 2 dae eee uu eos et u mM IR earn ees 21 6 4 5 Delete 00 SC u us buaya Si Saa cep Me RE 21 6 4 6 Discard tne CHANGES seis y x ee a ea 22 6 4 7 Me T 22 7 1 u 23 7 1 ACCESSING THE LIST MODULE sect aceseteceedeecstacseeddueudsscebeedeelareudaseetecveetiiaudscusieatensetauwes 23 7 2 EXPANDING THE au neds dc seeded Deo Ceo puqu we 24 753 lc u 24 7 4 BROWSING AMONG LIST ITEMS 25 7 5 HIDING SHOWING IMAGES IN THE LIST
11. i Adamaoua project funding agency project sector 200 200 COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 28 Intelligent Searching DAD ANALYTICS USER MANUAL 43 Scaled zoom in zoom out This option allows zooming in zooming out using the scale tool available in the Advanced GIS This means that when changing the zoom scales by clicking either on or you can magnify or reduce the viewport according to the scale value Mouse wheel based zoom in zoom out This option supports mouse wheel based zooming in zooming out In order to enlarge or reduce the viewport using the scroll wheel button of the mouse you should click anywhere on the map and use the wheel button in the backward motion to zoom in and in the forward motion to zoom out Zoom by selection This option allows magnifying the original viewport or a portion of it using the mouse To be able to enlarge an area on the map you should activate the Zoom by Selection option by clicking the button then select a region on the map to magnify 9 4 2 Measuring Distance In the Map module you can measure the distance between two points on map To do this click T button select the point on the map and drag the mouse to the second point to trace a path to measure Figure 29 The measured distance will be expressed both in metric and English units of measure Note Measuring is calculated using the latitud
12. At any time during the process of creating a report look in the Preview section at the bottom of the page in order to view the final structure of the report Figure 40 The Preview will not be ready for viewing unless the user has at least one table row defined DAD CAMEROON ANALYTICS USER MANUAL 56 x dad support minepat gov cm Contact us 7 DAD CAMEROON el 237 22 22 41 21 About Help L My Portfolio Dashboard Seve As Sua A m STN O Development Partner Profile Sector Profile i Header v Choose and structure the information you wish to report on in the table below Expand the Preview section to view the final look and structure of the report Click here to view row column compatibility matrix 1i Group report by Remove Filters 2 E 2 Columns View Criteria ist Level Implementer Filter by 1 Rows Project Y Add Column Implementation Status Add Sub column Sector Region Sector Funding Agency L di ny Data ist Level Implementer ing Agency More Filters jii Reset Submit ist Level Implementer Sector Funding Agency 15 Level Implementer 1 ist Level Implementer 1 1st Level Implementer 2 ency 1 ency 2 Funding Agency ist Level Implementer 1 ist Level Implementer 1 Funding Agency ist Level Implementer 2 ist Level Implementer 2 Figure 40 Pr
13. DEVELOPMENT ASSISTANCE DATABASE FOR CAMEROON DAD Cameroon ANALYTI CS USER MANUAL Version 2 4 DAD ANALYTICS USER MANUAL 1 TABLE OF CONTENT L TNTRODUCTIEON A 6 OVERVIEW uu lut 6 3 LOGGING INTO DAD CAMEROON APPLI CATION 7 SL REGISTERING A NEW USER usse eie bit re atn eer qoe e ende iD u o dra deo share o dea kde o RE Rr ps 8 3 2 ACCESSING DAD WITHOUT REGISTRATION lisse n hehehe eere ren 9 4 DAD ANALYTICS STRUCTURE suwwamamananananananananananananananananana 10 5 MY PORTFOLIO CIE DI I DDR n 12 S L PADD NGM NEW PROJECTS emerat ns uiui Bt ia srt n Maire im m iau emos alc 13 S SUBMITTING PROJECT S uu L qun ape ducent ER canton sins aca darent e DL Dua 13 545 MOVING PROJECT TO DRAPWT IN aes 14 VIEWING PROJECT DETAILS uu u rna deceat a Vw Moon eruta e lee 14 5 5 FILTERING PROJECTS IN MY PORTFOLIO ee qaae nnn 14 DASHBOARD 16 OL PEASPUBES u E
14. Updated On 20 Aug 2011 20 Aug 2011 20 Aug 2011 19 Aug 2011 19 Aug 2011 20 Aug 2011 19 Aug 2011 19 Aug 2011 19 Aug 2011 19 Aug 2011 Ready for Submission Not Ready Not Ready Ready Not Ready Move to Submitted On 20 Aug 2011 20 Aug 2011 20 Aug 2011 19 Aug 2011 19 Aug 2011 19 Aug 2011 19 Aug 2011 19 Aug 2011 19 Aug 2011 Ee 19 Aug 2011 COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS Figure 6 Create New Project Button in My Portfolio 5 2 Submitting Projects Each project created in DAD should first be submitted to become public and official Below we describe the project submission procedure DAD ANALYTICS USER MANUAL 14 User adds a project It is saved as a draft in the user s portfolio in the Draft Projects section Drafts may also be viewed and edited by other users having the corresponding permissions Further drafts should be revised by the user or by the corresponding project manager If all mandatory fields are filled in the project form then the draft gets a Ready state in the Ready for Submission column in the Drafts table If at least one mandatory field is not yet filled the draft has the Not Ready state Note Only drafts with the Ready state can be submitted Press the Submit button in the Drafts table n 5 3 Moving Project to Draft In submitted projects some essential data appears in the read on
15. 11 2 Browsing Projects In the Details section you can browse among the projects To browse projects use correspondingly Previous or Next buttons in the top of the Details window Figure 52 Note In the Chart and Map modules you can also scroll down to the bottom of the page find the appropriate project in the list presented and click it for the details to be displayed DAD ANALYTICS USER MANUAL 69 11 3 Printing Project Details In the Details section you can print out the details of the selected project In order to print out the selected project details follow the steps below 1 Click the appears 2 Choose the printer settings as needed and press Print Print button in the top toolbar A window with printer settings 11 4 Editing an Existing Project In the Details section you may also edit those existing projects that have been either created by yourself or you have permissions to manage In order to edit existing projects follow the steps below 1 Click the Edit button at the top of the Details window The data input window appears which is described in the Project Application User Manual see REFERENCES 2 Make the appropriate changes in the input window and save DAD ANALYTICS USER MANUAL 70 12 CUSTOMISED REPORTING The DAD application allows you to customize the already created reports in the List Chart Map and Reports modules i e to define the way the numeric val
16. 20 000 000 4 633 691 000 J CAA MONTANTS ET DATES COMI GAM OCOS Cameroon Water Affermage ORA peur l extension de la couverture en eau 5 300 000 22929848 510 1 4 0006 3 Agncultural Competitiveness Project PACA 5 000 000 28 751 710 000 PTF PART FINANCEMENT PAR 5 rs ta a ry a 4 lt gt 24M 002 25 Projet d appui investssemens dans le secteur de la sante PAISS 25 000 000 10 504 002 500 CISL DSCL CONTRIBUTION MISE CAMIQQOS21 Programme d appui Syst me Educatif PASE 52 000 000 45 070 422 400 2 pecoop ETAT DU PORTE GAM O00 22 Programme du D veloppement du Secteur de l Energie POSEN 5 100 000 27 352 422 510 CAM 000623 Proet de des canacites institutionnelies du secteur minier 454 283 154 289 571 DGT TOFE niveau decaissement Workspace Figure 4 DAD Analytics Structure DAD ANALYTICS USER MANUAL 11 IL contains the following components Name This is the application header that contains application name and the Cameroon logo On the right side following functions are available Contact Us e mail address of the DAD System Administrator Header My Profile this opens your personal settings and details For details see Registering a New User About opens application s about window Log Out this button is used to log off the application This is the main toolbar of the DAD application Following tabs are available here e
17. Charts and Reports ENTER AS PUBLIC USER Download DAD Cameroon User Manual For Project Focal Points and Administrators User Name Password Request a new account Login Forgot your password Figure 1 DAD Login Screen A successful login directs you to the My Portfolio module Note If you have forgotten your password you can retrieve it by clicking the Forgot Your Password link in the Login Screen and confirming your identity After submitting your identity information you will receive a password to the e mail account indicated DAD ANALYTICS USER MANUAL 8 3 1 Registering New User If you are new to the system and you need a personal account sign up for a username and password to start using the system In order to register in the system follow the steps below 1 Click the Request a new account link on the Login Screen A User Registration Form Figure 2 appears 2 Fill in the information requested 3 Click the Submit button to submit the inserted information DAD CAMEROON User Registration Form Required Field adam watson undp org Please type the content of the security image in the textbox below You may click on the security image to have it re generated in case the characters are nct clear 5FT2S Note You should provide a valid e mail address It will be used for future correspondence EIE Figure 2 The User Registration Form Once you submit
18. NGAOUNDERE OLAMZE SANGMELIMA YAOUNDE 1 YAOUNDE 3 Unspecified AKONO BAFANG BANA BANGANGTE BUEA EBOLOWRA FOUMBAN KOLUSSERI KUMBA LOMIE LOUM MAMFE MANJO MBAMGA MESSOR MEYOMESSALA MIMTOM NGAOLUNDERE NKONGSAMBA SAMGMELIMA YAOUNDE 6 Unspecified MEYOMESSALA Report generated on 16 Mar 2011 15 03 a Local intranet Organisation Type Funding Type Funding Agency hierarchy as the report rows Apply some formatting e g background color font size etc DAD CAMEROON ANALYTICS USER MANUAL 59 My Profile About Help Log Off DAD CAMEROON L My Portfolio Dashboard gt Project Development Partner Profile w Sector Profile Click here to view row column compatibility matrix Group report by Expenditure Category Add Grouping i Columns Drom D p Remove Filters Add Sub column View Criteria Organisation Type 7 Funding Type Data Funding Agency 7 Implementation Status Add Row Sector Reqion Funding Agency 1st Level Implementer i Footer More Filters Reset gt 1 Submit Expenditure Project 2 Figure 43 Creating a Report 2 You will have the following result Figure 44 DAD CAMEROON ANALYTICS USER MANUAL DAD Cameroon
19. i e List Chart Map or Report The system will regenerate and download to the client s side an updated report that applies the updated filtering criteria DAD CAMEROON ANALYTICS USER MANUAL 76 m Filter by ist Level Implementer 1st Level Implementer AFD4 CAA Caisse Autonome d Amortissement PNUD United Nations Development Programme Unspecified z To remove AFD Exclude Criteria Figure 56 Creating a Filtering Criteria Note is possible to exclude a Category item s from being included into the filtering criteria to be created In this case tick the Exclude check box All the Category items that appear in the second text area will be excluded from the filtering criteria to be created DAD CAMEROON ANALYTICS USER MANUAL Filter by ist Level Implementer 1st Level Implementer 4 PMUD United Nations Development Programme Unspecified z To remove AFD Caisse Autonome d Amortissement Current Criteria 1st Level Implementer n Cancel Reset Exclude Is CAA Caisse Autonome d Amortissement Figure 57 Sample Filtering Criteria 13 2 Sample Filtering Criteria If 1 Level Implementer is selected as filtering category and Caisse Autonome d Amortissement is excluded the following results will be acquired Figure 58 77 DAD CAMEROON ANALYTICS US
20. 5 FIGURE 47 REPORTS WINDOW WITH PROPERTIES FOCUS ON COLUMN 63 FIGURE 48 ASSIGNING PROPERTIES TO REPORT TABLE COMPONENTS 64 FIGURE 49 REORDERING REPORT TABLE 5 65 FIGURE 50 DEFINING THE SORTING ORDER 05 FIGURE 51 SWITCHING REPORT TABLE 66 2 LZ uu a kutu Pu p 67 FIGURE 53 SETTING CHART REPORT Hmmm 0 FIGURE 54 MEMORIZING A 71 FIGURE 55 ORGANIZING THE REPORTS nana aka aaa aaa aka nan nn nnn 73 FIGURE 56 CREATING A FILTERING CRITERIA Re RO X DR YRGE P Rer IN EE 76 FIGURE 57 SAMPLE FILTERING CRITERIA ueber D ple Gus DIS RE I x 77 FIGURE DI Ou uu u um u iunc meus ud AMI asuaka L DE 78 FIGURE 59 CREATING A SEARCH CRITERIA raa 9 FIGURE 60 DEFINING SEARCH CRITERIA 80 FIGURE OI SEARCH RESULT
21. 9 1 FEATURES OF THE GIS TOOL una m QS OU MEE da 39 9 2 ACCESSING THE MAP MODULE uu 41 9 3 THE SCREEN COMPONENTS T A E E T N EAA 41 9 4 WORKINGIN THE MAP MODULE u eae e eE 42 9 4 1 ZOOMIAG Ih 7 oo0millid out Kr dad C cb ined d a Cu cb e 42 9 4 2 SAS EI CIS CC Bio vitium fuic tant pum uu ono tad a pum ul ut ono aam 43 9 4 3 Buffered Zone Querying ee ness nns 44 9 4 4 USINO Layer 45 9 4 5 VIEWING Legend uy 47 9 4 6 48 9 5 VIEWING THE DATA DISPLAYED ON THE MAP s a etur us a eut cte d mbi en da 48 920 SAMPLE MAP REPORTS orione Dee Fav VIP EC VEN RENE II M VI IN VIE INI 49 9 6 1 Satripie Mab RebOEE 1 epatis ey teur erae ume 49 9 6 2 Sample Map Report 2 m 50 LO REPORT MODULE i 52 TO T ACCESSING THE REPORT MODULE ond oo l u tut eeu alo 52 TOZ CREATING POS notiores 93 10 3 PREVIEWING A REPORT u 55 10 4 XSENERATLNG A REPORT a acd atia
22. Note It is possible to select several groups columns by means of the Shift or Ctrl keyboard buttons Click the gt Select button The selected group s column s will appear in the Selected Groups Columns panel DAD ANALYTICS USER MANUAL 27 7 6 2 Re ordering Groups Columns Column Groupings To re order the selected groups columns column groupings follow the steps below 1 Select the group column column grouping that needs to be re ordered in the Selected Groups Columns panel 2 Click the Move Up Move Down button 7 6 3 Removing Groups Columns Column Groupings In order to remove the selected groups columns column groupings from the list follow the steps below l In the Selected Groups Columns panel select the group column column grouping that needs to be removed from the list 2 Click the E Unselect button The selected group s column s column grouping s will be removed from the Selected Groups Columns panel 7 6 4 Setting a View as Default After making changes in the view currently displayed in the List module you can set the newly created view as default This means that the new view will be displayed when the user accesses the List module In order to set a view as default follow the steps below l Make the necessary changes in the current view as described in the sections above 2 After finishing click the Set as Default button in the Modify Curr
23. Project Main View Development Partner Profile Er Category Region v ShowTop 10 Values Government Committed USD G v Sector Profile Show Top Secondary Axis gum t E Series chart s woo 15 15 update Rosat ataun m Government Committed USD Region Government Com Government Disb E Government Disbursed USD Centre 7 848 720 5 415 667 E Government Contribution USD Adamaoua 6 946 905 5 589 565 Sud 1 894 527 0 Extr me Nord 1 032 370 324 607 Nord 492 843 324 607 Nation Wide 218 859 218 859 Quest 20 400 20 400 Nord Quest 20 400 20 400 v _ 5 8 180 000 000 Remove Filters View Criteria Filter by 150 000 000 ist Level Implementer Implementation Status Sector Region 120 000 000 Funding Agency More Filters 90 000 000 G6 Flux financier par secteur SCE G5 Flux financier par r gion G4 Top 10 des multilat raux xp G3 Top 10 des bilat raux G2 Flux financier par type d oqanisme 30 000 000 ol G1 Flux financier par type d organisme comparaison d caisse recep d pense projets Cout total des projets par secteur rapport bailleurs etat distribution de cout par region 06 9r6 9 Adamaoua S 669 S 1806 8 6 58 5 0140076 08841 L 12 Nord Littoral Sud Ouest
24. RI rn 24 FIGURE 15 HIDING IMAGES IN THE LIST I HII nnn nn nn rrr 25 FIGURE 16 MODIFYING THE CURRENT hn ns nara ra nnn 26 FIGURE 17 DEFINING LIST VIEW GROUPINGS FOR SAMPLE VIEW 1 28 FIGURE 18 DEFINING LIST VIEW COLUMNS FOR SAMPLE VIEW 1 28 FIGURE SAMPIE VIEW ST toER u OO EO e be un PIER ERN D DR ae 29 FIGURE 20 DEFINING LIST VIEW GROUPINGS FOR SAMPLE VIEW 2 29 FIGURE 21 DEFINING LIST VIEW COLUMNS FOR SAMPLE VIEW 2 30 FIGURE 22 SAMPLE VIEW z ro OR EM PO o MED MD EOD LA 30 FIGURE 23 MAIN SCREEN OF THE CHART MODULE n e nne ner 32 FIGURE 24 VIEW SCREEN THE CHART MODULE hn nar 35 FIGURE 25 SAMPLE CHARI REPORT 42e isa u DI P a 37 FIGURE 26 SAMPLE CHART REPORT 2 TRUE EM UII 38 FIGURE 2 7 MAP MODULE 39 FIGURE 28 INTELLIGENT SEARCHING RR D EWexR REDE RUP NRI dr AE EET 42 FIGURE 29 MEASURING DISTANCE dev 2 luu a HP EMEN dade ol PR 44 FIGURE 30 BUFFERED ZONE QUERYI ero duce ob apu e ENDE EN Dp ERE Pr EE EE ER 45 FIGURE 31 SEVECTING CHART TYPE E tee kaw Ete e 46 FIG URE 32 VIEWING
25. Reference Number Organisation Type Figure 47 Reports Window with Properties Focus on the Column DAD CAMEROON ANALYTICS USER MANUAL 64 Ite mi BL Sort By Mone Wid Show Total None w Font x Caption English Project Font 1 French Reference English Font 1 rench Gss Ref Text English French Name Measures Project Code F Project B Cancel Apply Figure 48 Assigning Properties to Report Table Components 10 6 2 Re ordering Report Table Components This option enables the user to establish and modify the order of the report table components like rows columns etc In order to re order report table components the user should follow the steps described below 1 Click on the component item that needs to be reordered in the report 2 Select the respective Move Up Move Down Move Right Move Left option from the menu that appears The report generated will maintain the order of the items that was displayed in the Report Designer Figure 49 DAD ANALYTICS USER MANUAL 22 XI t e ot 65 Expression Shaw As F Sorting Order k Right Replace k Switch Place With Properties Figure 49 Reordering Report Table Components Note If any of these actions is not available the respective option will be disabled in the menu 10 6 3 Sorting Report Tab
26. SEARCH CRITERIO S Ea DE LC QUE 80 tS LOGGING OUT eS a HG 82 I6 8 a 82 DAD ANALYTICS USER MANUAL 4 TABLE OF FIGURES FIGURE L DAD LOGIN SCREEN uuu u uu unu s suu uu 7 2 THE USER REGISTRATION FORM l Qulu PIED PII UM 8 FIGURE MY PROFILE SECTION meiner 9 FIGURE 4 DAD ANALYTICS STRUCTURE pusa saqarnunaasckaqanassasqwausaqpananasqanqanaqqhauaa 10 FIGURE 5 PORTFOLIO MODULE ii uu uuu unpu uu usia a us MUS CIE 12 FIGURE 6 CREATE NEW PROJECT BUTTON IN MY PORTFOLIO 13 FIGURE 7 FILTERING PROJECTS IN Hmm nnn 15 FIGURE 8 DASHBOARD MODULE hu nn nn sa raa rns 17 FIGURE 9 ADDING A NEW nnn 18 FIGURE 10 LIST PRE DEFINED REPORTS HH HI Hsu hann nsns rn 19 FIGURE LI ADDING A NEW REPORT u uu UN u uu QU lu EU EU 20 FIGURE 12 CUSTOMIZING A DASHBOARD A 21 FIGURE 13 EIST MODULE 23 FIGURE 14 EXPANDING THE LIST ITEM LEVEL
27. Status BID Banque Islamique de D veloppement EU European Unic 367 090 304 0 ector Region m German Agency for Technical Cooperation BID Banque Islam 187 022 716 24 208 594 Funding Agency Coop ration financi re allemande GTZ German 114 626 947 32 371 602 More Filters FINT m IFAD International Fund for Agricultural Development Coop ration 114 239 636 0 m Other BADEA Arab Bank 80 660 000 43 686 935 G6 Flux financier par secteur SCE Other 789 842514 470 258 134 w ol G5 Flux financier par r gion 1145 G4 10 des multilat raux G3 Top 10 des bilat raux G2 Flux financier par type d oqanisme G1 Flux financier par type d orqanisme ol comparaison d caisse recep d pense projets ol Cout total des projets par secteur rapport bailleurs etat distribution de cout par region Agreement USD 187 022 716 11 21 1 49 ies 6 80 Figure 26 Sample Chart Report 2 DAD CAMEROON ANALYTICS USER MANUAL 39 9 MAP MODULE In the Map module of DAD you can make use of an advanced GIS tool for data visualization mapping and analysis Figure 27 In this module you can plot data directly on a map and then access that data through the map You can also query aggregate disaggregate filter and edit data on a map visually capture data at any desired level from the most general to the most de
28. Status Sector Region Funding Agency More Filters e Chart Implementation Status i Adamaoua e project funding agency 11 000 min e project sector 5 000 min ME mm M 0000000000 000 00 o 500 km gian Borders E mi Figure 36 Sample Report 2 DAD CAMEROON ANALYTICS USER MANUAL 52 10 REPORT MODULE In the Report module of DAD you can create and execute ad hoc queries on the data and acquire results in the form of different reports 10 1 Accessing the Report Module As it has been stated above the system provides for the opportunity to create different sorts of list reports In order to access the Report module of the system click on the Report tab You will be navigated to the Report module of the application where the Report Designer Figure 37 will open In this module you can create list reports save them as predefined reports arrange them in the desired way print them etc dad 22322 44 24 My Profile About Help Log Off DAD CAMEROON 22 22 41 2 Y L My Portfolio Dashboard De T gt Project Development Partner Profile Sector Profile i i Subtitle i Header Advanced 22871 Choose structure the information you v sh to report the table below Expand the Preview section to view the final look and structure of the
29. The DAD application is equipped with a comprehensive search mechanism which allows searching for any relevant information 14 1 Simple Search The simple search interface is available to find any relevant information quickly and easily within the integrated DAD content Simple search implies that you can type search operators directly into the search box 14 2 Advanced Search In addition to providing easy access to the content the DAD application has a number of specific features that is used to find exactly what is looked for One of these features is advanced search that allows setting different complex conditions using the Advanced Search Form It gives several additional fields which may be used to qualify searches by such criteria as district sub sector project title etc Follow the instructions below to create search criteria 1 Click the Advanced Search link under the Search section The Advanced Search Form appears Figure 59 Filter by Advanced Search bul Text to find PF cancel Search in cis Reset Funding Agency 1st Level Implementer Region Department Project Title Abbreviation DAD Reference Number 2nd Level Implementer Description d Sector Current Criteria Figure 59 Creating a Search Criteria DAD ANALYTICS USER MANUAL 80 2 Define the text to search for in appropriate field Specify the fields to look in by selecting the appropriate ch
30. Windows Internet Explorer File Edit View Favorites Tools Help ADF African Development Fund IDA International Developement Association PNUD United Nations Development Programme UNICEF United Nations Children s Fund WFP World Food Programme World Bank Trust Fund ADE African Development Bank ADF African Development Fund BADEA Arab Bank for Economic Development in Africa BID Banque Islamique de D veloppement EIB European Investment Bank IDA International Developement Association Unspecified Unspecified Unspecified CAM 000675 CAM 000682 CAM 000602 CAM 000603 CAM 000606 CAM 000616 CAM 000619 CAM 000624 CAM 000731 CAM 000601 CAM 000679 CAM 000698 CAM 000699 CAM 000700 CAM 000701 CAM 000703 CAM 000705 CAM 000723 CAM 000724 CAM 000725 CAM 000726 CAM 000727 CAM 000728 CAM 000729 000683 CAM 000684 000686 CAM 000687 CAM 000689 CAM 000599 CAM 000612 CAM 000618 CAM 000623 000617 CAM 000626 CAM 000674 CAM 000675 CAM 000676 CAM 000677 CAM 000685 CAM 000706 CAM 000711 CAM 000712 CAM 000718 CAM 000653 CAM 000658 CAM 000662 CAM 000663 CAM 000673 CAM 000694 CAM 000713 CAM 000648 CAM 000649 CAM 000650 CAM 000651 CAM 000652 CAM 000653 CAM 000654 CAM 000662 CAM 000663 CAM 000681 CAM 000715 CAM 000722 CAM 000599 CAM 000602 CAM 000603 CAM 000606 CAM 000608 CAM 000615 CAM 000619 CAM 000620 CAM 000621 CAM 0006
31. a New Dashboard In order to create a new dashboard follow the steps below My Profile About Help Log Off DAD CAMEROON mm My Portfolio Customize w Update All Figure 9 Adding a New Dashboard 1 Click the Add New button at the upper right corner of the screen New field appears in the left part of the screen to give a name other than the default one to the dashboard and to save it Also the list of all existing pre defined reports is used to add new items to the dashboard Figure 9 2 Give the desired name to the dashboard Add reports to the dashboard see Add an Item to a Dashboard 4 Save it js DAD CAMEROON ANALYTICS USER MANUAL 19 dad suppaortigimi Jqov cm I Contact us Tek 237 22 22 44 24 My Profile About Help Log Off DAD CAMEROON Dashboard Chart Map Customize Update All Dashboard1 Save Save as New Cancel Dashboard1 Public pa Ei DGE DGB DPI Prewision Ei DPPP ETAT IMPLEMEN Ei DGPAT PROJET LOCALITE P CAA MONTANTS ET DATES PART FINANCEMENT CTSE DSCE CONTRIBUTION DGCOOP ETAT DU PORTE F Drag items here Ed TOFE niveau decaisseme Default View Project project funding agency Project proiect sector Proiect tal Drag and drop the desired component onto ihe dashboard screen COPYRIGHT 2011 SINERGY INTERNATIONAL SYS
32. a glance insight into the data to be analyzed thus giving the decision makers the possibility to leverage information assets in real time through visually rich responsive and personalized business intelligence dashboards This way they will achieve better data interpretation and as a result more informed decision making 6 1 Key Features You can make use of the following key features of the Dashboard tool in DAD y intuitive drag and drop environment that turns adding reports to a dashboard into an easily manageable task Fully resizable report windows Better visualization of the information presented in graph reports The ability to print reports for future reference The ability to export reports on the dashboard in MS Word MS Excel and Adobe PDF formats ARTSA 6 2 Accessing the Dashboard Module In order to access the Dashboard module of the system you should click the Dashboard tab This will navigate you to the Dashboard module In this module you can create dashboards include reports under them etc DAD ANALYTICS USER MANUAL 17 6 3 Main Screen and Its Components My Profile About Help Log Off L My Portfolio Dashboard Customize Update All Dashboard1 Dashboard modified Save Save as New Cance lig Add New Ite Dashboard Public DGE DGB DPI Prevision engagements pour annee 1 Project gt v project_funding_agency Project 4 v Cout total des projets par sec
33. between report grouping rows and columns If there are sub columns selected switching between table groupings rows and columns is disabled It is possible to switch between table groupings rows and sub columns In order to switch report table components follow the steps below 1 Click on the component item that needs to be switched 2 Select the Switch Place with option from the menu that appears Figure 51 Expression Shaw As E Sorting Order 4 4 Move Left m Move Right Remove Replace 3 Switch Place With Tables Properties Rows Cols 1 Project Cost LISD Cols 3 Azzistance Figure 51 Switching Report Table Components 3 Define what component item the selected instance needs to switch place with The selected component item will be removed from its current position and added as an item to the specified component For instance if it is selected to switch between table grouping and row the selected table grouping item will be removed from table grouping and added as the row item while the row item will trade places with the table grouping item DAD CAMEROON ANALYTICS USER MANUAL 67 11 DETAILS SECTION The project Details section Figure 52 can be accessed from the List Chart Map Report and My Portfolio modules Here the project information contacts and monitoring and evaluation details are displayed for each project You may browse among other projects listed
34. features Plotting Category or Indicator Data as icons images flags Plotting data based on GPS coordinates Any layer which contains data associated to a precise GPS coordinate can be plotted on the map Coloring administrative territories based on dynamic scaling e g level of certain pollution Plotting graphs on maps Attaching photo images to GPS locations or conditional locations e Reference features Legend Dynamic legends are displayed depending on the selection of layer s Tooltips Details of an administrative territories Details on plotted categories and indicators e Navigation features Free zoom in zoom out Mouse wheel based zoom in zoom out Scaled zoom in zoom out Map Panning mouse drag and buttons Mini Map Preview The preview displays a small window of the entire world or country and is used for quick navigation to a desired location with one click without having to zoom out find the new location and zoom in again e GIS specific features Distance Measurement Buffered Zone Querying Geocoding e Internationalization features User interface multi lingual capability Map multi lingual capability e Export amp Print Export to PDF Word or Excel Print e Interoperability Map retrieval via web services DAD ANALYTICS USER MANUAL 41 9 2 Accessing the Map Module The system provides for the opportunity to present data on the map of the count
35. item This will expand the list item group level displaying the first sub level Figure 14 This can further be expanded unless there are no more sub levels to be displayed Note You can expand only one group level at a time If you expand the group level of another list item the previously expanded group level will get collapsed DAD CAMEROON L Portfolio 5 Dashboard gt Project Development Partner Profile Sector Profile Sector Project Project Title My Profile 4 of About Help Hide Images Project Cost Log Off 3 Save As Project Cost Modify Current View us Projects USD Social 15 132 776 763 73 178 763 125 35 754 584 331 625 803 587 412 infrastructures 51 8 444 525 876 2 272 474 298 245 Industry and services 4 42 294 549 20 707 463 948 Health 13 107 524 490 58 066 109 114 Remove Filters ES a wa 000715 Construction et quipement des h pitaux de district et centres de sant 9 090 000 12 802 816 863 View Criteria dans 4 provinces CAM 000658 Fonds commun de pr vention contre la grippe Aviaire 4 864 850 2 633 498 007 Filter by it i 5 5 i y 000697 Renforcement des capacit s de services de sant des tablissements 5 093 244 2 455 595 543 Implementation Status nationaux et des communaut s pour la gestion syst me de sant Sec
36. report Click here to view row column compatibility matrix Remove Filters View Criteria 1 Group report by Filter by Add Groupin Implementation Status Sector 1 Columns Region Funding Agency i Rows Add Column 1st Level Implementer Add R More Filters i Footer Reset gt Submit 5 PREVIEW Report Preview Figure 37 Report Module DAD ANALYTICS USER MANUAL 53 10 2 Creating a Report In order to create a report i e to structure the report table and choose what information should appear in the rows and columns of the table add report components which are Text entries title subtitle header and footer For these fields the expected input is a free text Report grouping allows grouping data according to a specific category Grouped data appear in different tables Each table contains data that fall under one group of the category specified Rows group data within the report table Columns show details specific to each table row Sub columns divide the row details displayed under each column In order to add report components follow the steps below They provide instructions on how to compose and submit queries 1 Type the text that should appear as the report title in the Title text box 2 Enter a Subtitle Header and Footer if needed 3 In the Group Report by section specify the category which will be used to group data into differen
37. section to view the final look and structure of the report 2 ni 2 n j w Advanced Click here to view row column compatibility matrix 1 Group report by Remove Filters Add Grouping View Criteria Filter by D Region Y Department Y Commune Implementation Status 2 Rows Sector Add Sub column Add Sub column Add Sub column Region y Funding Agency Sector Y ist Level Implementer Program 7 E More Filters Row i Footer Reset Submit scdc Programs Sectors Sector Program Sedo o C C Department 2 Department 1 Proaram 2 Reaion 2 Decartment 2 Commune 2 Figure 41 Creating a Report 1 You will have the following result Figure 42 DAD CAMEROON ANALYTICS USER MANUAL DAD Cameroon Windows Internet Explorer File Edit view Favorites Tools Help Programs by Sectors Department Sector Program 58 Unspecified 5 Est Unspecified Unspecified Extreme Nord Unallocated Est Mord Sud Ouest Sud Unspecified Unspecified Unspecified Unspecified _rr P r rn Extrermme Mord Sud Ouest Sud Unspecified Littoral Est Centre Mord Adamaoua Unspecified Unspecified Diamare Dja et Lobo Unspecified MEYOMESSALA lt rCm Nord Ouest Centre Est Adamacua Mord Extreme Unspecified Quest Unspecified Unspecified Kadey Lam et Djerem
38. the registration form the DAD administrator receives a notification The administrator will review the information submitted and either approve the application or reject it In case the application is approved you will receive an e mail message to the provided e mail address The e mail will contain your login information details automatically generated username and password and the link to the DAD login page Once logged in with the received username password you can manage your details i e change personal data and the password To edit personal details log into the application go to the My Profile section Figure 3 and make the appropriate changes DAD CAMEROON ANALYTICS USER MANUAL 9 dad support minepat qov cm Contact us Tet 237 22 22 41 21 DAD User Registration Form Reguired Field adamwatson Adam Watson WB adamwatsongmail com Please type the content of the security image in the textbox below You may click on the security image to have it re generated in case the characters are not clear 38AL2 Note You should provide a valid e mail address It will be used for future correspondence ra Figure 3 My Profile Section 3 2 Accessing DAD Without Registration To ensure more flexibility and to provide access to a wider range of users the system is designed in such a way that it allows pub
39. under the same parent item print project details etc If you have the corresponding permissions you can also edit the existing projects New Edit Delete Close G contact us E GENERAL INFORMATION Competitive value chains project PCFC PCFC Le projet PCFC coucourt notamment en mati re de filire l augmentation de la transformation du bois local la r habilitation des routes d acc s Le projet PCFC a pour objectif principal de contribuer une acc l ration durable de la croissance et de l emploi par l am lioration de la competitivit des fili res bois tourisme technologie de l information et de la communication et textile Confection to contribute to the growth of the wood and tourism value chains in Cameroon by improving their competitiveness and the investment climate 13 Feb 2009 31 Dec 2016 94 months 18 days Other Type Ongoing Is this a Nation Locations distribution of funds Commune Unallocated Figure 52 Details Section DAD ANALYTICS USER MANUAL 68 11 1 Accessing the Details Section In order to access the Details section follow the steps below 1 Access the Details section by clicking on the one of the following In the My Portfolio module Click the respective project You will be directed to the Details section Figure 52 In the List module Click the project for the details to be displayed This will open the Details section of the appl
40. 00 000 and Billions shows the numerals divided by 1 000 000 000 2 Title a text box to enter the chart report title 3 Note a text box to enter additional information about the chart report 4 Category Axis a text box to enter the description of the horizontal axis 5 Footer a text box to insert a portion of text that will appear in the bottom area of the chart report 6 Subtitle a text box to enter a subtitle for the chart report 7 Malue Axis a text box to enter the description of the vertical axis 8 Font allows selecting the font the chart report title subtitle footer note will appear in 9 Size allows selecting the font size the chart report title subtitle footer note will appear in 10 Workspace the main working area in the Chart module where the chart designed is displayed 8 5 Sample Chart Reports In the following chapters you can see several samples on charts 8 5 1 Sample Chart Report 1 If you have selected the Region as chart Category and Government Committed USD Government Disbursed USD Government Contribution USD as values to be shown on the chart and click on the 3D Column chart button to specify the chart type and activate the Data Table and Data Label options in the View window the following chart report will appear Figure 25 DAD CAMEROON ANALYTICS USER MANUAL 37 My Profile About Help Log Off DAD CAMEROON mm My Portfolio Dashboard Chart gt
41. 2 2 2 How to Save a Copy of the Report In the DAD application you can save a copy of an existing report The copy of the report can be saved in a different location with a different name or edited content In order to save a copy of a report follow the steps below l Click on the Save A button on the top right side of the screen A Memorize Report window Figure 54 will appear 2 Save the report by the steps described in the section above 12 3 Re organising Reports You can organise the reports in the desired way i e rename the reports create groups to include reports under etc From the List Chart Map and Report modules you can design appropriate reports and organize them in the preferred way In order to organize the reports follow the steps below 1 Click on the respective 2 Organise Views Charts Maps Reports button at the top right side of the Screen An Organise Views Reports window Figure 55 will appear You may perform the following actions Renaming Reports and Report Groups Deleting Reports or Report Groups Adding a Sub group Re ordering Reports and Groups Setting a Report as Default DAD ANALYTICS USER MANUAL 73 PUBLIC VIEWS MY VIEWS DGB DPI Prevision engagements pour ar DPPP ETAT IMPLEMENTAIONM PROJETS CDMT PROJET LOCALITE PLANIFICATIONM CAA MONTANTS ET DATES COMPARES DECAISSET PTF PART FINANCEMENT PAR SECTEUR ET AUTRE CTSE DSCE CON
42. 22 CAM 000625 CAM 000730 CAM 000573 CAM 000574 CAM 000577 IDA International Developement Association Los Figure 44 Sample List Report 2 10 6 Customizing Reports 60 You can customize the reports by assigning font characteristics to report components re ordering rows and columns etc The sections below will describe how to customize the reports DAD CAMEROON ANALYTICS USER MANUAL 61 10 6 1 Formatting Styling Report Components You may format style the text entries as well as main report table captions and values by assigning to them value characteristics such as font font size font color background color alignment i e left center or right etc In order to format style a report component follow the steps below l Click on the report component that needs to be formatted styled 2 Select the Properties option from the actions list that appears Figure 45 dad support minepat qov cm Contact us 1237 22 22 41 21 My Profile About Help Log Off DAD CAMEROON My Portfolio Dashboard BB uaa gt Project Development Partner Profile Sector Profile Choose and structure the information you wish to report on in the table below Expand the Preview section to view the final look and structure of the report Click here to view row column compatibility matrix Advanced Search i Group report by Remove Filters z Colum
43. 3 120 627 Funding Agency ist L 1 Impl t eui mq ementer Results 1 11 of 11 DGE DGB Prevision DGE ETAT IMPLEMENT DGPAT PROJET LOCALITE PL MONTANTS ET DATES PTF PART FINANCEMENT PAF CTSE DSCE CONTRIBUTION M DGCOOP ETAT DU PORTE DGT niveau decaissem Figure 22 Sample View 2 DAD ANALYTICS USER MANUAL 31 8 CHART MODULE The DAD application is equipped with a powerful chart designer that empowers you with all necessary tools to create charts for professionally looking presentations and reports A user friendly interface great number of visual effects and pre defined chart types flexible chart components selection and on screen real time chart visualization make using the chart designer an easy and delightful experience 8 1 Key Features You can make use of the following key features of the Chart tool in DAD Y Rich user interface that supports movable windows for arranging the screen as desired Y The ability to resize the charts directly in the workspace The ability to show or hide the data labels and legends Y The ability to customize the coloring or choose pattern filled charts for black and white printing lt 8 2 Accessing the Chart Module As it has been stated above the system provides for the opportunity to present data in form of different charts In order to access the Chart module of the system click
44. ATIONAL SYSTEMS Log Off Ready for Submission Not Ready Not Ready Ready Not Ready 20 Aug 2011 20 Aug 2011 20 Aug 2011 19 Aug 2011 19 Aug 2011 19 Aug 2011 19 Aug 2011 19 Aug 2011 19 Aug 2011 19 Aug 2011 Submitted Drafts EE EE E EE EE EP In My Portfolio module you can create projects view and edit the details of existing projects etc DAD CAMEROON ANALYTICS USER MANUAL 13 Note The user may have the permission to edit records in My Portfolio in case they have been created by him her or by someone from the user s group All these permissions are granted and managed in the DAD Administration Center Also in My Portfolio module you can perform search among draft and submitted projects using the advanced filtering engine the application is equipped with For details see Filtering Projects in My Portfolio 5 1 Adding New Projects To add a new project from My Portfolio module click the Create New Project button Figure 6 This will open an Add Project form which is described in the Projects Application User Manual see REFERENCES My Profile About Help Log Off DAD CAMEROON Ej My Portfolio Funding Agency 1st Level Implementer First Level Implementers 2nd Level Implementer Project Title DAD Reference Number Second Level Implementers Funding Agencies DAD Reference Number Reference Number 000768
45. CHART LEGEND uuu say uu aa aaa ERN E ato RIDERE PL ER EIDEM RS ETE 47 FIGURE 33 USING MINI uyu s VEN Feds 48 FIGURE 34 VIEWING THE DATA DISPLAYED ON THE 49 FIGURE 397 SAMPLE MAP REPORT esque ot ARE PAESE SE UD RES 50 FIGURE 36 SAMPLE MAP REPORT 2 2 uy uu PT REID SN E Rr ui usis DR NIE 51 FIGURE 37 REPORT MODULE hen nnn nnn naar aaa arare nnns 52 FIGURE 38 SELECTING A GROUPING FOR A e HH emn nnn 54 FIGURE 39 COMPATIBILITY MATRIX z u u utro besos y Su eau do E e Dose Etui seule 55 FIGURE 40 PREVIEWING THE 56 FIGURE TE CREATING A REPORT L uu y a UE E QE 57 FIGURE 22 SAMPLE LIST REPORT taya EU 58 FIGURE 45 CREATINGUA REPORT 2 a Sua m Mb Voss 59 FIGURE SAMPEET3STIREPORV 2 u ora unas a A e m ham aaa asal 60 FIGURE 45 REPORTS WINDOW WITH PROPERTIES FOCUS ON THE TITLE FIELD 61 FIGURE 46 FORMATTING STYLING 5 02 DAD ANALYTICS USER MANUAL
46. Categories Columns Measures Agreement Effective Start Date Agreement Signature Date PDI 5a 5b 6 3 Response Agreement Approval Date Activity Cost USD Activity Cost XAF Agreement End Date Contact Organisation Last Modified By Last Modified On Contact E mail Contact Phone Contact Title Created By Created On PDI 4 Percent Project Title Start Date End Date Government Committed USD Government Committed Government Contribution USD Government Contribution XAF Government Disbursed USD Government Disbursed Project Reference Number Agreement USD Agreement XAF Disbursed LISD Disbursed XAF Expended USD Expended XAF Project Cost LISD Project Cost XAF Received USD Received XAF of Projects Abbreviation 1st Level Implementer 2nd Level Implementer Activity Activity Status Agreement Number Co Financing Type Commune Contact Department Expenditure Category Factor Causing Delay Funding Agency Funding Source Funding Type Government Counterpart Implementation Status Is nation wide location specific Millennium Development Goals MDGs Month Year Organisation Type Outcome Outcome Indicator Paris Declaration Indicator 4 Paris Declaration Indicators 5a 5b 6 9 PDI 10a Mission Title PDI 10b Title of Analytical Work Probability to Occur Figure 39 Compatibility Matrix 10 3 Previewing a Report
47. Chart Map and Report modules you can design appropriate reports and export them in the PDF MS Word and MS Excel formats In order to export the reports in the PDF MS Word and MS Excel formats follow the steps below 1 Click on the respective Export in PDF Format Export in MS Word Format Export in MS Excel Format button A separate window will open 2 Make changes if necessary 12 5 Printing Reports From the Chart Map and Report modules you can design appropriate reports and print them out In order to print out the selected report follow the steps below 1 Click the Print button on the top toolbar in the right side of the screen A separate window will open 2 Select the Print option DAD ANALYTICS USER MANUAL 75 13 FILTERING The system allows for data filtration Filtering is used to narrow down the information displayed in the reports The filtration works in the Step by Step technology which is used to implement new filtering over the results of the previous one This option reduces the size of reports and makes them easier to read Filters can be added to new or existing reports Defined filtering is applicable for list reports charts and maps The list of the most frequently used filter categories is displayed under the Filter By section The list of all available filter categories is displayed when you click on the More Filters link 13 1 Creating Filtering Criteria Follow the
48. E4 PTF PART FINANCEMENT PA Unspecified em DSCE CONTRIBUTION Vis Ul 2 D n S 24 DGCOOP ETAT DU PORTE F E 5 roject e E zm 5 5 E4 DGT TOFE niveau decaisseme 5 5 valis m 5 lt 234 Default View Project n DGB DPI Prevision engagements pour annee n 1 Project project funding agency Project m v E project sector Project wau Government Sector Project Project Title lis comparaison d caisse recep d V mmitted Drag and drop the desired component onto the dashboard screen Unspecified CAM 000628 Fonds d Expertise et de Renforcement des Capacit s 8 Don hors projet du Japon CAM nnn74a DGCOOP ETAT DU PORTE F 000627 Fonds d Expertise et de Renforcement des Capacit s 7 CAM 000649 Projet pilote d am lioration de la qualit de l ducation de au Cameroun COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 11 Adding a New Report 6 4 3 Customize a Dashboard In the Dashboard module you can customize any dashboard created i e rename the dashboard save the changes made to it save a copy of the dashboard delete a dashboard and or discard the changes made For details see below In order to customize a dashboard follow the steps below l Click the Custo
49. ER MANUAL 78 DAD CAMEROON My Portfolio Dashboard b Project Development Partner Profile Sector Profile Remove Filters View Criteria Filter by Implementation Status Sector Region Funding Agency XY ist Level Implementer DGE DGB DPI BIP Prevision DGE DPPP ETAT IMPLEMENT DGPAT PROJET LOCALITE PL CAA MONTANTS ET DATES PTF PART FINANCEMENT CTSE DSCE CONTRIBUTION DGCOOP ETAT DU PORTE E DGT niveau decaisser My Profile List Please note a filter is applied you are currently reviewing a selection sub set of all projects Sector Project Y Project Title Ad Social 15 Rural 32 Infrastructures 50 Industry and services 4 13 29 Education 10 Unallocated 1 Unspecified 5 Total 138 About Help List Show Images f Ssve Project Cost USD 132 776 763 583 688 855 8 432 425 876 42 294 549 107 524 490 181 063 504 126 335 016 0 79 632 386 9 538 626 018 Results 1 9 of 9 Figure 58 Filtered List Modify Current View Project Cost XAF 73 178 763 125 421 209 342 467 2 267 122 056 845 20 707 463 948 58 066 109 114 120 930 160 292 147 586 357 733 0 37 423 587 597 DAD ANALYTICS USER MANUAL 79 14 SEARCH
50. Feu Unspecified 5 79 632 386 37 423 587 597 TOFE niveau decaissem Total 142 9 721 621 494 3 287 932 694 440 Results 1 13 of 13 Figure 14 Expanding the List Item Level 7 3 Sorting List tems You can sort the list view by column by clicking on the name of the column This will sort the list alphabetically or numerically depending on the type of data entered into that column The arrow that appears on the column can reverse the order of the list DAD CAMEROON ANALYTICS USER MANUAL 7 4 Browsing among List tems 25 You can browse among the list items by clicking on the number link of the page to navigate to The Previous and Next buttons can be used to move to the required page 7 5 Hiding Showing Images in the List In order to make the list load quicker you can choose to hide the images which are displayed in the list These images can be donor flags sector icons etc To hide the images the list click on the Hide Images button located at the top of the screen All the images in the screen will not display Figure 15 DAD CAMEROON My Portfolio Dashboard gt Project Development Partner Profile Sector Profile Remove Filters Filter by Implementation Status Sector Region Funding Agency ist Level Implementer More Filters DGE DGB BIP Prevision DPPP ETAT IMPLEMENTA DGPAT PROJET LOCALITE PLA
51. M 56 10 5 SAMPLE REPORT 56 REPO 57 10 5 7 d ot 58 10 6 CUSTOMIZING REPORTS sai Seta La ae E EE D 60 10 6 1 Formatting Styling Report Components 61 10 6 2 Re ordering Report Table Components 64 10 6 3 Sorting Report Table Components 65 10 6 4 Removing a Report Table Component 66 10 6 5 Switching Report Table Components 66 Fi DETAILS SECI ON um 5230960890099 67 FETI ACCESSING THE DETAILS SECTION ym z ates cove mu E L 68 11 2 BROWSING PROJECTS puyum a akiwa qk ta eoa eaa 68 11 5 PRINTINGIPROJECTDETADDBS uu u uuu u u qoa E xar RR ads ac Qo m Ter huku qusqu aaa lta cci 69 11 EDITING ANSEXISTING PROJECT n Ren ROME roster Rp b 69 12 CUSTOMISED REPORTING uu rr n OE RD RE rin n o Rn rr i i nd 70 12 1 SETTING REPORT OPTIONS 3 56 aac aeta 70 12 7 SAVING REPORTS
52. My Portfolio opens MY PORTFOLIO MODULE to manage user specific projects Dashboard opens DASHBOARD MODULE for quick access I the projects registered in the DAD system List opens the LIST MODULE of the selected Application see Main Menu description below Chart opens the CHART MODULE Map opens the MAP MODULE Report opens the REPORT MODULE Help opens the DAD application s help This menu contains sections with main functions of the DAD application e Application lists all applications present in the DAD e Search contains a common and advanced search functions among the selected application list For details see SEARCH Filter contains filtering options For details see FILTERI NG Main Menu Bar Public Views Charts Maps Reports saved list views charts maps reports depending on the opened module available to all users of the application My Views Charts Maps Reports views charts maps reports depending on the opened module created by and available to the current user only Left Right arrows used to hide open the Main Menu bar Main Menu and the Layers panel in the Map module Manipulation Up Down arrows J used to collapse expand the section Buttons in the Main Menu bar Frame Divider used to adjust the width of the Main Menu bar In this frame all applications and modules are managed Here are Workspace filtering and search results displa
53. Nord Centre Adamaoua Sud Unspecified Est Extreme Nord sag es C Unspecified Unspecified Diamare Dja et Lobo Sud Ouest Sud Unspecified Nord Est Unspecified Mwila Infrastructures Unspecified Mayo Banyo Vina Mfaundi Sud Unspecified Est Quest Nyong et 5oo Haut Myong Kadey Lom Extreme Mord Nord Ouest et Djerem Diamare Sanaga Maritime Littoral Centre Adamaoua Wouri Mezarn Mifi Noun Dja et Lobo Nord Sud Ouest FAKO MAN YU MEME NYONG ET KELLE OCEAN VALLEE BU NTEM Unspecified Unspecified Djerem Vina Mefou et Alcono Mfoundi Haut Nyong Diamare Logone set Chari Mayo Danay Mounga Haut NHkam Meneua Noun Dja set Lobo Mvila FAKO MANYU MEME Centre Nord Adamacua Littoral Sud Ouest Est Ouest Extreme Mord Nord Quest Unspecified Sud Unspecified Unspecified Sud Est Adamaoua Nord Extreme Nord Littoral Centre Sud Quest Quest Unspecified Unspecified Diamare Dja et Lobo Figure 42 Sample List Report 1 10 5 2 Sample Report 2 If you have indicated Figure 43 Expenditure category as the report table grouping Project as columns Unspecified GAROQUA BOULAI KENZOU KETTE Unspecified MEYOMESSALA Unspecified EBOLOWA Unspecified AKOM 2 BAFOUSSAM BAMENDA BERTOLIA DJOUM DOUALA 2 EDEA KETTE KRIBI LIMBE MBALMAYO MESSAMENA MEYOMESSALA MINTOM MVANGANE MVENGUE
54. TEMS INC Figure 10 List of Pre defined Reports 6 4 2 Add an Item to a Dashboard In order to add a report to a dashboard follow the steps described below 1 Click the Add New Item link The list of all reports previously saved reports will appear Figure 10 2 Select a report to add to a dashboard and drag and drop it onto the main screen 3 f you want to add another report to the dashboard select it in the list drag it onto the main screen and hold the left mouse button until a green rectangle appears on the screen indicating an area where the new report can be placed Figure 11 4 You may add multiple reports to the dashboard Note The reports can be arranged either in vertical or in horizontal order Once the place for the report is selected it cannot be changed DAD CAMEROON ANALYTICS USER MANUAL DAD CAMEROON mm My Portfolio Dashboard Dashboard1 Dashboard1 DGPAT_PROJET_LOCALITE_PLANIFICATION Project Region Department Commune Project Unspecified Chart Customize w Project Title Map Update All Dashboard modified of Projects Save Save Cancel Public Scroll Mode Action financi re des bailleurs Project 4 500 000 000 dad support minepat gov cm el 23 20 My Profile About Help Log Off lig Add New 15 Ed DGE_DPPP_ETAT_IMPLEMEN MONTANTS ET DATES Unspecified
55. TRIBUTION MISE OEUVRE STI DGCOOP ETAT DU PORTE FEUILLE PROJET niveau decaissement secteur bailleur Rename gt Delete m Add Group a Mowe Up IL Move Down Figure 55 Organizing the Reports 12 3 1 Renaming Reports and Report Groups Highlight the report group to be renamed Click the Rename button Fill in the desired name for the report group Click the Enter keyboard button to confirm renaming Note Public Reports and My Reports groups cannot be renamed 12 3 2 Deleting Reports Report Groups 1 Highlight the report group to be deleted 2 Click the Delete button 3 Click the OK button to confirm deletion Note Public Reports and My Reports groups cannot be deleted 12 3 3 Adding a Sub group 1 Click the Add Group button 2 Fill in the desired name for the sub group 3 Click the Enter keyboard button to confirm adding DAD ANALYTICS USER MANUAL 74 12 3 4 Re ordering Reports and Groups 1 Highlight the report group the sorting order of which needs to be changed 2 Click the Move Up Move Down button 12 3 5 Setting a Report as Default 1 Highlight the report to be displayed in the respective module when you access it 2 Click the Set as Default button The selected report will be marked with default for me option Note This option is available only in the Chart Map and Report modules 12 4 Exporting Reports From the
56. anized in various ways In the DAD Cameroon the user is able to present data in form of list chart and map reports memorize save the reports print them and export them into various formats The DAD Cameroon is designed to provide quick access to the project and development data remotely via I nternet Once you have accessed the application you can view the project data stored in the database add new projects edit existing ones etc The DAD Cameroon provides a web based user interface and requires a web browser Internet Explorer pre installed The examples described in the sections below are based on the Project application Note To ensure more flexibility and a more user friendly environment the DAD Cameroon has been implemented as a bi lingual system allowing the users to view the data presented in the system in two languages English and French DAD CAMEROON ANALYTICS USER MANUAL 3 LOGGING INTO DAD CAMEROON APPLICATION The starting screen of the DAD is the Login Screen Figure 1 To login you should validate yourself with the username and password and then click the Login button Note The password is case sensitive Note If you have failed to login 3 times the system will be blocked Contact your system administrator in order to unlock your user access DAD CAMEROON What can do in DAD Cameroon Once you enter DAD Cameroon you will be able to w View all the projects See project details Create Maps
57. ayed on the secondary axis in the chart Becomes available only if a Series is selected This option is disabled if you have selected the pie chart type Char Count limits the number of characters to be used to display the category item names to the value set in this field DAD CAMEROON ANALYTICS USER MANUAL 35 7 Values allows selecting a value from the list that will define the main chart criteria 8 Update loads the latest data from the database and displays them on the chart 9 Reset Default loads the default chart built according to the default chart category and chart type 10 Workspace the main working area in the Chart module where the chart designed is displayed 8 4 View Screen and Its Components DAD CAMEROON My Profile About Help Log Off My Portfolio Dashboard gt Project Development Partner Profile Sector Profile Remove Filters View Criteria Filter by Sector Region Funding Agency More Filters gt i n ui w 3 ist Level Implementer Implementation Status G6 Flux financier par secteur SCE 80 000 000 G5 Flux financier par r gion G4 10 des multilat raux 10 des bilat raux G2 Flux financier par type d oqanisme ol G1 Flux financier par type d organisme 0 comparaison d caisse recep d pense projets Cout total des projets par secteur rapport bail
58. cement des Capacites 7 Projet pilote d am lioration de la qualit de l ducation de base au Cameroun PAQUEE uu wee oo oom TY maarwa TY CAM 000627 000649 Anan AnA COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC n na cer nag Figure 12 Customizing a Dashboard 6 4 4 Save a Dashboard After the new dashboard has been created and items added to it it is necessary to save it to be able to view it later on It should be mentioned that there are two options for saving dashboards e Save saves all modifications made to the dashboard e Save as saves a copy of a dashboard under a new name In order to save a dashboard a copy of a dashboard follow the steps below 1 Select the respective Save or Save as New option 2 Click OK in the message window indicating the dashboard the changes to it have been saved successfully 6 4 5 Delete a Dashboard In order to delete a dashboard follow the steps below 1 Select the dashboard that you want to delete Its contents will be displayed on the main screen 2 Click the Remove link The selected dashboard will be deleted DAD ANALYTICS USER MANUAL 22 6 4 6 Discard the Changes In order to discard the changes made to the dashboard currently displayed on the screen follow the steps below 1 Click the Cancel link 2 Confirm that you want to discard all changes made to the da
59. de coop ration technique 2010 Projet Code Dvision Multiple Access CDMA Construction d un Second Pont sur le Wouri Douala Fonds d Etudes et de Renforcement de Capacit N 10 Pr t consolid Appui au SWAP Sant Projet d Etablissement de la Strat gie pour la durabilit des sources venus et la gestion des ressources naturelles Projet de D veloppement de la Riziculture Pluviale de Plateaux en zone de For t Pluviom trie Bimodale Fonds d Etudes et de Renforcement de Capacit s n 9 FERC n 9 12345678910 Next gt gt Contact Tel 237 22 22 41 21 Project Title Updated CHOUPE MINEPAT c CHOUPE MINEPAT c CHOUPE MINEPAT c CHOUPE Updated Dy Pierre Dy MINEPAT namo FOTSING namo FOTSING Eric CHOUPE MINEPAT Pierre MINEPAT Pierre Dy MINEPAT Pierre Dy MINEPAT Pierre Dy MINEPAT Guy GUE MINEPAT Guy GUE MINEPAT Pierre Dy MINEPAT namo FOTS namo FOTSING c namo FOTS c namo FOTSING MALEU MALEU namo FOTSING Figure 5 My Portfolio Module About Help DAD Reference Number Updated On 29 Jun 2011 17 Jan 2011 09 Mar 2011 20 Aug 2011 Updated On 20 Aug 2011 20 Aug 2011 20 Aug 2011 19 Aug 2011 19 Aug 2011 20 Aug 2011 19 Aug 2011 19 Aug 2011 19 Aug 2011 19 Aug 2011 COPYRIGHT 2011 SYNERGY INTERN
60. dify Current View link at the top right corner of the List screen A Modify Current View window Figure 16 will appear presenting the administrator with the groupings columns selected and available for the list view In the Groupings section add re order remove groups In the Columns section add re order remove columns In the Cross Tab Groupings section define add re order remove column groupings for the view Set the view as default if necessary Please note that the view can appear as default for a current user or for unregistered public users After finishing making changes in the view click the OK button for the changes to take effect Or click the Cancel button to discard the changes made Groupings Available Groups Selected Groups Project Type Sector Implementation Status Project Sub Sector Program OK Is nation wide location specific Region Department x Cancel Commune Funding Source Funding Agency ist Level Implementer 2nd Level Implementer Government Counterpart Organisation Type Set as Default for Contact Public Users Mowe Up Mowe Down Figure 16 Modifying the Current View 7 6 1 Adding List Groups Columns Column Groupings In order to add a group column column grouping to the list follow the steps below 1 In the Available Groups Columns panel select the group column column grouping to be added to the list
61. e and longitude coordinates from point to point and does not consider elevation DAD CAMEROON ANALYTICS USER MANUAL 44 dad support minepat gov cm Contact us Tel 237 22 22 41 21 My Profile About Help Log Off DAD CAMEROON mm My Portfolio Dashboard gt Project Development Partner Profi chart Sector Profile Info Cursor position Lat 5 36 Long 20 13 Categories Scaling i Nation Wide Chart Advanced Search Remove Filters View Criteria Borders Filter by 1st Level Implementer Implementation Status Sector Reqion More Filters project funding agency e project sector COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 29 Measuring Distance 9 4 3 Buffered Zone Querying This feature in the Advanced GIS tool is used to select a point on a map and display any type of data within a given radius In addition the tool is easily navigable through a Mini Map Navigation Bar and Intelligent Search Tools To be able to create a buffer zone to view data for select the button and then select the region on the map to highlight The selected area will be activated while the rest of the screen will be disabled Figure 30 This tool may be useful for presentations on screenshots to mark the selected area on the map DAD CAMEROON ANALYTICS USER MANUAL 45 DAD CAMEROON mm My Portfolio Dashboard b Project Development Pa
62. eckbox es 4 Click the OK button to apply the search criteria to the ad hoc query and to the screen that was active prior to the filtering alterations i e List Chart or Map w Note The simple search searching on all fields is also available at the bottom of the Filers section 14 3 Sample Search Criteria Filter by Advanced Search 1 Text to find fx Cancel Search in Reset Funding 1st Level Implementer P Region P Department Project Title C Abbreviation DAD Reference Number 2nd Level Implementer Description C Sector Current Criteria Figure 60 Defining Search Criteria If you have selected to search for Promotion among project titles and project descriptions Figure 60 the following search results will appear Figure 61 DAD CAMEROON ANALYTICS USER MANUAL 81 DAD My Portfolio Dashboard List List Show Images 3 B Save As Ey 7 Project Please note filter is applied you are currently reviewing selection sub set of all projects Development Partner Profile Modify Current View Sector Profile Project Cost Project Cost Sector Project Y Project Title USD Infrastructures 1 5 300 000 2 226 848 530 x Promotion Governance 1 39 760 608 20 150 000 000 Advanced Search Total 2 45 060 608 22 376 848 530 Results 1 2 of 2 Remove Filte
63. ects Project Cost USD Project Cost XAF Government Contribution USD Government Contribution XAF Aqreement USD Aqreement XAF Disbursed USD Disbursed XAF Received USD Received XAF Expended USD Expended XAF Government Committed USD Government Committed XAF Government Disbursed USD Government Disbursed XAF ist Level Implementer Implementation Status Sector Region Funding Agency More Filters G Chart Implementation Status i Adamaoua project funding agency e project sector Borders 200 km COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 31 Selecting Chart Type DAD CAMEROON ANALYTICS USER MANUAL 47 Borders You can turn on border information by expanding the Borders section in the Layers panel and selecting one of the following options e Auto displays border information for all territorial units when the zoom in is selected For example if you zoom in to commune level the border information for both departments and communes will be displayed on the map e Region displays the border information for all regions e Department displays the border information for all departments e Commune displays the border information for all communes 9 4 5 Viewing Legend To explain the data series or categories on the map the legend is used t
64. ed report table components 4 Click the Apply button for the changes to take effect Clicking the OK putton will close the window and navigate you to the Report module DAD CAMEROON ANALYTICS USER MANUAL 63 DAD CAMEROON My Portfolio Dashboard gt Project Development Partner Profile Sector Profile Remove Filters View Criteria Filter by Implementation Status Sector Region Funding Agency ist Level Implementer More Filters III Contact us M DESIGN i Header Choose and structure the information you wish to report on in the table below Expand the Preview section to view the final look and structure of the report Click here to view row column compatibility matrix i Group report by Add Grouping 2 Columns ist Level Implementer Expression i Rows Project Y Contact P Add Sub column Financial Sector General Funding Agency Data Important Dates Add Row Paris Declaration Indicators Sector and Location i Footer Project V Reset gt Submit ist Level Implementer 2nd Level Implementer PREVIEW secta Region Department Sector Funding Agency Project 1 of Projects dele qm ist Level Implementer 1 Ist Level Implementer 1 ist Level Implementer 2nd Level Implementer Government Counterpart Project
65. ent View window Please note that the view will be set as default only for the current user Note Clicking the Set as Default for Public Users button will display the view to those who access the application as unregistered public user 7 7 Sample Views In the following chapters you can see several samples on list reports DAD CAMEROON ANALYTICS USER MANUAL 7 7 1 Sample View 1 Groupings Available Groups Project Type Implementation Status Program Is nation wide location specific Region Department Commune Funding Source Funding Agency ist Level Implementer 2nd Level Implementer Government Counterpart Organisation Contact Year Figure 17 l Available Columns 2 of Projects Project Cost Abbreviation Implementation Status Project Type Start Date End Date Duration Project Reference Number Contact Organisation Contact Title Contact Phone Contact E mail Government Contribution USD Agreement USD 28 Selected Groups Sub Sector Project Defining List View Groupings for Sample View 1 T Columns Selected Columns Project Title Project Cost USD Figure 18 Defining List View Columns for Sample View 1 You will get the following result Figure 19 if you have selected Sector Sub sector Project hierarchy as a grouping Figure 17 and Project Title Project Cost as columns Figure 18 DAD CAMEROON ANALYTICS USER MANUAL 29
66. eviewing the Report All your added report components and structuring results will be displayed in the Preview section which helps you to check whether the report matches the required output or not This section can be expanded in order to display whole of the information 10 4 Generating a Report The final step in the process of creating a report is report generation By clicking the Submit i i i Submit button a request to the Reporting Engine is submitted in order to access the database gather the required data and present it in the manner required The Report containing all the real data appears in a new window 10 5 Sample Reports In the following chapters you can see several samples on reports DAD CAMEROON ANALYTICS USER MANUAL 5 10 5 1 Sample Report 1 If you have indicated Figure 41 e Sector Program hierarchy as the report row and add the total value to be shown before data e Region Department and Commune as columns and Sector as sub columns e Apply some formatting e g background color font size etc C cupport imine lilii Profile About Help Log Contact us Tel 237 22 22 412 Profile elp og DAD CAMEROON My Portfolio Dashboard 8 8 gt Project Development Partner Profile Sector Profile i Subtitle i Choose and structure the information you wish to report on in the table below Expand the Preview
67. for Sample View 2 DAD CAMEROON ANALYTICS USER MANUAL 30 X T Columns Available Columns Selected Columns Government Disbursed USD Project Title Activity Cost USD Government Contribution Expended USD Agreement XAF OK Disbursed XAF Received XAF Expended Government Committed Government Disbursed XAF Activity Cost XAF PDI 4 Percent PDI 5a 5b 6 9 Response Created On Created By as Default for Last Modified On Public Users Figure 21 Defining List View Columns for Sample View 2 Set as default You will get the following result Figure 22 if you have selected Region Commune hierarchy as a grouping Figure 20 and Project Title Disbursed USD Expended USD as columns Figure 21 dad support minepat qov cm DAD CAMEROON Contact us 237 22 22 41 24 Profile About Help Log Off WW My Portfolio Dashboard List List Show Images 3 55 As oF a Project Modify Current View Development Partner Profile Sector Profile Region Commune 4 Project Title Disbursed USD Unspecified 12 876 030 549 025 Sud Ouest Adamaoua 4 855 740 4 855 740 Centre 4 855 740 4 855 740 Est Littoral Remove Filters vi Criteri Nord r View Criteria Filter by Ouest 8 781 655 Implementation Status Sud Sector Reqion Total 54 529 288 3
68. g Agency e Project Title returns the project s that were titled exactly as indicated in the search criteria e DAD Reference Number returns the project s that were assigned with the DAD Reference number indicated Once one or more criteria are selected Figure 7 press GO to see the filtered list of projects My Profile About Help Log Off DAD My Portfolio 077 Create New Project Funding Agency 1st Level Implementer 2nd Level Implementer Project Title DAD Reference Number AFD French Development Agency First Level Implementers Second Level Implementers Submitted Move to Reference Project Title Updated By Updated On On Drafts Number CAM 000765 Construction d un Second Pont sur le Wouri Douala Pierre Dynamo FOTSING 19 Aug 2011 19 Aug 2011 0007864 Fonds d Etudes de Renforcement de Capacit 10 Pierre Dynamo FOTSING 19 Aug 2011 19 Aug 2011 MINEPAT CAM 000763 Pr t consolid Pierre Dynamo FOTSING 20 Aug 2011 19 Aug 2011 CAM 000762 Appui au SWAP Sant Pierre Dynamo FOTSING 19 Aug 2011 19 Aug 2011 MINEPAT CAM 000759 Fonds d Etudes et de Renforcement de Capacit s n 9 FERC 9 Pierre Dynamo FOTSING 19 Aug 2011 19 Aug 2011 MINEPAT CAM 000737 Projet d am nagement de l entr e Est la ville de Douala par la route nationale 3 Pierre Dynamo FOTSING 19 Aug 2011 04 Mar 2011 MINEPAT CAM 000730 Community Development Pr
69. g Mini Map The Mini Map window feature displays an additional view of the country map with a position indicator that corresponds to the current view inside the main screen Figure 33 One of the main features of the Mini Map is that while the Mini Map window responds to position adjustments in the main screen you can also interact directly with it Clicking any area within the window or dragging the position cursor to the desired place will adjust position both in the Mini Map and in the main screen to the point in the Mini Map window that the user selects dad support minepat Contact us Tel 1237 22 22 41 24 My Profile About Help Log Off DAD mm My Portfolio 55 Dashboard Project Development Partner Profi Zoom to GO Pie Chart v Sector Profile pre is Info Mbam et Kim Cursor position Lat 4 63 Long 11 78 Categories yo Scaling i Nation Wide Chart i Bui A Borders Remove Filters View Criteria Filter by 1st Level Implementer Implementation Status te Sector Region Funding Agency 1 More Filters project funding agency i Mifi i Mbam et Kim i Kogng Khi project sector jte Plata aux i Nd 50 km EIU 50 mi COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 33 Using Mini Map 9 5 Viewing the Data Displayed on the Map The Advanced GIS tool is used to view
70. ication where more detailed information about the project will be displayed Note Depending on the list representation settings additional expanding the list items may be required to reach the project In the Chart module Click the chart for the details to be displayed e g click on a relevant bar to see what it consists of This will open the Details section of the application where all items matching the selection will be listed The first item in the list will be displayed in an expanded mode In the Map module Point the mouse cursor on the object on the map The project information window will appear In order to access the project details section select the View Projects link This will open the Details section The first item in the list will be displayed in an expanded mode Note You can also choose to view the detailed information on all the projects that are in progress in the given territorial unit by pointing the mouse cursor on the lil button In the Report module Create a report indicating Project as a value for the report row and click the Submit button For more details on how to create and generate reports please see REPORT MODULE In the report generated click the project name 2 Take the necessary actions review the provided information update and improve as needed You may also want to print the project details see Printing Project Details for details The Close button is used to return to the main screen
71. ie Chart v Info Cursor position Lat 11 07 Long 23 07 il Nation Wide i Adamaoua 500 200 mi Figure 35 Sample Report 1 9 6 2 Sample Report 2 50 Profile About Help Categories C None Implementation Status C Sector Funding Agency ist Level Implementer Scaling Chart Borders Cancelled Completed Ongoing Planned Unspecified COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC If you have selected the Project cost USD in the Scaling section the following map report will appear Figure 36 DAD CAMEROON ANALYTICS USER MANUAL 51 DAD CAMEROON mm My Portfolio Dashboard b Project Development Partner Profile Zoom to est Pie Chart Sector Profile Info Cursor position Lat 14 95 Long 11 48 Categories i Nation Wide Implementation Status Sector Funding ist Level Implementer x me Nord Remove Filters Scaling View Criteria No Scale of Projects Project Cost USD Project Cost XAF Government Contribution USD Government Contribution XAF Aqreement USD Aqreement XAF Disbursed USD Disbursed XAF Received 180 Received XAF Expended USD Expended Government Committed USD Government Committed XAF Government Disbursed USD Government Disbursed Chart Filter by ist Level Implementer Implementation
72. in the Category drop down menu located at the top of the Chart window The selected category will define one of the chart axes Note Selection of a category for the chart report is required 2 Series allows selecting one of the options provided in the Series drop down menu located at the top of the Chart window The selected series will define the chart legend Note Selection of a series for the chart report is optional 3 Chart Types allows defining the chart type The following options are available Chart Type 1 Bar chart E i 1 M gt d ios 330 Ct 200 wer 008 pox OCC NK y wy DAD CAMEROON ANALYTICS USER MANUAL Column chart m 3 3D Bar chart 3 Column chart 71 Stacked Bar chart Stacked Column chart Stacked 3D Bar chart 33 DAD CAMEROON ANALYTICS USER MANUAL 34 8 Stacked 3D Column chart 9 Pie chart 19 10 30 chart 11 Line Chart United Nations Development Mercy Corps International B International R Test Implement Unspecified 4 Show Top lt Number gt indicates the maximal number of category items to be 6 displayed in the chart Show Top lt Number gt on Secondary Axis indicates the maximal number of series items that should be displ
73. in window has a complex preview as it is shown in Figure 4 DAD CAMEROON Header 8 My PortfolBn Dashboard ist Show mages Main gt Project Modify Current View Toolbar of Project Cost Project Cost Sector Profile Projecl Seclor Project Tithe Projects 50 XAF CAM OCOS0Z PGORN GTZ 38 245 922 18 009 090 069 AR Projet de Gestion Durable des Terres et des Syst mes Agro Syive Pastoraux dans le 35 1 000 009 5 041 921 2 Cadre du PGCT Projet d Appui eu Centre de Prestation de Service de la F d ration des Producteurs gt t CAM 547 432 00 0 n ott eked du Logone et Chan 547 432 3 00 000 2 Sy IAE Projet de dymamicahon du sous secteur de Micro et Pattes entreprises ENTREPRISE SEN AM z CAM ODISTA CAMEROUN 450 000 199 050 300 Manipulation 14 000602 Transparency and Accountability Capacity Building Project PRCTC 21 200 000 29 859 154 840 Pree E TAA 76 f 07 2 n Buttons nove Filters ogremme National de D veloppement Participati phase 6 000 000 107 042 253 209 Construction de la route angmelima Quesso Lot 1 angm lima Djoum VI nnh nr 445 ANN e Ez 20 000 000 9 207 392 000 2 Bikoula Djourn lang 38 km Central African Backbone Project CAB Compo
74. instructions below to create filtering criteria l Click on the hyperlink under the Filters section that represents the Category according to which the filtering will be carried out A Filters window Figure 56 will appear having the Category Item pull down menu set to the selected Category The first text area holds a list of all the available Category items that the report could display whereas the second text area holds a sub set list of the first one You may only edit the sub set list in the second text area At the end of the filtering if the sub set list is empty all the Category items will be included in the report If however the sub set is non empty only the items in the sub set list will be included in the report At the bottom of the pop up window the selection criteria from all categories are presented This view is also available from the main screen under the hyperlink View Criteria 2 Select a Category item from the list in the first text area 3 Click on the downward pointing arrow button to add the item selected to the list in the second text area Figure 57 4 Repeat steps 2 and 3 to add more than one Category item Note If a Category item needs to be removed from the second text area select it from the list in the second text area and click on the upward pointing arrow button 5 Click on the OK button to apply the filtering to the ad hoc query and to the screen that was active prior to the filtering alterations
75. le Components You may change the order in which the table components will appear in the final report The report table components can be sorted either in an Ascending or a Descending Z A order n order to alphabetically sort the report table components follow the steps below l Click on the component item for which the sorting order needs to be changed Select the Sorting Order option from the actions list Figure 50 Define whether the report item values should be sorted in the ascending or descending order Please note that selecting the None option from the list removes 2 3 the sorting criteria Note The sorting order for Properties window Show Tatal Move Right Remove Move To Replace Properties Sorting Order k the report components can also be defined from within the Mone B Sort fL Sort Desc ing k k Switch Place With F Figure 50 Defining the Sorting Order DAD ANALYTICS USER MANUAL 66 10 6 4 Removing a Report Table Component It is possible to remove a report table component from being included in the report if this is necessary In order to remove a report table component follow the steps below 1 Click on the component item that needs to be removed 2 Select the Remove option from the menu that appears The selected grouping value will be removed 10 6 5 Switching Report Table Components The report table components may be switched
76. leurs etat distribution de cout par region Chart se RD Main Show Data Table Data Label Legend Pattern Multicolor v Show in Original Title Footer Font Note Subtitle Size Category Axis Value Axis 200 000 000 160 000 000 420 000 000 40 000 000 Other EximBank China AFD French De ADF African D IDA Internati EU European U BID Banque Is OFID Fonds de German FKDEA Fonds BADEA Arab Ba Figure 24 View Screen of the Chart Module 1 Show allows selecting one or several of the following options Data Table presents the information contained in the chart in a grid or matrix Data Label shows the actual values of each chart cell This option is disabled if you have selected the pie chart type Legend explains the categories and data series displayed on the chart Pattern allows choosing a pattern filled chart for black and white printing Coloring Option allows defining whether the chart should be displayed in multiple colors or in one of the colors available Show in allows defining how the numerals e g project cost etc should appear on the chart The following options are available Original shows the numerals as it is recorded in the project documents Thousands shows the DAD ANALYTICS USER MANUAL 36 numerals divided by 1 000 Millions shows the numerals divided by 1 0
77. lic users to enter it without registration Public users wishing to view data should click on the ENTER AS PUBLIC USER the login screen Figure 1 They will be directed to the List module of the application DAD CAMEROON ANALYTICS USER MANUAL 10 4 DAD ANALYTI CS STRUCTURE The following applications are available in the current design of the DAD Project serves as a main information hub of all submitted projects Development Partner Profile serves for tracking information on the potential additional funding that the funding agency plans to provide e Sector Profile serves for tracking information on the sectors All applications contain a built in online data entry possibility which is designed to allow entering the corresponding data online from your web browser Internet Explorer The DAD consists of the following main sections e MY PORTFOLIO MODULE used for quick access to the projects registered in the DAD system by the user s group e DASHBOARD MODULE used for quick access to the projects registered in the DAD system LIST MODULE used to create and execute ad hoc queries on the data and acquire results in form of a list e CHART MODULE used to filter and display the data in a chart form e MODULE used to filter and display the data in a map form e REPORT MODULE generates complex reports over one or more criteria and presents the output in the printable and user friendly format The DAD ma
78. ly mode which means it cannot be modified in any way when editing the project details However in case changes in these data are required you will not have to create a new project and pass the submission procedure again Instead you can move the submitted project back to drafts using the 8 Move to Drafts button and make the necessary changes Please note that after finishing you will have to re submit the project Note This option is available to the users with administrative rights only 5 4 Viewing Project Details Depending on your permissions you may also see or edit projects added by other users To view details of drafts and submitted projects in the My Portfolio module follow the steps below 1 2 to Portfolio module Expand Drafts or Submitted Projects list correspondingly Figure 6 Click on the project you wish to see the details for This will open project details For details see DETAILS SECTI ON 5 5 Filtering Projects in My Portfolio You may perform advanced search among the draft and submitted projects in My Portfolio module using the following criteria Funding Agency returns the projects funded by the selected funding agency 151 Level Implementing Agency returns the projects implemented by the selected 1 Level Implementing Agency DAD CAMEROON ANALYTICS USER MANUAL 15 9 2nd level Implementing Agency returns the projects implemented by the selected 2 Level Implementin
79. mize button A new section will appear displaying all customizable options in the Dashboard module Figure 12 2 Take the necessary action 3 Save changes DAD CAMEROON ANALYTICS USER MANUAL 21 dad support minepat qov cm Contact us Tel 1237 22 22 41 21 My Profile About Help Log Off DAD CAMEROON 55 Dashboard Dashboard1 Dashboard modified Save Save as New Cancel Add New Item Dashboard1 Public Scroll Mode L DGPAT PROJET LOCALITE PLANIFICATION Project gt v Action financi re des bailleurs Project Bais oY Sees ee eee x O0 Unspecified ooo y 24 DPPP ETAT IMPLEMEN Unspecified ai Ei CAA MONTANTS ET DATES MEE E4 PTF PART FINANCEMENT PA mS Heind d 5 DSCE CONTRBUTON_ M s 7 Bi ETAT DU PORTE E s TS 3 9 24 TOFE niveau decaisseme E 5 lt E4 Default View Project E DGB DPI Prevision engagements pour annee 1 Project project funding agency Project E project sector Project uu 4 2 au I m aram Sector Project Project Title lig comparaison d caisse recep d v Unspecified Drag and drop the desired component onto 28 s d ertise et de Renforceme es CAM 00062 Fonds d Expertise et de Renforcement des 8 the dashboard screen CAM 000749 Don hors projet du Japon Education Fonds d Expertise et de Renfor
80. nent Cameroon 12 100 000 5 352 241 400 Let tavel implementa des capacit s environnement et sociales dans le secteur de 21 040 000 9 304 707 360 Implementation Status RENE sector Projet dragage d epprofondissement du d acc s su port de Douala 39 090 000 14 713 110 009 Resign Projet de d veloppement rural Participatif et d certralis de Grassfields GF 120 000 000 69 014 084 000 Funding Agency CERUDEF More titers Projet de r habilitation du pont de l Enfance sur le fleuve Sanaga 16 000 000 6 722 561 600 ao Projet de D veloppement Urbain et de l approvisionnement en Eau POUE 265 000 060 108 265 350 000 612 Projet d Appui Programme Sectoriel For ts et Environnement 120 090 000 6 573 892 009 Projet de Renforcement et d Ameliceation de l Alimentation en Eau Potable de la n nna non ville de douala lere phase 60 000 000 29 990 340 000 Programmes d Ameliarsbon de la Programmaton des D penses Publiques 5 662 514 2 623 834 088 DPI DIP Prevision 5 amp 1 Comgpetitive value chains project PCFC 35 900 000 17 606 699 300 DPPP ETAT IMPLEMENTAIO 0616 s curit et de suret du transoort arrien en Afrique de l ouest et du 33 570 000 1817220815 centr C PROJET LOCALITE PLANT 0002 Projet d Appui la Modernisation du Cadastre et au Climat des Affaires
81. ns View Criteria ist Level Implementer v Filter by i Rove Project Y Add Column Implementation Status Sector Reqion Sector Funding Agency L d x Data ist Level Implementer Funding Agency Add Row More Filters i Footer III Reset Submit PREVIEW ist Level Implementer Sector Funding Agency Project 1 Project 2 Sector 1 Funding Agency 1 ist Level Implementer 1 ist Level Implementer 1 1st Level Implementer 2 FT ist Level Implementer 1 ist Level Implementer 1 Figure 45 Reports Window with Properties Focus on the Title Field The Properties window will appear Please note that for text entries the Properties window includes text formatting buttons and a text area Figure 46 For other report components like rows columns etc the Properties window also allows assigning additional characteristics e g sorting order reference text etc Figure 48 DAD CAMEROON ANALYTICS USER MANUAL 62 Preview Text Figure 46 Formatting Styling Text Entries 3 Change the properties as needed Note To prevent you navigating away from the section every time when modifying the properties of a different report table component the Properties window allows selecting the next item to be modified To do that you need to select the appropriate Instance from the Items drop down list in the Properties window The list contains the previously select
82. o identify the patterns or colors that are assigned to the selected categories Figure 32 It is worth mentioning that each data series or category is represented by a unique pattern or color in the map legend which is displayed in the following ways e n Legend section if you have chosen to apply any category to the map e At the bottom left side of the map if you have selected to view data on the scaling map dad support minepat qov cm DAD CAMEROON Contact us Tel 237 22 22 41 21 Profile About Help Log Off mm My Portfolio 55 Dashboard List Ma b Project Development Partner Profile Zoom to est 60 Piethart Sector Profile Info C None i Nation Wide Implementation Status Advanced Search N x F420 Funding Aqency Remove Filters Scaling View Criteria J Chart Filter by 1 of Proiects ist Level Implementer 1 Proiect Cost USD Implementation Status Project Cost 1 Government Contribution USD egion 1 Government Contribution XAF Funding Agency More Filters e Chart Implementation Status D Education 8 Governance 1 Health project funding agency Industry and services e project sector Infrastructures e Rural 7 Social Unspecified COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 32 Viewing Chart Legend DAD CAMEROON ANALYTICS USER MANUAL 48 9 4 6 Usin
83. ogram Phase 2 Thierry Herv Jackson 19 Aug 2011 28 Feb 2011 NGWA EDIELLE MINEPAT CAM 000722 Projet d am lioration de la desserte en eau potable Yaound Bertoua Ed a et Ngaound r Pierre Dynamo FOTSING 18 Aug 2011 26 Feb 2011 MINEPAT CAM 000636 Protection et Gestion du Complexe transfrontalier du Tri National de la Sangha Pierre Dynamo FOTSING 18 Aug 2011 27 Nov 2010 MINEPAT CAM 000632 Protection des Gorilles de la For t de Deng Deng Pierre Dynamo FOTSING 20 Aug 2011 27 Nov 2010 1 2 Next COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS Figure 7 Filtering Projects in My Portfolio To clear the filtering clear all criteria and press the GO button again DAD ANALYTICS USER MANUAL 16 6 DASHBOARD MODULE Reporting requirements have changed dramatically over the past few years Nowadays it is not enough to be able to produce a report to analyze data but it is more essential to have a reporting tool that will allow for a visual display of the most important information consolidated and arranged on a single screen so that real time data can be monitored at a glance As a comprehensive reporting tool DAD removes the limitations on report development giving the possibility to view various types of reports such as lists maps and charts displayed in a user friendly environment a dashboard Unlike regular reports dashboards provide visual at
84. on the Chart tab The Chart module appears where a pre defined chart is displayed DAD CAMEROON ANALYTICS USER MANUAL 32 8 3 Main Screen and Its Components My Profile About Help Log Off DAD mm My Portfolio Dashboard Chart gt gt Project Main 7 View Development Partner Profile s Sector Profile Category Funding Agency v ShowTop 10 Values Government Contribution USD 3 Series v Show Top chart Tyee i ua m woo ES update Reset Remove Filters View Criteria 200 000 000 Filter by ist Level Implementer Implementation Status 160 000 000 Sector Region Funding Agency More Filters 120 000 000 G6 Flux financier par secteur SCE 80 000 000 G5 Flux financier par r gion G4 10 des multilat raux ol G3 Top 10 des bilat raux al G2 Flux financier par type d oganisme G1 Flux financier par type d orqanisme 0 comparaison d caisse recep d pense projets Cout total des projets par secteur rapport bailleurs etat distribution de cout par region 40 000 000 Other EximBank China AFD French De ADF African D IDA Internati EU European U BADEA Arab Ba BID Banque Is OFID Fonds de GTZ German Ag FKDEA Fonds K Figure 23 Main Screen of the Chart Module 1 Category allows selecting one of the options provided
85. roject sector Expended Government Committed USD Government Committed Government Disbursed XAF View Projects 500 km 200 mi COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 34 Viewing the Data Displayed on the Map Alternatively you can choose to view the project information referring not to a specific territorial unit but to the whole country For this purpose you will have to point the mouse cursor on the i button in the Nation Wide section Note Clicking the View Projects link at the bottom of the information window will take you to the Details section of the application For more information about the actions that can be taken in this section see DETAILS SECTI ON 9 6 Sample Map Reports In the following chapters you can see several samples on maps 9 6 1 Sample Map Report 1 You will get the following map report if you have selected the I mplementation Status as a map Category and opened the Legend panel Figure 35 DAD CAMEROON ANALYTICS USER MANUAL DAD CAMEROON mm My Portfolio Dashboard gt Project Development Partner Profile Sector Profile Remove Filters View Criteria Filter by ist Level Implementer Implementation Status Sector Region Funding Agency More Filters Chart Implementation Status e project funding agency e project sector dad support minepat gov cm 22 41 21 Contact us Tel 237 22 Zoom to est P
86. row column compatibility matrix Remove Filters View Criteria i G Contact Filter by Financial Implementation Status _ General Sector i Project Important Dates Funding Agency Organisations Agencies ist Level Im lementer Paris Declaration Indicators gt Sector Location gt Project Project 3 Fd Implementation Status Funding Agency Activit ist Level Implementer ae edie I 2nd Level Implementer Odi RE Sector Outcome Indicator Region Probability to Occur Department Risks Pro Factor Causing Delay DD Millennium Development Goals MDGs Year Month Year Report Preview Figure 38 Selecting a Grouping for a Report Note At any point it is possible to remove all components selected for the report and design a new report from scratch by clicking on the Reset button Note If you have defined a report which has incompatible columns columns over which reports cannot be generated they will be marked in red and an error message will occur To make your reports productive use the link as marked in red Figure 38 to open the Compatibility Matrix table Figure 39 This is a table that displays the compatibility between all categories and measures in the database to display them in the report DAD CAMEROON ANALYTICS USER MANUAL 55 Compatibility Matrix e indicates compatibility between Category and Measure Rows
87. rs View Criteria Filter by Implementation Status Sector Region Funding Agency ist Level Implementer Y More Filters DGE DGB DPI BIP Prevision DGE DPPP ETAT IMPLEMENT E DGPAT PROJET LOCALITE PL MONTANTS ET DATES t PTF PART FINANCEMENT CTSE DSCE CONTRIBUTION 1 DGCOOP ETAT DU PORTE DGT niveau decaisser Figure 61 Search Results DAD ANALYTICS USER MANUAL 82 15 LOGGING OUT Once you have finished using the DAD application it is necessary to log out In order to log out from the application press the Log Out button in the upper right corner of the application window 16 REFERENCES Please refer to the following DAD Cameroon related documents DAD Cameroon Project Application User Manual DAD Cameroon Development Partner Profile User Manual DAD Cameroon Sector Profile User Manual DAD Cameroon Administration Center User Manual
88. rtner Profile Zoom to Go Pie Chart v Sector Profile nfo Adamaoua ursor position Lat 7 83 Long 19 31 Advanced Search Remove Filters View Criteria Filter by ist Level Implementer Implementation Status Sector Region Funding Agency More Filters Chart Implementation Status project funding agency project sector Figure 30 Buffered Zone Querying 9 4 4 Using Layers The Layers feature in the Map Module provides a variety of data to select to display over the viewing area You can use the Layers feature to display the following information Display categories Choose to view data on a scaling map Plot data in the form of different graphs pie chart or bar chart Display map features such as department or commune borders The following layers can be applied in DAD Categories This option is used to plot category data on the map and to view them in form of different icons images To enable this option expand the Category section and selecting the category ies listed Note When pointing the mouse cursor on a respective icon image on the map you can view the details for the selected category DAD CAMEROON ANALYTICS USER MANUAL 46 Scaling This option is used to view the data on a scaling map This means that the selected data series will not be displayed in form of graphs but the administrative territories will be colored according to the selected scaling category ins
89. ry In order to access the Map module of the system click on the Map tab You will be navigated to the Map module where the map of the country is displayed In the Map module you can choose to view different data sets displayed on the map create and display reports save them as pre defined reports arrange them in the desired way print them etc 9 3 The Map Module Screen Components The following section describes some of the features available in the main screen of the Map module Figure 27 10 Zoom to panel allows free zooming to the desired administrative unit region department or commune Chart type selector allows defining whether the data should be presented in form of a pie chart or a bar chart when plotting graphs on the map Navigation controls a set of tools that provide common navigation functions such as panning and zooming Map the map of the country Nation Wide displays the project information referring to the whole country upon mouse over action Scale Bar allows you to work out the distances on the map The distances are expressed both in the metric and English units of measure Mini Map an overview map of the entire country displayed in a small window allowing quick navigation to a desired location with one click without having to zoom out find the new location and zoom in again Layers Panel provides a variety of data to choose to display on the map Legend Panel explains the ca
90. shboard by clicking OK in the warning message window that appears 6 4 7 Update Data For decision makers it is very important to have access to the latest data available This is why the Dashboard module allows you to update all reports included in various dashboards In order to load the latest data from the database select the Update AII option If you want to update the data in an individual report click Refresh button in the top toolbar of the report screen The latest data for the selected report will be loaded from the database DAD CAMEROON ANALYTICS USER MANUAL 7 LIST MODULE 23 In the List module Figure 13 of the DAD Cameroon application you can create and execute ad hoc queries on projects data and acquire results in form of a list My Portfolio 55 Dashboard List List gt Project Development Partner Profile Sector Profile Sector Project dad su Contact us Tej 493 ort minepat 22 22 412 Project Title 4 of Projects My Profile About Help Log Off g Hide Images Save Modify Current View Project Cost USD Project Cost Su an c Social 15 132 776 763 73 178 763 125 Rural 35 754 584 331 625 803 587 412 EEE Infrastructures 51 8 444 525 876 2 272 474 298 245 Industry and services 4 42 294 549 20 707 463 948 13 107 524 490 58 066 109 114 ft Go
91. t tables To add a report grouping click on the Add Grouping link in the Group Report by section and select the appropriate category from the menu that appears Figure 38 Note The report will be divided into as many tables as there are table groupings selected 4 Select table rows by clicking on the Add Row link and selecting the appropriate item from the menu that appears Please note that it is possible to select one row at a time from the list of available rows 5 Select table columns by clicking on the Add Column link and selecting the appropriate item from the menu that appears Please note that it is possible to select one column at a time from the list of available columns Note Once you have selected a report column Add Sub column link becomes available under the selected column It allows indicating how the row details displayed under each column will be divided DAD CAMEROON ANALYTICS USER MANUAL 54 dad support minepat qov cm Contact us Tel 1237 22 22 41 24 My Profile About Help Log Off DAD CAMEROON My Portfolio FH Dashboard Report gt ER X DESIGN gt Project Development Partner Profile Sector Profile i Title Y i Subtitle i Advanced Search Choose and structure the information you wish to report on in the table below Expand the Preview section to view the final look and structure of the report Click here to view
92. tailed down to the district level Moreover the GIS tool offers an impressive array of state of the art advanced GIS features such as the ability to zoom freely to select a point on a map and ask the system to display any category of data within a given radius buffered zone querying ai dad support minepat gov cm Contact us Tel 227 22 22 41 24 My Profile About Help Log Off DAD CAMEROON mm My Portfolio Dashboard gt Project Development Partner Profile Zoom to GO Pie Chart v Cursor position Lat 4 44 Long 20 16 Sector Profile Categories Scaling i Nation Wide Chart Borders Remove Filters View Criteria Filter by ist Level Implementer Implementation Status Sector Region Funding Agency More Filters project funding agency i Adamaoua e project sector 200 km 200 mi Select Zoom by Selection ini Distance Mio Map Buffered Zone Query Figure 27 Map Module COPYRIGHT 2012 SYNERGY INTERNATIONAL SYSTEMS INC 9 1 Key Features of the GIS Tool Below are the key features of the GIS tool in the DAD application e Vector based platform e Multi layer mapping Dynamic number of administrative territorial units DAD ANALYTICS USER MANUAL 40 Category or Indicator data Static Data Borders Cities Rivers Roads Construction Sites etc Names and Labels Any other type of layer e Data visualization
93. tead The scaling legend at the bottom left side of the map prompts on the coloring pattern used To enable this option expand the Scaling section in the Layers panel and select one of the possible alternatives listed Chart You can plot different data series on a map and view them in the form of different graphs such as pie charts or bar charts You can turn on this option by expanding the Chart section in the Layers panel and selecting the chart category ies to be displayed on the map By default the selected category ies will appear in the form of a bar chart However you can choose to view the data in form of a pie chart by selecting the appropriate option from the Chart Type drop down Figure 31 Note When pointing the mouse cursor on any of the chart constituents you can view the data that stands behind it The details on plotted chart categories are displayed when clicking the i button ad support bminepat qov cm 05 Tel 237 22 22 41 21 DAD CAMEROON Contact us Tel 237 22 My Profile About Help Log Off mm My Portfolio 55 Dashboard List Ma b Project Development Partner Profile Zoom to est GO Pie Chart Sector Profile Info Cursor position Lat 5 30 Long 19 53 Categories None i 3 Nation Wide C Implementation Status C Sector e C Funding Agency ist Level Implementer Remove Filters Scaling View Criteria Filter by e 7 4 of Proi
94. tegories and data series displayed on the map Location information section displays the name of the administrative unit when it Is pointed on the map DAD CAMEROON ANALYTICS USER MANUAL 42 11 Cursor position section displays the geographic coordinates expressed as latitude and longitude for any point on the map 9 4 Working in the Map Module 9 4 1 Zooming in Zooming out The GIS tool is equipped with the advanced zooming capabilities used to enlarge or reduce the view of the map on the screen The following zooming options are available Free zoom in zoom out This option allows you to easily explore the data through Intelligent Searching You can enter any combination of letters in the Zoom to panel and select the administrative territory district to navigate to from the list containing the search results Figure 28 The selected item will be magnified and displayed in the main screen Profile About Help Log DAD CAMEROON L My Portfolio Dashboard List Ma b Project Development Partner Profile Zoom to est Pie Chart v Sector Profile gom Est Nord Ouest at Long 11 49 Categories Quest Scaling Sud Ouest i 4 3 Nation Wide Commune West Coast Idenau Borders Chart Remove Filters View Criteria Filter by ist Level Implementer Implementation Status Sector Region Funding Agency More Filters e Chart Implementation Status
95. teur Project a 1 m M 3 th L z 15 f gt U I P 0 E 3 m LAT i 1 2 Rural Social Health Governance Education Unspecifi Unallocated Infrastructures Industry and se Figure 8 Dashboard Module e Dashboard Selector contains a list of pre defined dashboards By choosing definite dashboard from this list you can view the reports stored in the selected dashboard e Customize allows performing the following operations displays the dashboard name Save saves a dashboard so that it can be shared with other users Save as New saves a dashboard as a new one This option is especially useful if you need to make modifications in a definite dashboard while keeping the source information intact This way overwriting of the original dashboard is prevented Remove deletes a dashboard together with its contents e Cancel discards the modifications made to the dashboard currently displayed on the screen e Update all loads the latest data from the database e New creates a new dashboard e Add New Item adds a new report under the definite dashboard from the list of all pre defined reports previously created e Dashboard Workspace the main screen of the Dashboard module where the content of a definite dashboard is viewed DAD CAMEROON ANALYTICS USER MANUAL 18 6 4 Dashboard Management 6 4 1 Create
96. the data referring to definite territorial units departments communes when zoomed in to this level In order to access the data for a specific territorial unit point the mouse cursor the lil button Figure 34 The information in the displayed tooltip includes but is not limited to the number of projects being DAD CAMEROON ANALYTICS USER MANUAL 49 implemented some financial information etc If you have plotted any chart category on the map the chart category details appear in the information window as well dad support minepat qov cm US Tel 4237 22 22 44 24 My Profile About Help Log Off DAD CAMEROON m Portfolio Dashboard gt Project Development Partner Profile Sector Profile Info Nord Zoom to est Pie Chart xul Cursor position Lat 8 39 Long 14 14 Categories Scaling N 2 Nation Wida mE U a Borders of Projects 28 572 799 27 we 5 3 90 Y Project Cost USD Remove Filters View Criteria 4 Project Cost XAF Government Contribution USD Filter by Government Contribution X AF ist Level Implementer 1 USD Implementation Status A d c Sector hore lisbursed USD Funding Agency al More Filters ement XAF PUBLIC MAPS 0000000000000 lisbursed XAF teceived USD eceived XAF chart Implementation Status i ain project funding agency p
97. tor Renforcement des capacit s des prestataires de services nationaux pour CAM 000696 x n z s r la sant de la reproduction eii iic unding Agency 3 5 sya s E wal 000693 des capacit s nationales pour la r duction de la mortalit 3 252 799 1 568 265 476 More Filters e 000629 Renforcement des capacit s nationales pour I int gration de POP DEV 740 000 369 880 860 dans les plans de d veloppement PUBICVIEWS 000688 Programme Enfant VIH SIDA 2008 2012 12 362 500 6 179 259 638 CAM 000687 Programme Education de Base 2008 2012 12 362 500 5 614 318 113 000686 Programme du jeune enfant 2008 2012 19 312 500 8 770 598 063 CAM 000684 iti i i w E DGE DGB DPI BIP Prevision Programme Politiques Sociales et Partenariats 2008 2012 4 565 000 2 073 153 665 E 000679 Cameroon Millenium Villages Program Phase I 8 519 250 3 947 557 205 DGE DPPP ETAT IMPLEMENTA CAM 000627 Fonds d Expertise et de Renforcement des Capacit s 7 1 840 266 895 694 377 DGPAT PROJET LOCALITE PLA 000620 Projet d appui aux investissements dans le secteur de la sant PAISS 25 000 000 10 504 002 500 E CAA MONTANTS ET DATES c 29 181 063 504 120 930 160 292 E PIF PART FINANCEMENT PAR 2 Education 10 126 335 016 147 586 357 733 crsE DscE CONTRIBUTION Unallocated 0 0 pGcooP ETAT DU porte
98. ues can be displayed their format the number of the items to be displayed etc You may also re organise the reports in the desired way i e include it into a group of reports or create a new report group for it rename the report etc The DAD application can also export the reports to the desired format Word Excel etc or print them out 12 1 Setting Report Options In the List Chart Map and Report modules you can set the report options i e define whether the numeric values should be displayed in thousands millions etc In the Chart module you can also indicate the number of items to be displayed on the chart In order to set the report options follow the steps below 1 Click the 27 Set Options button in the top toolbar An Options window Figure 53 will appear 2 Define the format in which the numeric values should be displayed i e whether the original values should be displayed or they should be shown in thousands millions etc This prevents large numeric values represented by many zeros from taking a lot of space in the report 3 For charts indicate the number of items to be displayed on the chart by selecting the appropriate value from the relevant pull down list Show numeric values in original OK Cancel Figure 53 Setting the Chart Report Options 4 After finishing click the OK button for the changes to take effect Or click the Cancel button to discard the changes made DAD
99. vernance 29 181 063 504 120 930 160 292 ar Education 10 126 335 016 147 586 357 733 Filter by xd Unallocated 1 0 0 Implementation Status Sector ar Unspecified E 79 632 386 37 423 587 597 Region Funding Agency Total 142 9 721 621 494 3 287 932 694 440 1st Level Implementer More Filters Results 1 9 of 8 DGB BIP Prevision DGE DPPP ETAT IMPLEMENTA B DGPAT PROJET LOCALITE PLA CAA MONTANTS ET DATES PART FINANCEMENT CTSE DSCE CONTRIBUTION DGCOOP ETAT DU PORTE FEU niveau decaissemt Figure 13 List Module 7 1 Accessing the List Module A list consists of at least one group and one column but the actual quantity of groups and columns is defined by the user s choice of view Please see Modifying the Current View for more details on how to define groups columns of a list In order to access the List module click on the List tab You will be navigated to the List module In this module you can view data organized according to the selected groupings and columns modify the currently used list save it as a pre defined report include it under a definite group print it etc DAD CAMEROON ANALYTICS USER MANUAL 7 2 Expanding the List tem 24 It is possible to expand the list item level to view the information of the sub level s In order to expand the list item level click on the sign next to the name of the list
100. yed DAD CAMEROON ANALYTICS USER MANUAL 5 MY PORTFOLI O MODULE 12 The My Portfolio section Figure 5 of the DAD application provides quick access to the projects added by the corresponding user In order to access My Portfolio module click on the My Portfolio tab in the Main Menu of DAD application The list of draft and submitted projects will be displayed on the screen The information displayed in My Portfolio for each project includes the following information e Project ID the project ID Project Title the title of the project Updated By last update author Updated On last update date Funding Agency Submitted On the date of the project submission DAD CAMEROON J My Portfolio dad support bminepat qov cm 55 Dashboard Create New Project Funding Agencies Reference Number DRAFT DRAFT DRAFT Reference Number CAM 000768 CAM 000767 CAM 000766 000765 CAM 000764 CAM 000763 CAM 000762 CAM 000761 CAM 000760 CAM 000759 1st Level Implementer 2nd Level Implementer First Level Implementers Second Level Implementers Project Title Programme national de lutte contre le Paludisme PNLP GEF SMALL GRANTS Program Construction de l usine de traitement d eau Ayatto adoss e sur le fleuve Moungo Am nagement hydro lectrique de Lom Pangar Project Title Accord de coop ration financi re 2010 Accord

Download Pdf Manuals

Related Search

Related Contents

HP Deskjet 1510 series - produktinfo.conrad.com  • Manual de instrucciones. • Manual de instruções • Mode d`emploi  Pelco DD5L User's Manual  MANUAL DEL USUARIO - Besøg masterpiece.dk  

Copyright © All rights reserved. Failed to retrieve file