Bank of Ceylon’s Post

Hello all, I wanted to share this simple interactive crime dashboard I made using Tableau, with official crime data from the Toronto PS site, that features over 400k rows of data. I specifically utilized the data between 2014-2024 to observe crime trends specifically major crime indicators (MCI) categories over DOY, DOW, months and specific neighbourhoods (158 exactly) in the Toronto region. I found was that January 1st always had the most number of criminal cases. I first assumed maybe I did not properly account for null values however, upon inspecting the dataset, I noticed there genuinely were more entries made on January 1st by thousands in total compared to the rest of the DOYs, which can be for various reasons after doing some research. Assault has always been the leading crime making up to 50% of all reported crime in the Toronto region for multiple years, and Apartments being the leading location type for total crimes. Feel free to check it out, and play around with it at this link: https://lnkd.in/gtz7-pwX

Check below

London Borough Crime Analysis 🚨 Crime Analysis Report: London Boroughs 🚨 I’m excited to share our recent crime analysis report for London boroughs, providing critical insights into crime patterns and trends over the past 14 years . Using Power BI, we have visualized the data to help policymakers and law enforcement agencies make informed decisions. 🔍 Key Findings: Total Occurrences: 10,657,499 with 1,713,567 crimes reported over the past 24 months. Year-on-Year (YoY) Crime Rate: 9.07% Top 5 Boroughs by Crime: Westminster Camden Newham Southwark Lambeth Bottom 5 Boroughs by Crime: Bexley Merton Sutton Richmond upon Thames Kingston upon Thames 💡 Detailed Insights: Major Categories: The most frequent crimes include Theft, Violence, and Vehicle Offenses. Violence without Injury and Other Theft are the leading minor categories. Regional YoY Crime Rate: Central London leads with the highest YoY crime rate. Borough-Specific Analysis: Westminster has the highest total occurrence, while boroughs like Bexley and Merton report the lowest. Time Series Analysis: Our time series maps and graphs provide a clear view of crime trends from 2010 to 2024. This report aims to assist in enhancing safety measures and implementing targeted interventions. By understanding crime patterns, we can work towards a safer London for everyone. In this report i made use of bookmarks, tooltips, pagenavigation and icon map with a drilldown function that filters the borough to the Lsoa level (Lower Layer Super Output Area). Each LSOA is designed to have a population between 1,000 and 3,000 people or 400 to 1,200 households. Tools used Python for Data cleaning Power BI for Data visualisation #CrimeAnalysis #London #DataVisualization #PowerBI #Safety #LawEnforcement #PublicSafety #metropolitanpolice

Check below

🚨 Crime Analysis Report: Key Insights and Strategic Recommendations 🚨 I'm thrilled to share the results of my comprehensive crime analysis report, where I utilized advanced data analytics to uncover crucial trends and insights. Tool Used : PowerBi Here’s a snapshot of our findings: 🔍 Total Crimes Analyzed: 2,500 reported incidents 📈 Yearly Insights: 2021: 405 crimes, 68.64% resolved 2022: 1,150 crimes (+745 from 2021), 72.43% resolved 2023: 945 crimes, 67.72% resolved 🕒 Peak Crime Time: 12:00 AM to 2:59 AM 📅 High-Risk Days and Months: Days: Saturday, Sunday, Monday Month: October 🌍 Highest Crime Country: Austria (879 crimes) 💡 Crime Types Breakdown: Violence and Sexual Offences: 147 incidents Anti-Social Behavior: 77 incidents Public Order: 33 incidents Criminal Damage and Arson: 23 incidents 🔧 Data Preparation and Analysis: Split datetime to isolate time Extracted AM/PM into a "Moments" column Created a new Date table for time-based analysis Developed measures for resolved and unresolved crimes Implemented DrillThrough functionality for detailed insights 📊 Visualizations: Heatmaps showing crime distribution by weekdays and months Charts highlighting high-crime time periods 💡 Key Insights: Total Crimes: 2,500 reported incidents Resolved Crimes: 70.04%, showcasing effective law enforcement efforts Unresolved Crimes: 29.96%, highlighting areas for improvement Yearly Crime Trends: A significant spike in 2022 with 1,150 crimes (+745 from 2021) Peak Crime Times: 12:00 AM to 2:59 AM is the most crime-prone time Monthly Trends: October consistently records the highest crime rates Weekly Trends: Saturday, Sunday, and Monday have the highest crime occurrences Country-Specific Data: Austria has the highest crime rate with 879 incidents 🔧 Recommendations: Enhance Nighttime Patrols: Increase law enforcement presence between 12:00 AM and 2:59 AM. Focus on October: Implement targeted strategies to reduce crimes in October. Weekend Strategies: Allocate more resources on Saturday, Sunday, and Monday. Improve Resolution Rates: Strengthen investigative processes to reduce the unresolved crime rate (29.96%). Country-Specific Measures: Focus on Austria with dedicated crime reduction programs. This analysis highlights critical areas for law enforcement to prioritize and demonstrates the power of data in driving informed decision-making. Let's continue leveraging data to create safer communities! #DataAnalytics #CrimeAnalysis #DataDrivenInsights #PublicSafety #LawEnforcement #DataScience #BusinessIntelligence

I am thrilled to share my latest Crime Analysis Report Dashboard, created using Power BI, which demonstrates how data visualization can be a game-changer in analyzing and addressing crime trends. Highlights of the Dashboard: 📊 Comprehensive Insights: A total of 2,500 crimes have been analyzed, broken down by year, time groups, and country, offering a holistic view of crime patterns. ⏰ Critical Insights on Dangerous Crime Time: The most dangerous crime time identified is 11:30 PM, helping authorities prioritize patrols and enhance safety during high-risk hours. 🌍 Geographical Analysis: A map visualization highlights the distribution of crimes across different countries, with specific focus on Europe and Africa, enabling location-based crime interventions. 📅 Weekly Crime Trends: A heatmap provides a detailed breakdown of crimes across days of the week and months, with clear indications of peak crime activity. For example, Friday and October stand out as times of higher crime rates. 📈 Time-Based Trends: Crimes grouped by time intervals (e.g., 9 PM - 11 PM and 12 PM - 2 PM) provide actionable insights for resource planning during specific periods. ✅ Resolution Rates: The report also highlights the success rate of authorities: 70.04% of crimes resolved effectively. 29.96% still require attention, offering room for targeted efforts. Value of the Dashboard: This dashboard is a testament to how Power BI can empower decision-makers to: 1️⃣ Identify crime hotspots and peak activity times. 2️⃣ Optimize resource allocation for crime prevention. 3️⃣ Monitor resolution rates to enhance the effectiveness of authorities. 4️⃣ Drive data-driven policies for a safer community.

Public Safety Software News: Adams County Sheriff’s Office transforms operations with innovative iSOMS software solution In an era where public safety demands continuous innovation, the Adams County Sheriff’s Office has implemented cutting-edge software solution called iSOMS. iSOMS is an integrated Records, Jail, and Court management software application developed by M & M MICRO SYSTEMS, INC. This sophisticated browser-based application is set to redefine how first responders manage and utilize data, enabling them to address the evolving challenges of public safety with greater efficiency and effectiveness. As crime rates shift and community needs change, first responders are frequently stretched thin. The iSOMS software is designed to alleviate the stress on officers by streamlining essential tasks such as data entry, record retrieval, and real-time dispatch. From the offices of records clerks to the front lines of patrol officers, this system supports the entire lifecycle of crime data, ensuring that vital information is readily accessible when needed. Sheriff Travis Patten emphasized the significance of selecting the right technology for the agency’s needs. “In law enforcement, choosing the right tools is crucial. iSOMS is a next-generation solution offering powerful features like computer-aided dispatch (CAD) integration and data security. It is also designed to enhance how we serve our community,” he said. With more than a decade of partnership with M&M Micro Systems Inc., the Adams County Sheriff’s Office recognized the potential of iSOMS to significantly modernize its operations. The software is accessible via various portable devices, which empowers officers to seamlessly transition from the office to the field while keeping them connected to essential information. This enhanced mobility also enables faster decision-making in emergencies, a critical advantage when time is of the essence. #ISOMS #AdamsCountySheriffsOffice #PublicSafety #PublicSafetySoftware #PublicSafetyTechnology Read more at: https://hubs.li/Q030W-gb0

🌍 UK Street Crimes Dashboard - Borough/Council Level (Jan-May 2024) 🌍 This dynamic dashboard provides an in-depth analysis of recorded street crimes across all UK Boroughs/Councils from January to May 2024. Dive into comprehensive insights and trends. Key features include: 🔍 Crime Type KPI Cards: A snapshot of each street crime type showing the percentage change from the previous month with intuitive up/down arrows. 📊 Visual Cues: Quick visual identification with color-coded indicators for trends (Green: Decrease, Red: Increase). 📈 Maximum and Average Crime Rates: Track the highest number of crimes recorded and the average figures to understand broader trends. 📊 Total Crimes Overview: See the total recorded crimes across all categories for a holistic view. 🚀 Highest Rise This Month: Identify the street crime type with the most significant increase for timely interventions. 📉 Lowest Fall This Month: Highlight the street crime type with the most substantial decrease, showcasing success stories and effective measures. 🔧 Tools used: #PowerBI, #MySQL #UKCrimeStats #Excel #PublicSafety #CrimePrevention #CommunitySafety #PowerBI #UKPolice #Insights #DataVisualization #DataAnalytics #MySQL #DAX #Data

𝐍𝐂𝐁𝐀 𝐁𝐚𝐧𝐤 𝐅𝐢𝐧𝐞𝐝 𝐊𝐄𝐒 𝟕𝟎𝟎,𝟎𝟎𝟎 𝐟𝐨𝐫 𝐃𝐚𝐭𝐚 𝐏𝐫𝐢𝐯𝐚𝐜𝐲 𝐕𝐢𝐨𝐥𝐚𝐭𝐢𝐨𝐧 The Office of the Data Protection Commissioner (ODPC) has ruled against NCBA Bank Kenya PLC in a case where Dr. Bernard Shiaunda Aete complained about the bank sending false and misleading loan statement information to a third party (his former wife) despite multiple requests to remove her as an alternate contact. The ODPC found that NCBA violated the Data Protection Act by continuing to send notifications to the former wife for eight months after the complainant's formal request for removal on April 4, 2023, infringing on his right to object to data processing and right of erasure. The Commissioner ordered NCBA to pay KES 700,000 in compensation, broken down as KES 200,000 for unlawful processing of personal data, KES 250,000 for infringing the right to object, and KES 250,000 for infringing the right to erasure. While NCBA claimed the continued notifications were due to a technical error in their system's sync job between NQUEST and T24 platforms, which was finally corrected on January 16, 2024, the Commissioner rejected the bank's defense and ordered it to ensure future information sent to the complainant regarding bank balances is accurate and up-to-date. The Office of the Data Protection Commissioner (ODPC) has demonstrated its commitment to upholding data privacy rights, as evidenced by recent enforcement actions against organizations for unauthorized use of personal data, including images of minors without parental consent . Financial institutions must recognize that technical errors are insufficient defenses against data breaches; proactive measures are essential to ensure compliance with the Data Protection Act. #dataprotection #privacy #Kenya #fintech #compliance #ODPC