Synopsis
The Business Data Modelling 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 modelling approaches focus on the important requirements of the business that are discovered through significant user involvement during the analysis phase. Delegates 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 delegates 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 organisation
- 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 normalised 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 organisational and geographical data distribution
Supporting the organisational 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 Organisation
Data Management and Risk
Data, Costs, and Revenue
Data Quality
-
Business Data Modelling Workshop
Put what has been learned into practice
-
Conceptual Data Models
System development challenges
Data requirements
Models and modelling
Data, information and knowledge
-
Data Normalisation
Normalisation and forms
The physical data model
Reverse engineering
The database designer
Denormalisation
-
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
Sub-typing
Attributive entities and multi-valued attributes
Non-dependence
-
Verifying and Validating Data Models
Internal verification
Presenting data diagrams
Dos and don'ts of presenting data diagrams