Current Public Seminars

Architecture & Strategy
Zachman Enterprise Architecture: Modelling Workshop Zachman Certification
Management Strategies for Enterprise Architecture
Business Analysis
Business Architecture: The Foundation for Enterprise Transformation
Working with Business Processes: Discovery, Assessment, Mapping, Analysis and Design
Mastering the Requirements Process
Mastering Business Analysis
Enterprise Data Management
Ten Steps to Data Quality
Incorporating Big Data, Hadoop and NoSQL in BI Systems and Data Warehouses
Managing Your Information Asset
Predictive & Advanced Analytics
Building an Enterprise Data Lake & Data Refinery for Enterprise Data as a Service
Business-Oriented Data Modelling
Advanced Data Modelling: Communication, Consistency, and Complexity
The Logical Data Warehouse - Design, Architecture, and Technology
Information Management Fundamentals
Data Modelling Fundamentals
Data Modelling Masterclass


"Interesting speaker with the ability to relate to real-world situations and examples."

Andy Rigby, Business Analyst, ATS Euromaster

"Great stories and vast experience help explain what DW 2.0 can do for you."

Jason Perkins, Principal BI Architect, British Telecom

"Excellent speaker, clear communication with audience. The structure of the seminar was well designed."

Istvan Czako, Data Warehouse Developer, BWIN

"Very clear and crisp. The best ever lecture I have ever been to on data warehousing topic."

Sridhar Somaraju, Enterprise Architect, Barclays Bank

"Thank you for sharing your great experience."

Laurent Cabrit, Manager, Accenture



2-Day Seminar

DW 2.0: Next Generation of Data Warehousing

In the two decades that data warehousing has been around, there has been much change. Older technologies have matured, there is new technology, and organizations have accepted Business Intelligence as a standard part of the infrastructure. Today there are many different renditions of what a data warehouse is - an active data warehouse, a federated data warehouse, a star schema data warehouse and so forth. Unfortunately none of these types of a data warehouse are the same. There is no integrity in the definition of what a data warehouse is. In addition, 1st generation data warehouses have failed to take into account many important requirements that are now recognized as legitimate aspects of data warehousing. Now there is DW 2.0 which is the definition of data warehouse architecture for the future of data warehousing. This two day seminar describes what DW 2.0 is and addresses what data warehousing for the future will look like.

Learning Objectives

  • describe what the architecture for the future of data warehousing looks like,
  • describe how metadata fits into DW 2.0,
  • describe the levels of data of DW 2.0 - interactive, integrated, near line, archival,
  • describe how unstructured data can be gathered and integrated into a data warehouse,
  • describe the flow of data from outside of DW 2.0, into DW 2.0 and out of DW 2.0,
  • understand why data warehouses do not have to cost a huge amount of money, even when they contain a lot of data and have lots of users,
  • understand the fundamental transformation of data that takes place as data passes through ETL processing,
  • examine the role of new data warehouse technologies such as Talend, Dataupia, SeaTab, Kalido, and others,
  • understand the migration path from existing 1st generation data warehouses to DW 2.0,
  • understand the issues of data base design in different parts of the DW 2.0 environment,
  • understand the issues of building a data warehouse on a fluid foundation that can be changed as business requirements change.

Seminar Outline

     A brief word about the past

     An introduction to DW 2.0

  • recognizing the life cycle of data within the data warehouse
  • including unstructured data in the DW 2.0 environment
  • integrating metadata into the DW 2.0 environment
  • changing the DW 2.0 technology infrastructure as business requirements change

     DW 2.0 architecture

  • the interactive sector
  • the integrated sector
  • the near line sector
  • the archival sector
  • the flow of data into, out of, and through the DW 2.0 environment

     Data warehouse performance

  • SLA for the DSS environment
  • Homogeneous workload management
  • Monitoring the data warehouse

     Data marts

     Data warehouse exploration facility

     The fluid foundation - making sure that changes to business requirements
     do  not  hamstring the development and maintenance efforts

     ETL and transformation processing

     The granularity manager

     Data modeling throughout the DW 2.0 environment

  • the ERD model
  • the dis model
  • the physical data model

    The metadata infrastructure

  • enterprise metadata
  • local metadata
  • business metadata
  • technical metadata

    Integrating Unstructured data

  • the issue of terminology
  • stemming
  • stop words
  • external taxonomies
  • direct, indirect searches
  • textual analytics - using SQL for text searches

    The near line extension

  • data base utilities
  • cross media storage management
  • the economics of alternate storage

    The exploration facility

  • when a facility is needed
  • what sort of data goes into an exploration facility
  • the users of the exploration facility

    Archival sector

  • passive indexes
  • inverted lists
  • periodic rewriting
  • internally contained metadata
  • release independence

    The unstructured data base

  • integrating unstructured data
  • SOM's and other visualizations
  • creating the unstructured data warehouse
  • linking the unstructured data warehouse to the structured data warehouse
  • applications of unstructured data in an analytical environment
  • managing volumes of unstructured data

    Methodology throughout the DW 2.0 environment

  • the waterfall SDLC
  • the spiral development SDLC
  • heuristic processing
  • just giving the end users their data

The audience is anyone building a data warehouse or rebuilding a data warehouse after it was not built properly the first time. This audience includes -

  • Data Architects
  • Systems Managers
  • Systems Designers
  • Data Warehouse Managers
  • Data Analysts
  • Data Managers
  • Database Administrators
  • Data Administrators

Special Features

  • There will be a discussion of the places where other materials can be had relative the DW 2.0. This includes a review of web sites, newsletters, white papers, seminars, certification courses, and so forth. In addition, vendors that are compliant with DW 2.0 will be discussed as well.

Speaker Biography

Bill Inmon, Inmon Consulting Services

Bill Inmon, Inmon Consulting Services, - known as the Father of Data Warehouse and one of the 10 IT People Who Mattered in The Last 40 Years - has written 50 books and over 1000 articles. His books have been translated into 9 languages. Bill’s weekly newsletter with b-eye-network is read by over 55,000 recipients.

In-House Training
If you require a quote for running this course in-house, please contact us with the following details:

  • Subject matter and/or speaker required
  • Estimated number of delegates
  • Location (town, country)
  • Number of days required (if different from the public course)
  • Preferred date

Please contact:
Jeanette Hall
Telephone: +44 (0)20 8866 8366
Fax: +44 (0) 2036 277202

Speaker: Bill Inmon
Inmon Consulting Services
Bill Inmon, Inmon Consulting Services

Endorsed by:
DAMA International
  UK Chapter

Media Sponsor

Group Booking Discounts
If 5 delegates from the same organisation register at the same time for the same or various seminars, then the 5th delegate is free. We regret that this offer cannot be used in conjunction with the Series Discount.

Series Discounts
Attend more than one course in this series and you will be entitled to the following discounts:

  • 2nd course 10%
  • 3rd Course 15%
  • 4th Course 20%

Data Management Series
DW 2.0: Next Generation of Data Warehousing
29-30 April 2010, London

Data Modelling Fundamentals
15-16 February 2010, London
20-21 September 2010, London

Data Modelling Masterclass
17-18 February 2010, London
22-23 September 2010, London

Information Quality Improvement
12-14 April 2010, London