Jump Start Your Data Modeling & Data Warehouse Efforts with Universal Data Models

This interactive seminar starts with data modeling fundamentals and then walks you through the process of using common or “Universal Data Models” for data modeling and multi-dimensional modeling Attendees will leave not only with the concepts behind these models, but also with actual models customized for your organization. We will examine many data modeling, data warehouse and dimensional modeling pitfalls and learn how to avoid them. These models, hints, and techniques could save your organization a great deal of time and money by avoiding unnecessary redevelopment costs!

This dramatically different seminar teaches data modeling by example. We will provide an overall data modeling fundamentals section on the beginning of the first day, and then we will mainly teach by allowing the student to see real life examples of models. The participants can then use these to help create data models for their organization —you will build on the examples presented, to develop your own data models that you can use immediately to jump-start your own efforts.

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

Objectives

Understand data modeling fundamentals– a fast track approach to learning data modeling techniques. This includes defining entities, relationships, sub-entities, types versus instances, cardinality, optionality, unique identifiers, attributes, recursions, exclusive arcs, normalization
Learn a broad range of common, re-usable, “Universal Data Models” allowing you to jump start and quality assure your efforts. This course includes many structures that can be used to track CRM information, supply side processing, sales transactions and analysis, and much more. For example, it will include constructs for modeling people, organizations, relationships, contacts, products (goods and/or services), pricing of agreements and products, orders and sales transactions, shipments, invoices, work efforts, accounting, budgeting, web visits, server hits and additional e-commerce data structures.
Understand and avoid common pitfalls in data modeling, data warehousing and multi-dimensional modeling and “War stories” illustrating consequences of incorrect modeling
Learn alternative data warehouse approaches and how to convert logical data models into a data warehouse design including an eight step design process for converting data models into data warehouse designs taking into consideration historical time factors, granularity considerations, and various common denormalizations used in data warehousing.
Learn dimensional modeling techniques including an approach to creating effective multi-dimensional data marts as well as providing examples of star schemas for sales, procurement, human resources and financial analysis

Duration 3-4 days

Who Should Attend:

Data modelers, data warehouse designers, data analysts, data administrators, database designers, database administrators, database consultants and any other information systems professionals who need to be involved in data warehouse designs, data models, database designs, and data integration issues.

Prerequisite None

Course Format Lecture, workshops

Instructor Len Silverston