Questions? Feedback? powered by Olark live chat software

Business Analyse

Business Data Modelling

This business data modelling 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 organisational 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 modelling 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)™.

What topics will be covered in the course?

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
Conceptual Data Models
  • System development challenges
  • Data requirements
  • Models and modeling
  • Data, information and knowledge
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
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
Data Normalization
  • Normalization and forms
  • The physical data model
  • Reverse engineering
  • The database designer
  • Denormalization
Verifying and Validating Data Models
  • Internal verification
  • Presenting data diagrams
  • Dos and don'ts of presenting data diagrams
Business Data Modeling Workshop
  • Put what has been learned into practice

What will I 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

What is included in the price?

All Digital Course Materials

Individual training consultation before and after the course

Does this course help me towards certification/accreditation?

At the end of the course you will get the chance to verify your level of knowledge in a test. You will receive a certificate upon successful participation. This course is also eligible if you aim to achieve an Associate’s or Master’s Certificate from George Washington University. Learn more.

Available as customised in-house training

Let us bring our classes to you! Our in-house training are ideal for groups of 10 or more people. We can provide Off-the-shelf training in the form of our classic courses, or we can provide bespoke training, tailored to your organisational goals and objectives.

Share this course