Overview

Title: Assistant Graduate
Role: Data Analyst

Esri Story Maps let you combine authoritative maps with narrative text, images, and multimedia content. They make it easy to harness the power of maps and geography to tell your story. India Atlas is a project aimed to create story on India. The storymap gathered the information from the government of India public



View India Atlas StoryMap



View India Atlas Data Source

Responsibilities

  • Locate, download and upload datasheets for all states in India.
  • Create use cases based on the data. For example, I have the number of houses that has solar panels. I will clean this data and create different sheets for different level of granularity. For India, Granularity based on the geographical area is Country - States - Districts - Tehsils. Furthermore tehsil is divided into Urban and Rural.
  • Consolidate the worksheets and create worksheets for data at Tehsil level.
  • Analyze worksheets to understand granularity, summary levels, common variables to report to the team members.
  • Create pivote tables get the specific data.
  • Write Sql queries to aggregate data anf format as expected.
  • Import the data into StoryMap and create maps highlighting related information.