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.