For this expose, I will be using a US crime dataset from the Federal Bureau of Investigation (FBI), which you can access on my Github page. This dataset is specific to murder and manslaughter cases in the United States from 1980 to 2014. The dataset consists of some important variables like Crime type, Perpetrator sex, Victim sex, Perpetrator race, Victim race, Crime incidents, year of crime occurrence, Agency name, Agency type, Perpetrator ethnicity, relationship, the weapon used, perpetrator count, victim count, among others. These variables will be used in generating insights into the distribution of crime rates in the United States and will also help in making necessary recommendations and conclusions.
I will be using the Microsoft Power BI tool for this business intelligence and data visualization case study. This tool is a business intelligence tool for analyzing data and generating insights from data in visuals, reports, and dashboards. For this case study, I will be using the MS Power BI tool to import the dataset, transform the dataset in the Power Query Editor, design the data model, create some measures, and build the report.
You can check the step-by-step process and report for this case study using this link for more insights.
eyJrIjoiNGY0YzhmNjEtM2VjNy00MjEzLTljZmYtOTRiNmE1NGE2MGU2IiwidCI6IjkxODk1NjgwLTdkMDMtNDg4My1iMmJhLTUxMDk2MzM2YzI4MyJ9&pageName=ReportSection
