Client background: A police force responsible for policing service area encompassing 647 square kilometres with a population of around 1.5 million.
Industry: Public Sector
Products/Services: Microsoft Business Intelligence and Analytics platform

Business Challenge

  • Unable to replace existing conventional data management system due to security concerns

  • Join hands with a trusted partner who can replace the existing system with an advanced Business Intelligence tool

  • Deliver accurate and relevant crime information from their central data warehouse to a set of users to enable data-driven business decisions

Business Solution

  • Initiated a migration to Microsoft BI by installing the necessary software and prototyping the functionality needed for a large number of reports and dashboards

  • Gained a comprehensive understanding of the existing functionality and recommended the use of SQL Server Reporting Services and other tools once other capabilities were identified

  • Built a PoC and overall solution design for the migration with a detailed approach to complete the work

  • Achieved successful prototyping and enabled live migration encompassing activities including:

    • Platform installation and configuration of the latest Microsoft BI tools
    • Development of new reports and migration of existing reports and dashboards
    • Customised BI Portal
    • Migration of existing functionalities to the new platform
    • Support for UAT and Go-live
    • Deskside support, knowledge transfer, and user training on Microsoft products
  • Provided features such as the use of maps to identify various types of crime clusters as well as potential lawbreakers who reside in or commit a crime in the local area

Business Benefits

  • An integrated view of crime and incident data promoting data-driven decisions

  • Increased data credibility and easy access to critical information

  • 15 reports are generated daily

Environment

  • MS SQL Server, Power BI, SSRS, SSIS, SSAS tabular and multidimensional