WB Indicator Masher: The World Bank data API provides statistical data and metadata to over 2000 indicators in select languages. The objective of the WB Indicator Masher by Fraunhofer FOKUS is it to showcase how this rich supply of data can be made accessible for more people as well as visualized and easily costumized to individual needs.The WB Indicator Masher thus combines the Wold Bank data with the Google Google Language API. This enables the presentation of the data descriptions and the user interface in many more languages than the original ones provided by the World Bank itself. Especially having the theme and indicator descriptions available in one´s own language supports the understanding and usage of the data.Once the desired language is selected the mashups fetches the data live from the World Bank and has it translated via the Google Language API. The user of the mashup can then browse or search through the different themes. Through selection of one theme the corresponding indicators are pulled from the World Bank server and presented to the user. By browsing and searching through the list of indicators the user can select one, of which he wishes to see the actual values. The values are first displayed as a plain list of data sorted alphabetically by countries. In the next step, the user can select to have the data visualized. Herefore the data is combinded with the Google Charts API which provides an easy to grasp graphical representation of the selected indicator. The graphics are created on the fly and present the data in a bar chart format and on a world map.The user can go back to the indicator selection page, where he has the chance to create his own custom indicators. By combining existing indicators via basic mathematical formulas in the provided text editor new indicators can be constructed and than visualized just as the already existing World Bank indicators.For the future a graphical interface to the indicator editor is planned, which will make the creation of customized indicators even easier. Additionally a late binding function will be implemented which allows the user to bring in different data and visualisation APIs into the showcased mashup. Example of a user defined indicator:
Name: Total Population
Description: This is a user defined indicator for the total population. This indicator uses the values of the WB indicators "Urban population" [ID=SP.URB.TOTL] and "Urban population (% of total)" [ID= URB.TOTL.IN.ZS]. The following simple formula calculates the value of this new indicator: "INT ( I(SP.URB.TOTL) * 100 / I(SP.URB.TOTL.IN.ZS) )". The operator I(...) returns the value of the indicator with the given ID. The operator INT(...) converts a floating point number into integer.
Formula: INT (I(SP.URB.TOTL) * 100 / I(SP.URB.TOTL.IN.ZS))