Hello, we are TCC.

We are passionate about business change. We help people improve the way they deliver projects and programmes.

TRAINING

Data Modelling for Business Analysts

Duration
3 Day
Weekdays
Delivery Method
Classroom / Online
Max. 12 Delegates
Exam
No
N/A
Price
On Request
From

Course 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. Read more...
Training Venues | View Images
Course Materials | Look Inside
  • London: etc.venues Fenchurch St

    8 Fenchurch Place, London, EC3M 4PB.

    This location is within a 10 minute walk of London Liverpool Street Station providing fantastic links to London's transport network.

    With free WiFi, lunches, teas, coffees and refreshments this location provides a comfortable environment for delegates to enjoy their course.

    More about this Venue

    > Directions

    > Website

    Please note: We use multiple venues per location. To confirm the venue for your event, please contact us.
  • London: etc.venues 120 Moorgate

    120 Moorgate, Moorgate, EC2M 6UR.

    Fantastic location in the City of London's Square Mile right next to Moorgate Tube Station. Vibrant, buzzy cafe and networking area with signature etc.venues coffee stations.

    More about this Venue

    > Directions

    > Website

    Please note: We use multiple venues per location. To confirm the venue for your event, please contact us.
  • London: etc.venues Tenter House

    45 Moorfields, Moorgate, London, EC2Y 9AE.

    Fantastic location right next to Moorgate Tube Station. Striking design, loads of daylight and great views across the City. Vibrant, buzzy cafe and networking area with signature etc.venues coffee stations.

    New 'City Mezze' food offering provides a powerful explosion of energising brain fuel packed with taste and quality.

    More about this Venue

    > Directions

    > Website

    Please note: We use multiple venues per location. To confirm the venue for your event, please contact us.
  • London: etc.venues Bonhill House

    1-3 Bonhill Street, London, EC2A 4BX.

    A converted warehouse with its own contemporary art collection - providing a stimulating environment. Great location close to Silicon Roundabout and Tech City, and a short walk from the City of London.

    More about this Venue

    > Directions

    > Website

    Please note: We use multiple venues per location. To confirm the venue for your event, please contact us.
  • etc.venues Fenchurch Street
  • etc.venues 120 Moorgate
  • etc.venues Tenter House
  • etc.venues Bonhill House
  • What's included
  • Your desk

Need Advice?

Have a chat with one of our friendly advisors about this course.


Book Your Course
Data Modelling for Business Analysts

Find Courses
LOCATION:
Date Title Days Location Price
Currently, no scheduled courses match your criteria (we may still be able to help)
Get a Quote

Get a quote for us to come to you

It's easy to arrange an in-house course for your organisation. Simply tell us what you are looking for and we'll send you a personalised quote.
What are the benefits of inhouse training?

Data Modelling


Explore The Course
Data Modelling for Business Analysts

Course 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.

Business rules are a fundamental aspect of the requirements which Business Analysts need to capture and understand. Many business rules are intrinsically bound up with the structure of data, and a clear understanding of the business data enables the building of more flexible and maintainable systems.

When analysing business requirements, therefore, an understanding of the implications of the way in which data is structured is essential to an appreciation of the freedoms and constraints of current infrastructure, whilst investigating fully the business rules. Data modelling is therefore an essential skill for the Business Analyst.

What's Included?

When it comes to choosing a training provider, we recognise that it is important to know exactly what you are getting for your money.

TCC is proud to maintain some of the highest standards in the training industry.

Everything from our trainers, to the course materials and venues we use, is carefully considered to ensure that we deliver you a great course.

Take a look at what is included:

In the classroom

  • Expert Business Analysis trainer
  • Copies of all presentation slides (exclusive to TCC)
  • Practical classroom group exercises
  • A realistic case study
  • BCS exam
  • BCS Business Analysis book
  • Maximum class size of 12

At our training venues

  • A modern and comfortable training room
  • Buffet or restaurant lunch and light breakfast selection*
  • Hot & cold refreshments throughout the day

* Light breakfast selection available on city centre courses in Birmingham and at some London venues (please enquire for further information).

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

FAQs

Will I need to do any homework during the course?
No evening work should be required.
Are there any pre-requisites for completing this course?
There are no pre-requisites for the course.
Is there an examination included with this course?
There is no exam associated with this course.

Customer Reviews
Data Modelling for Business Analysts

Customer satisfaction is our number one priority and we will always aim to deliver outstanding service and quality.

Hear what people are saying about our courses - 99% say they would recommend us
View: Highlight List

Making the difference. Trusted by leading organisations worldwide, since 1981.

▲ TOP