210 likes | 294 Views
ICONSULTING. “Intelligent” Access Control System in Bologna Old Town centre. Bologna, June 2007. ICONSULTING. ICONSULTING is a company focused on Consulting, Design and Development of Decision Support Systems – Business Intelligence
E N D
ICONSULTING • “Intelligent” Access Control System in Bologna Old Town centre. Bologna, June 2007
ICONSULTING • ICONSULTING is a company focused on Consulting, Design and Development of Decision Support Systems – Business Intelligence • It was founded in 2001 by a group of young researchers working for the Data Warehouse Lab inside the university consortium called Cineca. • ICONSULTING maintains a strong link with University by investing in Research and Development • The inner Research Lab (R&D, Thesis, Testing, Products Evaluation) is a warrantee of independence from all the software vendors.
What is BUSINESS INTELLIGENCE? • Business Intelligence is a broad category of applications and technologies used to gather, provide access to, and analyze data and information belonging to an organization. • Decision-making fact-based support systems. • Business Intelligence + Raw and disconnected data • = • KNOWLEDGE 3
Planning and Control cycle DASHBOARD and B.P.M. APPLICATIONS BI MODELS QUERY & REPORTING and MD ANALYSIS Planning Strategic objectives andactions definition Control Control of results accordingto Plans and Programs Programming Operational objectives andactions definition Management Process Action DASHBOARD and SCORECARD
What is done for Public Administrations? • Besides our industrial client portfolio, we have realized many Business Intelligence solutions for Public Administrations such as Budget Applications, Management Control Systems, Enterprise Management Dashboards. Municipalities Comune di Bologna Comune di Reggio Emilia Regions and Regional Agencies Regione Emilia Romagna Agrea Arpa Avepa National Agencies Sviluppo Italia
Officers Services Districts Citizen Families Real estates Reference Background Municipality Revenues Services Communications
Officers Services Districts People Families Real estates Social Services Municipality Revenues Services Communications Social Services(Senior Services,Education, …)
Officers Services Districts People Families Real estates Public Works Management Municipality Revenues Services Communications Public Works
Officers Services Districts People Families Real estates Revenues Dashboard Municipality Revenues Services RevenuesDashboard (ICI, Tarsu,…) Communications
Officers Services Districts People Families Real estates Traffic Management Municipality Revenues Services Communications TrafficManagement
R ita R S irio S S R R S S R S R R S S S S R Telecontrol systems SIRIO e RITA Access to old town centre and to the Limited Traffic Zone are monitored by the telecontrol systems named SIRIO and RITA. OBJECTIVES
ACCESSES AUTHORIZATIONS SANCTIONS Background for the Analysis • In order to carry out a complete analysis of the in-traffic of the old town centre, information from various sources is needed: • Telecontrol system vehicle number plate, gateways, access time and date. • Authorization’s registers type of access authorization associated to the vehicle • Transaction databases of Municipalitity Offices Contraventions (PMGU Database) and other information regarding vehicles not recognized automatically at each gateway (SIRIO Database). OBJECTIVES
PROJECT GOALS To show the real benefits of using a BUSINESSINTELLIGENCE application to analyze accesses to a Limited Traffic Zone. 1 Evaluate the CAPABILITY of information integration. 2 Give examples of possible information analyses related to different authorizations and access to SIRIO/RITA. 3
Reports: Access Analysis Access Analysis per day and tipology
Reports: Access Analysis Access Analysis per day and tipology
Reports: Analysis of Authorized Accesses Analysis of Authorized Accesses by authorization type
Reports: Analysis of Authorized Accesses Analysis of Authorized Accesses by authorization type
Road Rules Violations Analysis Road Rules Violations Analysis Report related to 2006 by detector tipology . • analysis based on street, number plate, detectors etc • payments and transgressor profilesanalysis
Authorizations Analysis Report of Authorization trend within Municipality of Bologna OBJECTIVES
PROTOTYPE: Added Values • DATA INTEGRATION:possibility to put in relation/comparison data coming from various systems and applications. This kind of information results difficult to be handled by non-automated processes. • As a consequence ENHANCE data – integrated data can put in evidence very interesting informations/behaviours, not obtainable otherwise if separate data is to be considered. • Limited Traffic Zone CONTROL: possibility of constantly and on-time monitoring of various tipologies of accesses to ZTL.