empower your people,
empower your organization
Call:  08000 199337 From overseas call +44 20 7264 2185
face-to-face training
Training Since 2002
Online Learning
Certified Trainers with 20+ Year's Experience
Virtual classroom training
Above Industry Average Pass Rates
7-key IT disciplines
No Fee Course Resits

Enjoy live training & exams NOW from your own home Learn more Now offering Remotely Proctored ExamsLearn More

BCS Data Analysis Course

About the Course

Course Duration: 2 days
Exam Fees Included

Price From: £0


Private Course: Click Here
The BCS data analysis course consists of three key approaches to analysing and modelling data, and they’re all covered on our data analysis course.

You’ll also learn about approaches that reflect the business users’ needs and priorities, and gain an overview of the more mechanistic approach offered by normalisation. And finally we’ll explore the techniques used to validate data against stated requirements.

Who is it for?

The course is aimed at practising business analysts who wish to apply data analysis to their day to day work

Entry Requirements

No entry requirements for this course

Exam

During this two day course you’ll receive all the training you need to prepare for the BCS Professional Certificate in Data Analysis exam, which is held on the final afternoon of the course.

A pass in this module will contribute to the BCS International Advanced Diploma in Business Analysis. The course is also consistent with SFIA skills DTAN levels 2 and 3.

Course Objectives

Entity relationship modelling, analysis class modelling and normalisation of data. They’re the three key approaches to analysing and modelling data, and they’re all covered on our course on Data Analysis.

Syllabus – Key points

Data analysis for business analysts

  • The importance of data to the organisation
  • Data, information and business intelligence
  • Applying data analysis to understand the organisation
  • Using data analysis in business analysis

Principles of data analysis

  • Rationale for analysing and modelling data
  • Techniques used in data analysis
  • Entity relationship diagrams
  • Analysis class modelling
  • Normalisation of data

Entity Relationship Diagrams

  • Entities
  • Attributes
  • Relationships – cardinality and optionality
  • Keys
  • Entity and relationship descriptions
  • Attributes and domains

Analysis class modelling

  • Objects and classes
  • Structure of a class: name, attributes, operations
  • Associations and multiplicity
  • Naming associations
  • Generalisation

Normalisation of data

  • Third normal form analysis rules
  • Relations
  • Primary and candidate keys
  • Drawing third normal form models

Validating the data model

  • Cross-reference matrices, CRUD matrix
  • Data navigation path

Reviews

There are no reviews yet.

Be the first to review “BCS Data Analysis Course”

Your email address will not be published. Required fields are marked *

View dates and book

Select the BCS Data Analysis Course Classroom & Virtual Course

Now offering VIRTUAL courses. Enjoy live training NOW from your home Learn more
There are no dates scheduled for this course now. Please call Paula Jones to enquire about this course on 08000 199337, if you\'re calling overseas please call +44 207 264 2185. Alternatively, please email p.jones@tsg-training.co.uk and she’ll be in contact with you shortly.

This product is currently out of stock and unavailable.

To use Payl8r, please spend more than £50

Types of Exams

Pearson Vue Voucher Exams

Online Exam

Classroom Exam

OUR CUSTOMERS INCLUDE

OUR LOCATIONS

We operate from ten training centres across the country, giving you more choice for where to attend

SIGN UP ALL THE LATEST NEWS AND OFFERS