Mohit Kumar Mangla (s4575036), Akshay Choudhary (s4575351)
This blog has been written as a part of the assessment task for Business Analytics (BCO6007) studied at Victoria University. We are motivated by our respected mentor, Parvez Ahmad, to collect and analyze the data related to ‘Domestic Violence in Australia’ with the help of a powerful tool, SAP Lumira, which was introduced to us in the university class. We decided to analyze the data of only two years that is 2014 and 2015, due to the unavailability of clear usable data and the vast information available on the internet. It is a nice experience for us, as this is our first blog on any forum.
What is domestic violence?
Domestic violence is traditionally associated with cases of physical violence occurring within intimate relationships and in a domestic setting. It is most commonly perpetrated by a male against a female partner, but it also includes violence against men. Domestic violence occurs in both heterosexual and homosexual relationships and includes married, de facto and separated adolescents and adults.
What we did?
In order to prepare this project, we collected the data from different sources like Australian Bureau of Statistics (ABS) and Australian Institute of Criminology (AIC). Data was cleansed in a separate spreadsheet to make it suitable for the visualizations made by SAP Lumira. Each piece of data was carefully examined and appropriate visualizations were made using Bar Charts, Column Charts, Line Charts, Cross Tables and Pie Charts. These visualizations were the composed to create a story.
Statistics and Results:
Some of the key visualizations with description of our findings are:
Description: This Cross tab tells about the No. of recorded incidents of some categories of Domestic Violence in Australia in 2014 and 2015 by Gender. Figures says that highest no. of recorded incidents are of Assault.
Let’s look at another visualization to find some more results.
Description: From this Bar Chart visualization, it can be resulted that females are to be more victims as compared to the males.
Now, let’s have a look at this States-wise.
Description: This 3D Column Chart clearly shows that New South Wales (NSW), followed by Western Australia (WA) and South Australia (SA), has the highest number of recorded incidents in both the years.
Now, let’s look at some of the categories (Assault and Sexual Assault) of Domestic Violence more widely.
Visualization #4 (Assault)
Description: This Heat Map shows that Intimate partners are mostly involved in the assault cases of Domestic Violence.
Visualization #5 (Assault)
Description: It can be visualized from this Donut Chart that in more than 50% cases of Assault, the age of victims ranges between 25 and 44 with 28.42% cases from the 25-34 age group and 22.57% cases from the 35-44 age group.
Now, let’s have a look on the Relationship factor and Age Group factor for Sexual Assault.
Visualization #6 (Sexual Assault)
Description: This Column Chart shows that Other family members*(8,943) are mostly involved in the sexual assault cases of Domestic Violence, which are followed by Parents(3,691) and Intimate Partners(3,633).
*Other family members include Uncle, Aunt, Cousins, Grandparents etc.
Visualization #7 (Sexual Assault)
Description: It can be visualized from this Line Chart that the age of victims of Sexual Assault ranges between 10 and 19 with highest number of cases from the 10-14 age group followed by the 15-19 age group. Same trend is followed in both the years.