Domestic Violence in Australia:
To the teachers who inspired us to view the world from a different perspective
This year Victoria University started up new course called Business Analytics (BCO6007). Our final project, as a Business Analytics students, was to analyze and prepare a visualization report on domestic violence trends in Australia using SAP Lumira. I would also like to thank Mohamed Shahid who helped me writing this report. This blog contains the key findings from the report and also the visualizations.
So where to start?. We decided to start-off with a bigger picture of over-all Australia and then drill down to details. Australian Bureau of Statistics was a good point to start. We began by analyzing Personal Safety Survey 2012 data which provided the over-all picture of Australia. (Data Source: http://www.abs.gov.au/AUSSTATS/abs@.nsf/DetailsPage/4906.02012) and Recorded Crimes Data cubes (Data Cubes: http://www.abs.gov.au/AUSSTATS/abs@.nsf/DetailsPage/4519.02013-14?OpenDocument). Some data cleansing was needed to make data suitable for Lumira
Our first finding was that 49% of males and 40.80% of females had experienced some kind of violence since age 15..But on the other hand if we compared the ratio of partner violence between men and women. The ratio of women violence is far more than that of male partners. Between 2005 to 2012 female partners ratio is stranded at 1.5% when compared to male partner which is increasing from 0.4% in 2005 to 0.6% in 2012. Our next finding was that Women who have experienced partner abuse were more vocal than men. Our finding was that 25.60% women did not tell anyone when experienced partner violence compared to 54.10% men. This is definitely a serious social issue which needs to be resolved as we cannot reduce domestic violence unless people share problem with suitable persons. We further found out that only 4.4% of women who ever told anyone about partner violence talked to police and 15.10% women told the health professional. This means that health professionals can play a vital part in resolving post partner violence related issues. We also found out that 48.1% women and 27.5% men discussed the matter with friends or family.
Other horrifying facts we found were 21.70% of women who experienced violence from current partner experienced it during pregnancy, most sexual assault incidents by partner were occurring in NSW, 218 followed by QLD, 137. Most homicides by partners between 2010 to 2013 also occurred in NSW total 73 incidents followed by QLD total 57 incidents.
We further drilled down to age groups and found out that age group 25 – 34 were being most assaulted by partners, a total of 4107 and strangely in same age group people assaulted by total strangers were 4882 following a same trend. Does that mean that for age group 25 – 34 the probability of getting assaulted by a total stranger is same as by partner? We cannot say for sure. NSW was again in front for the partner assault.
- We now decided to focus on NSW to see what is happening over there. Data of number of incidents from 1995 – 2014 revealed domestic violence was continuously increasing year by year (Data source: http://www.bocsar.nsw.gov.au/Pages/bocsar_crime_stats/bocsar_detailedspreadsheets.aspx). We drew data on esri map (because it look cool J ). To gain further insights we ranked incident data by top 15 and years from 2008 to 2014. The resulting visualization revealed that out 15, 7 domestic violence incidents happened in Blacktown. We decided do find out further about Blacktown (Data Source: http://www.bocsar.nsw.gov.au/Pages/bocsar_crime_stats/bocsar_lgaexceltables.aspx)
Detailed data of Blacktown disclosed that domestic violence related assault was one of 10 major offences of area (Ranked 7th). Most of domestic violence victims were female aged 18 – 29. Offenders were largely male with no visible difference in offender’s age group. Most female offender were of age 20 – 29.
Next we tried to find our the relation between alcohol related offence and domestic violence assault. We found out that most offenders were prone to domestic violence under the influence ( total incidents 504) followed by non-domestic assault (total 400). So we suggest that by controlling alcohol distribution government can control domestic violence in area. Further our data showed that most incidents happened during months of January and November, on weekends and time between 6 pm to 12 am.
We created a master excel file and loaded all the data, from different data cubes in which we were interested, on it on different sheets and then loaded the file on Lumira. Link to youtube video SAP Lumira – YouTube
The visualization helped us understand how much percentage of total Australian experienced violence since they were 15 years of age.
The graph shows the percentage of people who had suffered violence by partner in last year and compared it with year 2005. It revealed that partner violence on males was increased.
When we loaded the data on Lumira to see how many people talk about their partner violence problem the result revealed that more than 54.1% of men don’t talk about their partner’s violence to anyone
Graph shows only 4.4% of women suffering from partner violence talk to police.
Total percentage of female who experienced violence from previous partners responded that they also experienced it duing pregnancy
A state-wise partner homicide data revealed that most incidents occurred in NSW
When we loaded age groups of people facing partner violence on lumira and also the relevant state data, results revealed that 25-34 year age group was facing violence the most across Australia and in NSW
Domestic violence pattern in NSW from 1995 – 2014, we plotted it on Esri Geo Map
When ranked by top 15 areas by total number of incidents reported, Blacktown surpassed all other areas
The graph showing 10 major offences in Blacktown, Domestic violence assaults is number 7th.
Above graphs shows victims’ and offenders’ profiles.
When we tried to find relation between alcohol and domestic violence we found, under influence of alcohol, majority people engaged in domestic violence more than any other type of violence
Monthly distribution showed most domestic violence incidents happened during the month of January. since December and January are festive seasons in which families come together, we thought it was may be result of alcohol consumption.
When alcohol related crimes and domestic assaults plotted against the days it showed that both were happening mostly on weekends
When further tried to find relation between domestic violence, Alcohol related Assaults and Sexual assaults, we found that sexual assault were mostly occurring on Tuesdays and Thursday. So maybe they were not related to domestic assaults and alcohol
Graph shows most domestic violence and alcohol related crimes mostly happened during 6 pm to 12 am.