Re-usable Patterns and Universal Data Models For Financial Data

3 Day Course (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 company and address information!”

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 data warehouse design 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

This course provides an extremely effective method of teaching data modeling to all data management skill levels by using practical, proven, data modeling methods, examples and concepts. The course focuses on common data model constructs that occur in financial services industries such as:

    • Investments and securities organizations
    • Wealth management organizations
    • Banks
    • Credit card companies
    • Mortgage companies and lenders

This interactive seminar walks you through the process of using common or “Universal Data Models” for data modeling and data warehousing. 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 and data warehouse design pitfalls and learn how to avoid them. These models, hints and techniques could save your organization millions of dollars in inevitable redevelopment costs!

This dramatically different seminar teaches data modeling by example. Other seminars focus on the techniques and methodologies behind data modeling; we believe a better approach is to learn by doing—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 data warehouse designs that can be the starting point for quality and integrated data architectures, databases and data warehouses.

You Will Learn

    • A data modeling introduction – 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
    • A broad range of common, re-usable, “Universal Data Models” allowing you to jump start and quality assure your efforts. This course includes many financial services common data modeling constructs such as:
      • Financial services party roles and relationships
      • Financial objectives, needs and plans
      • Mortgage and loan payment schedules
      • Financial services product definition
      • Financial investments and securities information
      • Financial product regulations and rules.
      • Financial agreement
      • Financial account and collateral
      • Financial account transaction.
      • Account notification
      • Risk analysis
    • Financial account and account transaction star schema
    • Common pitfalls in data modeling and data warehousing modeling and “War stories” illustrating consequences of incorrect modeling
    • Explanations of alternative data modeling, master data management, data warehouse and multidimensional approaches and how to convert logical data models into a physical design. An explanation of common approaches and architectures along with pros and cons of each approach will be provided.
    The data models provided in this seminar are robust and have been successfully implemented in a great variety of organizations.

    A broad range of common, re-usable, “Universal Data Models” allowing you to jump start and quality assure your efforts, including constructs for modeling people, organizations, relationships, contacts, products (goods and/or services), orders, shipments, work efforts, accounting, budgeting, web visits, as well as common data warehouse and data mart designs.
  • Common pitfalls in data modeling and data warehouse designs and “war stories” illustrating consequences of incorrect modeling
  • How to translate these universal data model constructs into effective databases and data warehouses

Who Should Attend

    • Data modelers
    • Data warehouse designers
    • Data analysts
    • Data administrators
    • Database designers
    • Master data management professionals
    • 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
Praise for UDM Seminars

“Len Silverston was very knowledgeable and spoke on a level appropriate for the experience and novice. We learned a lot in 3 days and went from very little knowledge to a really good foundation to start a data warehouse effort.”

Data Warehouse Architect, manufacturing and distribution organization

read more >

Request Information

To schedule and/or customize a UDM seminar for your organization, e-mail us or call

303.688.1412