4 Day Using UDM to Jump-Start Your Data Modeling and Data Warehouse Efforts

(Course can be customized for your organization)
Instructor: Len Silverston, President, Universal Data Models, LLC.
Course Outline

Why You Should Attend

Clients often ask: “Are there any standard ways to model our common data structures? Surely we are not the first company to model standard constructs like customer relationships, sales transactions or purchase orders!”

Experience has shown that more than 60% of a data model (corporate or logical) or data warehouse design consists of common constructs that are applicable to most enterprises. This means that most data modeling or data warehouse design efforts spend as much as 60% of their time and budget creating constructs that have been built many, many times before! Doesn’t it make sense, then, to have a source for these common constructs? Get a head start on your data model or multi-dimensional modeling efforts and stop “reinventing the wheel” each time you develop a new system!

Additionally, how many times have you taken a course with simplified examples and then had difficulty in applying them in a complex real world environment? Why not learn through real world examples illustrating effective and ineffective ways of modeling?

Course Description

The content of the course will vary, depending on each enterprises needs, and will be customized to cover pertinent constructs for the enterprise taking the course.

This course provides an extremely effective method of teaching data modeling and data warehouse design to all data management skill levels by using practical, proven data modeling, methods, examples, and concepts. This course has helped organizations to quickly jump-start their data modeling, data management and data warehouse efforts while helping to enhance the quality of their 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 You 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 enterprise data administration 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. Other seminars focus on the techniques and methodologies behind data modeling. 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” that can be the starting point for quality and integrated data architectures, databases and data warehouses.

You Will Learn

• A data modeling fundamentals section – 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 and normalization
• 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
• Common pitfalls in data modeling and data warehousing modeling and “war stories” illustrating consequences of incorrect modeling
• Explanations of alternative data warehouse and multidimensional approaches and how to convert logical data models into a data warehouse design. An explanation of common data warehouse design approaches and architectures along with pros and cons of each approach will be provided. Also included will be 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

The data models provided in this seminar are robust and have been successfully implemented in a variety of organizations.

Who Should Attend

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