Using Universal Data Models - 2 Day Course Outline

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