Home

User Guide - African Development Bank Fragile States Portal

1. AirScan AKE Group ArmorGroup International Background Asia Risk Solutions ChaseWWaterford Special Projects Chilport DynCorp International 0 EOD Technology Erinys International Global Strategies Group Groupe GEOS Groupe EHC International Charter Incorporated of Ore International Security amp Defence Syster International Peace Operations Associz Meyer amp Associates O MPRI MvM Northbridge Services Group Olive Security Overwatch Protection Solutions Internat Pacific Architects amp Engineers B Paci Kl u m mna 2 Viewing Country Profile The Maps page of the portal enables you to display key information about a country Details of the currently selected country include a brief description and two charts 28 amp FRAGILE STATES Portal Overview Data Search Countries List Congo Dem Rep ES Fa Cont Rep E 1 Cote d Ivoire Djibouti Egypt E Equatorial Guinea EM Eritrea BE Ethiopia E Gabon E Gambia amp Ghana HG Guinea BE Guinea Bissau SE Kenya Lesotho Liberia wm Libya E Madagascar E Malawi E Mal ul E Mauritania E Mauritius A E Morocco E Mozambique BA Namibia Niger ET Nigeria E Rwanda E Sao Tome and Principe y Regional Organizations International Conference on Indian Ocean Commission I Mano River Union MRU lt m A opment Bank Group
2. Erinys International Global Strategies Group Groupe GEOS Groupe EHC International Charter Incorporated of Ore Intemational Security amp Defence Syster International Peace Operations Associs Meyer amp Associates MPRI mvm Northbridge Services Group Olive Security Overwatch Protection Solutions Internat A A es A ah Jil man gt 22 Visualizing stability and instability factors on the map The Maps page of the portal enables you to visualize specific indicator stability and instability on an additional layer of the map This kind of data is displayed for fragile states only e To select stability and instability factors open dimension box on the right panel and select needed indicators The quantitative indicators are displayed as a histogram over the corresponding country Select the Legend tab on the right panel to see the histogram s legend FRAGILE STATES Portal English Francais PTT eran samse aoews ELCO Data Query Dashboards Data by Topics Indicators GDP current US 2011 Stability Factors Total 6 Pr C Show non empty indicators a Show all countries cau a E Social indicators A E Eee Most populous cities A Index of Intra African trade MA Index of External trade Number of neighboring fragile states Natural resources endowrr El Unemployment levels amp Infrastructure endowment
3. E 39 Filtering data trom th taDlO sasnusasoen nados sad 39 Highlighting data in the table eonenesnsonsnsonsseonsonensonsneonsnnensnnsnsnnsnnnsnnsnsnnsneonsnnnsonsannn 40 Adding conditional formatting to the table nennsessesessesessnnnnsnnnenonnnnonnnnnennnnene 42 Adding columns and rows for totals ccccssssessccsssesscssccssesssseeececesceeseeseceaceesseseneecees 43 Performing a Pareto 80 20 analicen sio 44 Applying a table leia 45 Setting the data formal ee ea ee 46 VV ORIGINS in CNAE ii 48 Changing the Chart Cy DS cata cites i u i enna E 48 Showing and hiding chart labelS oooonoonionnnnonioniononononnccnnocononacnonooononoononarncnnonocnnonos 49 Customizing the ca bue E E 49 Changing the range of data displayed on the chart in Table Chart mode 50 Hiding the table in Table Chart mode ooooooconooononononncnncnnonnononncoconnonononccononoononacnoss 50 PrINting a d exporting the results iaa 5 Printing te SS Uli case a ieee eee vote E E ORTE 5 o ons a coeur eocauteseh er E a E EE re vecaccsenens 5 Data Query 53 About Data Oeynhausen 55 Selecting the SOUFCE ne een 56 Selecting Ns o 57 Selecting elements from the dimension sesesssssssesesesossssesesesesesesesesesossssssesesesesesesesese 57 Searching for elements in a dimension sesesesesssssesesesossssesesesesesesesesesorsssesesesesesesesesese 58 Using a dimension s list context menu
4. Hide zero cells Hide empty cells Hide non numeric cells Hide cells satistying the condition Less than A A 100 lt E10 VE Can Check or uncheck general filtering options Hide zero cells Check this option to hide table cells containing the value 0 Hide empty cells Check this option to hide table cells containing no value whatsoever This option does not filter table cells whose value is equal to 0 Hide non numeric cells Check this option to hide table cells containing letters or symbols but no numbers Choose a filtering condition from the Hide Cells Satisfying Condition drop down menu and then type values in the A and B fields as required The A and B values correspond to the variables A and B in the condition statement If your filtering condition does not require a B value then this field remains uneditable Click Ok The Data Filtering Settings dialog box closes and the portal applies the filter to the table Highlighting data in the table To highlight data in the table follow these steps 40 e Click the Data Highlighting button gt in the toolbar above Table view The Data Highlighting Settings dialog box appears 5 Data highlighting settings Condition Less than A Format cell background font size 10 gt color E v Bold tale Underline ain Cancel Clear Choose a highlighting condition from the Condition drop down menu and then type values
5. of the following toolbar buttons e Line To apply this type of chart click the Line button e Column To apply this type of chart click the Column button 1 1 e Bar bottom up To apply this type of chart click the Bar Bottom Up button e Stacked column To apply this type of chart click the Stacked Column button sii e Stacked bar bottom up To apply this type of chart click the Stacked Bar Bottom Up button a 61 e Area To apply this type of chart click the Area button ta e Pie To apply this type of chart click the Pie button Working in the Map mode The Map mode visualizes data on the interactive map of the world You can show Map mode by clicking the Map button in the toolbar To visualize an indicator on the map expand the drop down menu in the top left corner of the browser window and click an element to select it The portal visualizes selected elements on the map Portal eN English Francais a i AN hh CN W Data Search Data Analysis Data Query Dashboards Data by Topics Resource Center FRAGILE STATES Pa Select Data Source 2 Select Elements 3 Construct Data View View results a BoA 5 re bass Total population million gt Units y Legend Locations W 27 52 m 162 47 M I 12 45 m 27 52 m I 5893 74 K 12 45 m W 1591 36 K 5893 74 K M 81 13 k 1591 36 K No data e To change the year click the corresponding year below the map 2009
6. FRAGILE STATES WY er Portal English Francais n eee a Pa Hi AN ca N sees 5 Overview Data Search Data Analysis Data Query Dashboards Data by Topics Resource Center Name Source Description Date ADB FSF Projects Information ADB Research on Fragile States U t IIN Fragility and State Building Public Finance Management Capacity Building bad e Tobrowse to the Documents page choose Documents from the navigation bar e Togo to the list of publication double click one of the topics e To come back to the list of topics double click the Go back button th e To download a resource double click its publication name The portal opens a new browser window and initiates your browser s procedure for downloading files For example in Microsoft Internet Explorer the File Download dialog box appears click Save to save the file to your computer 77 About The About page provides contact information as well as the User Manual ay FRAGILE STATES s De 1 Portal English Fran ais Br A EE N m Overview Data Search Data Analysis Data Query Dashboards Data by Topics Resource Center About Tutorial Data Portal Contacts 6 User Manual Mailing address Fragile States Unit OSFU African Development Bank B P 323 1002 Tunis Belvedere Tunisia Phone 216 7110 3791 Fax 216 7133 5537 E mail e mohamedou afdb org e To browse to the Abou
7. sseessessessssesesesesesesesesesesessssssesesesesesesesesesessssses 58 Constructing the data Vi Wisconsin 59 Viewing the resultat ee 60 WV OF KING In the Table Mode ua 60 Working in the Chart mode u00s0020000000000200e000n00ne0nennennnnennennennsnesnennennsnesnennennennsnesnenne 6l Worldne In the Map mode E TNA 62 Printing and exporting the results anne 64 Printing eres ae 64 EXPONE CIS TES airoso 64 Dashboards sica 65 About Dashboards nn ae A AOE 67 Working with dashboard visualiZationS ccccssscececcsssssssceccsssecseseccsccsceeeeesecccseeseeeeescees 68 Printing and exporting the dashboard document useesessessesesessesnennennnnnnnnnnennnnnnnnnnnnnnne 69 A O 69 EXporting the Pesults atico ica 69 Data DY Topics TI About Data DY TOPICS usina 72 EXDIOMING report DES nee 73 NAC WING Pepo Senats 73 Customizing a reports msc 74 Using the dimension box s context MENU cecesesseseceeceeseeeecceccceeseesecsecesceeseeseneeees 74 Printing and exXporting the resuls au a ae a E A 75 PEINEINS CHE PESUCS nee ee ee 75 EXPONE Relata 76 Resource Center iiisiniuhuiieitsisssessssense 77 IDO UE BECPRRERFERDERFPUFERFCERETETTLETFTERBETUERTTCEFETLFFEEFFERCHLLCFERT EEE ET LE dass cinc 78 Using the Portal In this chapter About the Fragile States Portal essesoesesnenesneonesneneonennennennenennennennennsnennennennsnesnennennsnesnennnne 8 System MEGUIMEMICIES scaacscissczcsesssneceesssascoes
8. Chad 17 Access to flush toilet septic tank as primary sanitation national of population Chad 18 Access to flush toilet septic tank as primary sanitation rural of population Chad 19 Access to landline telephone capital city of population Chad 20 Access to landline telephone national of population Chad Page 1 of 44 lt previous next gt oo Iz py cn pS TI py h co po O E Dos sozas 0121 African Development Bank Group 2012 e To browse to the Data Search page choose Data Search from the navigation bar 13 Searching the data To search the data according to any criteria do the following Type the search criteria in the search field The portal starts the searching process automatically Source Chad Q After the search finishes the list of data series found will be displayed under the search field To filter the data by a data source do the following Open the Source drop down menu on the left side if the search field SaSocio economic Database PEIFSP Pri Select the data source name to search the data in this data source Navigating the results If the search returns a large number of data series use the navigation bar under the list of results e To goto a results page click its number button e To go to the subsequent results page click the Next button e Togo to the previous results page click the Previous button Pag
9. To export the results to an external file format follow these steps e Inthe toolbar click the button corresponding to the file type to which you want to export the results Export to XLS Export to PDF a This format opens in Microsoft Excel This format opens in Adobe Acrobat e The portal opens a new browser window prepares the external file and initiates your browser s procedure for downloading files For example in Microsoft Internet Explorer the File Download dialog box appears click Save to save the exported file to your computer 64 Dashboards In this chapter o Es eo EA E S 67 Working with dashboard visualiZations cccccsssscesscssssssecssccscessseseccscesceeseesecccsseseeeeeecees 68 Printing and exporting the dashboard document u ursessessesssessessennenonsnnnnnnennnnnnnnnnnnnne 69 a A o O In e 69 EXPOrEINE Me SS see rare 69 65 About Dashboards The Dashboards page of the portal shows tables charts and maps for various indicators The visualizations that you get for any given indicator are built into the portal you cannot modify these preset types directly although for your convenience you can change any chart or map into a table and back again with a simple mouse click a Data Analysis FRAGILE STATES Portal English Francais N Dashboards Resource Center Data Query Data by Topics Calendar 2010 Country Chad Calenda
10. formats To export the results to an external file format follow these steps e Open the data series in the table chart mode modal window In the toolbar click the button corresponding to the file type to which you want to export the results Export to XLS This format opens in Microsoft Excel Export to PDF 2 This format opens in Adobe Acrobat The portal opens a new browser window prepares the external file and initiates your browser s procedure for downloading files For example in Microsoft Internet Explorer the File Download dialog box appears click Save to save the exported file to your computer Maps In this chapter ABOUETIIDS ee ee er 19 MISHA DOM io PPP a PPP er ee E 20 Visualizing a source and an indicator on the Map eesessesessessessennennnsnnnnnnennnnnnnnnnnnnn 20 Visualizing stability and instability factors on the Map ooooconccncnococanococonnnononanonononnonnoso 23 o e E E EE 26 Viewing County ProT Osses ennie E ENE E ia 28 EDGE EA A EA E E A E E ee nee 30 About Maps The Maps page of the portal enables you to visualize any indicator in any of several preset years on an interactive map of Africa 9 FRAGILE STATES i Wr SS Portal y English Francais Q 4 AN lth cE Data Search Data Query Dashboards Data by Topics Resource Center Indicators GDP current US 2011 Registered Private Security Companies Pr O Show non empty indicators only Show all c
11. 2010 2011 2012 62 Using the legend The map s legend enables you to highlight only those countries that belong to a specific range of data To do so switch to the Legend tab if necessary and hover over the desired range with the mouse pointer You do not need to click the FRAGILE STATES N m oS English Fran ais Q ew Data Search Data Analysis Data Query mouse button to see this effect Select Data Source 2 Select Elements Legend Locations M 27 52 4 m M Ml 12 45 m 27 m IM 5893 74 k 12 45 m MM 1591 36 K 5893 74 K I 1 12 K 1591 36 K No data 63 Printing and exporting the results The portal enables you to print the table and chart or your printer or export them to one of two external file formats Please note that the current mode of the results area Table mode Chart mode or Table Chart mode determines exactly what the portal prints or exports For example if Table view is currently hidden because you have enabled Chart mode then the portal ignores the table and prints or exports the chart only Printing the results To print the results follow these steps e Click the Print Preview button in the toolbar The portal opens a new browser window containing a printer friendly version of the results e Click the browser s Print button Your browser sends the printer friendly version of the results to your printer Exporting the results
12. 2012 4 N English Francais d Data Analysis Data Query Country Profile Congo Dem Rep Total Area 2 344 858 00 sq km Capital Kinshasa Currency Congolese franc CDF Agriculture value added 8 GDP growth 72 00 48 00 24 00 Agriculture value added of GDP il GDP growth annual Dashboards Resource Center Data by Topics Back to Map Population 67 757 577 00 total 2011 GDP 15 642 236 881 13 current US 2011 GHI per capita 190 Atlas method current US 2011 Inflation 17 30 consumer prices annual 2008 Current account balance no data of GDP Trade Balance 6 000 00M 4 800 00M 3 600 00M 2 400 00M 1 200 00M EEE ae ea a SPS HHS PH HP FPS HP oH rPPP PE PEF ep Ila Exports of goods and services current US Ila Imports of goods and services current US S N Ul e To view details for a particular country click this country on the map e To select country or regional organization click the desired country regional organization in the list on the left Back to Map e To revert to Map view click the button description above the 29 Exporting the map The Maps page of the portal enables you to export any indicator in any of several preset years to the PNG graphics file format e To export map to a PNG file click the Export button Download as a picture bove the map 30 Da
13. 264 855 00 1 289 526 00 1 314 795 00 1 340 814 00 Liberia 2 847 290 00 2 939 296 00 299608200 303741200 3 092 721 00 Sao Tome and 141 010 00 143 430 00 145 761 00 148 038 00 150 311 00 Principe GS African Development Bank Group 2012 e Dashboards Data by Topics 3 Construct Data View Resource Center A View results Total population million gt Units 2005 2006 2007 2008 2009 2010 7 251 424 00 7 474 363 00 7 707 781 00 7 943 385 00 8170 853 00 8 382 849 00 4 017 880 00 4 087 53400 4 160 940 00 4 237 961 00 4 318 128 00 4 401 051 00 9 785 902 00 10 084 087 00 10 371 839 00 10 653 762 00 10 937 089 00 11 227 208 00 642 974 00 660 559 00 678 602 00 697 034 00 715 774 00 734 750 00 3 533 177 00 3 628 561 00 373061200 3 836 339 00 3 941 454 00 4 042 899 00 18 020 946 00 18 325 979 00 18 646 754 00 18 987 007 00 19 350 026 00 19 737 800 00 808 367 00 57 420 522 00 823 682 00 59 088 415 00 839 453 00 60 772 175 00 855 636 00 62 474 901 00 872 090 00 64 204 304 00 888 716 00 65 965 795 00 4 456 155 00 4645 837 00 4 798 561 00 4 947 521 00 5 097 998 00 5 253 676 00 9 041 448 00 9 201 941 00 9 373 619 00 9 559 110 00 9 761 217 00 9 981 590 00 1 367 695 00 1 395 492 00 1 424 191 00 1 453 757 00 1 484 120 00 1 515 224 00 3 182 539 00 3 313 718 00 3 477 197 00 3 658 460 00 3583592900 3 994 122 00 152 622 00 154 970 00 157 361 00 159 852 00 162 515 00 165 397 00 2011 8 575 172 00 4 486
14. Chart setup Chart title I Chart type Column Glamorous columns filling Series Populations seres type Columns plot on secondary axis Line color L Line thickness 0 1 Transparency 50 Fill type Glamour Base color Transparency 0 View Background color show gridlines Labels Display data labels Legend Display legend Bottom 49 Changing the range of data displayed on the chart in Table Chart mode To change the range of data displayed on the chart in Table Chart mode drag to select the cell or range of cells in Table view that you wish to display in Chart view The portal redraws the chart to include only the data from the selected cells You can also select table elements with a single click e To select an entire column of the table click the header cell at the top of the column e To select an entire row of the table click the header cell at the left of the row e To select the entire table click the cell in the upper left corner of the table where the header column and the header row intersect Hiding the table in Table Chart mode To hide Table view when Table Chart mode is active click the Hide Table button in the toolbar above Chart view The portal reverts to simple Chart mode To restore the view of the table click either the Table Mode button or the Table Chart Mode button ij 50 Printing and exporting the results The portal enables you to print the
15. Searching tHe diTi ee a ee 14 Navigating the results 0 15 NTS CHE AA a a ae ern 15 Printing and exporting the results cscscsssssscsecescesseesssceccecesseeseccecesceesseseeseceseeeseeeeeeeees 16 PNTE he SS MUS nenn een ee 16 EXportine te results sarracenos raoinaesnicunaisaolaara 16 Du MaD ccssssnisocsiasssussnsssacsanscanceaveaesscecansensousstasscasscsesansnccencuadscusseessassassasesasenacoasconsse 17 ADOUE ODE ee ee ee 19 Doa A eo E OO een 20 Visualizing a source and an indicator on the Map coooocccconocanocaconnnononononononacnnoncnoonnonnoso 20 Visualizing stability and instability factors on the Map ooooconocccccccococononononnnnnnnnononnnnnoss 23 Using the legend stones oras 26 Viewing Country Profile epica iiien 28 orne IE a ee E aaeese 30 t Data Anal SIS osado EE E E O 31 About Data Analysis O NA EE NE A aa aia aii 33 Loading a preset data ViOW csccsssssssscssssssssssssscssssssssssssessessssssssssacsessessssecsnssesensecseces 33 Selecting elements from the dimensions ssssssssessssssssesesesesesesesesesessssesesesesesesesesese 34 Changing the position of the dimensions sssesssesesesesesesesesessssesesesesesesesesesesesessessss 36 Undo and redo recent operationS e sesssesessssesesesessssesesersssesesesessesesesessssesesessesesesesss 37 Working in Table View csscsccsssssssscssssssscsssecsesssssssscsnssesssssssacsnsssssssacsacseseesecsacsessesecsacees 39 SOFUNS NE oo
16. 2011 African Development Bank Group 2012 e To show information about Private Security Company select the RPSCs tab and hover over the desired range with the mouse pointer 25 FRAGILE STATES Portal English Frangais BA Q i AN Overview Data Search Maps Data Analysis Data Query DES Resource Center Indicators GDP current US 2011 Stability Factors Total 6 Pr Show non empty indicators onl j S O ply 13 Show all countries 6808 Lagana Social indicators A Download as a picture i 8 AirScan A E Natural resources endowrr E Unemployment levels E Infrastructure endowment E National account AKE Group ArmorGroup International Background Asia Risk Solutions MGDP current US ChaseWaterford Special Projects GDP growth annual Chilpart GDP per capita current Chilport DynCorp Intemational ODE por tapia growin ds Chilport is one of the UK s leading Specialist Security Companies specialising in EOD Technology EJ Expenditure on GDP Canine K9 Disciplines training and supplying our own dogs for such activities as 3 GNI current US search and rescue SAR drugs dogs bomb detection dogs bomb dogs bomb sniffing Erinys International GNI Atlas method curri dogs RASCO narcotics detection and many other security and detection areas Global Strategies Group RAR annual 9 where dedicated dogs can be effectively deployed By being owned and op
17. 35 83 39 26 Sierra Leone Pr Mon a E E a y i a i iii L Mortality rate infant per 1 ive births 157 60 145 50 119 20 4 C Malnutrition prevalence weight for age of children under 5 Sl el g Literacy rate adult total of people 2 00 ages 15 and above i x 5 C Gender parity index for gross 1 80 enrolment ratio Primary i a ig C Gender parity index for gross 10 enrolment ratio Secondary All 0 49 programmes v C Gender parity index for gross 120 E 0 78 s enrolment ratio Tertiary 2 L Human development index HDI 0 24 0 25 0 34 7 u ii Economic indicators 1990 2000 m GDP current US 0 65 0 64 2 24 GDP current US GDP growth annual 3 35 3 81 6 00 2 C GDP per capita growth annual 2 06 0 93 3 70 Balance of debt a Al 2 Debt forgiveness or reduction current 0 00 0 00 E Im s m gt African Development Bank Group 2012 e To browse to the Data by topics page choose Data by topics from the navigation bar 72 Exploring report types The Reports page provides five built in reports e Country Profile This report displays various social economic political indicators for a selected country To change chart click on the checkbox near indicators e Regional Investment This report contains the list of AfDB approved projects e Socio political Country Profile This report displays information about political situation ethnic and religious group International Organizati
18. 837 00 11 525 496 00 753 943 00 4 139 748 00 20 152 894 00 905 564 00 67 757 577 00 5 415 280 00 10 221 808 00 Il 1 547 061 00 4 128 572 00 168 526 00 Working in the Table mode The Table mode displays data in the table form This mode is the default view in the Data Query module To show Table mode click the Table button in the toolbar Then do any of the following 60 To hide the empty values click the Filter button T in the toolbar To increase the decimal precision of rounded table values click the Increase Decimal button Hi oo in the toolbar above Table view To decrease the decimal precision of rounded table values click the 00 Decrease Decimal button gt e To change the visualized fixed element do any of the following Select the desired element in the drop down menu in the top right corner of the browser window Urban population gt Units T Total population million gt Units Urban population Units N Rural population Units Click the button near the drop down menu to visualize the next indicator in the list Click the button near the drop down menu to visualize the previous indicator in the list Working in the Chart mode The Chart mode enables to display data in chart form You can show Chart mode by clicking the Chart button u The portal provides seven different chart types To change the chart type click any
19. DP per capita current fa GDP per capita growth E Expenditure on GDP GNI current US GNI Atlas method curri GNI growth annual gt Current account balanc A Current account balanci Net capital account Bot External balance on goc 4 External balance on goc Legend Locations Flow of transfers MM 20684 20 m 408236 75 m Gross saving IM 8487 97 m 20684 30 M EJ Export Ml 3377 75 m 8487 97 m E Import Ml 1317 98 m 3977 75 m E Balance of debt Ml 76 46 m 1317 98 m amp Remittances level Ml No data E External payment amp Productivity level s f Fl oval nf arrace tn rancia ill lt gt gt 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 evelopment Bank Group 2012 23 e To display CSOs icons on the map do the following select the CSO item in the dropdown list on the right panel select the CSOs tab click on the desired CSO type You will see icons with corresponding type over fragile states FRAGILE STATES English Francais a dl AN lh EF Data Analysis Data Query Dashboards Data by Topics Resource Center About Indicators GDP current US 2011 O Show non empty indicators only EA Legend RPSCS cada cid e Download as a picture Stability Factors Total 6 Pr Show all countries v A Association Cooperative Development Consultancy Natural resources endowrr Unemployment levels Infrastructure
20. Elements 3 Construct Data View A View results Indicators Regions Select all Deselect all Selected 3 a Search eo Regions _ Countries Selected 19 _ Aggregates es _ Fragile states x Fragile states Y Burundi x Burundi p W Central African Republic x Central African Republic y v Chad x Chad iM Comoros x Comoros iM Congo Rep x Congo Rep l W Cote d Ivoire Ente d enire iM Djibouti iM Congo Dem Rep W Eritrea Calendar W Guinea v Guinea Bissau selected 13 W Liberia iM Sao Tome and Principe iM Sierra Leone iM Somalia v nits v Sudan Y South Sudan selected 1 Y Togo iM Zimbabwe Right click on any indicator above to review extended selection functions e Togo to the next step of the wizard click Next e To change the data source click Back Selecting elements from the dimension To select the elements from the dimension do either of the following e Select the dimension by clicking its title in the list on the left side of the browser window and check the checkboxes near the desired elements e Use the Select All and Deselect All buttons to select or deselect all elements in the list 57 Searching for elements in a dimension To find an element quickly use the Search tool above the dimensions elements field Type the text to find and the portal displays all element names that contain this sequence of characters in the dimension box s drop down menu Using a dim
21. FRAGILE STATES Portal Fragile States Portal USER GUIDE Copyright 2012 Prognoz Corporation All rights reserved All trademarks are the property of their respective owners No portion of this user guide may be reproduced or transmitted in any form or by any means electronic or mechanical including photocopying recording or information storage and retrieval systems for any purpose other than the recipient s personal use without the express written permission of Prognoz The information contained in this user guide is subject to change without notice While every effort has been made to ensure the accuracy and reliability of this information neither Prognoz nor its partners or affiliates shall be liable for errors contained herein or consequential damages in connection with the furnishing performance or use hereof The software described herein is licensed subject to the conditions set forth in the software services agreement Document version 1 0 Table of contents 1 Using the Portal erratas een 7 About the Fragile States Portal us0e00s00ssnssesneonenneneonennennennenennennennennsnesnennennsnesnennennsnessesnnne 8 System PEGUIMEMIEMES scascsesscaccsacssnsceasssascnessunsdecoasetsnaciiacsoeessadsecstensdecsatadcsespeecdeeneenideacssasdonseuetaoeess 9 USO SN WY een ne 10 2 DACA SEAMEN a siswcssscsnsscincssnscvncsanssnacsenssvadseesssasbisnsabscsenatons seessseasaessaesssedtbacsecssocssd Il E PS e o o 3
22. Microsoft Internet Explorer the File Download dialog box appears click Save to save the exported file to your computer 69 Data by topics In this chapter About Data DY TOPICS anne een 72 EXplOring REDOTT YPES armo O anton anes 73 VIEWINE A Opos 73 Customize A FEBOTE en ee 74 Using the dimension box s context MENU uesessessessennssnnsennennennnnnnnennnnnnsnnnnnsensnsnnsnnsnnnne 74 Printing and exporting the results r20ss0ssssssossonsonnonnonnonnonnonnonnonnnnnnnonononnonnonnonnennenne 75 A en ee een 75 EXPOrtinp CIS results nee eine 76 71 About Data by Topics The Data by Topics page of the portal enables you to view customize and print or export reports i gt FRAGILE STATES 2 Portal English Francais A el 4 AN l l Ta Overview Data Search Data Analysis Data Query Dashboards Data by Topics Resource Center Reports 2 84 Country Profile Regional investments Sierra Leone Country Profile Socio political Country Profile i f Indicators 1990 2000 2011 Diagrams Conflict and crime C80s Social Indicators x Population growth annual a i 9 Envilonniental County Pranie Population growth annual 1 26 2 81 2 19 2 00 L GNI Atlas method current US 802 290 046 23 633 723 190 98 2 069 102 129 14 a C People living with HIV AIDS total 500 00 21 000 00 29 Regions Urban population of total 33 03
23. States featured in this Portal are the ones eligible to the AfDB Fragile States Facility The portal provides comprehensive quidance on economic and social data for fragile state economies from various institutions and public and private sources as well as AfDB project and research sources Factors leading to fragility such as structural and economic factors political and institutional factors social factors and international factors are included The availability of this information aims at facilitating the Bank and other stakeholders to make strategic choices and define overall objectives We trust the indicators included in this Portal will assist users in monitoring the impact of statebuilding interventions and measuring progress for the accountability of governments toward their citizens as well as development partners Defining goals setting timelines and establishing performance benchmarks represent political commitments and need to be appropriate to the context Monitoring and evaluation indicators need to account for the long time frames involved in any fragile or conflict affected setting We wish you a fruitful navigation O African Development Bank Group 2012 10 Data Search In this chapter About Data Search nun een AP 3 id the MN aae mA E E E E EE pee eettaetees 14 Navigating the results en 15 We Wine the Gi ean E E palito 15 Printing and exporting the results 2c0u20000e00e002000000eonennenennennennenn
24. Technology Erinys International Global Strategies Group Groupe GEOS Groupe EHC International Charter Incorporated of Ore International Security amp Defence Syster International Peace Operations Associs Meyer amp Associates MPRI MM Northbridge Services Group Olive Security Overwatch Protection Solutions Internat Pacific Architects amp Engineers s u Ju EX e To focus on a particular region of the map such as Central Africa switch to the Locations tab and choose the desired region 27 Data Search Data Analysis Data Query y 4 N Dashboards Data by Topics Resource Center Indicators CI Show non empty indicators only Social indicators A DP current U S GDP growth annual GDP per capita current GDP per capita growth Expenditure on GDP GNI current US GNI Atlas method curr GNI growth annual Current account balanc Current account balance Net capital account Bot External balance on goc External balance on goc Flow oftransfers Gross saving Export i Import Balance of debt Remittances level External payment Productivity level Level of access to financial i Flineame level of nanulatian IM GDP current US 2011 Show all countries Download as a picture Legend Locations All Africa Southern Africa Northern Africa East Africa West Africa Central dni ly
25. a time while dimensions in Columns and Rows positions support multiple element selections e To change the position of a dimension drag and drop it e To change the order of the dimensions in the field drag and drop the dimensions e To goto the next step of the wizard click Next e To change the selection of elements click Back 59 Viewing the results The View Results step provides three data visualization types for selected data table chart and map gt FRAGILE STATES wwe T Portal English Francais O AN BZ Overview N Data Search 1 Select Data Source Data Analysis 2 Select Elements Data Query a DEA OF amp 2000 2001 2002 2003 2004 Burundi 6 374 347 00 6499653 00 6656071 00 6838 764 00 7 039 534 00 Central African 3 701 607 00 3 767 068 00 3 829 238 00 3 890075 00 3 952 281 00 Republic Chad 8 222 327 00 8517 944 00 883119900 9153893 00 9474 792 00 Comoros 562 469 00 577 569 00 593 170 00 609 271 00 625 876 00 Congo Rep 3 135 773 00 3 213 330 00 3 288 923 00 31365171 00 3 445 765 00 pols 16 581 653 00 1689286400 17 180 649 00 17 455 501 00 17 731 840 00 Djibouti 731 930 00 749 604 00 765 283 00 779 640 00 793 738 00 Congo Dem 49 626 200 00 50 989 424 00 52 491 329 00 54 098 245 00 55 754 885 00 Rep Eritrea 3 667 576 00 3812147300 397397300 4 145500 00 4 318 343 00 Guinea 8 344 486 00 8 472 339 00 860493600 8774395400 8 889 321 00 Guinea Bissau 1 240 655 00 1
26. al de Rural population of total population a Population growth annual dk Urban population growth annual dk Rural population growth annual African Development Bank e To browse to the Data Analysis page choose Data Analysis from the navigation bar Loading a preset data view Data Analysis provides several preset data views organized into categories like Socio Economic Database and Food prices The categories appear as the Sources list on the left side of the browser window 33 e To load a preset data view click a data view The portal makes the necessary selections from the dimensions and displays the corresponding data in the results area Selecting elements from the dimensions The data dimensions appear in dimension boxes on the left side of the interface These dimension boxes contain selectable elements or items which represent the data that appears in the results area All the dimensions are structured in that they organize their elements into a two or three tiered hierarchy For example the Trade Index element in Indicators is further divided into two separate subelements Index of Intra African trade and Index of External trade e To open a dimension box click the inverted triangle on its right side A drop down menu of selectable elements appears e To close the dimension box click anywhere outside it e To expand a parent element in the Indicators dimension click the triangle ic
27. d Fixed The Columns and Rows represent the columns and rows of the table in the results area while the Fixed position represents the values in the cells of the table By default the Calendar dimension is in the Columns position the Indicators dimension is in the Rows position and the Regions dimension and Units dimensions is in the Fixed position Columns Calendar Calendar Total 9 Fr Rows Indicators Populations Total 5 Pr Fixed Regions Zimbabwe Pr Units Units Er e To change the position of a dimension drag the dimension from its current position and drop it under the desired position The portal displays a blue line to show you where the dragged dimension will go 36 Auto refresh Columns Calendar Calendar Total 9 Fr Rows Indicators Populations Total 20 Pr negiodE Zimbabue Zimbabwe Dx Units Units Pr To lock a position click the triangle icon to the right of the position s name While locked the position s dimensions are hidden from view You cannot move dimensions to or from the locked position and you cannot change the element selection inside the affected dimensions Click the triangle icon again to unlock the To invert the dimensions in rows and columns quickly click the Rotate Table button in the toolbar above the Table view see Working in Table view later in this chapter for more information Undo and redo recent operations To undo
28. e Chart Mode button Ll or the Table Chart Mode button 11 in the toolbar This section covers the portal s various commands and options for working with data in Chart view Changing the chart type The portal provides various chart types To change the chart type click any of the following toolbar buttons 48 Line To apply this type of chart click the Line button Column To apply this type of chart click the Column button 1 1 Bar bottom up To apply this type of chart click the Bar Bottom Up button Stacked column To apply this type of chart click the Stacked Column button zi Stacked bar bottom up To apply this type of chart click the Stacked Bar Bottom Up button A Area To apply this type of chart click the Area button da Pie To apply this type of chart click the Pie button Y Radar To apply this type of chart click the Radar button A Line column chart To apply this type of chart click the Line Column Chart button 7 Showing and hiding chart labels To show or hide labels on the chart click any of the following toolbar buttons Axis To show or hide axis labels click the Axis Labels button ve Data To show or hide data labels click the Data Labels button As Legend To show or hide legend click the Legend button E Customizing the chart To customize the chart in Table Chart mode or Chart mode click the Customize chart button amp The chart setup dialog box appears jos
29. e 1 of 7 lt previous next gt M2324567 Viewing the data The Data Search tool enables you to view the data of the found data series To view the full data of the data series in Table Chart mode click the desired data series name in the results list Rural population of total population Chad Data It DM 2011 78 17 2010 78 26 Se 2009 78 28 A 2008 78 34 2007 78 33 X 2006 78 35 so LA 2005 78 37 A 2004 72 29 A 2003 78 4 Y 7 k 2002 73 43 2001 78 45 N 2000 78 47 1999 75 48 A 1998 78 50 pao 1997 78 52 1996 78 54 N 1995 73 56 820 4 1994 75 69 N 1993 78 81 e 1892 78 94 ao 1994 79 06 u 1990 79 19 gm nee 1989 79 40 1988 79 60 4987 79 581 mu L 1986 80 01 E 1985 20 22 1934 20 42 1983 20 62 1 1 Ci I 19 1999 1 L all el zu 2011 Printing and exporting the results The portal enables you to print the table and chart on your printer or export them to one of two external file formats Printing the results To print the results follow these steps e Click the Print Preview button in the toolbar The portal opens a new browser window containing a printer friendly version of the results e Click the browser s Print button Your browser sends the printer friendly version of the results to your printer Exporting the results The portal enables you to export the table and chart to one of two external file
30. e toolbar above Table view The Conditional Formatting dialog box appears Conditional formatting Color scales Icon sets BAD YY EL ley fic Pe par pe pr E tapuy 629305 e39000 00000 asasa Choose a color scale or icon set to apply to the table values Click OK The Conditional Formatting dialog box closes and the portal applies the conditional formatting scheme to the values in the table cells 42 Adding columns and rows for totals The portal enables you to add totals columns or totals rows which are columns or rows of the table containing sums averages or other common mathematical functions To add totals to the table follow these steps e Click the Totals button E in the toolbar above Table view The Totals Settings dialog box appears Totals settings Rows O Sum Average Minimum Maximum Number of non empty L Number of empty Mode Median ariance Standard deviation Skewness Kurtosis Range ariation coefficient _ Sum of squares First degree autocorrelation Upper decile Upper quartile Lower quartile Lower decile Treat empty values as zeros Columns Sum Average Minimum Maximum Number of non empty L Number of empty Mode Median ariance Standard deviation Skewness Kurtosis Range ariation coefficient _ Sum of squares First de
31. ed Organization A Foundation Trust E National NGO CSO Network Unemployment levels Infrastructure endowment Academy for Peace and Development Expenditure on GDP 0 uN All aa so Si an e NGO CSO i Center For Education and Development CED GNI current US Community Development Centre Y Not specified GNI Atlas method fcurn Cooperazione Internazionale GNI growth annual iis a a Wonen Tokero A E Subregional NGO CSO Network Current account balanci KAASHIF VOLUNTARY ORGANIZATION KVO E KISIMA Peace Development Organization E Think Tank Current account balanc Realsom Organization for Welfare amp Developmen Net capital account Bot Resource Management Somali Network Coordination 8 Trade Union i Resource Management Somali Network Coordination Office External balance on goc Solidarity Youth Voluntar y Organization SOYV External balance on goc Legend Locations Somali Journalists Rights Association y Somali Youth Movement for Democracy SYMD Flow of transfers I 20684 20 m 408236 75 MAA Feten Gross saving z 8487 97 M 20684 30 la Somalia Youth Link SOYL Export Ml 3377 75 m 8487 97 m Import IM 1317 98 m 3977 75 m Balance of debt Wl 76 46 m 1317 98 m Remittances level I no data External payment ES Productivity level _ Pa i El aval nf arrace tn arar lt gt Pai l Klum gt 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010
32. endowment al a MA DP current USS Faith based Organization GDP growth annual t i A Foundation Trust GDP per capita current gt GDP per capita growth q 4 E National NGO CSO Network Expenditure on GDP Y o NGO CSO GNI current US GNI Atlas method curri Y Not specified GNI growth annual gt 4 Subregional NGO CSO Network Current account balance Current account balanci Net capital account Bot External balance on goc External balance on goc Legend Locations EE Flow oftransfers E Gross saving A E Think Tank 8 Trade Union 20684 30 m 408236 75 M I 8487 97 m 20684 30 M E Export MM 2977 75 m 8487 97 m E Import IM 1317 98 m 3977 75 m _ Balance of debt M 76 46 m 1317 98 m Remittances level WE no data External payment E Productivity level Fli aval nfarrace tn rancia ill ES gt 1 i i i q ES IIA ES 2 000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 African Development Bank Group 2012 e To show information about CSOs hover over the desired icon with the mouse pointer 24 ih AN lth Data Quen Dashboards Data by Topics Resource Center Indicators GDP current US 2011 Stability Factors Total 6 Pr Show non empty indicators onl i 8 O ply y Show all countries E Legend RPSCs Social indicators Economic indicators Ad A Association Cooperative Development Consultancy Faith bas
33. ension s list context menu You can also right click any element in the open dimension box for a context menu of time saving commands 58 Select All The tool selects all the elements in the dimension Deselect All The tool deselects all the elements in the dimension Select Level The tool selects all the elements at the same level in the hierarchy as current element Deselect Level The tool deselects all the elements at the same level in the hierarchy as the current element Select Children The tool selects all the child elements of the current parent Deselect Children The tool deselects all the child elements of the current parent Expand All The tool expands all parent elements Collapse All The tool collapses all parent elements Constructing the data view The Construct Data View step enables you to construct the table and chart that will be displayed in the last step of the wizard N gt FRAGILE STATES English Francais Data Analysis Data Query Dashboards Data by Topics Resource Center 1 Select Data Source 2 Select Elements 3 Construct Data View A View results Rows Columns 1 Regions i Calendar Filters i Indicators Units Notice that these dimensions are arranged into three positions Columns Rows and Filters which correspond to the columns rows and cell data of the results table Dimensions in the Filters position can have only one selected element at
34. erated by g former Military Security Experts it ensures that the company is at the forefront of both Groupe GEOS Current account balanc traditional and state of the art techniques for all the disciplines it offers Groupe EHC Current account balanc Net capital account Bof International Charter Incorporated of Ore Information retrieved from Home on 20 June 2005 http www chilport co uk External balance on goc P International Security amp Defence Syster Fu 18 Legend Locations y ae External balance on goc International Peace Operations Associs Flow of transfers Ml 20684 30 m 408236 75 m Om dendi E ae eyer amp Associates Gross saving Ml 8487 97 m 20684 30 m y EJ Export Ml 3977 75 m 8487 97 M MPRI E import IM 1317 98 m 3977 75 m MM E P E Pa a MM 76 46 m 1317 98 m Northbridge Services Group E Remittances level Mi No data E External payment Olive Security amp Productivity level E i DO Levalint seeane tn financial gt C2 eT gt 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 ho a W ings Overwatch Protection Solutions Internat O African Development Bank Group 2012 Using the legend The map s legend enables you to highlight only those provinces that belong to a specific range of data e To highlight the country with specific range of data hover over the desired range with the mouse pointer You do not need to click
35. eye N m E TE ES 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 ES y pa u 2 O African Development Bank Group 2012 e To browse to the Maps page choose Maps from the navigation bar 19 Using the map The map offers several convenient functions all of which you can activate with one or two mouse clicks Visualizing a source and an indicator on the map By default only fragile eligible countries data is available on the map Other countries are grayed out FRAGILE STATES AS Portal English Francais a di O lth Data Search Data Analysis Data Query Dashboards Data by Topics Resource Center About Indicators GDP current US 2011 Registered Private Security Companies Pr O Show non empty indicators only Show only FSF eligible countries v amp Social indicators A Economic indicators NET E m AirScan el _ amp Natural resources endowrr EJ Unemployment levels Infrastructure endowment E National account MGDP current US 0 AKE Group ArmorGroup International Background Asia Risk Solutions 0 ChaseWaterford Special Projects GDP growth annual Chilport hand per capita current DynCorp International GDP per capita growth 4 O EOD Technology E Expenditure on GDP ii Erinys International Global Strategies Group Groupe GEOS Groupe EHC International Charter Incorporated of Ore GNI growth annual Current account ba
36. gree autocorrelation Upper decile Upper quartile Lower quartile Lower decile Ok Cancel Check the total types under Rows or Columns that you would like to add Checking items under Rows adds the designated rows to the table while checking items under Columns adds the designated columns You may add as many of each as you like 43 Check the Treat Empty Values As Zeroes option to make the portal assume the value of 0 for table cells that do not have any value Doing so can affect the results of certain totals types or it can have no effect at all Click Ok The Totals Settings dialog box closes and the portal adds the appropriate rows and columns to the table Performing a Pareto 80 20 analysis In a Pareto or 80 20 analysis the table shows the top 80 of the results normally and combines the bottom 20 as a single sum To perform a Pareto analysis on the table follow these steps 44 Click the 80 20 Analysis button 3 in the toolbar above Table view The 80 20 Analysis Parameters dialog box appears 55 80 20 Analysis parameters In Pareto Analysis large values are shown while only a summed total of the smallest values 0 of the sum of all values is shown Column to analyze Zimbabwe 2010 Format cell background font size 10 color EN Bold tale Underline aK Cancel Clear 2 From the Column To Analyze drop down menu choose the tab
37. in the A and B fields as required The A and B values correspond to the variables A and B in the condition statement If your highlighting condition does not require a B value then this field remains non editable Set the format of the highlighting effect Cell background Choose a color from the color swatches to use as the background color of a highlighted cell The default is white Font size Choose a font size for the text or value in a highlighted cell The units are points and the default is I Color Choose a color for the text or value in a highlighted cell The default is red Bold Check this option to use boldface for the text or value in a highlighted cell This option is checked by default Italic Check this option to use italics for the text or value in a highlighted cell This option is unchecked by default Underline Check this option to underline the text or value in a highlighted cell This option is unchecked by default Click Ok The Data Highlighting Settings dialog box closes and the portal highlights all table data that meets the criteria established in Step 2 using the appearance attributes that you specified in Step 3 41 Adding conditional formatting to the table Conditional formatting uses a color gradient or a graphical icon to indicate the relative value in any given table cell To add conditional formatting follow these steps e Click the Conditional Formatting button in th
38. iolet HE Dark blue nas Dark violet HE Red HF Orange FF Dark red Dark orange O HF Green O E Dark green om E Clean 2 Choose a table style by clicking its radio button 3 Click Ok The Table Style dialog box closes and the portal applies the desired table style to the table Setting the data format The data format determines how the portal displays the values in the table cells There are four data formats each of which applies to all the values in the table 46 General format The portal displays all data values exactly as they appear in the data source without rounding To apply this data format click the General Format button in the toolbar above Table view Currency format The portal displays all data values with a currency symbol and rounds to nearest hundredths by default To apply this data format click the Currency Format button in the toolbar above Table view Percentage format The portal displays all data values with a percent symbol and rounds to nearest hundredths by default To apply this data format click the Percentage Format button e in the toolbar above Table view Delimiter format The portal rounds all data values to nearest hundredths by default To apply this data format click the Delimiter Format button in the toolbar above Table view 47 Working in Chart view Chart view visualizes data in chart form You can also show Chart view by clicking th
39. ion million gj Urban population il Rural population e To browse to the Data Query page choose Data Query from the navigation bar 55 Selecting the source Start by choosing Source from the Sources list on Select Data Source page Scroll down to see the whole list of the sources a FRAGILE STATES D ur E Portal English Fran ais EFFFE NA dih o meena raras Y Data Analysis Data Query Dashboards Data by Topics Resource Center 1 Select Data Source 2 Select Elements 3 Construct Data View A View results Sociol ronomic Database Source owner World Bank FAOSTATS International Labor Organization AidFlows CIA Reporters Without Borders Transparency INTL UN Treaty Collection US Institute of Peace UN Peacekeeping EM DAT Mo Ibrahim Foundation UNDP HDR The Fund for peace Data span 1950 2012 Description No description available Food prices Source owner FAO GIEWS Data span 1980 2012 Description No description available e To select the desired source click the preset with its title e To go to the next step of the wizard click Next 56 Selecting the elements In this step of the wizard you select the data to be downloaded in the last step of the wizard a FRAGILE STATES NS Wr SEA Portal English Francais Q EE i AN l l y nenn Data Search Data Analysis Data Query Dashboards Data by Topics Resource Center 1 Select Data Source 2 Select
40. lanc Current account balanci Net capital account Bof External balance on goc External balance on goc Legend Locations i E Flow of transfers q International Security amp Defence Syster 9 International Peace Operations Associz Some en rg ens MM 1239 40 m 2937 07 M ae E Import MB 622 04 m 1239 40 m mM Balance of debt I 76 46 m 622 04 m Northbridge Services Group Remittances level WE no data amp Olive Securit E External payment y Productivity level Overwatch Protection Solutions Internat E Level of access to financial O gt q Pacific Architects amp Engineers ke 2 a 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 th o la African Development Bank Group 2012 e To show non empty indicators only check the checkbox Show non empty indicators only above the left panel e To display data for other countries open the dimension box above the map and select a desired map view 20 Show all countries Show all cou ll S Show only FSPreligikle countries Show all African Fragile States a show non empty indicators only e To visualize an indicator on the map click the desired indicator in the list on the left The portal visualizes the selected elements on the map e To change the year click the year point directly below the map ana o 2002 2003 2004 2005 006 2007 2005 009 2010 2011 2000 2001 e To show the count
41. le column that the portal should use for determining the top 80 and the bottom 20 of the data values 3 Under Format choose how the portal should display the Pareto analysis Cell background Choose a color from the color swatches to use as the background color of the cells in the column that you chose in Step 2 Font size Choose a font size for the text or values in the cells of the column that you chose in Step 2 The units are points and the default is I Color Choose a color for the text or values in the cells of the column that you chose in Step 2 Bold Check this option to use boldface for the text or values in the cells of the column that you chose in Step 2 Italic Check this option to use italics for the text or values in the cells of the column that you chose in Step 2 Underline Check this option to underline the text or values in the cells of the column that you chose in Step 2 4 Click OK The 80 20 Analysis Parameters dialog box closes and the portal applies the Pareto analysis to the table Applying a table style A table style is a collection of appearance attributes for the table Applying a table style does not change the values in the table but it does change the colors that the portal uses to display the table To apply a table style follow these steps Click the Table Style button HE in the toolbar above Table view The Table Style dialog box appears 45 O H Blue O H V
42. le in Table Chart mode 020000000000ennnnnnsnnnennennnnnnnnnnennnnnnnnnnnnnnne 50 Printing and exporting the results uusssssossssossossonsonnonsonnonnonnonnonnonnononnnnnnnnonsonsonsennennenne 5 A eo OO 5 Exporting Me results nee ee ee 5 31 About Data Analysis The Data Analysis page of the portal offers a powerful tool for slicing and visualizing the data The data is provided in several dimensions such as Calendar Regions and Indicators FRAGILE STATES IAS Portal English Francais Overview Data Search Data Analysis Data Query Dashboards Data by Topics Resource Center Sources Fixed Rows Columns eee re Indicators selected 5 Calendar selected 9 Food Prices 2 O Auto refresh 2 83 1864 5566 18E eS v 000 so se Columns 2002 2003 2004 2005 2006 2007 2008 2009 2010 Calendar Calendar Total 9 y Urban population of total NW 34 60 35 02 35 44 35 86 36 31 36 77 37 22 37 68 38 13 Rural population of total population MW 65 40 6498 64 56 64 14 63 69 63 23 62 76 62 32 61 87 ai Population growth annual Wi 0 26 0 04 0 12 0 22 0 33 0 39 0 24 0 18 0 78 Populations Total 5 pr Urban population growth annual m 148 125 1 07 0 85 6 99 1 39 1 98 Rural population growth annual E 0 38 0 60 0 77 0 87 1 04 1 10 0 96 0 55 0 05 Fixed Regions Zimbabwe Pr Units Units Pr de Urban population of tot
43. m the dimension ssssssssssssssesessssssesesesesesesesesesesssseseseseseseseseseses 57 Searching for elements in a dimension sssssssssssssesesessssssesesesesesesesesesesossesesesesesesesesesee 58 Using a dimension s list context menu ssesessssssssssseseseseseseseseresessssesesesesesesesesesesesessees 58 Constructing the data Misses 59 E EE E A A Seccancesacesccsesacadcset dandcsuascesucstiacsessnaseseesnsecte Sestacen 60 Working in the Table Mode nen 60 Working in the Chart mode uuu sscsssssssscsssssssssscssssssssssssesssssssssecsassessssscsassesseseneacees 6 Worldine in the Map Mode une Bere 62 Printing and exporting the results csscsscccsscsssscsssscsssssssscsesessssssssnssesssssssessessesseseceaees 64 Printne the results en kinri aian eine ee 64 o e O E Ea E E EEEO 64 53 About Data Query The Data Query wizard of the portal offers a powerful tool for data visualization in table chart and map mode ay FRAGILE STATES AI Portal English Francais BZ Q i I AN l l rs Overview Data Search Data Analysis Data Query Dashboards Data by Topics Resource Center 1 Select Data Source 2 Select Elements 3 Construct Data View A View results BQreamorrexMiE B we 55 Burundi gt Units B Burundi gt Units 9 000 000 00 7 200 000 00 5 400 000 00 3 600 000 00 1 800 000 00 0 00 7 rs A gt S q S S S S S S S S S S N N N F 6 ES F P Ila Total populat
44. on Participation for a selected country e Conflict and crime This report provides information about crime situation private security companies weapons trade for selected country e CSOs This report contains the list of Civil Society Organizations for a selected country e Environmental Country Profile This report displays various environmental indicators for selectable country Viewing a report To view a report click the report in the Reports panel on a left Reports Regional investments socio political Country Profile conflict and meh 2508 Environmental Country Profile 73 The portal loads this report in the results area of the interface and supplies default data You may change the default selection in one or more of the report dimensions as you require see Customizing a report later in this section Customizing a report The portal s built in reports enable you to change the selection in the countries list or in the data dimension The customizable dimension appears in a list of dimension boxes on the left side of the browser window The dimension box contains selectable elements or items which represent the data that appears in the report e To open a dimension box click the inverted triangle on its right side A drop down menu of selectable elements appears e To close the dimension box click anywhere outside it e To view more elements in the dimension box scroll to the bottom of the dro
45. on to the left of the parent element s name The child elements for this parent appear e To view more elements in the dimension box scroll to the bottom of the drop down menu or the bottom of the list of child elements under a parent element and click Next If you do not see a Next choice there are no more elements to display e To resize the dimension box drag the handle in the upper right corner of the drop down menu e To select or deselect an element from the dimension box click the element in the drop down menu 34 Using the dimension box s context menu You can also right click any element in the open dimension box for a context menu of time saving commands Select All The portal selects all the elements in the dimension Deselect All The portal deselects all the elements in the dimension Select Level The portal selects all the elements at the same level in the hierarchy as current element Deselect Level The portal deselects all the elements at the same level in the hierarchy as the current element Select Dependent The portal selects all the child elements of the current parent Deselect Dependent The portal deselects all the child elements of the current parent Collapse all The portal collapses all parent elements Expand all The portal expands all parent elements Auto refresh 35 Changing the position of the dimensions The dimensions appear under three positions Columns Rows an
46. ountries gt Social indicators Download as a picture Economic indicators p AiScan Natural resources endowrr One EEE E Unemployment levels Infrastructure endowment EJ National account ah BSDP current US GDP growth annual ArmorGroup International Background Asia Risk Solutions ChaseWaterford Special Projects i Chilport goes m DynCorp International _ GDP per capita growth Mes n El Expenditure on GDP O echnology Erinys International 6 Global Strategies Group y 39 Groupe GEOS x Groupe EHC International Charter Incorporated of Ore GNI current US GNI Atlas method cur GNI growth annual 9 Current account balance Current account balanci I Net capital account Bof External balance on goc External balance on goc International Security amp Defence Syster Legend Locations International Peace Operations Associs E Flow oftransfers I 20684 20 m 408236 75 M Meyer amp Associates E Gross saving Ml 8487 97 m 20684 30 m Export Ml 3977 75 m 8487 97 M GB MPRI E Import IM 1317 98 m 3977 75 m mvM E 3 gt i E Balance of debt M 76 46 m 1317 98 m Northbridge Services Group Remittances level W No data E External payment 8 Olive Security Productivity level 6 Overwatch Protection Solutions Internat T T T i ji T T T T i Ell aval nf arrace tn fnanciai ill lt O
47. p down menu or the bottom of the list of child elements under a parent element and click Next If you do not see a Next choice there are no more elements to display e To resize the dimension box drag the handle in the upper right corner of the drop down menu e To select or deselect an element from the dimension box click the element in the drop down menu After you change the element selection of a dimension and close the dimension box the portal automatically updates the data in your report To refresh the data in l a the report manually click the Refresh button in the toolbar Using the dimension box s context menu You can also right click any element in the open dimension box for a context menu of time saving commands e Select All The portal selects all the elements in the dimension e Deselect All The portal deselects all the elements in the dimension e Select Siblings The portal selects all the elements at the same level in the hierarchy as current element 74 e Deselect Siblings The portal deselects all the elements at the same level in the hierarchy as the current element e Select Children The portal selects all the child elements of the current parent e Deselect Children The portal deselects all the child elements of the current parent e Collapse All The portal collapses all parent elements Printing and exporting the results The portal enables you to print the table and chart or you
48. r 2010 Education Li Be olo ES Employment Economics Legend Population ages 0 14 total Potential stability factors Potential instability factors BE 86 525 165 396 EN i 165 397 495 998 Fe GINA We eee ie Ml 495 999 8 382 848 y Bir pr OS Ml 8 382 849 31 951 411 O Population ages 65 and above tc til WB 21 951 412 158 423 182 no data Population ages 15 64 total e g Population ages 0 14 total Population ages 15 64 total Population by age group Population ages 65 and above total Urbanization level 6 Anuual growth 6 Country Chad Calendar 2001 2009 Country Cote d Ivoire olo EE 4 100 000 00 3 860 000 00 3 620 000 00 3 380 000 00 IF 3 140 000 00 2 900 000 00 11 a 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2001 2002 2003 2004 2005 2006 2007 2008 20 09 gt Population growth annual gt Urban population growth annual de Population in largest city e Tobrowse to the Dashboards page choose Dashboards from the navigation bar 67 Working with dashboard visualizations To view the dashboards for a group of indicators click on the desired dashboard document on the left side of the browser window The portal displays this indicator s preset dashboard visualizations in the results area Each dashboard appears in its own frame e To maximize or minimize a dashboard frame click the Maximize Minimize icon in
49. r printer or export them to one of two external file formats Please note that the current mode of the results area Table mode Chart mode or Table Chart mode determines exactly what the portal prints or exports For example if Table view is currently hidden because you have enabled Chart mode then the portal ignores the table and prints or exports the chart only Printing the results To print the results follow these steps e Click the Print Preview button S in the toolbar The portal opens a new browser window containing a printer friendly version of the results e Click the browser s Print button Your browser sends the printer friendly version of the results to your printer 75 Exporting the results To export the results to an external file format follow these steps 76 In the toolbar click the button corresponding to the file type to which you want to export the results Export to XLS Export to PDF 5 a This format opens in Microsoft Excel A This format opens in Adobe Acrobat The portal opens a new browser window prepares the external file and initiates your browser s procedure for downloading files For example in Microsoft Internet Explorer the File Download dialog box appears click Save to save the exported file to your computer Resource Center The Resource Center page of the portal enables you to browse and download various documents and publications gt gt
50. ry flag hover over the desired country with the mouse pointer 21 Overview Data Search Indicators Cl Show non empty indicators only Social indicators Economic indicators Natural resources endowrr Unemployment levels Infrastructure endowment Expenditure on GDP GNI current US GNI Atlas method curri GNI growth annual Current account balanc Current account balance Net capital account Bof External balance on goc External balance on goc Flow oftransfers Gross saving Export E Import Balance of debt Remittances level External payment Productivity level a FI aval af arrace tn finanrial lv Kl m African Development Bank Group 2012 gt FRAGILE STATES Portal English Francais DENT Data by Topics Data Query Data Analysis GDP current US 2011 Show all countries v Download as a picture pol Congo Dem Rep 15642 236 881 13 N AS E A q Legend Locations I 20684 30 m 408236 75 M I 487 97 m 20684 30 M W 2977 75 m 8487 97 M 1317 98 m 3977 75 M I 76 46 m 1317 98 m fa No data TEN s s P r 7 r aja lt gt io 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 Registered Private Security Companies Pr AirScan AKE Group ArmorGroup International Background Asia Risk Solutions ChaseWaterford Special Projects Chilport DynCorp International EOD Technology
51. snennennennennsnesnennennnnesnennnne 16 PCMH Mer Uli OOO PPP UE PU E Arena 16 Exporting the oo eee ee 16 About Data Search The Data Search page of the portal enables you to search any indicator data in any of the data sources of the Fragile States Portal a FRAGILE STATES Portal English Francais in BZ Q ii AN AN l l o Overview Data Search Data Analysis Data Query Dashboards Data by Topics Resource Center Sea Chad a Found 880 indicators h Internet subscribers numben Chad 2 Internet subscribers per 100 inhabitants Chad 3 Public payphones of main lines Chad 4 Ability to track and trace consignments 1 low to 5 high Chad 5 Access capital city of population Chad 6 Access national of population Chad 7 Access rural of population Chad 8 Access urban of population Chad 9 Access to flush toilet septic tank as primary sanitation urban of population Chad 10 Access to bucket pan as primary sanitation national of population Chad 11 Access to bucket pan as primary sanitation rural of population Chad 12 Access to bucket pan as primary sanitation urban of population Chad 13 Access to cellphone national in of population Chad 14 Access to cellphone rural in of population Chad 15 Access to cellphone urban in of population Chad 16 Access to flush toilet septic tank as primary sanitation capital city of population
52. sunsdecoasetsneciiacsoeeseadcacatenscecsatadcsespueddeeseteddeacieasdonssuetaenees 9 DO een 10 About the Fragile States Portal The Fragile States Portal provides many advanced features for analyzing visualizing and reporting economic and social data for all African countries including fragile states The portal s functionality works entirely in a Web browser such as Microsoft Internet Explorer Google Chrome and Mozilla Firefox This user guide describes the portal s features and provides step by step instructions for using them System requirements To ensure trouble free operation of the Fragile States Portal please check that your computer meets the following requirements Using Overview The Overview page contains brief information about the portal Re Overview 4 5 7 Pr De FRAGILE STATES Portal Q N English Francais Data Search Data Analysis Data Query Dashboards Data by Topics Resource Center Welcome to the African Development Bank Fragile States Portal This web based application portal consolidates information on Fragile States providing a one stop shop platform to navigate these indicators and their documents and offer customized tools for data management analysis and display The AfDB Fragile States Portal FSP features visually compelling interactive maps insightful and informative reports and an analytical interface to view data in one user friendly platform The Fragile
53. t page choose About from the navigation bar e To download the User Manual click the User Manual link 78
54. ta Analysis In this chapter ADOT DAB ANYS ee ee ee 33 Loading a preset data ViOW cccssssssssccscesssssssssccsceseesessecessesssssessecesceesseseececssceeseeseneeees 33 Selecting elements from the dimensions ussesesessessenennnsnnsennennennnnnnnennennnnnnnnnnnnnnn 34 Changing the position of the dimensions ussesesessessesenonsnnnennnnnnnnnnnnnnnnnnnnnnnnnnnnne 36 Undo and redo recent operations useesessessessersonsonnonnnnnnnnnnnnnnnnnnnnsononnonnonnonononsennenne 37 Working in Table Vie Wisin idad idad 39 Sorting the CAS anne e 39 Filtering data from the Bleu 39 Highlighting data in the table u 0u000002000000ne0eonennenesnesnennennsnennennennennenesnennennnnennennnne 40 Adding conditional formatting to the table o ooncnncnicnononnnnnononononononnornnonononarnnoss 42 Adding columns and rows for totals ccccssssssseccsssssccsccscesseecsececesceesecsecesceeeseseneacees 43 Performing a Pareto 80 20 analysis ueeesessessessessssessessennennnnnnnnnennnnnnnnnnnnnennnnnnnnnnnnnnne 44 Applying a table Syyle u i ue iron cia inicio 45 Setung CINE data TOA Coenie a E E ee 46 Working in Chart VIEW aaa 48 Changing the chart Denen en 48 Showing and hiding chart labels 0000000000eseesessessennesnnsnnnnnnennnnnnnnnnnnnnnnnnnnnnnnnnnnn 49 Ar II 49 Changing the range of data displayed on the chart in Table Chart mode 50 Hiding the tab
55. table and chart or your printer or export them to one of two external file formats Please note that the current mode of the results area Table mode Chart mode or Table Chart mode determines exactly what the portal prints or exports For example if Table view is currently hidden because you have enabled Chart mode then the portal ignores the table and prints or exports the chart only Printing the results To print the results follow these steps e Click the Print Preview button in the toolbar The portal opens a new browser window containing a printer friendly version of the results e Click the browser s Print button Your browser sends the printer friendly version of the results to your printer Exporting the results To export the results to an external file format follow these steps e Inthe toolbar click the button corresponding to the file type to which you want to export the results Export to XLS Export to PDF This format opens in Microsoft Excel This format opens in Adobe Acrobat e The portal opens a new browser window prepares the external file and initiates your browser s procedure for downloading files For example in Microsoft Internet Explorer the File Download dialog box appears click Save to save the exported file to your computer 51 Data Query In this chapter ABOUE DI OU Verena A 55 a ea ee 56 Selectine INS BIENEN A T ee een 57 Selecting elements fro
56. the most recent change to the data dimensions or the results area click the Back button in the toolbar above Table view To redo an action that you previously undid click the Forward button 37 38 Working in Table view Table view shows data in a table form This view appears by default in Data Analysis You can also show the table by clicking the Table Mode button the Chart Mode button LL or the Table Chart Mode button il in the toolbar This section covers the portal s various commands and options for working with data in Table view Sorting the table To sort the table click the grey inverted triangle of the column by which you want to sort The icon changes to a dark grey inverted triangle meaning that the table is sorted in descending order according to the values in this column Click the icon a second time and it changes to a dark grey triangle meaning that the table is sorted in ascending order according to the values in this column Click the icon a third time to revert it to the grey inverted triangle and turn off table sorting Filtering data from the table The portal enables you to hide or filter data from the table when this data matches a specific type or meets a certain condition To filter data from the table follow these steps E e Click the Filter button _ in the toolbar above Table view The Data Filtering Settings dialog box appears 39 y Data filtering settings x
57. the mouse button to see this effect 26 Portal Mp ay FRAGILE STATES English d h C lil Data Search Data Analysis Data Query Dashboards Data by Topics Indicators GDP current US 2011 O Show non empty indicators only Show all countries z Social indicators A Download as a picture Natural resources endowrr Unemployment levels Infrastructure endowment National account SDP current US GDP growth annual GDP per capita current DP per capita growth Expenditure on GDP GNI current US gt GNI Atlas method curr GNI growth annual 9 Current account balanc Current account balanci Net capital account Bot External balance on goc External balance on goc Flow of transfers E Economic indicators Legend Locations Gross saving IM 20684 30 m 408236 75 M Export Ml 8487 97 20684 30 M Import Ml 3977 75 m 8487 97 M Balance of debt MM 1317 98 m 3977 75 M Remittances level WM 76 46 m 1317 98 m E External payment WE no data Productivity level Level ofaccess to financial i ae ntti O el gt 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 O African Development Bank Group 2012 Resource Center About Registered Private Security Companies Pr AirScan 0 AKE Group ArmorGroup International Background Asia Risk Solutions Chase Waterford Special Projects Chilport DynCorp International EOD
58. the upper right corner of the dashboard frame A maximized dashboard frame expands to fill more of the screen while a minimized one sits comfortably beside its neighbor e To view a chart or map in table form click the As Table button EE just above the chart or map e To view a table in its designated graphical form whether chart or map click the As Chart button ll or As Map button LI as applicable This button appears just above the table 68 Printing and exporting the dashboard document The portal enables you to print the dashboard document or your printer or export them to one of two external file formats Printing the results To print the dashboard document follow these steps e Click the Print Preview button in the toolbar The portal opens a new browser window containing a printer friendly version of the results Click the browser s Print button Your browser sends the printer friendly version of the results to your printer Exporting the results To export the dashboard document to an external file format follow these steps e In the toolbar click the button corresponding to the file type to which you want to export the results Export to XLS Export to PDF gt a This format opens in Microsoft Excel ES This format opens in Adobe Acrobat The portal opens a new browser window prepares the external file and initiates your browser s procedure for downloading files For example in

User Guide - African Development Bank Fragile States Portal

Contents

Download Pdf Manuals

Related Search

Related Contents