Skip to main content

Empty

£0.00

  • youtube
  • linkedin
Home » Courses » Classroom Courses » Data Analysis

Data Analysis

  • Classroom

    Course Details:

    Duration: 2 days

    Price: £1065+VAT


    Next available course:

    De Vere West One, London
    De Vere Holborn Bars, London
    De Vere West One, London
  • Online
About the Course
  • 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.

How is the course structured?

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
  • Data analysis for business analysts
  • Principles of data analysis concepts
  • Entity relationship diagrams
  • Types of relationships
  • Documenting entities, attributes, relationships and domains
Day
2
  • Analysis class modelling
  • Normalisation of data
  • Building a normalised data model
  • Validating the data requirements
Is there an exam?

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

Anything else?

You’ll also be given a comprehensive Data Analysis course manual, containing additional information and guidance on further reading.

Full Course Outline

Data Analysis (a two-day course)

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

©Assist Knowledge Development Ltd.

Contact Us

Need help?

Please call us on

01844 211665