CPSI Data Warehouse The key to security information

CPSI Data Warehouse “The key to security information” ESCI – CPSI final symposium 4/5 march 2010 Marcel de wit (Sogeti Netherlands)

Topics • Why is there a need for a DWH • What are the requirements • How can questions be answered • How does the DWH look like

Topics • Why is there a need for a DWH • What are the requirements • How can questions be answered • How does the DWH look like

The need for a DWH Registered crime Perceived security Validation Media Intervention Analysis • Separate sources • A lot of data • Multiple purposes Culture Public opinion Reporting • Manageability ? • Transparency ?

The need for a DWH Registered crime Perceived security Media Intervention Culture Public opinion Data Warehouse Validation Analysis Reporting • Integration by uniformity and conformation

Topics • Why is there a need for a DWH • What are the requirements • How can questions be answered • How does the DWH look like

Requirement (1/3): Usability • Scalability Local Regional National • Reliability Data Warehouse • Exportability Excel SPSS

Requirement (2/3): Integrability Time Crime theme Registered crime Perceived survey Media Intervention Culture Public opinion Geography Facts Questionnaire Security theme Media source

Requirement (3/3): Analysability Age Gender Year Month Day Time Registered crime Perceived survey Media Culture Intervention Public opinon Dwellings Country Region City Geo. Neighborh. graphy … Income Crime theme Offence Crime theme Foreigner Mediasource Media source Securitytheme Security theme Paragraph Question. Answer naire

Topics • Why is there a need for a DWH • What are the requirements • How can questions be answered • How does the DWH look like

Answering questions (1/3) How do the different media sources publish on discrimination issues related to each other? Year Month Day Registered crime Perceived survey Media Culture Intervention Public opinon Country Region City Neighborh. Crime theme Offence Mediasource Securitytheme Paragraph Question Answer

Answering questions (2/3) Feel people more safe since camera’s have been placed? Year Month Day Registered crime Perceived survey Media Culture Intervention Public opinon Country Region City Neighborh. Crime theme Offence Mediasource Securitytheme Paragraph Question Answer

Answering questions (3/3) Which differences in demographic characteristics can be detected between actual and perceived security? Age Gender Year Month Day Registered crime Perceived survey Dwellings Country Region City Neighborh. … Income Crime theme Offence Foreigner Mediasource Securitytheme Paragraph Question Answer

Topics • Why is there a need for a DWH • What are the requirements • How can questions be answered • How does the DWH look like

Presentation (1/5): Tabular The media sources with the no. of publications on all security themes (grouped - sorted):

Presentation (2/5): Statistic The % respondents feeling safe per neighborhood (ranked down):

Presentation (3/5): Trend analysis The no. of actual crimes over the period nov’ 08 – jun’ 09:

Presentation (4/5): Graphical The no. of published articles over the period feb-jun 2009 per security theme: Man made disasters 5. 132 War conflict 2. 562 3. 411 Discrimination 5. 057 Drugs Violence vandalism 2. 965 2. 729 Economic downturn Terrorism 5. 590 Several 1. 486 4. 123 Natural disasters 2. 697 Property crime

Presentation (5/5): Geographical Neighborhood: Perception: 13% Actual: 11% Inhabitants: 5078 City: Perception: 35% Actual: 14% No. of people feeling unsafe: High Medium Low

Summary The CPSI Data Warehouse is: • A proven methodology for integrating several data sources • A scalable and flexible solution • The platform for information

Result driven marcel. de. wit@sogeti. nl