Program Management Curriculum Hero Image
Business Data Modeling

Available Modalities:

  • e-Training
  • Public Classroom
  • On Site
  • Virtual Classroom
SHOW CREDIT DETAILS
Delivery Method PDU Total Technical PMP/PgMp Leadership Strategy PMI RMP PMI SP PMI ACP PfMP PMI PBA
e-Training 15 15 0 0 0 0 0 0 15
Instructor-led training 21 21 0 0 0 0 0 0 21
Virtual instructor-led training 15 15 0 0 0 0 0 0 15
Delivery Method e-Training Instructor-led training Virtual instructor-led training
PDU Total 15 21 15
Technical PMP/PgMp 15 21 15
Leadership 0 0 0
Strategy 0 0 0
PMI RMP 0 0 0
PMI SP 0 0 0
PMI ACP 0 0 0
PfMP 0 0 0
PMI PBA 15 21 15
  • CDUs: 21 BABOK V2.0 used in the CDU approval of this course
  • CEUs: 2.1
  • CPEs: 25
  • PDUs: 21
Synopsis

This business data modeling training course explores business rules, policies and procedures and how they can be modeled effectively. Participants will learn entity relationship diagramming, super and sub-types, attributive and associative entities, and documenting data constraints. The course's logical data modeling approaches focus on the important requirements of the business that are discovered through significant user involvement during the analysis phase. You will also learn how to create models without being limited by technology or organizational structure. 

The ability to communicate the intersection of business processes and information/data needs is key to the success of any software development project. Understanding and explaining user needs is a major challenge and opportunity for the business analyst. The business analyst who understands structured modeling has a distinct advantage in addressing and communicating requirements. And the use of models can greatly increase all stakeholders’ understanding of the relevancy of business rules and data management requirements to the project at hand.

Reminder: Prior to taking this course, we recommend that you have acquired the background as taught in Eliciting and Managing Requirements.

This course is aligned with version 3.0 of A Guide to the Business Analysis Body of Knowledge® (BABOK® Guide)™. 

Learn
  • Explain how a lack of effective data analysis and usage can affect the risk exposure, cost control, and profitability of your organization
  • Explain the role of the business analyst in gathering data-related requirements from stakeholders
  • Create, communicate, and validate conceptual data models with your business stakeholders
  • Create normalized logical data models as a hand-off to solution delivery
 
Topics
  • Applying Logical Data Models
    • Associative entities
    • Data constraints
    • Using logical data models
    • Analysis of organizational and geographical data distribution
    • Supporting the organizational data standards
    • Software acquisition
  • Business Data and Governance
    • Data Governance
    • Data Management Functions
    • Data Governance vs. IT Governance
    • Data Management Roles
    • Business Analysis and Data Management
    • The Value of Data to the Organization
    • Data Management  and Risk
    • Data, Costs, and Revenue
    • Data Quality
  • Business Data Modeling Workshop
    • Put what has been learned into practice
  • Conceptual Data Models
    • System development challenges
    • Data requirements
    • Models and modeling
    • Data, information and knowledge
  • Data Normalization
    • Normalization and forms
    • The physical data model
    • Reverse engineering
    • The database designer
    • Denormalization
  • Data Relationships
    • Naming standards for relationships
    • Relationship cardinalities
    • Relationships affected by time
    • Modeling time-dependent data
    • The importance of definitions
    • Alternative notations
  • Logical Data Models
    • Entity types
    • Subtyping
    • Attributive entities and multivalued attributes
    • Nondependence
  • Verifying and Validating Data Models
    • Internal verification
    • Presenting data diagrams
    • Dos and don'ts of presenting data diagrams