954
Report Author: Nicolás San Marco
954
Share template with others
Report submitted for FP20 Analytics ZoomCharts Challenge, November 2023. The report was built with Tactical Crime Analysis dataset and includes ZoomCharts custom Drill Down PRO visuals for Power BI.
Author's description:
1. It is found that the primary crimes in London are: • Sexual violence ranks first, accounting for 37.97% of the total. • Anti-social behavior follows at 19.60%. • Offenses related to public order come in third at 7.95%.
2. On the other hand, a significant increase in the crime rate is identified during the year 2022, particularly in January, May, and October. On a daily basis, the overall rise in criminal activity is observed, with Thursdays experiencing the highest incidence and reaching its peak on Sundays.
3. The areas most affected by crimes in London are Westminster and Brixton, located in the city center.
4. Regarding demographic data, the highest crime rate is among males at 70.34%. Within this group, Ethnicity 1 holds the top position at 37.23%.
5. Crimes with the highest resolution rates are sexual violence (70.74%), vehicular crime (73.54%), and public order offenses (73.69%).
Participate in data challenges, build and submit reports to get free template downloads.
Join CommunityMobile view allows you to interact with the report. To Download the template please switch to desktop view.
How to use a PBIX template
Preview the interactive report, download the PBIX file, open it in Power BI Desktop, and replace the same data connection with your own dataset.
Preview and download
Explore the report online and download the PBIX template file.
Open in Power BI Desktop
Open the downloaded PBIX file in Power BI Desktop.
Connect your data
Replace the sample data source with your own dataset.
Refresh and adjust
Refresh the model and update fields or visual were needed.
Save and share
Save your report and publish it for your audience.