Information Builders Case Studies Estonian Police and Border Guard Boosts Data Quality With WebFOCUS and iWay

Edit This Case Study Record

	Estonian Police and Border Guard Boosts Data Quality With WebFOCUS and iWay Information Builders

Estonian Police and Border Guard Boosts Data Quality With WebFOCUS and iWay

Information Builders

Technology Category	Analytics & Modeling - Real Time Analytics Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries	National Security & Defense
Applicable Functions	Logistics & Transportation Quality Assurance
Use Cases	Predictive Maintenance Real-Time Location System (RTLS)
Services	Data Science Services System Integration
Challenge	The Police and Border Guard Board (PBGB) of Estonia faced a challenge as their data warehouse grew to contain information on 150,000 misdemeanors and more than 30,000 criminal offences. The analysts were tasked with automating data quality procedures. The team wanted to minimize the accrual of inaccurate data so that police reports and procedures would be consistent and correct. Bad data can impact each level of the organization and lead to inaccurate decisions regarding how resources are allocated, public order is maintained, and police procedures are conducted. For example, an incorrect date or time field can lead to an inaccurate evaluation of work performance. Read More
About Customer	The Police and Border Guard Board (PBGB) is the law enforcement agency of the Republic of Estonia, a country of 1.3 million citizens in the Baltic region of Northern Europe. The board is under the supervision of the Ministry of the Interior, which supervises the PBGB, the Estonian Internal Security Service, the Rescue Service, the Emergency Response Centre, the IT and Development Centre of the Ministry of the Interior and the Academy of Security Sciences. With a grant from the European Union, PBGB set out to improve its analytic capabilities. Analysts envisioned a new data warehouse, an agency-wide reporting portal, and a predictive policing system that could help officers make decisions based on their analysis of recent crime trends. Read More
Solution	PBGB purchased Information Builders’ WebFOCUS business intelligence (BI) and analytics platform and the iWay Data Quality Suite to automate data quality and data profiling activities. iWay Data Quality tools allow the department to set up business rules to monitor and maintain data quality, now and in the future. iWay Data Quality Server is invoked during an iWay DataMigrator process to generate a log of executions. This log is used for internal reporting and communication. When problems are detected during the processing, iWay sends a list of anomalies for remediation. PBGB continues to use these iWay tools on a day-to-day basis as new information is loaded into the warehouse. The bureau uses iWay Data Quality Suite in conjunction with WebFOCUS to conduct data quality audits. WebFOCUS plays a role in the department’s data quality initiative by generating reports that summarize errors and anomalies in the source systems. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Application Infrastructure & Middleware - Data Exchange & Integration

Applicable Industries

National Security & Defense

Applicable Functions

Logistics & Transportation

Quality Assurance

Use Cases

Predictive Maintenance

Real-Time Location System (RTLS)

Services

Data Science Services

System Integration

Challenge

The Police and Border Guard Board (PBGB) of Estonia faced a challenge as their data warehouse grew to contain information on 150,000 misdemeanors and more than 30,000 criminal offences. The analysts were tasked with automating data quality procedures. The team wanted to minimize the accrual of inaccurate data so that police reports and procedures would be consistent and correct. Bad data can impact each level of the organization and lead to inaccurate decisions regarding how resources are allocated, public order is maintained, and police procedures are conducted. For example, an incorrect date or time field can lead to an inaccurate evaluation of work performance.

About Customer

The Police and Border Guard Board (PBGB) is the law enforcement agency of the Republic of Estonia, a country of 1.3 million citizens in the Baltic region of Northern Europe. The board is under the supervision of the Ministry of the Interior, which supervises the PBGB, the Estonian Internal Security Service, the Rescue Service, the Emergency Response Centre, the IT and Development Centre of the Ministry of the Interior and the Academy of Security Sciences. With a grant from the European Union, PBGB set out to improve its analytic capabilities. Analysts envisioned a new data warehouse, an agency-wide reporting portal, and a predictive policing system that could help officers make decisions based on their analysis of recent crime trends.

Solution

PBGB purchased Information Builders’ WebFOCUS business intelligence (BI) and analytics platform and the iWay Data Quality Suite to automate data quality and data profiling activities. iWay Data Quality tools allow the department to set up business rules to monitor and maintain data quality, now and in the future. iWay Data Quality Server is invoked during an iWay DataMigrator process to generate a log of executions. This log is used for internal reporting and communication. When problems are detected during the processing, iWay sends a list of anomalies for remediation. PBGB continues to use these iWay tools on a day-to-day basis as new information is loaded into the warehouse. The bureau uses iWay Data Quality Suite in conjunction with WebFOCUS to conduct data quality audits. WebFOCUS plays a role in the department’s data quality initiative by generating reports that summarize errors and anomalies in the source systems.

Impact #1	System reliability has increased since the police department started using WebFOCUS and iWay.
Impact #2	If errors occur in the process of entering data, it is much easier to detect them and fix the problem.
Impact #3	Better information leads to better decisions, which improves services to citizens.

Impact #1

System reliability has increased since the police department started using WebFOCUS and iWay.

Impact #2

If errors occur in the process of entering data, it is much easier to detect them and fix the problem.

Impact #3

Better information leads to better decisions, which improves services to citizens.

Benefit #1	The data warehouse grew yearly by 150,000 misdemeanors and 30,000 criminal offenses and their proceedings.
Benefit #2	Approximately 1,300 people use WebFOCUS and the user base is constantly growing.

Benefit #1

The data warehouse grew yearly by 150,000 misdemeanors and 30,000 criminal offenses and their proceedings.

Benefit #2

Approximately 1,300 people use WebFOCUS and the user base is constantly growing.

Download PDF Version

Overview

Estonian Police and Border Guard Boosts Data Quality With WebFOCUS and iWay

Operational Impact

Quantitative Benefit