fd2363fc1f88c86289479fb8eea16df7.ppt
- Количество слайдов: 21
ICONSULTING “Intelligent” Access Control System in Bologna Old Town centre. Bologna, June 2007
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. 2
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 3
Planning and Control cycle DASHBOARD and B. P. M. APPLICATIONS BI MODELS QUERY & REPORTING and MD ANALYSIS Planning Strategic objectives and actions definition Control Management Programming Control of results according to Plans and Programs Process Operational objectives and actions definition Action DASHBOARD and SCORECARD 4
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, Applications Management Control Systems, Enterprise Management Dashboards. Systems Dashboards Municipalities Comune di Bologna Comune di Reggio Emilia Regions and Regional Agencies Regione Emilia Romagna Agrea Arpa Avepa National Agencies Sviluppo Italia 5
Reference Background Officers Services Revenues Municipality Services Communications Citizen Families Districts Real estates 6
Social Services Officers Services Revenues Services Municipality Communications People Families Districts Social Services (Senior Services, Education, …) Real estates 8
Public Works Management Officers Services Revenues Municipality Services Communications People Public Works Families Districts Real estates 9
Revenues Dashboard Officers Services Revenues Municipality Services Communications Revenues Dashboard (ICI, Tarsu, …) People Families Districts Real estates 10
Traffic Management Officers Services Revenues Municipality Services Communications People Traffic Management Families Districts Real estates 11
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 Rita R S irio S R S S R R S S S S 12 R
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: OBJECTIVES ACCESSES AUTHORIZATIONS SANCTIONS • 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). 13
PROJECT GOALS 1 To show the real benefits of using a BUSINESS INTELLIGENCE application to analyze accesses to a Limited Traffic Zone. 2 Evaluate the CAPABILITY of information integration. 3 Give examples of possible information analyses related to different authorizations and access to SIRIO/RITA. 14
Reports: Access Analysis per day and tipology 15
Reports: Access Analysis per day and tipology 16
Reports: Analysis of Authorized Accesses by authorization type 17
Reports: Analysis of Authorized Accesses by authorization type 18
Road Rules Violations Analysis Report related to 2006 by detector tipology. • analysis based on street, number plate, detectors etc • payments and transgressor profiles analysis 19
Authorizations Analysis Report of Authorization trend within Municipality of Bologna OBJECTIVES 20
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 ontime monitoring of various tipologies of accesses to ZTL. 21
ICONSULTING srl Via Bazzanese, 32/7 - Casalecchio di Reno (BO) – Italy Tel +39 0514391311 - Fax +39 051430692 www. iconsulting. biz
fd2363fc1f88c86289479fb8eea16df7.ppt