monitor activity dashboard and georrefered analysis

Welcome #EUC11

Monitor Activity Dashboard&

Georeferred AnalysisMiguel Lora

LANTARES EUROPE

About LANTARES

BI, CPM & DM Focused

TechnicalExcellence

BusinessFocus

BUSINESS PARTNER

About LANTARES

Performance ManagementPerformance ManagementPerformance ManagementPerformance Management

RiskRisk, Compliance , Compliance & & FraudFraudRiskRisk, Compliance , Compliance & & FraudFraud

Customer IntelligenceCustomer IntelligenceCustomer IntelligenceCustomer Intelligence

Business Intelligence

Competence Center

BusinessCentric

Customer IntelligenceCustomer IntelligenceCustomer IntelligenceCustomer Intelligence

Data ManagementData ManagementData ManagementData Management

DatawarehouseDatawarehouse, Reporting, , Reporting, & Dashboard& Dashboard

DatawarehouseDatawarehouse, Reporting, , Reporting, & Dashboard& Dashboard

Business Intelligence

Competence Center

ITCentric

Case Study:

Project:

Monitor Activity Dashboard & Georeferred Analysis

Customer Profile:

Location: Barcelona, Spain

Industry : Enforcement & Security OrganizationIndustry : Enforcement & Security Organization

Focus area: police incidents, accidents, complaints, human resource management, material resource management, ...

Geographic Management:

1 City

10 Districts

73 Neighborhoods

Monitor Activity Dashboard & Georeferred Analysis

Baseline:

I. Large data volumes

III. Information in different systems, not integrate d

II. Difficulty accessing the information at all lev els of the organization

IV. Manual processes for the preparation of information (low reliability, low agility)

V. Little or no end-user autonomy

VI. Difficulty understanding the reason for the deviations and to align with the achievement of the objectives

Monitor Activity Dashboard & Georeferred Analysis

Challenge:

• Plan, forecast and control the resources

• Measure and analyze performance

• Generate reliable information• Generate reliable information

• Align metrics, initiatives and resources with the strategy

• Associate metrics to territory, and represent their occurrence on mapping

Monitor Activity Dashboard & Georeferred Analysis

Solution:

• Integrate all corporate data and unify key business concepts to provide a unique vision of the organization

• Increase the analytical capacity and generation of user information

• Analyze information from multiple perspectives. Multidimensional Analysis.

• Dispose the capacity to measure, monitor and diagnose the level of compliance with the targets

• Finding the hot spots and areas of impact

• Detect and prevent the hot spots

Monitor Activity Dashboard & Georeferred Analysis

Benefits:

• Enable public safety and security organizations to create a flexible and reliable information environment.

• Deliver a foundation for more proactive law enforcement /policing.• Provide greater predictive analysis and data mining from disparate data

sources.sources.• Provide visibility and control of information across the organization.• Respond to inquiries, requests for services and investigative actions in a

timely manner and increase citizen satisfaction.• Increase quality of decisions by providing more accurate, timely reporting.• Move beyond physical records retention to electronic transactional history,

reporting, analysis, planning and monitoring.• Redeploy resources effectively to meet objectives that evolve over time.• Reduce operational and IT costs by providing self-service reporting and

analysis to users.

Monitor Activity Dashboard & Georeferred Analysis

Functional Architecture:

OPERATIONALS SYSTEMS EXTERNAL SYSTEMS

…… ……Text Files

INTEGRATION - ETQLTransformations +

Validations + DataQuality

DataWarehouse

DM DM DM DM DM ……

MODELIZACION

Relacionals ModelsDimensionals Models

(DMRs)…… ……

EXPLOTACIONPORTALS REPORTS DASHBOARD

Monitor Activity Dashboard & Georeferred Analysis

Functional Architecture:

Monitor Activity Dashboard & Georeferred Analysis

Dashboard:

Monitor Activity Dashboard & Georeferred Analysis

Dashboard:

Monitor Activity Dashboard & Georeferred Analysis

Dashboard:

Monitor Activity Dashboard & Georeferred Analysis

Dashboard:

Integration between IBM COGNOS and ESRI

Thank You