0345 4506120

BCS Professional Certificate in Data Analysis

Course Details

Name BCS Professional Certificate in Data Analysis
Description
URL
Location:
London - West
Start Date:
Working Days:
Price:
£1079.00 +vat
Availability:
Exam:
Residential:
Course ID:
467608

Overview

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.

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.

Presented to you by one of the expert training consultants pictured below, each member of our Data Analysis training team bring their substantial data analysis and data modelling experience to the programme.

Who is this course for?
Business analysts, project managers and solution developers who require a practical approach to analysing and modelling data. Data Analysis is also an Analytical Skills module on the BCS Advanced Diploma in Business Analysis.
Included
You’ll be given a comprehensive Data Analysis course manual, containing additional information and guidance on further reading.

Learning Objectives

Course Content

To give you more of an idea of what you’ll learn and how the course will help you, here’s a quick guide to those two days.
Day 1
09:30 start to 17:00 finish
  • Data analysis for business analysts
  • Principles of data analysis concepts
  • Entity relationship diagrams
  • Types of relationships
  • Documenting entities, attributes, relationships and domains

Day 2

09:00 start to 17:00 finish

  • Analysis class modelling
  • Normalisation of data
  • Building a normalised data model
  • Validating the data requirements

Course Content

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 paths

London - De Vere West One

Description:

De Vere West One is conveniently set in London's West End, with quick links to the rest of the city. The venue itself is awash in natural light and provides an inspiring atmosphere.

Location:

9-10 Portland Place
London
W1B 1PR

 

Directions:

De Vere West One is just a five minutes' walk from Oxford Circus tube (Central, Victoria, and Bakerloo), Bond street (Jubilee) and a 10 minute walk from Great Portland Street tube (Circle, Hammersmith & City and Metropolitan) and Marylebone station.

A student manual, containing information about data modelling techniques and providing references for further reading, is supplied as part of the course.

Further Reading:
Data Analysis for Database Design, by David Howe (Butterworth Heinemann)

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 Analaysis. The course is also consistent with SFIA skills DTAN levels 2 and 3.

Exam format

  • 40 multiple choice questions
  • 1 hour and 30 mins duration (candidates are entitled to an additional 23 minutes if they are sitting an examination in a language that is not their native/official language)
  • closed book
  • supervised
  • pass mark 26/40 (65%)
  • calculators cannot be used during this examination
  • paper-based examination

What's next?

If this course is part of your BCS Advanced Diploma in Business Analysis programme you have a choice of further modules you can take including Business Architecture, Agile Business Analysis, Advanced Requirements Engineering, Stakeholder Engagement, Business Finance, Benefits Planning and Realisation and Team Leadership.

Our Customers Include