Data Modelling for Business Analysts

Target Audience

The course is aimed at Business Analysts, Consultants or other Change Management professionals with little or no experience of Data Modelling.

Approach

The course is highly interactive and delegates are encouraged to learn through group exercises including a case study.

Close team work is essential and delegates are encouraged to make short informal presentations at the end of each exercise to build their confidence.

Instructors

Instructors are experienced Business Analysts rather than ‘training specialists’. They can therefore quote real-life examples as well as being able to confidently field delegates’ questions that might relate to projects or scenarios outside the scope of the course.

Course Objectives

By the end of the course the delegate will be able to:

• Understand the purpose and benefits of Data Modelling
• Decide when to use Data Models
• Draw Entity Relationship diagrams
• Define and document attributes
• Understand the link to process models and structured methods
• Understand how Data Models become physical databases
• Confidently present findings to their peer group and project team

Course Duration

The course runs for 2 days and can be extended to 3 days to allow clients to produce a Data Model for an existing or upcoming project.

Course Content

The course is highly practical with delegates developing a data model in stages throughout the course.

The course is broken down into the following sections.

What is a Data Model?

Why do we need Data Models?

Who should do Data Modelling?

Stakeholders in Data Modelling

Entities, Relationships and Attributes

Building a logical Data Model

Reviewing a Data Model

Naming Relationships

Data Modelling Rules

  •  Resolving many to many’s
  •  Resolving one to one’s

Alternative Data Modelling styles

Defining attributes

Complex Data Modelling

  • subtypes
  • recursive relationships

Normalisation (to 3rd normal form)

Physical translation

  •  Primary keys
  •  Foreign keys

Links with other modelling techniques

  • Process models
  • Class Models
  • Use Cases

Data Modelling through the project lifecycle

CASE tools

Available Courses

This is available as an on-site course only, no public courses are scheduled.



If you would like further information on our courses, or would like to discuss how we can build a course for your organisation using our training modules, please contact us.