The Fifth Elephant 2012

Finding the elephant in the data.

Structuring data from surveys - A case study from a slum survey conducted in 2010

Submitted by Onkar Hoysala (@onkarhoysala) on May 8, 2012

Section: Industry & Business Technical level: Intermediate Session type: Lecture Status: Confirmed & Scheduled


To present a case study of the slum survey conducted by NGIL, CSTEP in 2010 and to discuss the data collection and cleanup process, and the challenges that were faced.


An extensive survey was carried out across 1000+ households in 36 slums across Bangalore by NGIL, CSTEP in 2010. We will talk about the process of data collection and cleanup and the challenges that we faced during the data collection and during cleanup. We will also give an overview of the database schema we designed for the survey.

Speaker bio

Aditi Murthy is a researcher at Fields of View, a non-profit organisation working on problems related to urban systems and public safety & security. She has two years experience in working with market simulations, game design and working with datasets. She was involved in the cleanup process of the slum survey data at NGIL and is involved in its analysis at Fields of View.

Onkar Hoysala is a researcher at Fields of View. He has 2 years research experience developing games and simulations for urban systems and disaster management. He was involved in the data cleanup and schema design for the slum database at NGIL and is trying to look at using the data to develop models at Fields of View.




  • Govind Kanshi (@govindsk) 7 years ago

    Thanks Aditi/Onkar. If you could add - what would you do different in terms of extraction/cleansing with today’s tools and “basis” of choosing those tools. That will be great takeaway for the attendees.

  • Shawn Mendis (@michealshawn) a year ago

    Data gethering from the surveys has always been a good opportunity to know the performance of a particular business, food restaurants, retailer stores like The Kroger Co. and other companies. I would like to add something interesting here that I have been a keen learner of the data which is extracted by the Surveys and this is the website I developed for various feedback surveys to win prizes like free 50 fuel points in KrogerFeedback site on

    Thank you Aditi/Onkar.
    I love this Hasgeek.Com website a lot.

    Best regards,

  • arya12 (@arya12) a year ago
  • jon shina (@jon01) 11 months ago

    food survey Customer Satisfaction Survey is way to tell your feedback and Participate in food survey on

  • Chris Pine (@chris-pine) 6 months ago

    Home Depot store is also gathering the customer’s feedback through online customer surveys. The customer satisfaction survey is the proper way to collect feedback from the customers and using the feedback to improve their services. Home Depot conducting the survey at Every customer has a chance to win a $5000 gift card at home depot store by taking the official home depot survey 2020.

  • survey villa (@surveyvilla) 5 months ago

    A survey is a research based methodology where we gain information about data, reviews and collect feedback by asking questions from the client. Survey is conducted among the peoples to give their feedback.

  • mik raj (@mikraj) 3 months ago

    I am Mikraj
    Thanks for sharing Information sucha as so useful.

Login to leave a comment