[CLICK TO DOWNLOAD]
COMPLETE COURSE INFORMATION

10 Reasons to attend Inteq Training Programs
[read more]



FREQUENTLY ASKED QUESTIONS

Q: How do I schedule an on-site training program?
A: All Inteq training programs are available on-site at your location. On-site training enables us to tailor the delivery of the program to the unique need and requirements of your organization. Contact us for details.

Q: How are the programs priced?
A: On-site training is cost effective with as few a 6 participants. The pricing is tiered, based on the confirmed number of participants, up to 24 participants. Contact us for a quote.

Q. Do you offer custom programs?
A: Yes. We can create custom configurations across our existing programs, integrate hands-on mentoring, etc., to meet your special and unique training requirements.

Q. Do you offer open enrollment scheduled programs?
A: Inteq training is designed for corporate on-site training. If you have less than 6 participants, consider combining your participants with other organizations in your area. We can help. Contact us for details.

Q. Who will be our instructor?
A: All Inteq instructors are first and foremost real-world hands-on practitioners of the subject matter. Our instructors are highly experienced professionals that also have excellent teaching and communication skills. (Also see "8 Reasons to Schedule an Inteq Training Program")

Q: How do I get more info?
A: Please contact us at 800.719.4627 or email us a info@inteqgroup.com or send us your questions via the comment box on this page.

Advanced Data Modeling –
Modeling and Analyzing Complex Business Rules, Patterns & Abstractions

An Intensive 2-Day Instructor Led Training Program

This program is designed for business & systems analysts, data modelers, architects & DBAs, application developers & designers, application, BI & ETL developers, technical designers & architects and anyone interested in acquiring and applying key business and systems analysis skills.


Program Description

The focus of this intensive 2-day instructor led program is on providing participants with the deep knowledge, critical thinking skills and experienced judgment to identify and thoroughly analyze complex business concepts and data structures, to understand and create logical data models at the appropriate level of abstraction and to identify and analyze the impact of data modeling design choices.

This program includes advanced data patterns such as rules-based entity types, meta-entity types, conditional recursion, multi-recursive networks, state-transitions and sub-type variants. This program also includes advanced topics in data abstraction, data model analysis, normalization and data fragmentation and allocation.

This program is designed for business and systems analysis professionals that are analyzing complex data oriented business rules and developing and managing highly sophisticated business and functional requirements

Prerequisites: Inteq’s Business Data Modeling training program or equivalent senior level business systems analysis experience.


You will learn:

• Data patterns that enable you to quickly recognize and accurately analyze complex data oriented business rules and validate complex requirements. Generalization and abstraction techniques that enable flexible data structures that adapt to rapidly changing business processes and business requirements.

• To review and validate data models with a comprehensive and effective data model quality assurance approach. Best practice approaches to standardizing modeling components, meta-data and naming conventions To identify and analyze the impact of normalization anomalies.

• To analyze the impact of data model abstraction on physical database design and systems development approaches.

Our intensive 2-day instructor led classroom format and integrated curriculum is the most effective, practical and convenient approach to acquire and integrate the skills and knowledge into your work environment.


Program Format

This program comprises best practices, supporting techniques and practical knowledge gleaned from the experience of numerous real-world projects.

It includes practical application of model driven analysis techniques followed by carefully crafted exercises and case studies designed to reinforce the techniques and enhance participant skills.


Program Outline (1.5 CEU credits)

Introduction
• Advanced data modeling key concepts
• Model driven analysis
• Review of 10 base data patterns

Model Abstraction
• Developing model flexibility
• Generalization of entity types
• Transition from meta-data to data

Advanced Data Patterns
• Advanced subtype variations
• Multi-recursive networks
• Meta entity types
• Rules-based entity types
• State transition rules

Advanced Data Analysis
• Advanced normalization concepts
• Principal/kernel entity types
• Static vs. dynamic entity types
• Key structures & relationships
• Derived and optional attributes
• Data coupling and cohesion


Putting it all together - Participants work in small groups to analyze a complex business case and create a detailed logical data model utilizing a variety of advanced patterns and analysis techniques. This session provides invaluable hands-on experience in applying the techniques to enable participants to immediately apply the techniques effectively within their own organization.

Best Practices and Practical Tips
• Conceptual v. logical data model
• Logical to physical transformation
• BI and dimensional considerations
• Business and functional requirement considerations
• Model management and stewardship



The Advanced Data Modeling training program is part of Inteq’s integrated Business Analysis Series (which also includes Business Process Management, Business Systems Analysis, Business Intelligence Requirements and Business Data Modeling) is based on Inteq’s MoDA™ Framework* – the rapidly emerging worldwide standard for business and systems analysis.

__________

*Model Driven Analysis Framework