Data Modelling and Data Warehouse Design Using Universal Data Models (DM & DWH Design usin)

Venue: Jurys Clifton Ford Hotel

Location: London, W1, United Kingdom

Event Date/Time: Apr 26, 2004 End Date/Time: Apr 27, 2004
Report as Spam


Seminar Overview:
Data modeling and database design is important. However it can turn out to be costly and time consuming. One reason for this is that many standard data model and data warehouse constructs are being modeled over and over again in various organizations, instead of re-using these constructs. Even though organizations are unique, generally at least 60% of an enterprise’s information requirements are common! If you are interested in having more tools available to you to develop better data models, database designs or data warehouse designs in much less time, then you will want to enjoy this 2 day seminar.

This interactive seminar will provide participants with a powerful toolkit of “Universal Data Models” and data warehouse designs that can be the starting point for quality and integrated data architectures, databases and data warehouses.

Learning Objectives
This seminar will provide:
n A broad range of common, re-usable, “Universal Data Models” allowing you to jump start and quality assure your efforts, This will include constructs for modeling people, organizations, relationships, contacts, products (goods and/or services), orders, web visits, as well as common data warehouse and data mart designs.
n Common pitfalls in data modeling and data warehouse designs and “War stories” illustrating consequences of incorrect modeling
n How to translate these universal data model constructs into effective databases and data warehouses
The data models provided in this seminar are robust and have been successfully implemented in a great variety of organizations.

This seminar is intended for data modelers, data analysts, data architects, data warehouse designers, data administrators, database designers, database administrators, database consultants and any other information systems professionals involved in data modeling, data architecture, data warehouse design, database design, or data integration.

Seminar Outline
This interactive seminar will walk participants through the building of common or “Universal Data Models” and data warehouse designs for many common data structures from customer contact management to web visit data structures. Participants will walk away with both the concepts behind these models as well as actual real life models to use as a starting point for common design efforts. Mr. Silverston will point out some data modeling and data warehouse design pitfalls and explain how to create practical, quality designs. Additionally, he will provide step-by-step instructions on how to create architecturally sound data warehouse designs from a corporate or logical data model.

Day 1
The what, why, and how of Universal Data Models
Universal Data Models for Parties
This includes common constructs for managing information about various types of people and organizations including customers, suppliers, key contacts, distributors, and internal organizations.
This section will cover many data model constructs including:
· People and organization demographic information
· Customer, supplier, internal organization, and other contact information.
· Relationship management
· Contact information such as address, phone, email and other contact mechanism structures
· Communication event or call center management
Class exercise in customizing the ‘party’ universal data models for your organization’s needs

Universal Data Models for Products
This section will provide product constructs can be used in a wide range of industries since almost all organizations offer some type of product (either goods or services)
This section will cover many data model constructs including:
· Product structures for goods and services
· Product variations, options and features
· Product categorizations
· Inventory management
· Product pricing
Class exercise in customizing the ‘product’ universal data models for your organization’s needs

Universal Data Models for Orders
This section will provide common data model constructs for managing orders, commitments and agreements between parties
This section will cover constructs illustrating how to best model:
· Orders and order items
· Various parties and contact mechanisms of orders
· Agreement and contract models
Class exercise in customizing the ‘order’ universal data models for your organization’s needs

Day 2

Universal Data Models for the Web
This section will provide some data model constructs for managing common eCommerce information.
This section will cover constructs illustrating how to best model:
· User Login Information
· Web Content Management
· Web Visits (and visitors)
· Server Hits

Implementing the Universal Data Models
This section addresses how to use the data models to implement effective, integrated databases.
Examples of physical database designs will be provided to show how to convert the data model into a physical database design.

Using Universal Data Models to Build Data Warehouse Designs
This section will address:
· Various data warehouse architectures and guidelines on when to use each architecture.
· Transformation rules for creating an enterprise-wide data warehouse design from a corporate data model
· Techniques for developing quality data marts and data analysis solutions in short amounts of time
· Sample designs for common data mart applications such as sales analysis, financial analysis, and human resource analysis

Previous delegates comments (boxed in)
" This is the very best seminar I have ever attended. The examples of situations encountered in the ‘real world’ were excellent. We have subsequently used many of the Universal Models from the course on several projects to successfully implement modified versions these of these designs." Cindy Nixon, data warehouse consultant, Frontline Systems

“This is a very useful seminar that I would recommend to architects and designers. It was particularly valuable in that it re-affirmed and extended much of the knowledge I already had. We will definitely use these templates as the starting point for new designs and re-designs.”
Rod Russell, VP Solution Development, eXcape Business Transactions, Inc.

“Len's ability to equate examples to participants in specific industries was awesome. His delivery of material was riveting. I acquired a considerable amount of new information in addition to reaffirming approaches currently taken in my organization,” W. Beach, British Columbia Ministry of Health

"Mr. Silverston validated that IBM's approach in using template models is
an effective way to establish a corporate data model and effectively and
efficiently design databases at the application level. The course was
excellent." Steven Arbogast, Enterprise Information Management Program Director, IBM.

“Len Silverston is an excellent instructor. His ability to give real life examples and to draw out the participants was excellent. We are taking home a long list of things to tackle using these tools, as soon as we get back to our data warehousing effort.” Data Warehouse Consultant, Distribution Organization

Len Silverston


Additional Information

£995 + VAT