Journey of Creating a Storyboard “Crime behind the doors” using SAP Lumira
In this blog I will be talking about our journey of creating a storyboard using SAP Lumira.
Crime behind the doors
Family Violence is biggest law and order challenge in Victoria. – Fiona Richardson.
Domestic violence is a horrifying experience for anyone. It knows no boundaries. More and more people are becoming aware and coming forward to report these crimes. Victorian police is aware of this and is trying its best to tackle these incidents. We used their stats as our data set for Lumira. SAP Lumira helped us to visualize this data through different perceptions like yearly basis, region wise etcetera and provides analysis, for what we are looking, in a detail. Family incidents are one of the most increasing crime in Victoria since 2010. The main reason is people do not report to police about their family violence incidents immediately and this results to be late in monitoring and controlling them on time.
We came across a data for number of family incidents along with their rates for four regions of Victoria along with their Local Government Areas (LGA) for 5 years. We cleansed the data file (a number of times to make it compatible) and imported that into SAP Lumira. We started creating the visualizations. First visualization was about LGA with highest offences and the answer came out to be Casey. I was offended because (I love Casey!) I live in this area for the last one year and never heard one in my locality.
My conscience did not allow me to go further, I was upset L with the results. It was our first hurdle. Alina suggested to use rates, and we thought it would be better than using number of offences, as comparing one LGA to another using a same base would be more logical. This resulted in one more cleansing of data. Then the play-time started.
Working in Lumira is fun. We started with simple visualization comparing rate of incidents in various Regions of Victoria for 5 year time period. Suddenly we saw our second hurdle, when we were using LGAs the incident rate was correct but with the Regions it was adding up all the LGA rates for that region. There is a feature in Lumira where we can change the aggregation function, it was changed from Sum to Average to get the correct results.
Feeling: Lumira is good 🙂
We found out there has been increase in incidents in every region except Southern Metro region for the last year.
After that we wanted to see in how many cases children were present and made the following visualization.
It made us curious. Then we compared number of cases where children were present to total cases.
Even this visualization was not able to answer our question properly. This resulted in finding a way to have percentage of cases with children to total number of cases.
We used creating formula function in Prepare Tab to find the percentage of cases where children were present to total number of cases. Feeling: Lumira is awesome 😎 !
It resulted in following visualization.
Further we saw that in West Wimmera half of the cases have children involved in them. This visualization also show us that metro regions have lesser rate of cases with children present.
Similarly other visualizations were created along with the questions that came in our mind which led to our storyboard.
Here is our storyboard and findings:
- The rate of family incidents have been increasing: It is not just the offences has increased but the number of offences that are reported have increased as earlier people were not reporting to police. On the other hand rate has decreased in Southern Metro region in the last years.
- Number of children involved in family incidents have been on the rise. But a particular trend is seen, the rates in Eastern and Western regions are remarkably high than other regions.
- A very peculiar trend is seen in this visualization. There is just one LGA from Metro region in these 15 LGAs with highest rate of family offences.
- Two suburb of western region has maximum number of family incidents i.e. Campaspe and Central Goldfields due to unsolved cases by court against family violence.
- High rate of children involved in Regional Areas.
- Growth in percentage of cases where charges laid against total cases from 2009/10 to 2013, due to the implementation of Family Violence Protection Act 2008 and also of notice published by police regarding family violence has increased number of incident report from victims.
- There has been increase in reporting of offences hence this has resulted in increased number of incidents these days.
- Campaspe and Central Goldfield have the maximum number of offence rates.
- More incidents in rural and regional areas as compared to metro areas.
- Percentage of cases where children are involved decreased from 2009 till 2013 but show a small increase again in 2014.
- Remarkable increase in number of cases where charges are laid, showing strict actions by law.
- More Intervention orders and Safety Notices are issued in the last year.
Conclusion of story: From the data that we have collected and analysed, visualizations show that Western region is rapidly increasing in family incidents. Reporting has increased the offence rates. Where there is a presence of couple then there is high chance of child been exposed directly to such incidents. But, Victorian Law and police is trying their best to reduce those incidents by taking strict action against offenders and hiring more officers. So, hoping in near future there will be minimal cases or issues about family incidents.
Experience of our journey
- A very user friendly and easy to use tool, you just upload the data file and it will automatically pick up the measures and dimensions.
- Amazing tool to get granular level details.
- It lets you to play with the data, giving amazing ways to drill down the data by using filters, measures, calculators etcetera.
- A number of different typesof visualizations can be produced showing number of things in same visualization.
In the end I would like to say using SAP Lumira is fun. Just let you imagination jump from one question to another and it will answer your queries. Self-explanatory story board and stunning infographics can be prepared. Data starts speaking when introduced to Lumira.
Bakhshash Kaur Saini