Transcript Diapositiva 1

Budapest, January, 21th
Data Warehouse for Piedmont
non-profit services:
Piedmont Region,
Municipality of Turin and
Piedmont Schools
Guido Albertini
Head of International Projects Directorate
Marco Boero
Decisional System Development, CSI-Piemonte
January 2009
Guido Albertini, Marco Boero
Agenda
 Some information on CSI-Piemonte
 Focus on the Business Intelligence
Competency centre
 Who we are
 What we do
 Non-profit services
January 2009
Guido Albertini, Marco Boero
Who We Are
Regional-based inter-University Consortium
and
Leading Italian ICT operator
Founded members
in members
1977 by
Ordinary
Supporting
Regione Piemonte
Città Region
di Torino
Piedmont
City of Turin
Università di Torino
University of Turin
Provincia di Torino
Province of Turin
Politecnico di Torino
Polytechnic of Turin
January 2009
Guido Albertini, Marco Boero
Main figures
• 75 Associated Consortium Members
• Annual revenue 177 millions € in 2008
• 6 sites in Piedmont (1 in Brussels)
• Over 1,200 employees
CSI-Piemonte is the largest Italian public agency
developing e-Government projects financed by the Italian
Central government
CSI-Piemonte has a company Quality Management
System certified according to UNI EN ISO 9001:2000
(Vision 2000) standards
January 2009
Guido Albertini, Marco Boero
CSI-Piemonte Mission
Building the
“Piemonte System”
to be a “system integrator” acting
• to implement the quality of the public action
(administrative decentralization)
• to simplify the public procedures
• to promote the transparency and the
participation
• to foster data-exchange and integration of
the PA through integrated information
services
through the use of information technologies
January 2009
Guido Albertini, Marco Boero
Areas of Activity
CSI-Piemonte, plans, develops and manages Information
Systems for all Public Sector ACTIVITY AREAS, eg:
 Agriculture and forestry
 Environment and territory
 Manufacturing activities and labour
 Culture
 Land registry and taxes
 Education and professional training
 Healthcare
 Administration systems
 ….
January 2009
Guido Albertini, Marco Boero
International Activities
Some international projects under way:











Business Intelligence consultancy for the Province of KwaZulu-Natal, South Africa
EU MEDA - Twinning Tunisia - Development of the Statistical Information System on
Enterprises in collaboration with the Tunisian Statistical Institute (INS)
Business Intelligence consultancies in the banking sector in Cyprus and Turkey
Interreg IV C Territorial cooperation: B3 Regions to transfer the acquired know how on
programming and development of regional broad band programmes to the New
Member States
EU MEDA - EuropeAid project for the Ministry of Water Resources of Algeria on study,
training, and technical assistance for document management, setting up of an
information system and a database for the water resources
EU MEDA - Twinning Tunisia - Strengthening the capacity of Regional Development
Organizations
EU PHARE - Twinning Poland - Local Government Budget Management System
EU PHARE - Twinning Hungary - Environmental sector
FP 6 Information Technology Society: Picture (Process Identification and Clustering for
Transparency in Reorganising Public Administrations)
FP 6 Information Technology Society: HENVINET (Health and Environment Network)
FP6 RDT: LUNA Natural speech recognition in different languages for CRM services
January 2009
Guido Albertini, Marco Boero
Data -> Knowledge ->Decision
Territory and Environment (289)
Institutional activities (175)
Educational, culture and free time (72)
Health-care systems (265)
Producing activities and work-related topics (355)
Human Resources (340)
Demography
Land Register and Taxes
Justice
Agriculture
Labour
Internet and ICT
Decisions
Information
Knowledge
*update October 2008
January 2009
Guido Albertini, Marco Boero
Business Intelligence
From IDC’s article
 Public sector executives are under high pressure to
raise productivity of government operations to
release resources for better public services ... the
role of business intelligence becomes crucial to
discover, analyze and forecast levels of spending,
resource utilization, and usage patterns of services
and thus feedback information into decision process
for service improvement.
?
Business Intelligence is the solution
January 2009
Guido Albertini, Marco Boero
100
50
0
1st 4th
Qtr Qtr
Business Intelligence
From IDC’s article
 The strategic role that business intelligence acquires
in the government modernization process will
prompt executives to adopt new organizational and
technological solutions to face these challenges
Business
Intelligence is the
solution
January 2009
Guido Albertini, Marco Boero
History of Decisional Systems at CSI-Piemonte
Report on
mainframe
Stand-alone
applications
Web
applications
1980
1990
2000
Palm
services
2005
Application on
Mainframe
2010
Client-server
applications
January 2009
Guido Albertini, Marco Boero
Data -> Knowledge ->Decision
Health, to support the Piedmont Health Bodies
in the daily management activities, as for
example:
Decision making system on pharmaceutical
prescriptions, Health activities control indicators:
check indicators of family doctors prescriptions,
Oncology screening Indicators, Epidemiological
Observatory (based on demographic data),
Executive Reporting of Public Hospitals,
Accounting and cost/revenues management
system for Public Hospitals, …
knowledge
Observatories for: Education,
Labour, Industry Labour Market,
Commercial Network, Mountain,
Handcraft Activities, …
Services Control: Trade acceptance
files, accidents, offences, penalties
contentious, tourism and sport files,
housing files…
Management Control: Financial
indicators, account plans, policies…
Strategic Planning: Dashboards
Indicators and balanced Scorecards…
January 2009
knowledge
Human resources: Salary reports,
Dashboard of human resources
allocation, Skills, Criticalities, Salary
Demography – Statistics: Demographic
paths, Resources development,
Evolutive Data Bank, Questionnaires on the
Reports on personal demographic
quality of life, Statistics on population registry
data, Re-organization simulations….
office…
Agriculture: Agriculture Census
Observatory, Agriculture
development plan monitoring, …
Data Quality: Data quality assurance (DQA) in
order to verify the reliability and effectiveness of
data
Metadata Catalogue to describe all the
business and technical metadata and services
Guido Albertini, Marco Boero
Target of our applications
 For more interactive customers:
 Services check across the
local area:
 For more strategic customers:
 Project on monitoring and
political evaluation:
Financial indicators, account
plans, Social policies
Municipality Management:
Taxes, Municipal Police,
Electoral Observatories…
 Observatories:
Services Control: Fiscal fraud,
Trade acceptance files,
accidents, offences, penalties
contentious, tourism and sport
files, housing files…
Education, Agriculture
Census Observatory,
Agriculture development plan
monitoring, Industry Labour
Market …
 For all:
 Dashboards Indicators and Balanced Scorecards
January 2009
Guido Albertini, Marco Boero
Sharing Information
 Unique centralized platform for everyone
 Single software platform for all customers
 Shareable databases
 Both One2One and cross-Customer applications
But mainly CSI-Piemonte has a Business

Intelligence Competency centre (BICC) with
 Statistical know-how and support centre
 Standardised and reusable software
January 2009
Guido Albertini, Marco Boero
The BICC at CSI-Piemonte
25
Employees
Consultants
53
PA
Institution 2
PA
Institution 1
BICC
APPLICATIONS
DATA
SOFTWARE
INFRASTRUCTURE
January 2009
Guido Albertini, Marco Boero
PA Institution 3
PA
Institution 4
Supporting Actions Offered by the Organization
Vendor contract management
Training plans
The
BICC
consists
of
78
people
skilled in
Future trends of BI architecture
Upgrading
applications/platforms
according to new releases
in a centralised way
Vendor contracts
management,
Support
user licenses administration
BI Program
5%
Matrix organisation
5%
Methodology for decisional
applications life-cycle
design and management
DW/BI Standard and best
practices (18 doc.)
5%
10%
25 %
Data acquisitionBack-End
New ETLs developing
ETLs management (155)
ETL for data massive
migrations
January 2009
15%
15 %
20%
60 %
DW/BI Standard
and
best practices
Support
Cross area team to
support front-end and
Front-End
back end activities
BI Delivery (214)
“standard” front-end
“custom” front-end
(java-jsp)
20%
20%
Advance analytics
Data and text mining
techniques, statistical
modeling, optimization
for PA
Guido Albertini, Marco Boero
Data Stewardship
Company metadata
management
Data quality (29)
“Data re-use” support
Classifier and codes
management
Examples of non-profit services
Piedmont Region
for Piedmont Schools
Municipality of Turin
for citizens
January 2009
Guido Albertini, Marco Boero
Examples
 Piedmont Region
for Piedmont Schools:
 Da.ma.sco Datawarehouse
 Compulsory Training Register DB
 Professional Training Ranking
January 2009
Guido Albertini, Marco Boero
Italian Education System
 Education and Training as two complementary systems
 The Italian educational system consists of:
 nursery, preschool (3 years)
 elementary school (5 years),
 lower secondary school (3 years),
 upper secondary school (5 years), followed by post-secondary and
tertiary education.
 Under the law, all Italian children must attend elementary school,
lower secondary school and the first year of upper secondary
school.
 Once they have completed their compulsory schooling, pupils not
intending to go on to further or higher education may opt to leave
school, but they must enrol for some form of training until they are
18 years old.
 Mixed Ownership of Schools: Public, Non Public
January 2009
Guido Albertini, Marco Boero
Italian Governance Roles
 State (Department of Education):
 general personnel management
 general indications on subjects (syllabi) and level of competencies
 Region:
 general planning and coordination of the school network system
(education and training)
 Financial resources management (Statal and Regional funds)
 Monitoring
 Schools:
 Administrative issues
 Didactics (loosely)
Constitutional Reform (ongoing): increased role of Regional
Administration – personnel management, regional component of
indications on subjects (syllabi)
January 2009
Guido Albertini, Marco Boero
Education Information System: CSI’s framework
January 2009
Guido Albertini, Marco Boero
Da.ma.sco: School Data Mart
 The Piedmont Region has collected, for 26 years now,
information on school population, teaching staff and
structural characteristics of the school buildings of all
levels through some questionnaires.
 Thanks to these data, two decisional services are
available to browse through the data:
 a multidimensional analysis service, set up by the Region,
accessible to all the public
 a query reporting service for the Regional Department of the
Italian Ministry of Education, University and Research,
Municipalities and the schools of some Provinces.
January 2009
Guido Albertini, Marco Boero
Da.ma.sco: School Information
Questionniares on
school surveys
Historical Data
Bases
Schools
Historical
series on
school surveys
Multidimensional
analysis services
Aggregated
information
Query and
reporting
services
Other
services
Access to school information
January 2009
Guido Albertini, Marco Boero
Region
Region,
Provinces,
Schools
Da.ma.sco: examples
January 2009
Guido Albertini, Marco Boero
Da.ma.sco: examples
January 2009
Guido Albertini, Marco Boero
Compulsory Training Register
Centralizes the students’ personal data from different sources
SCHOOL
CIA
COMPULSORY
TRAINING
REGISTER
Data are fed to the system on a daily basis
APPRENTICESHIP
PROFESSIONAL
TRAINING
Each source contains the personal data of the students
Each student should appear only once and is identified through his or her Fiscal Code
January 2009
Guido Albertini, Marco Boero
Compulsory Training Register Cleansing: Activities-1
Improvement methodologies based on data
(data quality techniques)
 Formal checks on fields
FISC_
COD
fiscal code correctness, coherence of fiscal code with
personal data, coherence the gender with first name, etc..
 Identification of duplicated data
application of “record matching” techniques 
identification of similar record groups (cluster
group)
 Criteria definition to identify a valid entry in a cluster group
application of a weight and measure system
that determines a record ranking
in a cluster group
January 2009
Guido Albertini, Marco Boero

Compulsory Training Register Cleansing: Activities-2
Improvement methodologies based on processes
 Redesign the Compulsory Training Register data base
 Redesign feeding flows, introducing Data Quality functionalities
School
DB
Professional
Training
DB
Apprenticeship
DB
Operational DB
CIA
Feeding procedures + Data Quality control
New Compulsory
Training
Register
January 2009
ETLq
ETL + DataQuality
Operational Data Store
Guido Albertini, Marco Boero
Professional Training Rankings
The Piedmont Region issues funds on a yearly basis through
tenders dedicated to Professional Training on the following
main topics:
 right and duty to education
 University master degrees
 labour market (on employment/unemployment)
Funds are assigned according to the
ranking of the institution, on the
basis of the following criteria through
a decisional algorithm:
Participants to the tenders:
 Historical series on the participants of
the 3 previous years
• Premises and equipment
• Outcome of the training
programme
• Use of the funds
 Evaluation of the training offer
January 2009
Guido Albertini, Marco Boero
Public institutions:
University of Turin
University of Eastern
Piedmont
Polytechnichs of Turin
Private institutions
Data Warehouse initial logical model
Operational
databases
January 2009
Guido Albertini, Marco Boero
Decisional
world
Training
Turnovers
Wages
Budget
Educational services
Administrative fees
Registry
Building
Public Works
Commerce
Sector
Data Marts
Constabulary
DATA & SERVICES CATALOGUE
Municipality of Turin
Operational
world
Expectations for the Data Warehouse
Decisional
World
Directional dashboard/
Social Budget
access
(DW data)
Registry
Data Marts
Training
Turnovers
Wages
Citizens
Economical and manufacturing activities
Employees
Territory (geo-reference)
Operational
databases
January 2009
Budget
Educational services
Administrative fees
Registry
Building
Public Works
Commerce
catalogue
search &
consultation
Sector
Data Marts
Constabulary
metadata
compilation &
pubblication
Management control
DATA & SERVICES CATALOGUE
Infodir
and
Sitad
Guido Albertini, Marco Boero
Operational
World
Cross-section Registry Data Marts
Benefits from the new structure
 Unique and optimised registry data supplier for all the several Data Warehouse
components
 Unique access to the supplying managerial database
 Centralized analysis with general DW access tools
 Improved data quality
 Guideline towards a Federal Data Mart structure, in which to read info in a
cross-sectional way in relation to the detailed Data Warehouse components,
starting from the links we find in the registry Data Marts
 Share within the Authority the information (alphanumeric and territorial)
knowledge
 Give a territorial meaning also to managerial information and allow the users to
have new geographical and non-specialized info
January 2009
Guido Albertini, Marco Boero
Information and Contact
 web site: http://www.csipiemonte.it/en
 contacts: [email protected]
[email protected]
January 2009
Guido Albertini, Marco Boero