Welcome to Debtech International

Onsite Seminar

Data Modeling and Data Warehouse Design Using Universal Data Models

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 share an extremely effective method for developing higher quality data models and data warehouse designs in much shorter time frames. It will provide participants with a powerful toolkit of "Universal Data Models" and data warehouse designs that can be the starting point for data models, integrated data architectures, databases and data warehouses.

This interactive seminar will teach effective data modeling and data warehouse design by using proven, real-world examples. Participants will learn how to build and customize "Universal Data Models" and data warehouse designs for many common data structures from customer contact management to web visit data structures. This course will not only share effective methods for developing these models, but you will be able to practice customizing them for your environment and take away valuable template data models to use as a starting point for your design efforts. Mr. Silverston will point out 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.

Upon completion of this course attendees will:

  • Know how to data model using 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), sales orders, purchase orders, electronic objects and images, web visits, common data warehouse designs, data mart designs and much more.
  • Understand and be aware of common pitfalls in data modeling and data warehouse designs and "War stories" illustrating consequences of incorrect modeling
  • Know how to translate these universal data model constructs into effective databases and data warehouses

The “best practice” data models provided in this seminar are robust and have been successfully implemented in a great variety of organizations.

Course Outline

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.

  • Demographics and characteristics of people and organizations
  • Customer, supplier, internal organization, and other contact information.
  • Relationship management
  • Contact information such as address, phone, email and other contact mechanism structures
  • Communication events such as phone calls, meeting, emails and call 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).

  • Product structures for goods and services
  • Product variations, options and features
  • Product solutions
  • Inventory management
  • Products, parts, items, bills of materials, and configurations

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

  • Requirements or needs leading to orders
  • Sales orders
  • Purchase orders
  • Flexible models for specifying ship to, bill to, and various roles involved in order processing
  • Agreement and contract models

Class exercise in customizing the 'order' universal data models for your organization's needs

Universal Data Models for the Web
This section will provide some data model constructs for managing common eCommerce information.

  • Web Object and Image Management
  • Web Content Management
  • Web Visits (and visitors) and enabling web traffic and behaviour analysis

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

2 days

Course Format
Lecture, group discussion and exercises

Len Silverston

To request a quote for this in-house seminar
Please call (561) 218-4752 or email info@debtechint.com

Return to Onsite Seminars Table of Contents