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...
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.
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.
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.
Please note: We use multiple venues per location. To confirm the venue for your event, please contact us.
ect.venues Maple House
Manchester: etc.venues Piccadilly - 11 Portland Street
11 Portland Street, Manchester, M1 3HU.
Situated across the 8th floor with fantastic views over the city and an abundance of natural light. Vibrant design, state of the art tech and on-site catering.
Only half a mile from Manchester Piccadilly Station with direct trains to London and Birmingham.
Please note: We use multiple venues per location. To confirm the venue for your event, please contact us.
Manchester: Novotel Manchester Centre
21 Dickinson St, Manchester, M1 4LX.
Relax in 4-star comfort just steps from Chinatown at Novotel Manchester Centre hotel in the city's convention quarter, just minutes from St Peter's Square and only half a mile from Manchester Piccadilly Station with direct trains to London and Birmingham.
Please note: We use multiple venues per location. To confirm the venue for your event, please contact us.
etc.venues Piccadilly
Holiday Inn City Centre
Novotel Manchester Centre
Virtual Classroom
Attend from a location of your choice.
Virtual Classroom courses provide an experience very close to in-person, without the need to travel to one of our training centres.
Live and trainer-led, delivered by the same experienced trainers who lead our in-person events.
The latest video conferencing software, allowing you to see and interact with your trainer and the other delegates.
Support for video break-out rooms and advanced collaboration, with virtual whiteboards, polls and quizzes, to allow you to engage in group work with your fellow delegates.
Physical training manuals delivered to your home/office.
Virtual Classroom courses run from 09:00 - 17:00, UK Time, and include regular breaks throughout the day. You can join from anywhere, with just a computer, webcam, microphone and Internet connection. Our friendly team are happy to help you get set up.
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.
etc.venues Fenchurch Street
etc.venues 120 Moorgate
etc.venues Tenter House
etc.venues Bonhill House
What's included
Your desk
ect.venues Maple House
etc.venues Piccadilly
Holiday Inn City Centre
Novotel Manchester Centre
Find Courses
Get a Quote
