The next indicator in this Power BI Series for World Bank Indicators is GDP Growth (annual %) – following is the detail about this indicator.

Annual percentage growth rate of GDP at market prices based on constant local currency. Aggregates are based on constant 2005 U.S. dollars. GDP is the sum of gross value added by all resident producers in the economy plus any product taxes and minus any subsidies not included in the value of the products. It is calculated without making deductions for depreciation of fabricated assets or for depletion and degradation of natural resources. Source: World Bank national accounts data, and OECD National Accounts data files.

The live graph be accessed here – GDP Growth (annual %)

Graph View

Map View

The next indicator in this Power BI Series for World Bank Indicators is GDP (current US$) – following is the detail about this indicator.

GDP at purchaser’s prices is the sum of gross value added by all resident producers in the economy plus any product taxes and minus any subsidies not included in the value of the products. It is calculated without making deductions for depreciation of fabricated assets or for depletion and degradation of natural resources. Data are in current U.S. dollars. Dollar figures for GDP are converted from domestic currencies using single year official exchange rates. For a few countries where the official exchange rate does not reflect the rate effectively applied to actual foreign exchange transactions, an alternative conversion factor is used. Source: World Bank national accounts data, and OECD National Accounts data files.

The live graph be accessed here – GDP (current US$)

Graph View

Map View

The first indicator in this Power BI Series for World Bank Indicators is CO2 Emissions (metric tons per capita) – following is some detail about this indicator.

Carbon dioxide emissions are those stemming from the burning of fossil fuels and the manufacture of cement. They include carbon dioxide produced during consumption of solid, liquid, and gas fuels and gas flaring. Source: Carbon Dioxide Information Analysis Center, Environmental Sciences Division, Oak Ridge National Laboratory, Tennessee, United States.

The live graph be accessed here – CO2 Emissions (metric tons per capita)

Graph View

Map View

The world is one big data problem – Andrew McAfee

The technology revolution in the last three decades has caused an explosion of data that is unprecedented – the current digital footprint of the world is estimated to be around 8-9 ZB (zettabytes) and is increasing by 40% every year. By 2020, it is expected to reach 44 zettabytes and many studies have shown that less than 1% of this data is analyzed – so the world is indeed a colossal data analysis problem.

In the enterprise space, most public and private organizations today collect massive amounts data for various aspects of their businesses (inventory, supply chain, manufacturing, operations, finance, customer service to name a few) but the decisions still mostly remain ad-hoc and reactive – part of the problem is that traditional Business Intelligence tools have never enabled the end-user / information worker directly and instead only offered static dashboards and KPIs that cannot keep up with the pace of the business and as the corporate dashboards become irrelevant, people go back to using excel spreadsheets for data analysis.

Microsoft Power BI is an exciting new visualization tool that enables information workers to create data visualizations, interactive reports, dashboards and collaborate with these visualizations in real-time. In addition to this there are a range of data analytics backend tools now available in Microsoft Azure like SQL Azure, SQL Data Warehouse, Data Factory, Data Lake Analytics, HD Insight, Machine Learning and Stream Analytics that can be used to process the data to make it ready for a Visualization tool.

Following is one of our sample dashboards “United Nations – World Bank Indicators” that we have put together using Microsoft Power BI.  The indicators represent an interesting view of the world that we live in. The data is openly available on United Nations and World Bank Websites (http://data.un.org/)

We will be posting an indicator every day in this series of posts over the next few days – each indicator has a graph view with a country filter that can be used to compare data for different countries and other groups (world, continents, high income, low income, OECD countries etc.) and map view with a year filter that overlays data on a map.

Graph View

Map View

The live graph for the above “Population Growth (annual %)” indicator can be accessed here.