Skip to Content
Author's profile photo Former Member

DataGeeK III:Educational Institutions Analysis in India

Hi Everyone,


This is my first ever blog post in SCN. I
am writing this blog as a part of the Data Geek Challenge III under the category House of Spirits relating to Social Good.

  My SAP BusinessObjects Lumira storyboard main objective is to analyse population attending educational institution by age,gender and type of Educational Institution in India. Downloaded the data from the Govt of India website and reformatted in way to get the best out SAP Lumira.



Data Sources:  Link to data



Dataset specification is shown below:


STATE Dimension
Age Group Dimension
Total Population Measure
Males in Total Population Measure
Females in Total Population Measure
Total People Attending Institutions Measure
Males in People Attending Institutions Measure
Females in People Attending Institutions Measure
People Attending Schools Measure
Males Attending Schools Measure
Females Attending Schools Measure
People Attending Colleges Measure
Males Attending Colleges Measure
Females Attending Colleges Measure
People Attending Vocational Institutes Measure
Males Attending Vocational Institutes Measure
Females Attending Vocational Institutes Measure
People Attending Other Institutes Measure
Males Attending Other Institutes Measure
Females Attending Other Institutes Measure
People Attending Literacy Centers Measure
Males Attending Literacy Centers Measure
Females Attending Literacy Centers Measure




Also created some Calculated Measures which will be more helpful to gain insight of the data.

Females not Attending Institutions

{Females in Total Population} – {Females in People Attending Institutions}

Males not Attending Institutions

{Males in Total Population} – {Males in People Attending Institutions}

People not Attending Institutions

{Total Population} – {Total People Attending Institutions}

Access the Story : Storyboard in SAP Lumira Cloud  (Need SAP Lumira Cloud Account)

Underlying Story based on the Data:

Page 1:

              This page gives insight about population of a State  and people attending Intuitions.

slide 1.JPG

Page 2:

                   This page also gives insight about  people attending Intuitions by State .


slide 2.JPG

Page 3:

           This page gives insight about population of a state by Gender and States where Senior Citizens are attending Intuitions.Input control to filter by State is provided for all the next pages.

/wp-content/uploads/2014/12/2_600304.jpg

Page 4:

               This page deals with people attending Literacy centres by Gender.

/wp-content/uploads/2014/12/3_600335.jpg

Page 5:

               This page deals with people attending Intuitions,Total Population by age group and Gender.

/wp-content/uploads/2014/12/4_600336.jpg

Page 6:

               This page deals with people not attending any Intuitions by Gender by State.

slide 3.JPG

Outcome:

The Storyboard gives information about States where people are attending Literacy centres and where people are not attending institutions. Further steps can be taken to encourage people to attend institutions based on their age group, Gender. This gives a chance to create new policies and launch new campaigns by Government to encourage people attend Institutions.



Looking forward to contribute more in SCN.


Wishing everyone Good Luck for all the participants of DataGeek Challenge.

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Hari Srinivasa Reddy
      Hari Srinivasa Reddy

      Hi Sateesh,

      This is fantastic. Much Appreciated.

      Best regards,

      Hari

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hari Srinivasa Reddy : Thank u Hari

      Author's profile photo Former Member
      Former Member

      This is a Very good Document Sateesh .

      Regards

      Santosh Utla