Home

DAD Sierra Leone User Manual

1. 46 FIGURE 31 VIEWING CHART LEGEND counter code deesbeceeens 47 FIGURE 32 USING MINI seadzesstacdssnsaastgsolonodossvandeasuscacdsuobaadeubesonouasbauceasusoncdoaetasdeusesonguesoseuseabotonoes 48 FIGURE 33 VIEWING THE DATA DISPLAYED ON MAP sccccccccccccccccccccstsesseeeccccccccccccececassatsssseeececceecs 49 FIGURE 34 gt SAMPLE MAP eee ee ade e iota urbana de sees dea cun eut ER 50 FIGURE 35 SAMPLE dedi ctae ees des do uto shausbasealessiustausbabeatesslastaus aS dul 51 FIGURE 30 REPORT MODULE aces NUT TU T S 52 FIGURE 37 SELECTING A GROUPING FOR A REPORT ssssssssseeececececccccceccccccccssssseceecececcccccscaaacccsssstseceeeceeecs 54 FIGURE 38 COMPATIBILITY MATRIX isch dives cotes meteor pus dod ede dreruas vates eu eere ta od rre doas eaa e duo Da aod ad ovp tudo 55 FIGURE 39 PREVIEWING THE REPORT anui anc de Li su aea 56 FIGURE 40 CREATENG A IEPORTD dne Ledesma 57 LEIGURE VES SAMPLE LIST REPORT D usc hodie hin 55 FIGURE 427 CREATING A REPOR TZ E ve LEO LER E 50 FIGUBE 43 SAMPLE EIS TTREPORT Zio ageossingeseesaue
2. Lj DEVELOPMENT ASSISTANCE DATABASE FOR SIERRA LEONE DAD SIERRA LEONE ANALYTI CS USER MANUAL Version 1 1 VaSYNERGY INTERNATIONAL SYSTEMS DAD SIERRA LEONE ANALYTICS USER MANUAL 1 TABLE OF CONTENT 1 EN ERODUG es ee ee va fetu oup Md sve v2 a dou oua 6 De OVERVIEW 6 3 LOGGING INTO DAD SIERRA LEONE 7 3 1 REGISTERING A INEW LISER 5 oe ass 8 3 2 DAD WITHOUT REGIS TRATION so ee etek it ded nna AUR CETUR eee 9 4 DAD ANALYTICS STRUCTURE incisis auictinteissieiactties 10 5 MY PORTFOLIO MODULE vicvecvvcissccaccciicicenisinincecsesaricdcccduccddeciseciscuiudesdusavccbecetwisssvinvediiniuddcdsiseccbsssixisteweds 12 5 ADDINGINEWPRO EG T2 24 ettet tette diet den et et toit 13 52 VIEWING PROJECT a N 14 6 DASHBOARD MODULE idi need ers deve eie Due De iu eeu eod rededeuv ovs du Dub veda eet uel esbu dou vea dude Peu Udo d 15 6 1 KEY a O e e unb Eust ipei E Pru d ei eal tee fe Ear 15 6 2 ACCESSING THE DASHBOARD MODUDE 2 eati tot ee eedem en eec Sob cuta Eosdem tatu 15 6 3 MAIN SCREEN AND L TS COMPONENTS itte t peo toI pep be te San Saee ponto Eee ec pa ante un vv pato 16 6 4 DASHBOARD MANAGEMENT ted sd e e PEU ted de
3. Figure 37 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 37 to open the Compatibility Matrix table Figure 38 This is a table that displays the compatibility between all categories and measures in the database to display them in the report DAD SIERRA LEONE ANALYTICS USER MANUAL 55 Compatibility Matrix e indicates compatibility between Category and Measure Rows Categories Columns Measures Beneficiaries Households KPI Progress Modified by Modified on Project Code Project Title Beneficiaries Total of of Beneficiaries Children of Female of SLL USD Created by Created on SLL USD Duration End Date KPI Target Last Last SLL USD Start Date Assistance Type Assistance Type Modality Chiefdom District Donor Agency Donor Agency Type Donor Reference Number Factor Causing Delay Funding Source Implementation Status Implementer Implementer Type ls on budget off budget Key Performance Indicator Month Year ee e ee 99 0 o 996 0 0 9 9 9 iotproects National Partners Project 6 a a
4. Project Details by Donor and Sector E Implemell Sorting Order v Disbursed USD Sector v Province 1 Rows Total Add Column A Add Sub c Add Sub column Add Sub column Add Sub column Lis C E Project not ats Data 3 Add Row Date xim E O a ot Move Right Remove i Footer Move To b o Replace M pi Switch Place With Reset seers 5 PREVIEW Donor Agency 1 Donor Agency 2 COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS IN Figure 46 Reports Window with Properties Focus on the Column DAD SIERRA LEONE ANALYTICS USER MANUAL 63 Committed USD Show As Numeric Value Append After the value P Gort By Mone Caption committed USD Font i Reference Ref Text 5 Expression Expr Member 1 Committed USD Operation Expr Member 2 Select a member Cancel Figure 47 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 displa
5. imgaplarmanmer Car mimed USD USO Community Action for Aural Cavalapmant DIARD L 1 x FC 1 805 248 ee Capacity Building of government agencies Unspacified Comminniby Achion Far Rural Dus sermant f FCAR ELI 7 436 450 6 563 942 013 Capacity Bulld ng of government agencies HATIOMWIDE DAmrmistik Ahan far Hura Daceleamant CARDS Li Lu egean nien EU Figure 43 Sample List Report 2 10 6 Customizing Reports 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 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 44 DAD SIERRA LEONE ANALYTICS USER MANUAL 61 z support synisys com Contact us 4 525 55 225458 9 My Profile About Help tLogO Me DAD SIERRA LEONE My Portfolio Dashboard Kapan ae a DSC osue Remove Filters View Criteria i Header Filter by Choose and structure the informat
6. Delete 1E Add Group als Mowe Up IL Mowe Down Figure 54 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 AUNE Click the Enter keyboard button to confirm renaming Note Public Reports and My Reports groups cannot be renamed 12 3 2 Deleting Reports or 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 SIERRA LEONE ANALYTICS USER MANUAL 73 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 Chart Map and Report Modules From the Chart Map and Report modules you can design appropriate reports and export them in the PDF MS Word and MS Excel forma
7. My Profile About Help Log Ofi sd DAD SIERRA LEONE My Portfolio Dashboard Chart ees AL A LL Advanced Search Category Donor Agency vy Show Top 10 55 Values of Projects v mass amp Serasi Bub z Remove Filters Chart Types E lE uS H P Char Count 15 x Update View Criteria Filter by Funding Source Funding Source 240 Donor Agency Implementer District Chiefdom More Filters 200 160 of Projects by Status of Projects by Donor and Sect Donor Agency Contributions aa ee a n RB eo Unspecified VVillamette Medi Association For Community Actio Diakonia Interd Assemblies of G Cotton Tree Fou Ben Hirsch Chil Community Actio European Union COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 22 Main Screen of the Chart Module 1 Category allows selecting one of the options provided 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 DAD SIERR
8. justice Sector Development 326 811 300 186 653 412 E projects by Location HMB os Private Sector Development 101 890 749 63 776 901 E projects by Sector 052 Youth Development 5 75 501 447 59 410 309 E projects by Funding Source 053 Agriculture Rural development and Food Security 13 390 546 706 318 082 355 i 054 Infrastructure 7 440 761 850 260 849 169 081 Health 9 521 770 075 414 040 951 Y 082 HIV AIDS 1 15 070 561 14 890 561 Di 093 Education 3 66 629 532 59 749 089 BRI 084 Water and Sanitation 3 8 336 202 2 413 959 HP ogs Environment 1 30 014 100 10 099 488 Total 59 2 162 625 245 1 456 630 431 Results 1 3 of 3 COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 60 Search Results DAD SIERRA LEONE ANALYTICS USER MANUAL 81 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 Off button in the upper right corner of the application window 16 REFERENCES Please refer to the following DAD Sierra Leone related documents e DAD Sierra Leone Projects Application User Manual e DAD Sierra Leone Administration Center User Manual
9. 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 Footer a text box to insert a portion of text that will appear in the bottom area of the chart report 5 Subtitle a text box to enter a subtitle for the chart report 6 Font allows selecting the font the chart report title subtitle footer note will appear in 7 Size allows selecting the font size the chart report title subtitle footer note will appear in 8 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 Commitments and Disbursements Distribution by Top 10 Sectors If you have selected the Sector as a chart Category and Committed USA Disbursed USA 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 option in the View window the following chart report will appear Figure 24 DAD SIERRA LEONE ANALYTICS USER MANUAL 36 Me DAD SIERRA LEONE My Portfolio Dashboard E Main View Advanced Search Category Sector v Show Top 10 Values Committed USD Disbursed USD v _ Secondary Axis 5 Update Remove Filters Chart Types l tb E t 4 Char Count 15 View Criteria Filter by 560 000 000
10. 987 852 29 627 855 45 257 659 797 967 999 103 012 023 93 764 766 115 892 830 1 499 737 451 Results 1 2 of 2 COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 21 Sample View 2 DAD SIERRA LEONE ANALYTICS USER MANUAL 30 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 s 8 2 Accessing the Chart Module As it has been stated above the system provides for the opportunity to present data in the form of different charts In order to access the Chart module of the system click on the Chart tab The Chart module appears where a pre defined chart is displayed DAD SIERRA LEONE ANALYTICS USER MANUAL 31 8 3 Main Screen and Its Components
11. Cotton Tree Foundation Sierra Leone 101 682 058 75 221 954 E Council for Human Ecol in Sierra Leone 45 937 920 29 801 872 WT Diakonia Interdenominational Services for Counselling Evangelism and Teaching DISCET 3 484 124 3 484 124 European Union EU 350 000 Evangelical Fellowship of Sierra Leone 15 000 15 000 85 Handicap International SL 2 045 000 2 045 000 t Kenema District Association Restore Hope 5 860 369 4 779 927 lE willamette Medical Teams IMT 65 189 669 61 261 270 Main Menu Remove Filters Manipulation View Criteria Buttons E Projects by Location Projects by Funding Source Main Menu Bar Total 636 2 333 092 807 1 499 737 451 Results 1 23 of 23 COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Work Frame Figure 4 DAD Analytics Structure It contains the following components This is the application header that contains application name and the DAD Sierra Leone logo On the right side following functions are available e Contact Us e mail address of the DAD System Administrator DAD SIERRA LEONE ANALYTICS USER MANUAL 11 My Profile this opens your personal settings and details For details see Registering a New User About opens DAD Sierra Leone about window Log Off this button is used to log out the application This is the main toolbar of the DAD application Following tabs are available here e Portfolio opens MY PORTF
12. Funding Source Sector Committed USD Disbursed USD Donor Agency Implementer 054 Infrastructure 536 760 135 387 584 765 District 490 000 000 081 Health 346 093 543 294 606 305 Chiefdom More Filters 055 Macroeconom 328 803 573 314 419 186 420 000 000 083 Education 296 863 746 139 140 014 E 00 Unspecified 227 392 596 123 735 430 of Projects by Status a 350 000 000 016 Justice Sector 145 597 788 65 805 421 of Projects by Donor and s of Projects bv Donor and Se 013 Capacity Buil 135 831 514 116 650 804 Donor Agency Contributions 012 Transparency 117 641 616 76 852 620 280 000 000 011 Public Finane 112 450 884 80 313 914 421 660 686 336 740 616 210 000 000 140 000 000 70 000 000 Other ifi 2011 SYNERGY INTERNATIONAL SYSTEMS INC Other 054 Infrastru 081 Health 083 Education 053 Aaricultu DO Unspec 016 Justice S 013 Capacity 012 Transpare 011 Public Fi 055 Macroecon Figure 24 Sample Chart Report 1 8 5 2 Sample Chart Report 2 Total Commitments and Disbursements Distribution by Province If you have selected the Province as a chart category and Committed USA Disbursed USA as values to be shown on the chart and click on the 3D 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 25 DAD SIERRA LEONE ANALYTICS USE
13. 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 e n the My Portfolio module Click the respective project You will be directed to the Details section Figure 51 e n the List module Click the project for the details to be displayed This will open the Details section of the application 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 e n 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 e n 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 2 Take the necessary actions review the provided information update and imp
14. Criteria Filter by Funding Source Donor Agency Implementer District Chiefdom More Filters Projects by Location Projects by Sector E projects b Funding Source E su Contact us Project Title Province District Chiefdom Project 4 Hide Images Unspecified 176 Unallocated 5 EASTERN 64 Eastern province wide 4 Kailahun 29 Unspecified 26 Kailahun district wide 1 Kissi Kama 1 Kissi Teng 1 Kissi Tongi 2 Promoting Agriculture SL 001079 Promoting Agriculture Governance and the Environment PAGE Governance and the Environment PAGE SL 001311 Sustainable Nutrition and Agricultural Promotion SNAP Sustainable Nutrition and Agricultural Promotion SNAP Luawa 1 Mandu 1 Peje West 1 Penguia 1 Yawei 2 Kenema 30 Kono 35 NATIONWIDE 316 NORTHERN 61 SOUTHERN 43 WESTERN 67 Total 636 My Profile amp 5 Ei Save As 29 About Help Log Of 8 us Modify Current View Committed USD 448 390 318 915 201 161 847 565 5 698 307 57 864 754 51 471 099 244 053 696 635 696 635 1 229 920 696 635 533 286 696 635 533 286 533 286 533 286 1 229 920 41 111 713 57 172 791 1 267 284 677 154 056 977 125 332 792 175 265 398 2 333 092 807 Disbursed USD 267 902 632 571 936 120 625 335 2 316 971 43 422 850 38 394 195 89 396 454 566 454 566 987 852 454 566 533 286 454 566 533 286 533 286 533 286
15. LI ST CHART MAP AND REPORT MODULES 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 values 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 List and Report Modules In the List and Report modules you can set the report options i e define whether the numeric values should be displayed in thousands millions etc In order to set the report options follow the steps below 1 Click the zT Set Options button in the top toolbar An Options window Figure 52 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 m OK Est Cancel Figure 52 Setting the Chart Report Options 4 After finishing click the OK
16. Project SASP 9 580 000 SL 001240 Construction of Primary Schools 196 968 E Projects by Location SL 001241 Oil PALM PRODUCTION AND PROCESSING 364 924 E Projects by Sector SL 001242 Rural Infrastructure Development 3 000 000 5 00 Production 200 000 E Christian Extension Services SL 2 1 490 053 6 Christians In Action Development Agency 8 23 201 360 1 Community Action for Rural Development CARD SL 55 46 149 412 3 i Community Action for Rural Empowerment 16 67 541 601 6 Community Programmes For Women 4 1 110 000 zm Conservation Society of Sierra Leone 7 24 599 409 El Cotton Tree Foundation Sierra Leone 31 101 682 058 7 EE Council for Human Ecol in Sierra Leone 6 45 937 920 2 WT Diakonia Interdenominational Services for Counselling Evangelism and Teaching DISCET 55 3 484 124 European Union EU 18 350 000 Evangelical Fellowship of Sierra Leone 3 15 000 Handicap International SL 3 2 045 000 Kenema District Association Restore Hope 5 5 860 369 8 Willamette Medical Teams IMT 111 65 189 669 6 COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 13 Expanding the List Item Level 7 3 Sorting List Items 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 red arrow that appears on the column can rev
17. Set as default for public users 4r Mowe Up IL Mowe Down Figure 15 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 L In the Available Groups Columns panel select the group column column grouping to be added to the list 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 7 6 2 Re ordering Groups Columns Column Groupings In order 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 Click the n Unselect button The selected group s column s column grouping s will be removed from the Selected Groups Columns panel DAD SIERRA LEONE ANALYTICS USER MANUAL 26 7 6 4 Setting a View as Default After making changes in the view currently disp
18. Show W Data Table Data Label Legend Pattern Blue Xu Show in Original v Title Footer E Font Remove Filters Note Subtitle v Size View Criteria Filter by Funding Source 240 Donor Agency of Projects Donor Agency Implementer Willamette Medical 111 pista Association For Rur 55 iefdom More Filters 200 Community Action 1 55 Diakonia Interdenor 55 Cotton Tree Found 31 of Projects by Status d Unspecified 28 of Projects by Donor and Sect s of Projects by Donor and Sect European Union Ellie Donor Agency Contributions Ben Hirsch Child Cz 17 Community Action 1 16 lt Other 244 HHHHnnn ann ion VVillamette Medi Association For Community Actio Diakonia Interd Assemblies of G Cotton Tree Fou Unspecified European Un Ben Hirsch Chil Community Actio COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 23 View Screen of the Chart Module 1 Show allows selecting one or several of the following options DAD SIERRA LEONE ANALYTICS USER MANUAL 35 e Data Table presents the information contained in the chart in a grid or matrix Data Label shows the actual values of each chart cell 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
19. Sierra Leone 7 24 599 409 Projects by Sector Cotton Tree Foundation Sierra Leone 31 101 682 058 75 221 954 EB Council for Human Ecol in Sierra Leone 6 45 937 920 29 801 872 WE Diakonia Interdenominational Services for Counselling Evangelism and Teaching DISCET 55 3 484 124 3 484 124 European Union EU 18 350 000 MYVIENWS 000005 Evangelical Fellowship of Sierra Leone 3 15 000 15 000 86 Handicap International SL 3 2 045 000 2 045 000 ar Kenema District Association Restore Hope 5 5 860 369 4 779 927 BB Willamette Medical Teams IMT 111 65 189 669 61 261 270 Total 636 2 333 092 807 1 499 737 451 Results 1 23 of 23 COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 12 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 7 2 Expanding the List Item It is possible to expand the list item level to view the information of the su
20. button for the changes to take effect Or click the Cancel button to discard the changes made DAD SIERRA LEONE ANALYTICS USER MANUAL 70 12 2 Saving reports List Chart Map and Report Modules 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 1How to Save New Reports From the List Chart Map and Report modules you can design an appropriate report and save it In order to save the report created follow the steps below 1 Click on the Save button on the top right side of the screen A Memorize Report window Figure 53 will appear 2 Define the report name in the Memorized Name field Include under the following Group PUBLIC VIEWS Include cu rrently selected filters Figure 53 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
21. by Fund e UN Projects 200 km 100 mi COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 27 Intelligent Searching 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 DAD SIERRA LEONE ANALYTICS USER MANUAL 43 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 7 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 the map To do this click EA button select the point on the map and drag the mouse to the second point to trace a path to measure Figure 28 The measured distance will be expressed both in metric and English units of measure Note Measuring is calculated using the latitude and longitude coordinates from
22. cannot be changed DAD SIERRA LEONE ANALYTICS USER MANUAL 19 support synisys com Contact us 232 22 235458 9 My Profile About Help Log Off Mee DAD SIERRA LEONE L My Portfolio Customize Update Dashboard Dashboard modified Sawe Sawe as New Cancel Eg Add New Item Public of Projects by Status PROJECT UN Projects PROJECT ai P E Projects by Sector PROJECT E3 Projects by Funding Source P q Funding Source Activity PROJ E CH mm m Ongoing Projects by Funding So north East E E ig Financial Details b District PR t 2 ls of Projects by Donor and Sect a lig Donor Agency Contributions P Projects by Location PROJECT lu 1 PROJECT ay o lg Financial Details by District PR _ W Project Details by Donor and Se v a 18 16 Drag and drop the desired component onto 24 81 the dashboard screen COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS Figure 10 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 1 Click the Customize button A new section will appear displaying all customizable options in the Dashboard module Figur
23. click Cancel to discard the changes made DAD SIERRA LEONE ANALYTICS USER MANUAL 71 12 2 2How to Save a Copy of the Report In 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 1 Click on the 53 button on the top right side of the screen A Memorize Report window Figure 53 will appear 2 Save the report by the steps described in the section above 12 3 Re organising Reports List Chart Map and Report Modules 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 l Click on the respective E Organise Views Charts Maps Reports button at the top right side of the Screen An Organise Reports window Figure 54 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 SIERRA LEONE ANALYTICS USER MANUAL DAD PUBLIC REPORTS Sector Funding Type HY REPORTS 72 A ok Ei Cancel E Set as Default far Public Users _ Set as default a Rename
24. 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 an 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 SIERRA LEONE ANALYTICS USER MANUAL 54 suppornt synisys com Contact us 555 55 525458 9 My Profile About Help Mee DAD SIERRA LEONE L My Portfolio Dashboard log wlAaa Advanced Search i Title isse Remove Filters View Criteria i Header Filter by Choose and structure the information you wish to report on in the table below Expand the Preview Funding Source section to view the final look and structure of the report Donor Agency Implementer District Chiefdom ic More Filters Financial Add General d TERAP ESS ee Funding Source Pg 2 Financial Details by District 9 Performance Indicators and Outputs Project Details by Donor and Sector i Sector and Location A ITE Add Assistance Type National Partners Implementation Status Donor Reference Number Year UNDP Reference Number Monty Donor Agency Type d Is on budget off budget 5 PREVIEW Report Preview COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS IN
25. projects through the built in Online Data Entry Module The DAD Sierra Leone provides a web based user interface and requires a web browser Internet Explorer pre installed DAD SIERRA LEONE ANALYTICS USER MANUAL 7 3 LOGGING INTO DAD SIERRA LEONE 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 EN DAD SIERRA LEONE What can do in DAD Sierra Leone Once you enter DAD Sierra Leone you will be able to View all the projects v See project details v Create Maps Charts and Reports ENTER AS PUBLIC USER t Download DAD Sierra Leone User Manual For Registered Users and Administrators User Name 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 SIERRA LEONE ANALYTICS USER MANUAL 8 3 1 Registering a New User If you are new to the system and you need a personal account sign up for a username an
26. report by More Filters Donor Agency Y 9 Financial Details by District g Project Details by Donor and Sector 2 Columns Implementer Committed USD v Disbursed USD v Sector Province Y 1 Rows x dum 7 column Add Sub column cm Proje J Data Dat Add Column Add Sub column ui i Footer Reset Submit 5 PREVIEW Donor Agency 1 Project Implementer Committed USD Disbursed USD Project 1 Implementer 1 Committed USD 1 Disbursed USD 1 Sector 1 Province 1 Project 2 Implementer 2 Committed USD 2 Disbursed USD 2 Sector 2 Province 2 Donor Agency 2 Project Implementer Committed USD Disbursed USD Province Project 1 Committed USD 1 Disbursed USD 1 Project 2 Implementer 2 Committed USD 2 Disbursed USD 2 Sector 2 Province 2 COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 42 Creating a Report 2 You will have the following result Figure 43 DAD SIERRA LEONE ANALYTICS USER MANUAL 60 gt DAD Sierra Laone Windows Intarnet Explorar U0 Dihued 1h WoT A 1 455 00 BSG 677 533 Agripulbure Rural develooment and Food Becurity 10 0001 034 Sgctulhire Rural davalesant asd Faed Seti STe 0DO uG Urgnecihed ef Heu Seles gy Gl PALM ERO TION uectAD Islamic Devalooment Bank DDB unspactied
27. s Province Sector Sub Sector Thematic Marker UNDP Reference Number e 4 9 o elelelelelelelelelelelielielelelel elelele le e e SoOnmied elelelelelelelelelelelelelelelel elelelele e eo Disbursed elelelelelel elelelelelelielelelel elelelele e eo Disbursed elielelelelelelelelelelelelelel elelelele e e eo Cos 5 5 9 o elelelelelelelelieliel elelelelel elelele e e e e Cos Year Figure 38 Compatibility Matrix 10 3 Previewing a Report 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 39 The Preview will not be ready for viewing unless the user has at least one table row defined DAD SIERRA LEONE ANALYTICS USER MANUAL 56 support synisys com z Contact us 555 55 525458 9 My Profile About Help Log Off m DAD SIERRA LEONE L Portfolio 3H Dashboard Advanced Search i Subtitle i Header Remove Filters View Criteria 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 Filter by Click here to view row column compatibility matrix Funding Source Donor Agency i Group report by Implementer District Add Grouping Chiefdom More Filters 2 Columns Committed USD Disbursed US
28. 5458 9 My Profile About Help Log Off DAD SIERRA LEONE DL My Portfolio Dashboard Customize Update All O Ne Dashboard1 Save Save as New Cance 8 Add New Item l ublic E E3 Projects by Location PROJECT E3 Projects by Sector PROJECT Projects by Funding Source P E Funding Source Activity PROJ E Ongoing Projects by Funding So Drag items here 1 UN Projects PROJECT lis of Projects by Status PROJE of Projects by Donor and Sect lig Donor Agency Contributions P lis 1 PROJECT k Drag and drop the desired component onto the dashboard screen COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 9 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 9 2 Select a report to add to a dashboard and drag and drop it onto the main screen 3 If 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 10 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
29. 78 14 3 SAMPLE FILTERING CRITERIA cccccccccseeccccccsccccccccsccccccccsceccccuuueccccusuceccccuauececceuucececeeaucesecesaucceeeeuaees 80 15 LOGGING OU P eee 81 IG REFERENCES ai coo HERO o ee Ii nai NI DRIED 81 DAD SIERRA LEONE ANALYTICS USER MANUAL 4 TABLE OF FIGURES FIGURE Ea PM Ge I eig ics PNE SY RS 7 IGURE 2 USER REGISTRATION FORM its adt uta aa tetas usd a oo saves do sha uec De tuve are ausos eauved da dha uec De rd usv ar o uet TE Qa eia Use A 5 FIGURE S MY PRORIEE SECTION N T en E a N T antiga uie ivi prre E Euntes al 0 FIGURE 4 DAD ANALYTICS STRUCTURE cccccccceesssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssees 10 FIGURE 5 MY PORTFOLIO MODULE itio desee euro ren eu ee 12 FIGURE 6 CREATE NEW PROJECT BUTTON IN MY 13 FIGURE 7 DASHBOARD MODULE DL M IDE DUE E DUE EIC 16 FIGURES ADDING ANEW DASHBOARRBD 5 232 5 56 0 Eattoteseni Sasduudi ba etate osse Toto tissu ta aad Tolet sp oou ees de Ld s ci c cE 17 FIGURE 9 LIST OF PRE DEFI NED REPORTS ccccccccessssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssees 18 FIGUBE LO ADDING Ac NEW REPORT s uie
30. 9 417 51 183 887 er en ee aera 23 37 268 066 23 277 690 L i Y i Projects by Location e 053 Agriculture Rural development and Food Security 70 226 372 075 142 660 466 L projects by Sector i 054 Infrastructure 53 447 714 515 284 764 880 i Y i g pes H projects by Funding Source BS 055 Macroeconomic Management 8 238 160 245 156 408 838 00 Unspecified 1 2 563 302 2 439 464 MYVIENS 122 Direct Budget Support 3 226 684 565 151 288 388 5L 000737 Sierra Leone Budget Support Programme 2006 Sierra Leone Budget Support Programme 2006 21 551 724 SL 000791 Macro Economic Support PRBS Macro Economic Support PRBS 93 726 027 84 260 267 SL 001148 Budget Support Programme for Macro Economic Stabilisation Budget Support Programme for Macro 111 406 814 67 028 122 Economic Stabilisation 123 Balance of Payments Support 1 2 680 986 2 680 986 123 Other Macroeconomic Support 1 6 231 390 Y oe Health 135 294 690 195 232 155 056 Y 082 HIV AIDS 35 32 627 694 18 325 923 983 Education 56 280 332 929 121 971 641 X BN 994 water and Sanitation 18 29 626 164 10 312 421 P 085 Environment 26 44 996 867 26 044 359 128 Humanitarian 4 35 985 255 29 803 004 99 Unallocated 2 6 391 661 5 308 063 Total 636 2 333 092 807 1 499 737 451 Results 1 3 of 3 Figure 18 Sample View 1 COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC DAD SIERRA LEONE ANALYTICS USER MANUAL 28 7 7 2 Samp
31. A LEONE ANALYTICS USER MANUAL Chart Type 1 Bar chart 2 Column chart m 3 3D Bar chart 4 4 3D Column chart 5 Stacked Bar chart E sea EA Minin neam panh Com 32 DAD SIERRA LEONE ANALYTICS USER MANUAL 6 Stacked Column chart Imi Wy 1 5 E 33 3 H 7 tOo E 1 i amp Y amp 4 s i 7 Stacked 3D Bar chart 8 Stacked 3D Column chart 9 Pie chart B 10 3D Pie chart 33 DAD SIERRA LEONE ANALYTICS USER MANUAL 34 4 Show Top lt Number gt indicates the maximal number of category items to be displayed in the chart 5 Show Top lt Number gt on Secondary Axis indicates the maximal number of series items that should be displayed on the secondary axis in the chart Becomes available only if a Series is selected 6 Char Count limits the number of characters to be used to display the category item names to the value set in this field 7 Malues 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 Workspace the main working area in the Chart module where the chart designed is displayed 8 4 View Screen and Its Components support synisys com 232 22 235458 9 Contact us Ee DAD SIER LEONE 2232 22 2354 My Profile About Help Log Off L My Portfolio Dashboard Sl EB eura
32. D 2 Rows Assistance Type Assistance Type Add Column 9 Financial Details by District Project Details by Donor and Sector Add Sub column Add Sub column Donor Agency Dat Dat Laia Lala i Footer Reset gt Submit c4 Committed USD Disbursed USD Donor Agency Assistance Type 1 Assistance Type 2 Assistance Type 1 Assistance Type 2 Doner Agency 1 Committed USD 1 Committed USD 1 Disbursed USD 1 Disbursed USD 1 Donor Agency 2 Committed USD 2 Committed USD 2 Disbursed USD 2 Disbursed USD 2 COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 39 Previewing 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 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 SIERRA LEONE ANALYTICS USER MANUAL 57 10 5 1 Sample Report 1 Total C
33. DFID Diakonia Interdenominational Services for Counselling Evangelism and Teaching DISCET Disability Awareness Action Group DAAG Kenema District Association Restore Hope Wilamette Medical Teams WT word Hope International WH 829468 C S Ld European Union EU Evangelical Fellowship of Sierra Leone Handicap International SL 68 139 518 177 801 199 64 100 053 22 544 361 24 011 783 1 563 752 Christians In Action Development Agency 13 315 147 Community Empowerment for Rural Development CEFORD ru Conservation Society bo Cotton Tree Foundation Sierra Leone Local intranet Figure 41 Sample List Report 1 10 5 2 Sample Report 2 Assistance Portfolio Report If you have indicated Figure 42 e Donor Agency as the report table grouping e Project as the report row e Implementer Committed USA Disbursed USA Sector and Province as columns DAD SIERRA LEONE ANALYTICS USER MANUAL 59 Contact us 2 25458 My Profile About DAD SIERRA LEONE L My Portfolio Dashboard i Title 7 i Subtitle Remove Filters View Criteria i Header Filter by Choose and structure the information you wish to report on in the table below Expand the Preview Funding Source section to view the final look and structure of the report Donor Agency Implementer Click here to view row column compatibility matrix District Chiefdom 1 Group
34. E 54 ORGANIZING THE REPORTS cccccccccsssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssees T2 FIGURE 55 CREATING A FILTERING CRITERI A decoro tein cte cuot E OAN E a a 75 FIGURE 56 SAMPLE FILTERING CRITERIA cssos sesonsesnssndlsbausnusealisstousausousranlssodd sbausaudeadussdegssusouszectesndd T R a 76 FIGURE FILTERED LIS Tronan aa a aaa a a a a setae lasek 77 FIGURE 58 CREATING A SEARCH CRITERIA 00sccscsssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssseeeeees 79 FIGURE 59 DEFINING SEARCH 80 FIGURE OO use a ob mu a 80 DAD SIERRA LEONE ANALYTICS USER MANUAL 6 1 INTRODUCTION The purpose of this document is to describe how the Development Assistance Database for Sierra Leone DAD Sierra Leone application functions and provide the necessary instructions to ensure successful work with the application Use of this document and compliance with the Standards specified herein is mandatory for anyone working with the above mentioned application 2 OVERVIEW The Development Assistance Database for Sierra Leone DAD Sierra Leone application is an aid management s
35. ERNATIONAL SYSTEMS INC Figure 40 Creating a Report 1 You will have the following result Figure 41 DAD SIERRA LEONE ANALYTICS USER MANUAL 58 DAD Sierra Leone Windows Internet Explorer File Edit View Favorites Tools Help Q Snagit E a DRE SRI NP 7777 DN UR TT RS DT TR ICI d PRO MMC BR ML DESDE fnsaral Development Svices ee cng sree dd arab Eoyptan Aid Development Ageney done O Assemblies of God Relief and Development Organisation AGRADO o 25 627 411 241 602 425 Association For Rural Development ARO 8 575 892 41 308 519 11 244 429 r 3 426 278 48 830 403 67 205 586 12 087 412 425 000 110 675 242 51 592 876 5 106 004 Report generated on 07 Jul 2011 11 35 velopment Office Chibuzor Human Resource Development Organisation CHIDO A Lu m ABE ola 3 3 3 i E e 3 o 3 5 3 a v o lt lt o o 3 3 8 D a 3 3 m m a 3 2 4 on m oO 9 B o 9 isti i i SL a T 2 ce 3 A m 3 4 o 2 t m 2 n m un 4 187 500 19 013 860 63 827 713 74 107 468 Community Action for Rural Development CARD SL Community Action for Rural Empowerment r 1 110 000 24 599 409 Community Programmes For Women i of Sierra Leone Council for Human Ecol in Sierra Leone Department for International Development
36. N THE MAP MODULE ctc prato n lon ote fu Lee e Pa et 41 9 4 1 F oeajsoMiaEAeenduko0 ww 41 9 4 2 Measurind DISESPEee s eet ree Eti obe te ttim Ut MEDI ILE 43 9 4 3 Butter Zone QUGOEVIPgs eai eet EEE sane 44 9 4 4 Me Sl ac REM 44 9 4 5 oae ect TEN Sie eNO RECEN AU T S 46 9 4 6 om C 47 9 5 VIEWING THE DATA DISPLAYED ON THE MAP uuu cccccesccccesssscecceeessseecceeesseeeceeessseeeceeesseeceeeessseeeeeens 48 9 6 SAMPLE REPORTS TT T UR 49 9 6 1 Sample Map Report 1 Projects Distribution by Implementation Status 49 9 6 2 Sample Map Report 2 Projects Cost by District 50 10 REPORT MODULE ONE Va ba CURE RI ANE HEATED 52 JACGESSINGCTHE REPORT MODUEE 45 25 25 650p Ii ota toti Suet de a a Eo EpL Loos 52 102 CREANGA REPOR Tet 52 IOS IJPREVIEWLING AJTSEPORIS GS teet taf cot eh Los boi ta eia puit 55 101 GENERATING A REPORT 5 5 Eta toet op poros oes eno operae b 56 TORS Sy INIPIE SNE ORT S sph mese Earn ME I n desir itor um Mdud 56 10 5 1 Sample Report 1 Total Commitments and Disbursements by Do
37. OLIO MODULE to manage user specific projects Dashboard opens DASHBOARD MODULE for quick access Main Toolbar to the projects registered in the DAD system List opens the LIST MODULE 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 Search contains a common and advanced search functions among the selected application list For details see SEARCH Filter contains filtering options For details see FILTERING PISO MANU Sar 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 Up Down arrows 1 used to collapse expand the Main Menu Manipulation une Buttons section 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 displayed DAD SIERRA LEONE ANALYTICS USER MANUAL 12 5 MY PORTFOLIO MODULE The My Portfolio section Figure 5 of the DAD application provides quick access to the projects added
38. R MANUAL DAD SIERRA LEONE My Portfolio Dashboard Main View Series None Show Top Chart Types lk amp ole EE Char Count 15 Update Remove Filters View Criteria Filter by Bl vationwive Committed USD Province Committed USD Funding Source EE unspecified NATIONWIDE 4 487 162 514 Donor Agency Implementer By western Unspecified 684 568 179 District NORTHERN WESTERN 236 937 410 Chiefdom More Filters H EASTERN NORTHERN 204 502 749 SOUTHERN EASTERN 173 827 786 EE Unallocated SOUTHERN 133 159 526 Unallocated 915 201 4 of Projects by Status ri of Projects by Donor and s Donor Agency Contributions 5 96 23 46 8 12 COPYRIGHT 2011 SYN Figure 25 Sample Chart Report 2 My Profile e a Category Province Show Top 10 Values Committed USD Disbursed USD Disbursed USD 963 338 406 619 518 507 142 482 491 131 449 229 139 881 578 103 910 108 571 936 About tGY INTERNATIONAL SYSTEMS INC DAD SIERRA LEONE ANALYTICS USER MANUAL 38 9 MAP MODULE In the Map module of DAD you can make use of an advanced GIS tool for data visualization mapping and analysis 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 mo
39. S Figure 56 Sample Filtering Criteria 13 2 Sample Filtering Criteria If Sector is selected as filtering category and Education Youth Development HIV AIDS and Health are selected as category items the following results will be acquired Figure 57 DAD SIERRA LEONE ANALYTICS USER MANUAL 77 Contact us 54 ZELLE My Profile About Help Me DAD SIERRA LEONE DL My Portfolio ic Dashboard List Hide Images f IS SaveAs 9 vg Please note a filter is applied you are currently reviewing a selection sub set of all projects Modify Current View Lu Advanced Search mum Committed Disbursed Remove Filters View Criteria f 052 Youth Development 23 37 268 066 23 277 690 an 081 Health 135 294 690 195 232 155 056 082 HIV AIDS 35 32 627 694 18 325 923 Funding Source Donor Agency 09 Education 56 280 332 929 121 971 641 Implementer Total 220 644 918 884 395 730 310 Chiefdom Y More Filters Projects by Location Projects by Sector Projects by Funding Source Results 1 4 of 4 SYNERGY INTERNATIONAL SYSTEMS INC Figure 57 Filtered List DAD SIERRA LEONE ANALYTICS USER MANUAL 78 14 SEARCH 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 rel
40. aeu etd ot A ius AA tus Cedsssa s ide dead b qu a ARM da ta CES nQE 19 FIGURE 11 CUSTOMIZING A DASHBOARD ccceecee III hehehe hh hehe eee eere eene eere nnne 20 FIGURE EZ BEST MODULE dbeesa se auematwadeceus dvoeusGoed sbouse pus cese ua dessus 22 FIGURE 13 EXPANDING 5 23 FIGURE 4 AIDING IMAGES INTHE EIS ou Rp roe Uer ten Faster dextri oou octo 24 FIGURE 15 MODIFYING THE CURRENT VIEW u cccc ccc ceeeeeeeeeeeeeesesssssssssssssssssssssssssssssssssessssssssssesesessseesssseessseseesees 25 FIGURE 16 DEFINING LIST VIEW GROUPINGS FOR SAMPLE VIEW 1 eene nennen 26 FIGURE 17 DEFINING LIST VIEW COLUMNS FOR 1 27 FIGURE L9 SAMPLE M E E ER 27 FIGURE 19 DEFINING LIST VIEW GROUPINGS FOR SAMPLE VIEW 2 0 ccccccsssssssseseececcccccccccececcesastsesecececceecs 28 FIGURE 20 DEFINING LIST VIEW COLUMNS FOR SAMPLE VIEW 2 cccccccccccccccsssesssseeeececcccccccccceecaaesestsssseeceeceecs 28 FIGURE Z Le SAMPLE VIEW E 20 FIGURE 22 MAIN SCREEN OF CHART MODULE ssss
41. 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 DAD SIERRA LEONE ANALYTICS USER MANUAL 21 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 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 dashboard 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 All 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 SIERRA LEONE ANALYTICS USER MANUAL 22 7 LIST MODULE In the List module Figure 12 of t
42. b level s In order to expand the list item level click on the sign next to the name of the list item This will expand the list item group level displaying the first sub level Figure 13 This can further be expanded unless there are no more sub levels to be displayed DAD SIERRA LEONE ANALYTICS USER MANUAL 23 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 M support synisys com Contact us 23222 215458 9 My Profile About Help Log Off IN DAD SIERRA LEONE L My Portfolio Dashboard Rist RR maces El B Seve ss Modify Current View 5 Donor Agency Project 4 diuisa Committed Remove Filters EE Unspecified pee er Arab Egyptian Aid Development Agency 13 44 556 202 2 INN a ra El Assemblies of God Relief and Development Organisation AGRADO 34 344 263 221 22 Filter by GD Association For Rural Development ARD 55 266 280 332 17 Funding Source Ben Hirsch Child Care Women in Development Programme 17 200 889 350 11 Donor Agency l CEM Development Office 1 22 544 462 2 Implementer Chibuzor Human Resource Development Organisation CHIDO 8 36 717 892 2 c SL 000561 Oil Palm Production and Processing 1 496 000 More Filters SL 000562 Rural Infrastructure Development 11 380 000 1 SL 001008 Diversified Food Production 10 500 000 SL 001186 Social Action Support
43. blic and non governmental sector services Linda Williams 05 Apr 2011 EC Delegation L 001472 Supporting Youth Livelihoods in Liberia and SL Linda Williams 05 Apr 2011 EC Delegation SL 001471 improve social inclusion and increase employment opportunities for disabled people in SL Tanzania and Uganda Linda Wiliams 05 Apr 2011 EC Delegation SL 001470 From economic nuisance to economic empowerment improving livelihoods of vulnerable populations Linda Wiliams 05 Apr 2011 EC Delegation SL 001469 Unblocking the cocoa value chain through informal and formal pathways to learning in eastern SL Linda Wiliams 05 Apr 2011 EC Delegation SL 001468 Advancing TechnicalVocational capacities for employment and enterprise development in SL Linda Williams 04 Apr 2011 EC Delegation SL 001467 Technical Cooperation Facility TCF Ill Linda Williams 23 Mar 2011 EC Delegation L 001466 Opening Political Space at Chiefdom amp Ward levels for marginalised Voices Women and Youth Joseph Samah 27 May 2011 MoFED 12345678910 Next gt gt COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 6 Create New Project button in My Portfolio Note Only submitted drafts are displayed in the List table see LIST MODULE and accessible to other users of DAD application In this module the project may be created details of the existing projects can be viewed and edited The information displayed in My Portfolio for each project includes the followin
44. by the corresponding user In order to access My Portfolio module click on the My Portfolio tab in the Main Menu of DAD application Editing permissions of records in My Portfolio can be based on the user whether the user has created the record or user s group whether someone from the group user belongs to has created the record All these permissions are granted and managed from DAD Administration Center Contact us 4 555 55 525458 9 My Profile About Help Log Off ER DAD SIERRA LEONE i23 My Portfolio Dashboard Create New Project Ready for Project ID Project Title Y Last modified by Last Modified On Submission DRAFT Youth Housing Scheme Not Ready DRAFT Youth Employment Program synergy Admin 06 Jul 2011 Ready 5 Synergy DRAFT Wounded in Action Payments Not Ready DRAFT Workshop to develop communication strategy plan on malaria Not Ready DRAFT Workshop to develop and adapt IEC plan for ACT implementation Not Ready DRAFT Workshop and training of PLWHA on care and support and related activities Not Ready DRAFT WHO Health Service Support Not Ready DRAFT WFP Secondment in kind Not Ready DRAFT WFP non USG food aid alone Offline User 19 Oct 2009 Not Ready DACO Synergy DRAFT West Africa Trade Hub Program Not Ready 23456789 10 Next gt gt COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 5 My Portfolio Module In My Portfolio module you may see a list of draft and submitted projects Each project created
45. d 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 onizel _ Support synisys com ontact US 232 22 235458 9 m IN DAD SIERRA LEONE User Registration Form Required Field johnsm ith a John Smith FAO johns fao 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 sre not clear E8V66 Note You should provide a valid e mail address It will be used for future correspondence IN Figure 2 User Registration Form Once you submit the registration form the DAD s 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 s 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 pe
46. d appear in the rows and columns of the table add report components which are DAD SIERRA LEONE ANALYTICS USER MANUAL 53 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 N Type the text that should appear as the report title in the Title text box Enter a Subtitle Header and Footer if needed In the Group Report by section specify the category which will be used to group data into different 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 37 Note The report will be divided into as many tables as there are table groupings selected 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 Select table columns by clicking
47. e 11 2 Take the necessary action 3 Save the changes DAD SIERRA LEONE ANALYTICS USER MANUAL 20 support synisys com Contact us 232 22 235458 9 My Profile About Help Log Off E DAD SIERRA LEONE My Portfolio Customize Update All New Dashboard Dashboard modified Save Save as New Cancel lig Add New lten Public E of Projects by Status PROJECT UN Projects PROJECT ew Y E3 Projects by Sector PROJECT Projects by Funding Source P i North West 200 Funding Source Activity PROJ Ongoing Projects by Funding So 150 lia of Projects by Donor and Sect lig Donor Agency Contributions P 1 PROJECT 100 be il North Central lg Financial Details by District PR _ 50 ig Project Details by Donor and Se v Drag and drop the desired component onto 0 om F the dashboard screen ih 250 a a s amp 63 5 P g 1 Projects by Location PROJECT gt y 16 400 000 16 400 000 18 167 022 MeemMAC Jm COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 11 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
48. e ette Da ERN cea ba des 70 12 2 2 How to Save a Copy of the REPort oecon eene nnne nnne nnns 71 12 3 RE ORGANISING REPORTS LIST CHART MAP AND REPORT 5 71 12 3 1 Renaming Reports and Report Groups esse eene nennen nennen 72 12 3 2 Deleting Reports or Report Groups eene nnne nennen nnne 72 12 3 3 Adding a Sub dErOU Ditto ces nda sada te les ence last itat 72 12 3 4 Re ordering Reports and 73 12 3 5 Setting g Rebortas Delali rere d eta eer n ess 73 12 4 EXPORTING REPORTS CHART MAP AND REPORT 5 73 DAD SIERRA LEONE ANALYTICS USER MANUAL 3 12 5 PRINTING REPORTS CHART MAP AND REPORT 5 73 T3 oh OL Re 74 15 1 IGREATING FILTERING CRITERIA a Soie t Ent d dbsddeta depo bs Dui 74 19 2 SAMPE FIETERING itle bote es tx ORE IR Eod pe Eat uta eo ote ei soto S D uot Rl cies Nia 76 T4 SEARCH mex 78 11 1 SEARCH 78 14 2 JABDVANCED SEABRCH ocio etos ies biota ihe edaiec hoe es dc heise ce aoe Oi
49. ed as the row item while the row item will trade places with the table grouping item DAD SIERRA LEONE ANALYTICS USER MANUAL 11 DETAILS SECTION The DAD Sierra Leone application has a built in Details section where you can view detailed project information e g project financial information the sector s of economy it supports the project location etc The Details section can be accessed from the List Chart and Map modules In the Details section you can view detailed project information browse among other projects listed under the same parent item print project details etc Moreover you are able to add a new project and or modify or delete an existing one New Edit Delete Close Contact Us Help E GENERAL INFORMATION Title Description distribution of funds Locations distribution of funds Wilkinson Road Viddening Project An infrastructural development project which involves the construction of a 4 Lane Dual Carriagew ay 5 2 km 01 Ju 2010 01 Ju 2011 12 months 0 days Ongoing Sector Infrastructure Road network Geographic Target Areas WESTERN Western Area Urban Western Area Urban ORGANISATIONS amp CONTACTS FINANCIAL INFORMATION KEY PERFORMANCE INDICATORS NOTES amp ATTACHMENTS PROJECT HISTORY Figure 51 Details Section 100 00 Unallocated 0 00 o 100 00 Unallocated 0 00 DAD SIERRA LEONE ANALYTICS USER MANUAL 67
50. elected scaling category instead 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 pie chart However you can choose the view the data in the form of a bar chart by selecting the appropriate option from the Chart Type drop down Figure 30 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 lil button DAD SIERRA LEONE ANALYTICS USER MANUAL 46 laj_nicol qmail com Contact us 4 539 99 935458 9 My Profile About Help Log Off Me DAD SIERRA LEONE My Portfolio Dashboard Zoom to est GO Pie Chart v Advanced S cn 4 3 Cursor position Lat 8 89 Long 10 22 Remove Filters v P 3 Categories View Criteria Scaling i Nationwide Filter by z Chart Funding Source 4 of Projects Donor Agency x 1 P
51. elects DAD SIERRA LEONE ANALYTICS USER MANUAL 48 z laj nicol qmail com Contact us 545 52 235458 9 My Profile About Help Log Off EN DAD SIERRA LEONE My Portfolio Dashboard Zoom to est GO Pie Chart m Advanced Search PEPERIT Lr M li aao tu Cursor position Lat 8 44 Long 11 64 Remove Filters P Categories View Criteria oo09 9 C None i Nationwide E Funding Source Filter by o 9 OQ O O Donor Agency Funding Source C Implementer Donor Agency C Implementer Sector District Status Chiefdom 3 Scaling More Filters Chart D Funding Source Activity e Ongoing Projects by Fund D UN Projects Approved 9 Completed Extended d Ongoing Unspecified 50 km i Southern E mi ee Figure 32 Using Mini Map COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC 9 5 Viewing the Data Displayed on the Map The Advanced GIS tool is used to view the data referring to definite territorial units provinces and or districts chiefdoms when zoomed in to this level In order to access the data for a specific territorial unit point the mouse cursor on the li button Figure 33 The information that is displayed in the information window includes but is not limited to of projects project cost etc If you have plotted any chart category on the map the chart category details appear in the information window as well Alternatively you can choose t
52. els Any other type of layer e Data visualization 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 specific features Distance Measurement Buffer Zone Querying Geocoding DAD SIERRA LEONE ANALYTICS USER MANUAL 40 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 9 2 Accessing the Map Module The system provides for the opportunity to present data on the map
53. erse the order of the list 7 4 Browsing among List I tems 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 mages 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 in 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 14 DAD SIERRA LEONE ANALYTICS USER MANUAL 24 support synisys com Contact us 4 525 55 225458 9 My Profile About Help Log Off IN DAD SIERRA LEONE My Portfolio Dashboard 5 show maces G ll sees LP Modify Current View Advanced Search Committed Donor Agency Project 4 Remove Filters Unspecified aa ae Arab Egyptian Aid Development Agency 13 44 556 202 27 51 I EFE UNS Assemblies of God Relief and Development Organisation AGRADO 34 344 263 221 220 8 Filter by Association For Rural Development ARD 55 266 280 332 175 31 Funding Source Ben Hirsch Child Care Women in Development Programme 17 200 889 350 1148 Donor Agency CEM Development Office 1 22 544 462 22 54 Implementer Chibuzor Human Resource Development Organisation CHIDO 8 36 717 892 24 7 SL 000561 Oil Palm Productio
54. esetieces 60 FIGURE 44 REPORTS WINDOW WITH PROPERTIES FOCUS ON THE TITLE FIELD eren 61 FIGURE 45 FORMATTING STYLI NG TEXT 5 61 FIGURE 46 REPORTS WINDOW WITH PROPERTIES FOCUS ON THE 62 FIGURE 47 ASSIGNING PROPERTIES TO REPORT TABLE 5 63 FIGURE 48 REORDERING REPORT TABLE COMPONENTS ccccccessessssesssssssssessssssssssssssssssssssssssseesesssseseesseeeeees 63 FIGURE 49 DEFINING SORTING ORDER W cccccccscsssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssees 64 FIGURE 50 SWITCHING REPORT TABLE COMPONENTS cccscccccsecccccccccccscccccasceccucsceccsccesacceseucecesssecesaeceesues 65 DAD SIERRA LEONE ANALYTICS USER MANUAL 5 FIGURE S Fe DETAILS SECTION 10 556 eaectosdeadaceaconcerastantacsndarerandee sa Gonsen 00606 evade 66 FIGURE 52 SETTING THE CHART REPORT 5 6 FIGURE 5 MEMORIZING A REPORT d ides a n iden etude dac t Sacto ibe batt Sousa eee eA Sado 70 FIGUR
55. evant 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 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 58 DAD SIERRA LEONE ANALYTICS USER MANUAL 79 zx Filter by Advanced Search OK Text to find E Search in GF Reset F Imlementer L Sector Project Title Project Code Donor Agency C National Partners F Province Current Criteria Figure 58 Creating a Search Criteria 2 Define the text to search for in the appropriate field 3 Specify the fields to look in by selecting the appropriate checkbox 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 DAD SIERRA LEONE ANALYTICS USER MANUAL 14 3 Sample Filtering Cri
56. g information e Project ID the project ID e Project Title the title of the project e Last Modified By last modification author e Last Modified On last modification date 5 1 Adding New Project 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 Users Manual see REFERENCES DAD SIERRA LEONE ANALYTICS USER MANUAL 14 5 2 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 Go to the My Portfolio module 2 Expand the 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 SECTION DAD SIERRA LEONE ANALYTICS USER MANUAL 15 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 vie
57. he DAD Sierra Leone application you can create and execute ad hoc queries on projects data and acquire results in form of a list support synisys com Contact us 5 23222 2315458 9 My Profile About Help Log Off Me DAD SIERRA LEONE 88 Dashboard L My Portfolio G E B Save As i a a Modify Current View List Eo Hide Images Disbursed USD Committed USD of Projects Donor Agency Project 5 Unspecified 29 Remove Filters View Criteria Arab Egyptian Aid Development Agency 15 44 556 202 27 552 492 a AEs ES Assemblies of God Relief and Development Organisation AGRADO 34 344 263 221 220 879 621 Filter by GD Association For Rural Development ARD 55 266 280 332 175 316 554 Funding Source Ben Hirsch Child Care Women in Development Programme 17 200 889 350 114 846 420 Donor Agency E CEM Development Office 1 22 544 462 22 544 361 Implementer J Chibuzor Human Resource Development Organisation CHIDO 8 36 717 892 24 747 313 EZ Christian Extension Services SL 2 1 490 053 1 490 053 More Filters 4 4 Christians In Action Development Agency 8 23 201 360 15 982 625 Community Action for Rural Development CARD SL 55 46 149 412 39 155 797 PUBLIC VIEWS 0000000000000 i Community Action for Rural Empowerment 16 67 541 601 60 639 719 gt Community Programmes For Women E 1 110 000 207 962 E Projects by Location Conservation Society of
58. he map 9 Location information section displays the name of the administrative unit when it is pointed on the map 10 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 to navigate to from the list containing the search results Figure 27 The selected item will be magnified and displayed in the main screen DAD SIERRA LEONE ANALYTICS USER MANUAL 42 laj nicol qmail com Contact us 545 55 235458 9 My Profile About Help Log Off Me DAD SIERRA LEONE L My Portfolio Dashboard Zoom to est GO Pie Chart v Advanced Search 0 Province 4 District Lat 11 36 Long 13 08 n ilter Categories Remove Filters Western Area Rural View Criteria Scaling Western Area Urban i Nationwide 3 Chart Filter by Chiefdom Funding Source Borders Donor Agency Implementer District Chiefdom More Filters D Funding Source Activity i Northern D Ongoing Projects
59. ide an updated report that applies the updated filtering criteria DAD SIERRA LEONE ANALYTICS USER MANUAL 75 Filter by Donor Agency Donor Agency Unspecified Ansarul Development Services AnDes Arab Egyptian Aid Development Agency Assemblies of God Relief and Development Organisation AGRADO Association For Rural Development ARD Ben Hirsch Child Care Women in Development Programme Canadia International Development Agency CIDA CEM Development Office Chibuzor Human Resource Development Oraanisation CHIDO x Ei Exclude Current Criteria Figure 55 Creating a Filtering Criteria Note It 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 SIERRA LEONE ANALYTICS USER MANUAL 76 s x Filter by Sector m OK 015 Decentralisation 016 Justice Sector Development 051 Private Sector Development 4 Cancel 053 Agriculture Rural development and Food Security a 054 Infrastructure 055 Macroeconomic Management amp h Reset 084 Water and Sanitation E 085 Environment 128 Humanitarian HE c C Exclude 052 Youth Development 081 Health 082 HIV AIDS 083 Education Current Criteria 182 HIWAIDS ooo 083 Education O
60. in DAD either from My Portfolio module or from Projects application should get Submitted first in order to become public and official Below is the procedure of project Submission e User adds a project It is saved as a draft in the user s portfolio in the Draft Projects section Figure 5 Drafts may also be viewed and edited by others users that have the corresponding permissions Further drafts should be revised by the user or by the corresponding project manager e f all mandatory fields are filled in the project form then draft gets a Ready state in the Ready for Submission column of the drafts table If at least one mandatory field is not yet filled the draft has Not Ready state e Only drafts with the Ready state can be submitted To submit the draft press the Submit button in the Drafts table DAD SIERRA LEONE ANALYTICS USER MANUAL 13 support synisys com Contact us 232 22 235 458 3 My Profile About Help Log O IN DAD SIERRA LEONE ij My Portfolio Dashboard Create New Project My Draft Projects 462 My Submitted Projects 636 Project ID Y Project Title Last modified by Last Modified On SL 001476 Suppot to the Strategy and Policy Unit in the office of the President Joseph Samah 08 Jun 2011 MoFED SL 001474 Preventing substance abuse among young people in Freetown Sierra Leone Linda Williams 18 Apr 2011 EC Delegation SL 001473 Improving Health Outcomes through strengthening Pu
61. ion you wish to report on in the table below Expand the Preview Funding Source section to view the final look and structure of the report Donor Agency Implementer Click here to view row column compatibility matrix District Chiefdom 1 Group report by More Filters Donor Agency Y a i ictei Z Financial Details by District Ae E V Proj i E Project Details by Donor and Sector Implementer Committed USD Disbursed USD 5 Sare EEEE i Rovs Add Column i Project Data Data Data Data Data Add Row E IR i Footer Reset Submit PREVIEW Donor Agency 1 Project Implementer Committed USD Disbursed USD Project 1 Implementer 1 Committed USD 1 Disbursed USD 1 Sector 1 Province 1 Project 2 Implementer 2 Committed USD 2 Disbursed USD 2 Sector 2 Province 2 Donor Agency 2 Project Implementer Committed USD Disbursed USD project 1 Implementer 1 Committed USD 1 Disbursed USD 1 Sector 1 Province 1 Project 2 Implementer 2 Committed USD 2 Disbursed USD 2 Sector 2 Province 2 COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INK Figure 44 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 45 For other report components like rows columns etc the Properties window also allows assigning additional characte
62. l dashboard is prevented Remove deletes a dashboard together with its contents 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 DAD SIERRA LEONE ANALYTICS USER MANUAL 17 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 6 4 Dashboard Management 6 4 1 Create a New Dashboard In order to create a new dashboard follow the steps below supporh synisys com Contact us 545 55 225458 9 My Profile About Help Log Off e DAD SIERRA LEONE My Portfolio Dashboard New M Customize Update All COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 8 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 8 2 Give the desired name to the dashboard Add reports to the dashboard see Add an Item to a Dashboard 4 Save it d DAD SIERRA LEONE ANALYTICS USER MANUAL 18 support synisys com Contact us 232 22 23
63. layed 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 1 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 Current 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 7 7 1 Sample View 1 Total Commitments and Disbursements by Sectors DAD x Ta Groupings m Available Groups Selected Groups Donor Agency Sector Funding Source Sub Sector Donor Agency Type Project National Partners m OK Province District Chiefdom x Cancel Implementation Status Donor Reference Number UNDP Reference Number Implementer Set as default Implementer Type Year Month Year Set as default for Assistance Type public users 4r Mowe Up IL Move Down Figure 16 Defining List View Groupings for Sample View 1 DAD SIERRA LEONE ANALYTICS USER MANUAL 2 T Available Columns mi Columns Selected Columns Project Code Start Date End Date Project Cost SLL Project Cost USD Committed SLL Disbursed SLL Moda
64. le View 2 Projects Distribution by Geographic Location x E Groupings Available Groups Selected Groups Donor Agency Province Funding Source District Donor Agency Type Chiefdom National Partners Project sector Sub Sector Implementation Status Donor Reference Number UNDP Reference Number Implementer Implementer Type Set as default Year Month Year Assistance Type Set as default for Assistance Type Modality public users in Mowe Up IL Mowe Down Figure 19 Defining List View Groupings for sample view 2 Columns TE Available Columns Selected Columns Project Code Project Title Start Date of Projects End Date Committed USD Project Cost SLL Disbursed USD AF Project Cost USD Committed SLL Disbursed SLL of Cancel Modality Created on Created by Last Modified on Last Modified by Duration KPI Target Set as default for KPI Progress public users zin Mowe Up Ir Mowe Down Figure 20 Defining List View Columns for sample view 2 You will get the following result Figure 21 if you have selected Province District Chiefdom Project hierarchy as a grouping Figure 19 and Project Title 4 of Projects Committed USD Disbursed USD as columns Figure 20 DAD SIERRA LEONE ANALYTICS USER MANUAL EN DAD SIERRA LEONE My Portfolio Dashboard Remove Filters View
65. lity Created on Created by Last Modified on Last Modified by Duration KPI Target KPI Progress Project Title of Projects Committed USD Disbursed USD Set as default A MUERE Set as default far public users 4 Mowe Lp IL Move Down Figure 17 Defining List View Columns for Sample View 1 You will get the following result Figure 18 if you have selected Sector Sub sector Project hierarchy as a grouping Figure 16 and Project Title of Projects Committed USD Disbursed USD as columns Figure 17 n 5 Contact us My Profile About Help Log Off Me DAD SIERRA LEONE My Portfolio Dashboard 3 Hide Images G E 59 Save As us Modify Current View Advanced Search i 8 Committed Disbursed A Sector Sub Sector Project 4 Project Title Tr USD USD secun Tile 00 Unspecified 66 56 911 842 23 727 750 View Criteria 4 011 Public Financial Management 16 111 226 875 77 535 540 f 012 Transparency and democracy 68 85 297 025 59 687 325 ilter by Funding Source ik 013 Capacity Building of government agencies 52 129 862 659 93 795 384 Donor Agency 014 security Sector 14 33 309 809 31 351 164 impiementer District 015 Decentralisation 14 91 248 889 53 327 322 Chiefdom More Filters p 016 Justice Sector Development 36 89 670 747 58 096 806 051 Private Sector Development 18 61 37
66. ll New S 1 Mi F c c e n Dashboard Dashboard modified Save Save as New Cancel Add Now om ig Add New Iten Ongoing Projects by Funding Source PROJECT Y of Projects by Status PROJECT e e e e Completed Unspecified Approved Extended 2 0050159 Health Sector Support Programme rn 16 400 000 16 400 000 SUO00171 Local Government Elections 2004 L 000177 Democratic Governance AWP 1 130 860 v 0001738 Sierra Leone Biodiversity Strategy 10130 000180 NORAD Support to Reintegration ERE 723 870 L 000182 Pro Poor Policy Formulation o 5 L 000183 Shelter Assistance Phase 2 L 000185 Coordination and Outreach 190 330 COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 7 Dashboard Module e Dashboard Selector contains a list of pre defined dashboards By choosing a definite dashboard from this list you can view the reports stored in the selected dashboard e Customize allows performing the following operations e Name 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 origina
67. mpleted Extended Ongoing Q Unspecified COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 33 Viewing the Data Displayed on the Map 9 6 Sample Map Reports In the following chapters you can see several samples on maps 9 6 1 Sample Map Report 1 Projects Distribution by I mplementation Status You will get the following map report if you have selected the Status as a map Category select of Projects as a map Scaling and open the Legend panel Figure 34 50 DAD SIERRA LEONE ANALYTICS USER MANUAL ms DAD SIERRA LEONE L My Portfolio Dashboard laj_nicol qmail com Contact us 5 2122223845 8 9 My Profile About Help Log Off LILLE ee 5 Advanced Search 4 Remove Filters View Criteria Filter by Funding Source Donor Agency District Chiefdom More Filters Funding Source Activity e Ongoing Projects by Fund e UN Projects 310 150 Zoom to est Implementer GO Pie Chart v Info Cursor position Lat 8 87 Long 10 04 i Nationwide o 0 Q9 OO i Northern oo Q o0 i Southern O O 9 o0 B s Sa RO Categories Hone Funding Source Implementer C C C Donor Agency C C Sector Status No Scale amp of Projects Project Cost USD C Committed USD C Disbursed USD Project Cost SLL FN ee ee mats Q Approved 9 Completed Extended vw Ongoi
68. n snd Processing 1 496 000 5 More Filters L 000562 Rural Infrastructure Development 11 380 000 10 0t SL 001008 Diversified Food Production 10 500 000 amp SL 001186 Social Action Support Project SASP 9 580 000 9 5 SL 001240 Construction of Primary Schools 196 968 1 5 Projects by Location SL 001241 Oil PALM PRODUCTION AND PROCESSING 364 924 3t EJ Projects by Sector SL 001242 Rural Infrastructure Development 3 000 000 3 06 LI Production 200 000 2 Christian Extension Services SL 2 1 490 053 1 46 Christians In Action Development Agency 8 23 201 360 15 98 Community Action for Rural Development CARD SL 55 46 149 412 39 15 Community Action for Rural Empowerment 16 67 541 601 60 6 Community Programmes For Women 4 1 110 000 2 Conservation Society of Sierra Leone 7 24 599 409 Cotton Tree Foundation Sierra Leone 31 101 682 058 75 21 Council for Human Ecol in Sierra Leone 6 45 937 920 298 Diakonia Interdenominational Services for Counselling Evangelism and Teaching DISCET 55 3 484 124 3 4t European Union EU 18 350 000 Evangelical Fellowship of Sierra Leone 3 15 000 Handicap International SL 3 2 045 000 2 0 Kenema District Association Restore Hope 5 5 860 369 4 7 Willamette Medical Teams IMT 111 65 189 669 61 2 COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 14 Hiding I mages in the List Note Clicking the 5 315 Images butto
69. n will show the images 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 1 Click on the Modify Current View link at the top right corner of the List screen A Modify Current View window Figure 15 will appear presenting the administrator with the groupings columns selected and available for the list view 2 n the Groupings section add re order remove groups In the Columns section add re order remove columns 4 In the Cross Tab Groupings section define add re order remove column groupings for the view 5 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 6 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 d DAD SIERRA LEONE ANALYTICS Groupings Available Groups Funding Source Donor Agency Type National Partners Province District Chiefdom Sector Sub Sector Implementation Status Donor Reference Number UNDP Reference Number Implementer Implementer Type Year Month Year USER MANUAL 25 Selected Groups Donor Agency Project
70. ng Unspecified 100 km 100 mi COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 34 Sample Map Report 1 9 6 2 Sample Map Report 2 Projects Cost by District If you have selected the Project cost USD as a map Scale the following map report will appear Figure 35 DAD SIERRA LEONE ANALYTICS USER MANUAL 51 laj _nicol qmail com Contact us 4 545 52 235458 9 My Profile About Help Log Off EN DAD SIERRA LEONE LI My Portfolio Dashboard ee 2 Zoom to est GO Pie Chart i lt gt D 9 50 Cursor position Lat 8 18 Long 8 Remove Filters 5 i Categories View Criteria None i Nationwide E C Funding Source Filter by C Donor Agency Funding Source Implementer Donor Agency Implementer Sector District Status Chiefdom Scaling More Filters No Scale i Northern Proiec Cost USD e Funding Source Activity C Committed USD D Ongoing Projects by Fund 1 Disbursed USD 1 C Project Cost SLL UN Projects I C Committed SLL 1 Disbursed SLL Chart Borders 3 000 min 1 000 min 200 km 100 mi Figure 35 Sample Map Report 2 COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC DAD SIERRA LEONE 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 Accessi
71. ng 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 36 will open In this module you can create list reports save them as predefined reports arrange them in the desired way print them etc Contact us 4 525 55 225458 9 My Profile About Help Log Off Me DAD SIERRA LEONE L My Portfolio Dashboard lag wlhae i Title 7 I Subtitle Remove Filters View Criteria i Header 7 Filter by Choose and structure the information you wish to report on in the table below Expand the Preview Funding Source section to view the final look and structure of the report Donor Agency Implementer Click here to view row column compatibility matrix District Chiefdom 2 Group report by More Filters Add Grouping i 2 Columns Financial Details by District 2 Rows Add Column Project Details by Donor and Sector Add Row i Footer Reset Submit PREVIEW Report Preview COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 36 Report Module 10 2 Creating a Report In order to create a report i e to structure the report table and choose what information shoul
72. nor Agency VG Assistalce TY OC tienda ade actuated 57 10 5 2 Sample Report 2 Assistance Portfolio Report 58 L0 6 CUSTOMIZING REPOR nemin n na a ens 60 10 6 1 Formatting Styling Report COMponentS sesesssssseessrersesrerssriessrresssrressrresssrressrressereess 60 10 6 2 Re ordering Report Table Components eene 63 10 6 3 Sorting Report Table 64 10 6 4 Removing a Report Table Component eene eene 64 10 6 5 Switching Report Table Components ssssesee eene 65 ET DETAILS SECTION ccce 66 Lii ACCESSING THE DETAIES SECTION ss uti tetes ce pese nat te A 67 ELZ SBROWSING PROJECTS coii pnmo eter tese s bdo 67 T13 PRINTING PROJECT DETAILS ertet tener aper 67 Tq EDITNGANEXSTING PRO EC hei ain dt Ido CU EI x M LLM ELM DELI CINE 68 12 CUSTOMISED REPORTING IN LI ST CHART MAP AND REPORT MODULES 69 12 1 SETTING REPORT OPTIONS LIST AND REPORT 5 69 12 2 SAVING REPORTS LIST CHART MAP AND REPORT 5 70 12 2 1 WOW tooave New REDON s MEO e
73. o 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 lil 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 SECTION DAD SIERRA LEONE ANALYTICS USER MANUAL E DAD SIERRA LEONE L My Portfolio 9 Dashboard Remove Filters View Criteria Filter by Funding Source Donor Agency Implementer More Filters e Funding Source Activity e Ongoing Projects by Fund e UN Projects Zoom to est Contact us 2 GO Pie Chart Info Northern Cursor position Lat 9 12 Long 11 97 i Nationwide o 0 Q O O pr Northern o l misi n E Ss Q of Projects 60 Project Cost USD 490 837 747 Committed USD 146 600 539 E 7 Disbursed USD 97 974 394 m Project Cost SLL 1 486 092 723 965 D Qu Committed SLL 436 563 272 540 as Disbursed SLL 299 247 878 486 View Projects i Southern qe A 100 km 50 mi 49 laj_nicolg qmail com 22 22 235458 9 My Profile About Help Log Off Categories Mone Fundinq Source Donor Agency Implem enter Sector Status Scaling Chart Borders Q Approved 9 Co
74. of the country 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 figure describes some of the features available in the main screen of the Map module Figure 26 l Zoom to panel allows free zooming to the desired administrative unit province district etc 2 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 3 Navigation controls a set of tools that provide common navigation functions such as panning and zooming 4 Map the map of the country 5 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 6 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 DAD SIERRA LEONE ANALYTICS USER MANUAL 41 7 Layers Panel provides a variety of data to choose to display on the map 8 Legend Panel explains the categories and data series displayed on t
75. olution promoting good governance and public accountability and transparency It is an automated information management system which is designed to improve efficiency and coordination of donor activities in 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 donor and NGO community as it ensures effective access to aid data The DAD Sierra Leone application is a powerful tool that is used to view project data organized into lists reports charts and maps In the DAD Sierra Leone application you can present the project data in form of a list chart and map reports memorize save the reports print and export them The DAD Sierra Leone application is designed to provide quick access to the project and aid data remotely via Internet Once you have accessed the application you can view the project data stored in the database add new projects edit existing ones etc In the current design the DAD Sierra Leone consists of the Project application designed to track the ongoing projects that are financed from external sources e g donor community International NGOs etc Once you have accessed this application you are able to view project details track aid flows to the country and create analytical reports in the forms of Lists Charts and Maps Moreover in this application you can add new projects or modify the information of existing
76. ommitments and Disbursements by Donor Agency and Assistance Type If you have indicated Figure 40 e Donor Agency as the report row and add the total value to be shown before data e Committed USA and Disbursed USD as columns and Assistance Type as sub columns Contact us My Profile About Help Log Off Me DAD SIERRA LEONE My Portfolio Dashboard BE lag al Lao i Subtitle v i Header Remove Filters View Criteria 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 Filter by Funding Source Donor Agency Implementer District Chiefdom More Filters Click here to view row column compatibility matrix 2 Group report by Add Grouping 2 Columns Committed USD Disbursed USD 1 Rows Assistance Type Y Assistance Type Y 9 Financial Details by District Project Details by Donor and Sector Add Sub column Add Sub column Donor Agency Data Add Row EU i Footer Reset Submit PREVIEW Committed USD Disbursed USD Donor Agency Assistance Type 1 Assistance Type 2 Assistance Type 1 Assistance Type 2 Donor Agency 1 Committed USD 1 Committed USD 1 Disbursed USD 1 Disbursed USD 1 Donor Agency 2 Committed USD 2 Committed USD 2 Disbursed USD 2 Disbursed USD 2 COPYRIGHT 2011 SYNERGY INT
77. on the scaling map laj_nicol qmail com Contact us 5 545 52 235458 9 My Profile About Help Log Off Me DAD SIERRA LEONE My Portfolio Dashboard Zoom to est GO Pie Chart v 1 Cursor position Lat 7 60 Long 10 24 Remove Filters 8 Categories View Criteria None i Nationwide o 0 Q9 O Funding Source Filter by Funding Source Donor Agency a Implementer District Chiefdom More Filters i Northem e Funding Source Activity Donor Agency Implem enter Sector Status UODO OO Scaling e Ongoing Projects by Fund UN Projects Chart Borders ES Approved oo0 9 o 9 9 Completed Extended i Ongoing Unspecified 100 km 100 mi COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 31 Viewing Chart Legend 9 4 6 Using 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 32 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 Double 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 s
78. point to point and does not consider elevation laj nicol qmail com Contact us 4 545 52 235458 9 My Profile About Help Log Off E DAD SIERRA LEONE L My Portfolio Dashboard Zoom to est GO Pie Chart vw Advanced Search rud Mer 4 gt Cursor position Lat 10 40 Long 11 71 Remove Filters 9 Categories View Criteria Scaling i Nationwide Filter by depart Funding Source Donor Agency Implementer District Chiefdom More Filters 4 e Funding Source Activity Borders i Northern e Ongoing Projects by Fund e UN Projects 100 km 100 mi COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 28 Measuring Distance DAD SIERRA LEONE ANALYTICS USER MANUAL 44 9 4 3 Buffer 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 29 This tool may be useful for presentations on screenshots to mark the selected area on the map EN DAD SIERRA LEONE L My Portfolio Dashboard Help BEE est GO Pie Char
79. re peti tta CN aa 17 6 4 1 Create au New DashbOsSt xu cedes asda cepe ise toudus cde deena 17 6 4 2 Add an Item to a 85 18 6 4 3 Customize a DashbosbQ su stat tatit mettant men ui iE 19 6 4 4 Save d DasmbDOdl el ste tud E do Rete pde ce e A eM Ee 20 6 4 5 oan oM lock In LC 20 6 4 6 Discard the UU UT 2 6 4 7 T 2 7 LIEST 22 7 1 ACCESSING THE LIST MODULE 22 7 2 EXPANDING THE ar sds Aa tala on oe 22 7 3 SORTINGAEEST UI Ses 23 7 4 BROWSING AMONG LIST ITEMS 23 7 5 HIDING SHOWING IMAGES IN LIST cccccccccssecccccccccccccccceccccuseccccccuaecccccceaececccceuaccesecuaeeeeeees 23 7 6 MODIFYING THE CURRENT VIEW 24 7 6 1 Adding List Groups Columns Column 25 7 6 2 Re ordering Groups Columns Column 25 7 6 3 Removing Groups Columns Column 25 7 6 4 Setting a VIEW Default et
80. 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 l 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 DAD SIERRA LEONE ANALYTICS USER MANUAL 65 10 6 5 Switching Report Table Components The report table components may be switched 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 l Click on the component item that needs to be switched 2 Select the Switch Place with option from the menu that appears Figure 50 Show As 3 Sorting Order Total H Move Right Remove gee Move To R Replace j 53 Switch Place With E E Properties I Project Cols 2 1 Year Quarter Cols 3 Supervising Unit Figure 50 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 add
81. ristics e g sorting order reference text etc Figure 47 Ei Preview Text Figure 45 Formatting Styling Text Entries DAD SIERRA LEONE ANALYTICS USER MANUAL 62 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 selected report table components 4 Click the Apply button for the changes to take effect Clicking the OK button will close the window and navigate you to the Report module support synisys com Contact us 231222 2315458 9 My Profile About Help Log O st DAD SIERRA LEONE My Portfolio Dashboard Advanced Search i Title 7 i Subtitle v Remove Filters View Criteria i Header Filter by Choose and structure the information you wish to report on in the table below Expand the Preview Funding Source section to view the final look and structure of the report Donor Agency Implementer Click here to view row column compatibility matrix District Chiefdom 2 Group report by More Filters Donor Agency Y Add Groupin Fi i ils by Distri idem Financial Details by District Show As gt illc IEEE f i i ai Z
82. roject Cost USD Implementer I Committed USD Chiefdom Disbursed USD More Filters M Project Cost SLL e I M Committed SLL n Borders e Funding Source Activity e Ongoing Projects by Fund e UN Projects i Southern 100 km 100 mi COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC Figure 30 Selecting Chart Type 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 district level the border information for both provinces and districts will be displayed on the map e Province displays the border information for all provinces e District displays the border information for all districts e Chiefdom displays the border information for all chiefdoms 9 4 5 Viewing Legend To explain the data series or categories on the map the legend is used to identify the patterns or colors that are assigned to the selected categories Figure 31 It is worth DAD SIERRA LEONE ANALYTICS USER MANUAL 4 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 Inthe 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
83. rove 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 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 51 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 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 DAD SIERRA LEONE ANALYTICS USER MANUAL 68 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 Projects Application User Manual see REFERENCES 2 Make the appropriate changes in the input window and Save DAD SIERRA LEONE ANALYTICS USER MANUAL 69 12 CUSTOMISED REPORTING IN
84. rsonal details log into the application go to the My Profile section Figure 3 and make the appropriate changes DAD SIERRA LEONE ANALYTICS USER MANUAL 9 suppaortgisynisys com Contact us 799 99 358458 0 My Profile About Help Log I DAD SIERRA LEONE Required Field My Profile Note You should provide a valid e mail address It will be used for future correspondence Synergy support syn isys com Synergy PO PO E PO If you would like to change your password please type the current and the new passwords in the fields below Figure 3 My Profile Section 3 2 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 public users to enter it without registration Public users wishing to view data should click on the ENTER AS PUBLIC USER on the login screen Figure 1 They will be directed to the List module of the application DAD SIERRA LEONE ANALYTICS USER MANUAL 10 4 DAD ANALYTICS STRUCTURE 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 e LIST MODULE used to create and execute ad hoc queries on the data and acquire results in the form of a list e CHART MODULE used to filter and di
85. splay the data in a chart form e MAP 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 main window has a complex preview as it is shown in the Figure 4 My Profile About Help Log DAD SIERRA LEONE Header L My Portfolio Dashboard Chart Main Toolbar y Hide Images G EJ H sever cf Gy Modify Current View of Committed Disbursed Projects USD USD Donor Agency Project Unspecified Arab Egyptian Aid Development Agency 44 556 202 27 552 492 Assemblies of God Relief and Development Organisation AGRADO 344 263 221 220 879 621 Filter by GD Association For Rural Development ARD 266 280 332 175 316 554 Funding Source Ben Hirsch Child Care Women in Development Programme 200 889 350 114 846 420 Donor Agency l CEM Development Office 22 544 462 22 544 361 E Chibuzor Human Resource Development Organisation CHIDO 36 717 892 24 747 313 KZ Christian Extension Services SL 1 490 053 1 490 053 4 Christians In Action Development Agency 23 201 360 15 982 625 BJ Community Action for Rural Development CARD SL 46 149 412 39 155 797 4 Community Action for Rural Empowerment 67 541 601 60 639 719 Community Programmes For Women 1 110 000 207 962 zm Conservation Society of Sierra Leone 24 599 409 Projects by Sector E
86. sseeceeeccccccccccccccccssctssseseeccceccecceceeceaaaaatessseeeeecceees 31 FIGURE 23 VIEW SCREEN OF THE CHART 34 IGURE Z4 SAMPLE a toon besdacatatenecdbaainetescess esiacsusieneessladtacoasiesne 36 FIGURE 25 SAMPLE GHART REPORT Za eos A NE 37 FIGURE 20 MAP MODULE S 2 5 152122 08 620 EA E Coto tacta 38 FIGURE 27 NTELLIGENT SEARCHING uocis cotes eee Ore eve din cota Eva dpi 42 5 43 FIGURE 2 PCI dE 44 FIGURE 30 SELECTING CHART
87. st general to the most detailed 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 buffer zone querying laj_nicol qmail com Contact us 4 555 52 235458 9 My Profile About Help Log Off Me DAD SIERRA LEONE mm My Portfolio Dashboard Zoom to GO E Pie Chart v P a j n ib a ui Hut W 1 n Info V 4 Cursor position Lat 9 74 Long 10 60 Remove Filters P 3 Categories View Criteria Scaling i Nationwide Filter by Chart Funding Source Borders Donor Agency Implementer District Chiefdom More Filters i Northern e Funding Source Activity e Ongoing Projects by Fund 9 UN Projects i Southern m 200 km Select n Zoom by Selection Mini Map Buffer Zone Query Measure Distance Figure 26 Map Module COPYRIGHT 2011 SYNERGY INTERNATIONAL SYSTEMS INC DAD SIERRA LEONE ANALYTICS USER MANUAL 39 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 Category or Indicator data Static Data Borders Cities Rivers Roads Construction Sites etc Names and Lab
88. t _ v Cursor position Lat 10 51 Long 9 93 Advanced Search Remove Filters Categories View Criteria View Criteria Scaling lil Nationwide Filter by E nationwide Henan Funding Source Borders Donor Agency Implementer District Chiefdom More Filters E e Funding Source Activity e Ongoing Projects by Fund e UN Projects Figure 29 Buffer 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 e Display categories e Choose to view data on a scaling map DAD SIERRA LEONE ANALYTICS USER MANUAL 45 e Plot data in the form of different graphs pie chart or bar chart e Display map features such as province district or chiefdom 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 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 s
89. te tesco aces ete elo ope Neen eee 26 7 7 SAMPEESVIBULS can 26 7 7 1 Sample View 1 Total Commitments and Disbursements by Sectors 26 2 Sample View 2 Projects Distribution by Geographic Location 28 8 CHART HM 30 8 1 KEY ET IRE an OA 30 8 2 ACCESSING THE GCHART IMODULE 45 5 0 Petre vestuanls ote d e Pan ev DUE D Oe e ed eae 30 8 3 MAIN SCREEN AND TS COMPONENTS ccccccceseecccccccccceseeeecccccccceseeeececccccesseeececcceuaatecececccauasesececceeas 31 8 4 VIEW SCREEN AND TS COMPONENTG cccccccssececcccccccccsseecccccccccscseccccccccaeseeecececeaautsececcccesaaateeececeeeas 34 8 5 SAMPLE GHART RREROR GS 2t E dre a ess Mo esteem essit E EAO E 35 8 5 1 Sample Chart Report 1 Commitments and Disbursements Distribution by WODO SE EOF i nee meer E Pe testo Eo eI LE Uie EU ERE ERE 35 DAD SIERRA LEONE ANALYTICS USER MANUAL 2 8 5 2 Sample Chart Report 2 Total Commitments and Disbursements Distribution by Province 36 9 MAPMODULE 38 9 1 KEY FEATURES OF THE GI S TOOL tuc eh b tiers Hohen sateen e A Eae ERR 39 9 2 DYeezsclesus zu aulemU RT mM ES 40 9 3 THE MAP MODULE SCREEN COMPONENTS ccccccccssscccesssececesseeceessseceesssecceeseeceesseeceessseeceenseeeeesseeeeesaes 40 9 4 WORKING I
90. teria Filter by Advanced Search Text to find development Search in d Imlementer Sector Project Title Project Code Doner Agency d National Partners F Province Current Criteria Figure 59 Defining Search Criteria 80 If you have selected to search for development among project titles and sectors Figure 59 the following search results will appear Figure 60 EN DAD SIERRA LEONE My Portfolio iG Dashboard development su T Contact us 2 List List Please note a filter is applied you are currently reviewing a selection sub set of all projects 2 Hide Images My Profile About Help Log Off s 3 3 Save As Modify Current View 3 Committed Disbursed 2 P CINE Remove Filters 00 Unspecified 3 62 939 070 928 152 View Criteria fk 012 Transparency and democracy E 5 842 848 5 823 816 Filter by 013 Capacity Building of government agencies 8 67 339 350 45 882 930 Funding Source 014 security Sector 1 1 978 578 1 978 578 implemester 8 015 Decentralisation 3 47 193 510 12 051 108 Chiefdom L 001096 Preventive Development Support 450 000 449 598 Y More Filters SL 001221 Capacity Development of Grassroots Institutions 1 401 510 1 401 510 SL 001315 Capacity Development for Comprehensive District Development in Northern Region 45 342 000 10 200 000 016
91. the Filters section that represents the Category according to which the filtering will be carried out A Filters window Figure 55 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 56 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 i e List Chart or Map The system will regenerate and download to the client s s
92. ts 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 Chart Map and Report Modules 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 SIERRA LEONE ANALYTICS USER MANUAL 74 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 instructions below to create filtering criteria l Click on the hyperlink under
93. w various types of reports such as lists maps and charts displayed in a user friendly environment on a dashboard Unlike regular reports dashboards provide visual at 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 An 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 E s 6 2 Accessing the Dashboard Module In order to access the Dashboard module of the system you should click the Dashboard DashbORT tab This will navigate you to the Dashboard module In this module you can create dashboards include reports under them etc DAD SIERRA LEONE ANALYTICS USER MANUAL 16 6 3 Main Screen and Its Components support synisys com Contact us 545 55 225458 9 My Profile About Help Log Off o DAD SIERRA LEONE 55 Dashboard Customize Update A
94. yed in the Report Designer Figure 48 7 Expression Show As Ji Sorting Order Move Up Move Down x Move Left 7 Move Right So Remove hy Replace ET Switch Place With 7M Properties Figure 48 Reordering Report Table Components DAD SIERRA LEONE ANALYTICS USER MANUAL 64 Note If any of these actions is not available the respective option will be disabled in the menu 10 6 3 Sorting Report Table 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 A Z or a Descending Z A order In order to alphabetically sort the report table components follow the steps below 1 Click on the component item for which the sorting order needs to be changed Select the Sorting Order option from the actions list Figure 49 3 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 the sorting criteria IM Note The sorting order for the report components can also be defined from within the Properties window Show As t Sorting Order none Total Sort Ascending e Sort Desc ing 4 T i Move Right Remove Move To i Pid Replace r Switch Place With PM Properties Figure 49 Defining the Sorting Order 10 6 4 Removing a Report Table Component It is possible to remove a

DAD Sierra Leone User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents