Skip to Content

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.

  1. 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. 


WORKSHOP:

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

/wp-content/uploads/2015/05/1_713252.jpg

The visualization helped us understand how much percentage of total Australian experienced violence since they were 15 years of age.

/wp-content/uploads/2015/05/2_713253.jpg

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.

/wp-content/uploads/2015/05/3_713254.jpg

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

/wp-content/uploads/2015/05/4_713255.png


Graph shows only 4.4% of women suffering from partner violence talk to police.



/wp-content/uploads/2015/05/5_713257.png


Total percentage of female who experienced violence from previous partners responded that they also experienced it duing pregnancy


/wp-content/uploads/2015/05/6_713258.png


A state-wise partner homicide data revealed that most incidents occurred in NSW


/wp-content/uploads/2015/05/7_713259.png

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


/wp-content/uploads/2015/05/8_713260.png


Domestic violence pattern in NSW from 1995 – 2014, we plotted it on Esri Geo Map


/wp-content/uploads/2015/05/9_713262.png


When ranked by top 15 areas by total number of incidents reported, Blacktown surpassed all other areas


/wp-content/uploads/2015/05/10_713263.png


The graph showing 10 major offences in Blacktown, Domestic violence assaults is number 7th.

/wp-content/uploads/2015/05/12_713269.png

Above graphs shows victims’ and offenders’ profiles.

/wp-content/uploads/2015/05/13_713276.png

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


/wp-content/uploads/2015/05/14_713277.png

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.


/wp-content/uploads/2015/05/15_713278.png

When alcohol related crimes and domestic assaults plotted against the days it showed that both were happening mostly on weekends


/wp-content/uploads/2015/05/16_713279.png

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


/wp-content/uploads/2015/05/17_713280.png


Graph shows most domestic violence and alcohol related crimes mostly happened during 6 pm to 12 am.

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