Data Modelling, Entity Relationship & Logical Models

Overview

This practical workshop will teach the delegate industry-standard, recognised techniques for data analysis. The course is highly interactive and gives extensive practice in defining the data groups (classes, entities) and relationships / associations. The delegate will explore business rules, test out the viability of system options and construct logical models of the data to reflect business needs.

Duration

This is a 3 day course.

Prerequisites and evening study

There are no pre-requisites for the course and no evening work should be required.

Course Objectives

This course will enable delegates to:

Understand the need for data modelling
Model data from different perspectives
Understand how business rules can be identified
Use data modelling to complete the requirements

Who Should Attend

Those who are likely to become involved in database definition, business analysis and systems analysis, design and development at any level, including:

Business Analysts and Systems Analysts
Database Administrators
Data Management Specialists
Systems Designers
Developers
Team Leaders
Quality Assurance and Quality Control Specialists

Course Content

Introduction to Data Modelling

Concepts and objectives of data modelling in business analysis
Approaches to data analysis
Class Models and Entity Relationship Diagram

Identifying Data Groups

Notations and conventions
How to identify data groups
Sub types and super types

Identifying Attributes

Data attributes
Identifiers

Drawing the Data Model

Steps for model creation
Validating the model against requirements

Identifying Relationships

How to identify data relationships
Degrees of relationship
Resolving relationships
Exclusivity, recursion
Validating the data model

Relational Data Analysis

Notation and convention
Relations and domains
Types of data identifiers
Process navigation
Normalising data
Rationalising results

Validating the Data Model

Validation of models
Volumetrics

Practical Work

Interactive tutor-led sessions examine the problem domain and identify steps to analyse data both "top down" and "bottom up". Explore both worked examples and data sources from real life to give extensive, workshop-based experience of analysing data in a real world situation.

Do you want:

a training course run on your premises (reducing accommodation and travel fees)?
a course written or tailored specifically for your staff?
a standard course run just for your staff?

Do you have:

four or more people to train?
a definite time at which the training needs to be provided?

Then you're probably looking for "in-house" training.

We can run any of our standard courses just for you. If you require something special, or a combination of several courses, we can discuss this with you and tailor an event designed to meet your needs. These courses can be run at a time convenient to you, either on your premises or at a separate venue. The location can be specified by you or we can recommend a suitable venue if you prefer.

Need more help?

We can advise on combinations of training courses which typically prove the most effective. We can, if you wish, perform a full training needs analysis of your staff, to help you to identify training needs, and the programmes of training to put into place to meet both your current and future needs.

What to do next...

Decide what you want from this training - what are your objectives?
Decide which course(s) you need, or whether something tailored is required;
Decide approximately when you would like the training to be run;
Ascertain when your people can be available and how many people in total you need to train.

Then please contact us to discuss your needs.

Dates, Prices & Booking

View Basket

Please contact us for availability.

DATA MODELLING FOR BUSINESS ANALYSTS