It’s been a long time wish to make an entry into Data Genius Contest.  This year we were able to make it. All we thought was to create a quick visualization of an interesting data using some fancy components. We picked the US Crime Data from http://www.ucrdatatool.gov and it looked as below:

/wp-content/uploads/2015/11/datamodel_840862.png

Modelling the Data became so easy as we opted to use Analysis for Office Workspaces (Analysis for Office with SAP Design Studio).

So was able to get the data model done in less than 20 minutes as below:

/wp-content/uploads/2015/11/excel_840872.png

Here comes the Dashboard created with Design Studio with following visualizations.

Crime Count of each Crime type in US:

As you can see below, there are tiles showing up the count of each crime type in US. They are alerted with a Rule (Crime count > 25M are red and < 25 M are green). It didn’t take much time in setting up font style for each element. “Global font override feature” was handy to use google font across the Component.

Slide1.png

Crime count vs State:

So here is the Heat Map that shows the state and heat intensity based on the Crime Count value.

/wp-content/uploads/2015/11/slide2_840874.png

Crime Count Vs Region:

Comparison always is done better with a column Chart.

/wp-content/uploads/2015/11/slide3_840875.png

Historical Data:

Sparkline Chart below was helpful in easily hooking up the data source and viewing the data of Current year and the past 5 Years.

/wp-content/uploads/2015/11/slide4_840878.png

Export Functionality:

I found this component being fancy and able to export the dashboard quickly in pdf, ppt, doc, jpg formats. So added another view “Share via email”, which has the above said functionality.

/wp-content/uploads/2015/11/slide5_840879.png

DOC Export:

/wp-content/uploads/2015/11/exporteddoc_840881.png

Video recording can be found here : https://youtu.be/06nU0Wr6_I8

The entry for data genius by my colleagues  Naveen Ravichandran and Dinesh Lakshmanan

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply