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.
Page 2:
This page also gives insight about people attending Intuitions by State .
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.
Page 4:
This page deals with people attending Literacy centres by Gender.
Page 5:
This page deals with people attending Intuitions,Total Population by age group and Gender.
Page 6:
This page deals with people not attending any Intuitions by Gender by State.
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.
Hi Sateesh,
This is fantastic. Much Appreciated.
Best regards,
Hari
Hari Srinivasa Reddy : Thank u Hari
This is a Very good Document Sateesh .
Regards
Santosh Utla