Skip to Content
Author's profile photo Former Member

My Data Geek Story on Population Analysis

Here’s my ‘Data Geek Story’. For the first time when I read about The Data Geek Challenge, three things excited me.

  1. Playing with SAP Lumira
  2. Share the data geek story
  3. Yes!.. the T-shirt with DATA GEEK Logo.. 🙂 ( as it was something like superman’s HOPE logo 😛 )

In my Data Geek Story, I used sample data related to Population of India in 2011. It includes population analysis for urban and rural regions in 2011.

Excel sheet was used as the data source for this analysis.

  1. Uploaded the excel into Lumira. The flat file contains a set of data with 5 Columns (State and union territory, Population in 2011, total % of all population, Rural population, Urban population)
  2. The below mentioned elements were enriched as measures /wp-content/uploads/2013/08/1_271310.jpg
  3. Created geographic hierarchy by names for ‘State and union territory’ as shown below/wp-content/uploads/2013/08/2_271300.jpg
  4. Created Visualizations as shown below
  • Population in 2011 and Rural population by Region( Stacked Column Chart)/wp-content/uploads/2013/08/3_271301.jpg

The rural population of Uttar Pradesh is high and Lakshadweep is low

  • Population in 2011 and Urban population by Region(Column Chart)/wp-content/uploads/2013/08/4_271302.jpg

The urban pollution of Maharashtra is high followed by Uttar Pradesh. Lakshadweep is low in population.

  • Population in 2011 by Region (Geographic Bubble Chart)/wp-content/uploads/2013/08/5_271303.jpg
  • Population in 2011 and total % of all population by Region(Pie with Variable Slice Depth)/wp-content/uploads/2013/08/6_271304.jpg
  • Population in 2011 by Region ( Tree Map)


  • Population in 2011 by Region (Tag Cloud)


Uttar Pradesh stands top in the population rate.

  • Population in 2011, Urban population and Rural population by Region( Area Chart)/wp-content/uploads/2013/08/10_271311.jpg

This graph shows that the rural population is greater than urban population. Rural population is nearly 2 times that of urban population.

And here ends my data geek story. Thanks for reading.. 🙂

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Good Analysis...

      Best Regards,

      Naresh K.

      Author's profile photo Former Member
      Former Member

      Hi Sai,

      Good Day !

      I appreciate your analysis. Nice blog.

      Please try to post good blogs like this. Keep Posting.

      Have a wonderful day!


      Hari Suseelan

      Author's profile photo Jitendra Kansal
      Jitendra Kansal

      Sai Prasad

      simply great.. 😀