FREE ELECTRONIC LIBRARY - Books, dissertations, abstract

«Presentation on an Industry Model for Local Government Barry Williams Presentation on the Industry Data Model for Local Government 1. Target Data ...»

Presentation on the Industry Data Model for Local Government

Presentation on an Industry Model

for Local Government

Barry Williams

Presentation on the Industry Data Model for Local Government

1. Target Data Architecture – Overview

2. Target Data Architecture - Details

3. Phase 1 – Load Electoral Register (TBC)

4. Phase 2 – Add Council Tax (TBC)

5. Phase 3 – Add Data Marts

6. Customer-Services Data Model

7. Business Drivers

8. Stakeholder Involvement

9. Phases in Delivery

10. Table Details

11. Web Links

12. Suppliers

Presentation on the Industry Data Model for Local Government

1. Target Data Architecture – Overview This is an extension of the simpler Architecture in Barry’s CV.

He has designed this Architecture based on his many years experience as a Solutions Architect in data integration projects.

It shows the six major layers in an End-to-End Architecture for Data Migration from Data Sources, through a Data Integration Layer and into an Enterprise Data Warehouse.

Data Marts for specific requirements are then prepared with functionality and a User Access Layer provides tailored Reports and Data Sets for users on a Publish and Subscribe approach.

User Access Layer Business Intelligence (BI) Data Marts Enterprise Data Warehouse Data Integration Layer

–  –  –

2. Target Data Architecture - Details Now we would introduce three Data Marts for specific categories of data :Customers (for total counts, also by Ethnic Origin), Customer Services – for example, the most popular, most expensive Services, Services – eg Environment, where Customers are not involved.

–  –  –

3. Phase 1 – Load Electoral Register (TBC)

3.1 Loading Data from the Electoral Register In Phase 1, we are getting started, using only Customer data from the Electoral Register We plan to load data from the Electoral Register directly into a Customers Table and an Address Table.

We would introduce Web Services for CRUD (‘Create, Read, Update and Delete’) operations on the data in the Customer Data Mart.

In fact, we should say ‘CRUA’ because we would expect to Archive data, rather than Delete it.

We need to provide for Address matching because more than one member of the same Family can be on the Electoral Register.

They can have different names (like Barry and his Malaysian wife)

–  –  –

4. Phase 2 – Add Council Tax (TBC)

4.1 Adding Data from second System At this point, we would add data from a second System.

We would choose a System from the ‘Top 20’ – such as Council Tax, Housing Benefits, Parking, Social Services and so on.

We would choose depending on criteria such as Data Quality for Customer Names and Addresses.

–  –  –

5.2 Tables in the Customer Data Marts At this point, we add LGSL as Services Reference Data and switch to the PAF File (the Royal Mail Postcode Address File) for Address Reference Data.

–  –  –

6. Customer-Services Data Model

6.1 Introduction This version shows Entity names only and is from this page on Barry’s Database Answers Web Site : http://www.databaseanswers.org/data_models/local_govt_uk_residents/data_model_entity_names.htm

6.2 Detailed Attributes This Generalised Data Model establishes a common way of thinking of information which is consolidated across different Services.

We can use it to load data for any Council Service into the Data Warehouse in a consistent format so that it can be manipulated in a common way.

–  –  –

7. Business Drivers Typical Business Drivers could include –

1) Confirm the population for Central Government funding.

2) Trace missing children

3) Identify Families

4) Predict Youth Offenders

5) Check Fraud – eg trading in Blue Badges (Disabled Parking)

8. Stakeholder Involvement Typical Stakeholder Involvement will include :Agree the Approach and Objectives For example, “To obtain a Single View of the Truth”

2. Agree Top-to-Bottom Solutions Architecture

3. Define initial thin slice – from BI Layer with KPIs, down to Data Sources, Data Quality, etc..

KPIs – Total number of Residents, by Ethnic Origin and change on a monthly basis.

4.Obtain Commitment From senior management (already achieved ?), middle management.

Identify the Data Stewards for major Systems – Council Tax, Housing Benefits, Social Services, Parking and so on.

5.Establish Priorities For example, build a Customer Master Index.

6.Review Technology Base Identify features in a Phased MDM Platform

7. Interview Suppliers Draw up a short Statement of Requirements and circulate to potential Suppliers.

–  –  –

MCC will retain ‘Thought Leadership’ and talk to Suppliers from a position of superiority.

The Plan :Agree Target Architecture This defines the long-term goal and provides a direction

2) Get started simply and increment in a controlled manner Terminology could include CMI (Customer Master Index), Customer or MDM Hub or Data Marts.

–  –  –

10. Table Details

10.1 Direct Load from Electoral Register to the Customer Hub Phase 2 would add an early version of the Customer Master Index.

This Phase creates a separate Address_Master table.

Otherwise, the work involved is trivial and we would not make serious progress.

People who are on the Register with different names can live at the same address.

10.2 Typical Electoral Register Presentation on the Industry Data Model for Local Government

10.3 Direct Load from Electoral Register to the Customer Hub

–  –  –

10.4 Customer Master Index This Model shows an early version of the Customer Master Index (‘CMI’).

Multiple sources of customer-related data bare integrated in a single Customer Master Index.

It is on this page : http://www.databaseanswers.org/data_models/master_data_mgt/master_data_mgt_customers.htm

–  –  –

10.5 Early Customer Master Index (CMI) This Model shows multiple sources of customer-related data being integrated in a single Customer  http://www.databaseanswers.org/data_models/local_govt_top_level/getting_started_phase_1_hub.htm

–  –  –

10.6 Another Early CMI Phase 4 : Add an early version of the Customer Master Index This Model shows multiple sources of customer-related data being integrated in a single Customer  http://www.databaseanswers.org/data_models/local_govt_top_level/getting_started_phase_2_hub.htm

–  –  –

10.7 BI Dashboard This was a BI Dashboard produced by Barry as part of a ‘Clean and Green’ Environmental Monitoring initiative in Ealing This shows 23 Wards with Red, Amber or Green marking Wards that need management attention.

–  –  –

11. Web Links LGSL - http://doc.esd.org.uk/LocalGovernmentServiceList/4.00.html LGSL Entry - Electoral Register (364) http://doc.esd.org.uk/LocalGovernmentServiceList/4.00.html#/http://id.esd.org.uk/service/364 The Open Data Institute : http://theodi.org/

–  –  –

12. Suppliers

12.1 Major Players (alphabetic) 12.1.1 IBM IBM InfoSphere Master Data Management Hub – “InfoSphere Master Data Management supports flexible management of master, reference and transaction data” http://www-01.ibm.com/software/data/infosphere/mdm/custom-domain-hub.html IBM Initiate Inspector  http://www-01.ibm.com/software/data/infosphere/inspector/ 12.1.3 Microsoft Microsoft Master Data Services SQL Server Master Data Services provides a central data hub that ensures the integrity of information and consistency of data is constant across different applications” http://www.microsoft.com/en-us/sqlserver/solutions-technologies/enterprise-informationmanagement/master-data-services.aspx What, Why and How of MDM http://msdn.microsoft.com/en-us/architecture/bb190163.aspx MDM Hub Architecture from Microsoft  http://msdn.microsoft.com/en-us/library/bb410798.aspx 12.1.4 Oracle Master Data Management  http://www.oracle.com/us/products/applications/master-data-management/overview/index.html Customer Hub  http://www.oracle.com/us/products/applications/master-data-management/customer-hub/overview/index.html 12.1.5 SAP Master Data Governance :http://www.sap.com/uk/solutions/enterprise-information-management/master-data-management/masterdata-governance/index.epx Master Data Management  http://www.sap.com/uk/solutions/enterprise-information-management/master-data-management/index.epx SAP for Local Government : http://www.sap.com/uk/industries/public-sector/state-local-government-software.epx

–  –  –

12.2 Niche Players (alphabetic) 12.2.1 Bloomberg Polar Lake Polar Lake Reference Data Management http://www.polarlake.com/reference-data-management/introduction 12.2.2 Loqate Address Validation Everything Location – Webinar: February 26th, 4pm GMT, 8am PST, 11am EST, 5pm CST Cloud-based self-service address cleansing : http://www.loqate.com/ 12.2.3 Kalido (Open Source) Kalido MDM http://www.kalido.com/master-data-management.htm 12.2.4 Object River Object River uses Web Services to integrate with Salesforce.com http://www.objectriver.net/ Object River MDM Architecture –  http://www.objectriver.net/partners.htm 12.2.5 QAS Address Validation QAS is a well-established supplier of specialist software for Address Validation and a Single Customer View and a ‘People Tracer’ for the Public Sector (used by Surrey Police) –  http://www.qas.co.uk/ QAS also offer the Name exploit the PAF File and Gazeteer : http://www.qas.co.uk/products/capture-name-and-address-data/gateway.htm

Similar works:

«! Intersectionality’s (brilliant) career – how to understand the attraction of the concept? M Prof. Dr. Helma Lutz Goethe-University Frankfurt Working Paper Series “Gender, Diversity and Migration“ No. 1 (2014) Bio Note Helma Lutz is Professor of Women’s and Gender Studies in Sociology at Goethe University Frankfurt, Germany. She previously worked at several European Universities in the Netherlands, France and Sweden. Her research is concerned with gender, migration, nationalism,...»

«erschienen in: Buch und Bibliothek, 51 (1999), 36-43 Was Bibliotheken wert sind. Die wirtschaftliche Bedeutung der Bibliothek und ihre Ausrichtung auf die Informationsgesellschaft* Hans-Christoph Hobohm, FH Potsdam Ausgehend von einer konkreten Studie in Brandenburg wird die Situation der Bibliotheken in der beginnenden Informationsgesellschaft beschrieben und konstatiert, daß trotz einer großen Zahl an politischen Willensbekundungen Image und gelebter Stellenwert von Bibliotheken immer noch...»

«Japan Und Seine Esskultur Traditionen Und Rezepte Einer Grossen Kuche A consumers know your vision and problem or will more that big are them to changes yet end. Mess some basis and decide the priced and needed credit potential but management job. Element, with experience, applies all home-based fire under house many in pdf, executives, entity, process, and any price more. A agent clearly is any media on just making the many significance and mobi. Adjusting to the store, a person with the...»

«SUGI 30 Focus Session Paper # 125-30 Implementing Data Warehousing and Business Intelligence at McMaster University Using the SAS® Intelligence Value Chain Debbie Weisensee, McMaster University, Hamilton, ON Eric Matthews, McMaster University, Hamilton, ON Anne McInnis, McMaster University, Hamilton, ON ABSTRACT This paper covers the incremental development of an enterprise-wide data warehouse at McMaster University, along with the deployment of end-user, web-based query and reporting tools...»

«Warren County Fiscal Year 2010-2011 Budget Approved by the Board of Supervisors April 27, 2010 Warren County Board of Supervisors Archie A. Fox, Chairman Glenn L. White, Vice-Chairman Tony F. Carter Linda P. Glavis Richard H. Traczyk Warren County Staff Douglas P. Stanley, County Administrator Richard J. Magnifico, Deputy County Administrator Carolyn W. Stimmel, Finance Director Janice C. Dearaway, Deputy Clerk to the Board of Supervisors Jodi R. Spittler, Human Resources Manager Shelley L....»

«Richtlinie des Bundesministeriums für Wirtschaft und Technologie zur Förderung von forschungsintensiven Unternehmensgründungen (EXIST-Forschungstransfer) im Rahmen des Programms „Existenzgründungen aus der Wissenschaft“ Neufassung vom 2. Dezember 2010 1 Zuwendungszweck und Rechtsgrundlagen der Förderung 1.1 Zuwendungszweck Die wirtschaftliche Verwertung neuer Forschungsergebnisse über die Gründung von Unternehmen gilt als besonders anspruchsvolle und effektive Form des Wissensund...»

«Improving Quality in Business Process Outsourcing through Technology Hongyan Li CORAL, Department of Business Studies, Aarhus School of Business, Aarhus V 8210, Denmark, Hojl@asb.dk Joern Meissner* Department of Management Science, Lancaster University Management School, Lancaster LA1 4YX, UK, joe@meiss.com Sufficient evidence shows that Business Process Outsourcing (BPO) is growing rapidly. Technological and communication advances help realize the wide-spread adoption of BPO, due to their...»

«CARRYING ON BUSINESS UNDER ASSUMED OR FICTITIOUS NAME Act 101 of 1907 AN ACT to regulate the carrying on of business under an assumed or fictitious name. History: 1907, Act 101, Eff. Sept. 28, 1907.The People of the State of Michigan enact: 445.1 Certificate required to carry on business under assumed name; filing; form; contents; fee; execution and acknowledgment; exceptions; certification and return of duplicate; “person” and “address” defined; imposition of fee by certain charter...»

«Institutions, Knowledge Assets & Financial Contracting: Private Equity in an Emerging Market∗ Florence Eid florence.x.eid@jpmorgan.com Middle East/North Africa Economist Emerging Markets Research & Strategy JP Morgan 125 London Wall London EC2Y 5AJ Tel: + with Kamil Roumieh Citibank  We thank all those who contributed to this paper especially Josh Lerner (HBS) and Antoinette Schoar (MIT Sloan) for sharing their version of the questionnaire used, and Jeff Nugent and Mine...»

«8 ISER Working Paper Series Who assimilates? Statistical artefacts and intergenerational mobility in immigrant families Renee Reichl Luthra Institute for Social and Economic Research University of Essex Thomas Soehl Dept of Sociology McGill University No. 2014-28 August 2014 www.iser.essex.ac.uk Non-Technical Summary One in five US residents under the age of 18 has at least one foreign-born parent. Although the distribution of immigrants in terms of human capital is bimodal – the foreign born...»

<<  HOME   |    CONTACTS
2016 www.book.dislib.info - Free e-library - Books, dissertations, abstract

Materials of this site are available for review, all rights belong to their respective owners.
If you do not agree with the fact that your material is placed on this site, please, email us, we will within 1-2 business days delete him.