Skip to Content
Author's profile photo Hari Srinivasa Reddy

DataGeek III Challenge: Accident Analysis in India 2003-2011

Dear All,

I thank SAP for giving an opportunity to participate in DataGeek III challenge. I have been using SAP Lumira for the past 5 months and my experience with this tool is amazing. It is perfect fit for Self-Service BI and Data Exploration. The best feature which I like is enabling d3/custom extensions in Lumira and I spent most of the time there.

Well, I accepted the Data Geek III Challenge to tell a story about “Road Accidents in India during years 2003-2011” using SAP Lumira Desktop.

Published At:

House: House of Spirits, caring for social good

Section: Experts section

A story board is created to show the analysis and trends about accidents for the state and year in India.

I have created a new extension Hierarchical Bar Chart which is used in one of the page in this story board to easy drill-down to next levels. Good thing about this extension is it has navigation path displayed on the top of the chart so that we can jump around into various levels.

Page - 03.jpg


Collected data from and also enriched in way it can be used for analysis



Name of the region


Name of the state


Year in which the accident took place



Total no. of accidents

#People Injured

Total no. of people were injured

#People Killed

Total no. of people were killed

Dataset – 01


Dataset – 02


Here is the analysis and story board:

Page 1:

A summary page gives the summary details about total accidents and no. of people injured and no. of people died. It also provides the information about Top 3 States and Years more no. accidents recorded.

Page - 01.JPG

Page 2:

This page shows the Bottom 3 states based on the no. of deaths and also yearly death rates.

Page - 01-02.jpg

Page 3:

This Page gives the detail analysis of total accidents, people injured and died in geographical charts. Input controls are used in the page to filter the data by state and year.

Page - 02.JPG

Page 4:

This page has Hierarchical Bar Chart extension which I developed to navigate to various levels. It has a navigational ribbons on the top of the chart can be used to jump easily to various levels within in the same chart.

Page - 03 - 01.JPG

When I click on South India bar element it will drill to South India region as shown below:

Page - 03 - 02.jpg

If I want to go back to home to select different region, I just need to click on the navigation ribbons on the top as shown below.

Page - 03 - 03.jpg

Below diagram shows I have navigated to <Home>

Page - 03 - 04.jpg

Here below I could switch back to another region Western India easily.

Page - 03 - 04-01.jpg

Page - 03 - 05.jpg

Please drive safely, wear safety belts and helmets without fail, follow Signs and You could save others.

  • Alert today – Alive tomorrow.
  • Normal speed meets every need.
  • The best drivers are aware that they must be beware If you know you are driving to your death –would you still drive so fast?
  • You can’t get home, unless you’re safe.
  • Night doubles traffic troubles.
  • Hug your kids at home, but belt them in the car.
  • Safety is not automatic, think about it.
  • Leave sooner, drive slower, live longer.
  • Slow down! Your family will be waiting for you.
  • Stop accidents before they stop you.
  • Drive as if every child on the street were you own.
  • Road sense is the offspring of courtesy and the parent of safety .
  • The best car safety device is a rear-view mirror with a cop in it.
  • Safe Driving, Saves Lives.
  • Life don’t have Reset button.


Please have a look at this video which has live actions of this story and extensions.

Story Highlights:

At the end of this story analysis, I could arrive at below conclusions:

  • Top 3 states which have more no deaths are “Andhra Pradesh, Utter Pradesh and Tamil Nadu” which means in region Southern India has more deaths by  accidents.
  • Death rate per year is growing at around 1.5% per year
  • Bottom 3 states based no. of accidents are “Lakshadweep, Andaman & Nicobar Islands and Daman & Diu” which means that Islands has less deaths by accidents

I hope you like this post. All the best for other participants!!!


Hari Srinivasa Reddy,

Manager, SAP Analystics


Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.