This blog is written by Muhammad Wasiq (s4576187) and Arjun Verma (s4575090), it is written as a task for our course Business Analytics (BCO6007) which is studied at Victoria University Sydney campus. Our lecturer, Parvez Ahmed assigned us task to analysis and visualise data for “Domestic Violence in Australia” using SAP Lumira. Due to insufficient data, we had to focus on year 2014 and 2015.
In simple words, Domestic violence refers to act of aggression between two individuals who had, or has intimate relationship. Type of violence include physical, sexual, emotional and psychological. Most common victims of domestic violence are females, while males are most commonly found perpetrator.
To visualize domestic violence across different states of Australia, we collected data from Australian bureau of statistics (ABS) and Australian Institute of Criminology (AIC). We had to breakdown and simplify data in order to load it up on SAP Lumira, to create different types of visualizations.
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.
Figure 1. Total domestic violence incidents occurred in Australia
Figure 2. Type of incidents in different states of Australia
In figure 1. we can see that NSW is highest with 66,335 incidents in 2014 and 2015, while Tasmania has lowest number of 2,472 incidents. Figure 2. explains that majority of incidents across Australia are Assault, however in QLD and VIC sexual assault is most common type of domestic violence. it is also evident that kidnapping/abduction incidents are very rare.
Figure 3. Incidents by Sex and Year
From Figure 3. we can clearly see that Females are primary victims of Domestic violence and it has increased from 2014 to 2015.
Figure 4. Incidents of Sexual Assault by Age group, year and sex
From Figure 4. we can conclude that the most affected age group of Sexual violence is 15-19 and females are leading here as well. We can also see that Incidents of Sexual violence have increased for females.