Logical Data Modeling Training Overview

Mapping & Analyzing Data-Oriented Business Rules

Logical Data Modeling is an essential component of professional business analysis. Logical data modeling is often mistaken for database design. However, logical data modeling is the foundation for excellence in business analysis, business systems analysis and business intelligence requirements analysis.

Inteq’s Logical Data Modeling training course provides the basis for understanding the complex moving parts of an organization - its data-oriented business rules - the foundation for precision and agility in requirements analysis.

Business terminology embodies an organization’s business concepts, rules and underlying relationships. These concepts, rules and relationships form a body of knowledge called “data-oriented business rules.”

In most organizations, data-oriented business rules live as tribal knowledge, informally, in the minds of the people doing the essential day-to-day work of the organization.

However, these informal rules unofficially govern how organizations operate and how decisions are made. These rules are surprisingly vague and ambiguous; they are rarely subject to critical analysis. Yet, these rules are the basis for articulating business system requirements that are equally vague and ambiguous.

Vague, ambiguous, incomplete, incorrect, inflexible, missing business rules result in:

• Systems that are ridged and rapidly become obsolete and ineffective.
• Non-productive time spent on “work-arounds” to compensate for lack of functionality.
• Business processes that are cumbersome and inflexible.
• Costly, inflexible and maintenance-intensive information systems; systems, that even after significant investment, still do not deliver the necessary functionality.

That’s truly unfortunate because there is a clear path to getting the requirements right. Based on decades of experience, Inteq has uncovered and refined the foundational patterns of data-oriented business rules. Participants in Inteq's Logical Data Modeling training course utilize these patterns to rapidly discover, critically analyze and precisely specify data-oriented business rules via entity relationship (ER) diagrams.

Inteq's Logical Data Modeling results in the specification of data-oriented business rules that:

• Are thorough, clear and accurate. Data-oriented business rules that fully support business and user requirements.
• Scale to support the enterprise. Data-oriented business rules are often more complex at the enterprise level than they initially appear at the departmental or business unit level.
• Enable organizational agility. Rules that can adapt and evolve over time. Data-oriented business rules that transcend specific project solutions to seamlessly adapt to future requirements as the organization evolves.
• Support business intelligence. Data-oriented business rules must be thorough and accurate to enable effective tactical and strategic decisions.

Business and IT Professionals Worldwide Choose Inteq's Training

Inteq's Logical Data Modeling training course has emerged as the gold standard for professional-level logical data modeling training - and are simply the most effective logical data modeling training course available in the industry.

Inteq's Logical Data Modeling training course is more than education; it's transformation - for the participants, project teams and their organizations.

That’s why over 300,000 business and IT professionals worldwide choose Inteq's business analysis training courses - Including Inteq's Logical Data Modeling training course.

Introduction and Foundation

Data-oriented business rules
The business vocabulary
Business transactions vs. business intelligence
Rules vs. knowledge
E/R diagrams and data models

Framework for E/R Diagramming

Business entity types
Attributes and meta-data
Cardinality and dependency
Principle relationships

Diagramming Baseline Rules and Patterns

Domain entity types
Associative relationships
Domain-based associations
Repeating groups
Transactional relationships

Diagramming Complex Rules and Patterns

Super type / sub-type relationships
Recursive hierarchies
Recursive networks
Role-based associations
Time-dependent data

Diagramming BI Rules and Patterns

Tactical and strategic business questions
Business facts and dimensions
Analyzing cross-organizational facts
Dimensional modeling

Business Rule Generalization

Normalizing business data
Generalizing business entities
Analyzing meta-data for abstractions

Practical Guidance

Scaling models to the enterprise level
Model transformation: conceptual, logical, physical
Using reference models to leverage analysis
Implementation considerations and best practices
Getting started

Who Should Attend?

Inteq's Logical Data Modeling training course is designed for Business Analysts, Business Systems Analysts, BI Requirements Analysts, Data Modelers, Data and Enterprise Architects, DBAs, Project Managers, Developers and IT Professionals, Subject Matter Experts and Business Professionals focused on discovering, analyzing and specifying data-oriented business rules and requirements.

Prerequisites:

None. Inteq's Logical Data Modeling provides a comprehensive and cohesive approach data modeling and entity-relationship diagramming regardless of background and level of experience.

Logical Data Modeling is an excellent precursor and integrates seamlessly with Inteq’s Advanced Data Modeling training course and is an excellent companion course with Inteq's Business Systems Analysis training course.

Learning Options:

Anytime eLearning™: Anytime | Anywhere | Any Device | Self-Paced

Onsite Training: Onsite at your locations worldwide or via our live virtual classroom | Contact us for details.

Course Length:

The course is designed for two full days of training. However, Anytime eLearning™ participants can learn at their own pace and on their own schedule.

Participants can go back and review the material at their own pace and time schedule to reinforce and further internalize the concepts.

Anytime eLearning™ participants have 45-days to complete the course and most participants typically complete the training over 1-3 weeks.

What’s included?

In addition to the world-class training, participants also receive a comprehensive course workbook - which is yours to keep, supplemental materials, a personalized Certificate of Completion and CEU (continuing education unit) credits.

Critical thinking skills to cut through superficial and ambiguous discussions to distill core business concepts.
To recognize recurring patterns of data-oriented business rules to improve the quality and speed of analysis.
Techniques that enable thorough analysis of complex business rules and validation of complex requirements.
To create a precise, common vocabulary that is consistent among business end-users, analysts, IT professionals and other stakeholders, across the organization.
To developed clear, precise entity-relationship (ER) diagrams that capture and specify virtually any set of data-oriented business rules.
... and much more