PRE-CONFERENCE TUTORIALS • 2 November 2009
INFORMATION QUALITY TUTORIALS

09:30-17:15
FULL DAY

Grounding Your Information Quality Management Capability In Proven Quality Management Principles, Processes And Practices
Larry P. English, President, INFORMATION IMPACT International
09:30-17:15
FULL DAY
Building and Growing a Successful Information Quality Function
C. Lwanga Yonke, Independent Analyst
 
DAMA TUTORIALS
09:30-12:45
HALF DAY
Modelling is not JUST for DBMS’s anymore - Evolve or Die
Chris Bradley, Business Consulting Manager, IPL
09:30-12:45
HALF DAY
DATA Governance for Master Data Management
Malcolm Chisholm, President, AskGet.com
09:30-12:45
HALF DAY
Process Orientation for Data Management Professionals – Using “Process” to Gain Support
Alec Sharp, Senior Consultant, Clariteq Systems Consulting
14:00-17:15
HALF DAY
The Human Side of Data Modeling – Improving Communication with Subject Matter Experts
Alec Sharp, Senior Consultant, Clariteq Systems Consulting
14:00-17:15
HALF DAY
Defining and Executing an Information Strategy
Jan Henderyckx, Information Architect, Brainware
14:00-17:15
HALF DAY
Metadata Management for the Enterprise
Malcolm Chisholm, President, AskGet.com
   
DATA WAREHOUSE & BUSINESS INTELLIGENCE TUTORIALS
09:30-12:45
HALF DAY
Business Intelligence and Unstructured Data
Bill Inmon, President, Forest Rim Technology LLC
09:30-12:45
HALF DAY

Data Vault Modeling and Methodology - A Primer
Daniel Linstedt, CIO, Genesee Academy

14:00-17:15
HALF DAY
New Technologies For Developing The Next Generation Of Data Warehouses
Rick van der Lans, Managing Director, R20/Consultancy
14:00-17:15
HALF DAY
Advanced Analytics In Practice- Real World Data Mining Techniques, Tools And Examples
Jos van Dongen, Principal, Tholis Consulting
11:00-11:15 Break, 12:45-14:00 Lunch, 15:30-15:45 Break
 
INFORMATION QUALITY TUTORIALS
Full Day
Tutorial
09:30-17:15

Grounding Your Information Quality Management Capability In Proven Quality Management Principles, Processes And Practices
Larry P. English, President, INFORMATION IMPACT International


Information quality management is not an academic exercise—it is a combination of quality principles, processes and culture transformation required for business performance excellence in the emerging, realized Information Age.

World-class organizations apply the same quality principles, such as Deming’s Fourteen Points, Kaizen (Continuous Process Improvement), Quality Function Deployment (QFD) and the Baldrige Criteria for Business Performance Excellence to information. This presentation addresses how these principles and techniques apply directly to Information Quality Management with information as a product and Knowledge Workers as Information Consumers.

In this tutorial Mr. English describes the fundamental principles of Quality Management as applied to Information Quality. He describes how an organization can improve the quality and value of its Information Processes. He describes the Customer focus requirement to understanding Knowledge Workers’ Information Requirements to create Information Quality Standards. Mr. English describes the cultural transformation organizations must make to successfully implement and sustain an effective information quality function and IQ culture.

1. Quality Management Principles of Proven Quality Systems

  • Focus on the Customer
  • Apply Plan-Do-Study-Act (Process Improvement Cycle) as a core competency
  • Measure costs of poor quality and return on process improvement
  • Apply proven quality methods and techniques
  • Hold managers accountable for Information Quality and use

2. Quality Management Applied to Information Quality

  • Plan-Do-Study-Act (PDC/SA) Applied to Information Process Quality
  • Principles and techniques to design information quality into information processes

3. Culture Transformation: Creating a Sustainable Environment for Quality Information

  • Deming’s14 Points of Quality applied to IQ
  • Crosby’s Quality Management Maturity Model applied to IQ
  • Organizing for a sustainable Information Quality function
  • Creating and sustaining business effectiveness through IQ Management as a Business Management tool
Featured Speaker:
Larry P English  

Larry P. English
President
INFORMATION IMPACT Internationall

Full Day
Tutorial
09:30-17:15

Building and Growing a Successful Information Quality Function
C. Lwanga Yonke, Independent Analyst


Successfully tackling the tough challenges caused by poor data quality often seems like an overwhelming and thankless task. Moreover, as awareness about the importance of information quality grows, information quality (IQ) practitioners are increasingly called to tackle a myriad of complex IQ problems.

To be successful in the short and long terms, the IQ practitioner must be equipped with a robust foundation deeply rooted in proven best practices and applicable to various IQ efforts including CDI, MDM, compliance, governance, data integration, business intelligence, etc.

Drawing from lessons learned at the frontline, this tutorial describes the fundamental components of successful IQ functions and provides practical guidelines on getting started and remaining successful. Several hands-on exercises are used to facilitate learning and promote mastery.

This workshop will be beneficial to those implementing new information quality programs and to those seeking to re-energize or re-focus existing ones. Participants will leave with tangible solutions to many of their toughest IQ implementation challenges.

Topics addressed include:

  • The fundamental activities of IQ management and improvement
  • IQ Methodologies and Systems
  • The best home on the organization chart
  • Measuring IQ costs and benefits
  • Building a company-wide IQ culture
  • Aligning business and IT for IQ success
  • IQ in the System Development Lifecycle (SDLC)
  • The CxO Perspective
  • The attributes of the successful IQ Leader
Featured Speaker:
C. Lwanga Yonke  

C. Lwanga Yonke
Independent Analyst

DAMA TUTORIALS
Half Day
Tutorial
09:30-12:45

Modelling is not JUST for DBMS’s anymore - Evolve or die
Chris Bradley, Business Consulting Manager, IPL


Data Modelling has been around for 30 years. Its roots were firmly in the DBMS world – how many of you can remember implementing a DBMS on a tape based system? Yes really (IMS HISAM). But in the intervening 3 decades the World has moved on. Today’s Business systems landscape isn’t just about developing “new” DBMS based systems. The IT portfolio contains a variety of additional components such as:
  • ERP packages
  • BI & DW systems
  • Mashups & portals
  • SOA & XML message based systems.

Is DATA important in these systems – you bet.

Has modelling moved on to cater for these? Well – that’s what this talk is about!

We’re all familiar with how to create a database from a logical and physical data model. But how do the rules change when we’re dealing with ERP, Mash-ups, XML or SOA applications? Or do the rules change? How do can we leverage our existing logical data models for this new audience?

This half day workshop will first re-emphasise the “traditional” place modelling has in the DBMS design lifecycle.
It will then go on to show how data modelling can be used and why it’s vital in other areas of the application portfolio, in particular:

  • ERP packages
  • BI & DW systems
  • Mashups & portals
  • SOA & XML message based systems.

The summary contents of the half day tutorial are:

  • Big Picture: “Aren’t data models just for RDBMS development?”
    • History of modelling
    • Top down (To-be)
    • Bottom up (As-is)
    • Leveraging models for the DBMS lifecycle

  • Modelling’s place in other technologies
    • Implementing an ERP packages (e.g. SAP) – I don’t need a data model!! Think again (Illustrated by real case study)
    • Legacy data take on & mapping – no place for models here - wrong
    • BI & DW implementation – leveraging existing models before building your dimensional model
    • Mashups & Portals – no time for modelling – got to get it released rapidly.

  • How to Map XML to a traditional Data Model
    • Technical Overview and Comparison: hierarchical vs. relational structures
    • How to map a logical data model to XML
    • How to create XML

  • How XML and Models relate to SOA
    • SOA needs definitions & context / usage of data
    • SOA data services
    • Models & SOA registry
    • Importance / benefits – how XML fits in with internal and 3rd party web services

  • Case Study Example
    • Benefits achieved of modelling for SOA and XML in a major UK oil company.
Featured Speaker:
Chris Bradley  

Chris Bradley
Business Consulting Manager
IPL

Half Day
Tutorial
09:30-12:45

DATA Governance for Master Data Management
Malcolm Chisholm, President, AskGet.com


Master Data Management (MDM) needs a strong data governance framework to succeed. This tutorial examines what MDM is, and its special data governance needs. Particular emphasis is placed on the management of physical data content. Ways of raising the quality of master data values through data governance and stewardship are discussed. A principles-based approach to stewardship is described that avoids the need for excessive process implementation, but which uses metrics for monitoring and evaluation. The different governance needs of specific categories of master data are described. The importance of mapping master data across the production data landscape is discussed, together with methods for making this sustainable in the context of a permanent data management organization.

Attendees will learn:

  • What master datais, and the specific data governance needs for each of its categories
  • How to map the production data landscape for master data, and apply governance and stewardship techniques to improve data quality
  • How to implement information knowledge management for master data
  • How to use metrics to monitor the success of a governance program for master data
Featured Speaker:
Malcolm Chisholm

Malcolm Chisholm
President
AskGet.com

Half Day
Tutorial
09:30-12:45

Process Orientation for Data Management Professionals – Using “Process” to Gain Support
Alec Sharp, Senior Consultant, Clariteq Systems Consulting


Organizations everywhere are looking at their business processes - undertaking Business Process Redesign, adopting Lean or Six Sigma methods, or getting into Business Process Management. This is great news for data management professionals with skills in the business process arena. That’s because our goal may be improved data and information, but experience has shown that focusing on business processes is a great way to get the attention and support of the enterprise. After all, business processes are at the heart of what an enterprise does and how it delivers value.

This session introduces techniques for working on process-oriented projects, and is packed with practical frameworks and tips to get you off to a successful start. It touches on all phases of a project, including introducing business process concepts, discovering processes, scoping and assessing the target process, modeling the as-is process, and designing the to-be process. Throughout, we’ll illustrate the interaction between process and data perspectives.

Specifics include:

  • What people think business processes are, what they really are, and why it matters
  • Good news – how a data-oriented approach is invaluable in process discovery
  • Bad news – why some of our beloved approaches and frameworks get in the way
  • How to make processes visible and the need for improvement compelling yet blame-free
  • Workflow mapping, and the essential difference between process and data modeling
  • Managing detail – contextual, conceptual, and logical process models
  • Differentiators, stakeholders, and enablers – ensuring your new process isn’t worse than the old one.
Featured Speaker:
Alec Sharp  

Alec Sharp
Senior Consultant
Clariteq Systems Consulting

Half Day
Tutorial
14:00-17:15

The Human Side of Data Modeling – Improving Communication with Subject Matter Experts
Alec Sharp, Senior Consultant, Clariteq Systems Consulting


Above all, data models should be viewed as a communication vehicle among different stakeholders, including decision-makers, content experts, business analysts, and designers. Unfortunately, the communication often gets lost, either in the clouds, in the weeds, or somewhere off to the side. Whether the modeler has drifted too quickly into abstraction and generalization, or has taken the “deep dive for detail,” the result is the same – confused, frustrated, or detached subject matter experts. And the result of this is inaccurate or incomplete models! Experience shows that it doesn't have to be this way - simple techniques, consistently and regularly applied, will go a long way to ensuring involvement, buy-in, and communication.

Drawing on thirty years of successful data modeling experience, this workshop will illustrate the core “human side” behaviors – accessibility, directionality, simplicity, consistency, visibility, relevance, patience, and empathy. These will be illustrated through a variety of topics and practical examples:

  • “Role induction” for clients, and why you can skip the "tutorial" on data modeling
  • Getting started – choosing between top-down, bottom-up, or sideways-in approaches
  • Presenting vs. modeling – considerations for the emerging world of “systems archaeology”
  • Appealing to all learning styles – visual, auditory, and kinesthetic
  • Conventions for comprehension – guidelines for data model graphics
  • “Scripts” for growing the model – the value of consistency
  • Using other techniques – workflow modeling, use cases, and service specifications
Featured Speaker:
Alec Sharp  

Alec Sharp
Senior Consultant
Clariteq Systems Consulting

Half Day
Tutorial
14:00-17:15

Defining and Executing an Information Strategy
Jan Henderyckx, Information Architect, Brainware


Information is a corporate asset that needs to be managed and governed. Having information that is correct, consistent, timely and coherent could be a key differentiator in these difficult economic times. During this seminar Jan will present an approach to not only define an Information Strategy but also how you can execute is effectively. The key components that will be described are Information Governance, Information Architecture and the Information Service Platform. After the session you will be able to asses your maturity level and define a roadmap for your own company.

Defining the components and objectives of your Information Strategy Understanding Information Architecture Key requirements and components of the Information Service Platform

This presentation is based on real life examples and not just some theoretical ramblings.

Featured Speaker:
Jan Henderyckx  

Jan Henderyckx
Information Architect
Brainware

Half Day
Tutorial
14:00-17:15

Metadata Management for the Enterprise
Malcolm Chisholm, President, AskGet.com


IT costs and complexity are rising over the years, but at the same time IT is seen as unresponsive to changing business needs. Part of this is because IT has few operational and informational applications to monitor its own activity. This tutorial explores how metadata management can be used to overcome these problems. Metadata is now much more than entity and attribute definitions. Indeed, it has become so complex that metadata integration is a real issue in many enterprises. An approach to meeting this integration requirement is discussed, along with the infrastructure required to implement metadata management. Emphasis is placed on the realities of the production environment and actual data values in addition to logical components. How to build adequate meta-models and the proper distribution of metadata across the data architecture are also described.

Attendees will learn:

  • An expansive view of metadata, its role in information management, and details of the most critical areas that need to be addressed
  • An approach to the holistic management of metadata, especially the prevention of "master-data-like" problems arising in metadata management
  • An understanding of the metadata associated with production data content, and approaches to its management
  • Building an enterprise-wide infrastructure to manage metadata.
Featured Speaker:
Malcolm Chisholm  

Malcolm Chisholm
President
AskGet.com

DATA WAREHOUSE & BUSINESS INTELLIGENCE TUTORIALS
Half Day
Tutorial
09:30-12:45

Business Intelligence and Unstructured Data
Bill Inmon, President, Forest Rim Technology LLC


The first step in creating the bridge between the unstructured world and the structured is to understand unstructured data. Typically unstructured data consists of email, telephone conversations, spreadsheets, documents, and so forth. Unstructured data has no keys, attributes or records. But still there is important data in the unstructured environment that can and should be turned into data fit for a structured data warehouse.

This presentation addresses the different types of unstructured data, how the unstructured data is accessed, and how the unstructured data is prepared for analysis in the structured data warehouse environment.

Topics include –

  • unstructured data and structured data
  • textual ETL
  • resolving terminology
  • resolving semi structured data
  • setting the stage for business intelligence
  • email – a special case
  • homographs and proximity variables
  • visualization of text
Featured Speaker:
Bill Inmon  

Bill Inmon
President
Forest Rim Technology LLC

Half Day
Tutorial
09:30-12:45

Data Vault Modeling and Methodology - A Primer
Daniel Linstedt, CIO, Genesee Academy


Do you have issues with your current BI/EDW system? Does it provide disparate answer sets? Are you tired of maintaining silo solutions? In this presentation we will cover the basic drivers of the Data Vault Model and Methodology which answer these questions. This is a unique approach to solving enterprise wide problems and stems from SEI/CMMI Level 5, PMP, Six Sigma and TQM concepts. We will also cover the following topics:
  • What is the Data Vault Model and Methodology?
  • How and when should you apply it to your EDW efforts?
  • Who’s using it, and what benefits are they seeing?
  • Addressing Joins, Scalability, and Performance
  • Introductory look at how to build a Data Vault/With LAB!

Learn from the author and inventor directly! Interact with the Data Vault creator, get your questions answered!

Featured Speaker:
Daniel Linstedt  

Daniel Linstedt
CIO
Genesee Academy

Half Day
Tutorial
14:00-17:15

New Technologies For Developing The Next Generation Of Data Warehouses
Rick van der Lans, Managing Director, R20/Consultancy


Data warehouse appliances, BI mashups, SAAS, BI as a service, data warehouse as a service, analytical databases; we are being bombarded with new technologies for developing our data warehouse and business intelligence environments. In this tutorial, an overview is given of all those new technologies. How do they compare with classic technologies? When should you be using them? What are their advantages and disadvantages? How mature are they? Why are customers using them today? What are vendors, such as SAP, Microsoft, Oracle, and IBM doing with respect to these new technologies? This tutorial is designed for data warehouse and business intelligence professionals who have been working with classic products and want to know more about the new technologies.
Featured Speaker:
Rick van der Lans  

Rick van der Lans
Managing Director
R20/Consultancy

Half Day
Tutorial
14:00-17:15

Advanced Analytics In Practice- Real World Data Mining Techniques, Tools And Examples
Jos van Dongen, Principal, Tholis Consulting


Business analysts and BI professionals are accustomed to reporting on organizational performance. By now, most people are familiar with the use of BI tools and OLAP to report to identify exceptions and answer basic questions.

The challenge for many businesses is that new questions require new ways of looking at data. Reporting and OLAP techniques are designed for situations where the types of questions are known, and to explain past or current activity. These techniques can’t be used to understand complex relationships, explore large volumes of detailed data or predict future activity.

Data mining (including statistical methods, visualization and text analytics) provides the means to accomplish tasks that aren’t possible with basic BI tools and spreadsheets. These advanced analytics are often not used because of their assumed complexity and cost. The truth is that many techniques can be applied simply, and often with relatively inexpensive – sometimes free – tools.

This half day course will not only satisfy your curiosity but will also give you a hands on overview of how you can apply data mining techniques in your current job ,and how this will help your organization become an 'analytical competitor'.

You will learn:

  • What data mining is and what it adds to your existing BI capabilities
  • Data mining techniques and how they can be applied
  • The value of advanced analytics
  • What tools are available on the market and what can be easily adopted
  • How to get started with data mining
Featured Speaker:
Jos van Dongen  

Jos van Dongen
Principal
Tholis Consulting

Copyright © 2009 IRM UK Strategic IT Training Ltd. All Rights Reserved.