This course is intended to enable business analysts to define data requirements with detailed understanding of what is required and a rigorous approach.
The course will provide business analysts with knowledge and understanding of data analysis activities and techniques designed to elicit and analyse data requirements and inherent business rules and how to define the structure of the data to meet business needs.
Key areas of the course include:
- Building and understanding two types of data models - Entity Relationship Diagrams and Class Models
- Normalisation of data and why this is a useful approach
- Validation of data requirements
- Examination on the afternoon of day 2
Please do note that the course timetable is designed to include coverage of new content up to around mid-afternoon on day 2. Delegates should be prepared to spend around 1 -2 hours in the evening on homework and revision activities. This may include activities set by the instructor as appropriate.
This certification is relevant for anyone wishing to gain an understanding of data analysis and techniques that maybe be applied when analysing business data. It is likely to be of benefit to business analysts, systems analysts and technical architects and solution architects. Project managers working on data-oriented projects may also find it a useful certification.
Note that if you are intending to work towards the BCS Advanced Diploma in Business Analysis then you must already have the International Diploma in Business Analysis.
Prerequisites for Data Analysis
- It is recommended that delegates should have completed, or have knowledge to the level of, the BCS International Business Analysis Diploma or the BCS Solutions Development Diploma, before attempting this course
- This 2-day specialist course leads to the BCS Professional Certificate in Data Analysis.
- An understanding of projects would be useful but is not essential.
Prerequisites for including this course as part of the Advanced Diploma in Business Analysis:
This course is one of the 4 BCS professional certificates offered by QA which can be combined and lead to the Advanced Diploma in Business Analysis.
If you are planning to work towards obtaining the Advanced Diploma then you must already hold the BCS International Diploma in Business Analysis and provide further evidential criteria, see below for details.
How do you obtain the Advanced Diploma?
Anyone who holds the BCS International Diploma in Business Analysis can begin working towards the BCS Advanced Diploma. There are three elements to be achieved in order to be awarded the Advanced Diploma:
- Gain certifications in four subject areas across three skill domains
- Provide evidence of a minimum of five years' experience in business analysis
- Provide evidence of engaging with the BA community.
If you are taking a BCS exam you must bring photographic identification with you (passport, driving license or student card), as it is a BCS requirement to produce it for the invigilator prior to the exam. Failure to produce a valid form of photographic identification will result in a candidate not being able to sit the exam. For any questions about what form of identification is acceptable please contact your Account Manager or the QA Examination Administration team on 44 (0)1793 696273.
BCS allow additional time for candidates who have a disability or whose native language differs to that of the examination paper. Full details are provided in the BCS Reasonable Adjustments Policy which is available to view on the BCS website. If you believe you qualify for this then please notify the Exam Administration team on the details below as early as possible. At least two weeks' notice will be required for processing this request. Delegates failing to advise QA and provide evidence when requested, may not be allowed the additional support offered via the BCS policy. QA Exam Administration can be contacted by email firstname.lastname@example.org or by phone 44(0) 1793 696162.
Data analysis for business analysts
- The context of data and importance to the organisation
- Application of data analysis
- Data analysis and business analysis
Principles of data analysis
- The rationale for modelling data
- Techniques for data analysis : Entity relationship modelling, Class diagrams, Data normalisation
- Grouping data through entities and classes
- Values of data (attributes)
- Relationships/associations between data items
- Business rules governing data relationships (multiplicity etc.)
Normalisation of data
- Rules for reaching third normal form
- Drawing models using third normal form
- Identifying keys
Validating the data model
- Cross referencing
- Data navigation paths
- Define data analysis as a tool for a business analyst
- Explain the purpose of data analysis and modelling
- Identify the components of different data modelling techniques
- Interpret a data model
- State business rules within data analysis artefacts
- Define the process and rules used to derive third normal form
- Evaluate data sets against normalisation rules
Frequently asked questionsSee all of our FAQs
How can I create an account on myQA.com?
There are a number of ways to create an account. If you are a self-funder, simply select the "Create account" option on the login page.
If you have been booked onto a course by your company, you will receive a confirmation email. From this email, select "Sign into myQA" and you will be taken to the "Create account" page. Complete all of the details and select "Create account".
If you have the booking number you can also go here and select the "I have a booking number" option. Enter the booking reference and your surname. If the details match, you will be taken to the "Create account" page from where you can enter your details and confirm your account.
Find more answers to frequently asked questions in our FAQs: Bookings & Cancellations page.
How do QA’s virtual classroom courses work?
Our virtual classroom courses allow you to access award-winning classroom training, without leaving your home or office. Our learning professionals are specially trained on how to interact with remote attendees and our remote labs ensure all participants can take part in hands-on exercises wherever they are.
We use the WebEx video conferencing platform by Cisco. Before you book, check that you meet the WebEx system requirements and run a test meeting (more details in the link below) to ensure the software is compatible with your firewall settings. If it doesn’t work, try adjusting your settings or contact your IT department about permitting the website.
Learn more about our Virtual Classrooms.
How do QA’s online courses work?
QA online courses, also commonly known as distance learning courses or elearning courses, take the form of interactive software designed for individual learning, but you will also have access to full support from our subject-matter experts for the duration of your course. When you book a QA online learning course you will receive immediate access to it through our e-learning platform and you can start to learn straight away, from any compatible device. Access to the online learning platform is valid for one year from the booking date.
All courses are built around case studies and presented in an engaging format, which includes storytelling elements, video, audio and humour. Every case study is supported by sample documents and a collection of Knowledge Nuggets that provide more in-depth detail on the wider processes.
Learn more about QA’s online courses.
When will I receive my joining instructions?
Joining instructions for QA courses are sent two weeks prior to the course start date, or immediately if the booking is confirmed within this timeframe. For course bookings made via QA but delivered by a third-party supplier, joining instructions are sent to attendees prior to the training course, but timescales vary depending on each supplier’s terms. Read more FAQs.
When will I receive my certificate?
Certificates of Achievement are issued at the end the course, either as a hard copy or via email. Read more here.