Find Out How We Help You To Learn New Skills Quickly
Think you are ready for the course? Take a FREE practice test to assess your knowledge!
On this 2-day accelerated BCS Level 4 Diploma designed for Apprentices, you’ll learn key skills needed to master Data Analysis Tools.
You’ll be immersed in the curriculum through our unique Lecture | Lab | Review technique, which allows you learn and retain information faster than traditional courses.
On this course you'll cover the range of concepts, approaches, tools and techniques that are applicable to Data Analysts. You will learn skills and knowledge applicable to Data Analysis Tools and the underlying principles and processes of data integration.
Key areas covered include learning to:
During the course you’ll sit BCS Level 4 Certificate in Data Analysis Tools Exam. Don’t pass the first time? Don’t worry – you’ll be covered by our Certification Guarantee .
Other accelerated training providers rely heavily on lecture and independent self-testing and study.
Effective technical instruction must be highly varied and interactive to keep attention levels high, promote camaraderie and teamwork between the students and instructor, and solidify knowledge through hands-on learning.
This information has been provided as a helpful tool for candidates considering training. Courses that include certification come with a Certification Guarantee. Pass first time or train again for free (just pay for accommodation, exams and incidental costs). We do not make any guarantees about personal successes or benefits of obtaining certification. Benefits of certification determined through studies do not guarantee any particular personal successes.
1. Processes and Tools Used for Data Integration
In this topic, the apprentice will describe how data integration is achieved through the manipulation of data from different sources. They will also learn about how this data is manipulated using programming languages and how it is prepared for analysis. You'll be able to :
1.1. Describe the purpose and outputs of data integration activities.
1.2. Explain how data from multiple sources can be integrated to provide a unified view of
1.3. Discover how programming languages for statistical computing can be applied to data
integration activities to filter and prepare data for analysis.
1.4. Explain the nature and challenges of data volumes and types being processed through
data integration activities.
1.5. Develop appropriate testing strategies to ensure that unified data sets are correct,
complete and up to date.
2. Industry Standard Tools and Methods for Data Analysis
In this topic, the apprentice will describe and use a range of tools, techniques and methods to prepare and analyse data. The successful apprentice should be able to:
2.1. Demonstrate the data manipulating, processing, cleaning and analysis capabilities of statistical programming languages and proprietary software tools capabilities and functions of statistical programming languages (such as, but not limited to; R, Python, SPSS, SAS, SQL, Microsoft Excel and VBA, Julia, Hadoop and Hive, Scala)
2.2. Demonstrate how to apply statistical programming languages in preparing data for analysis and conducting analysis projects.
The format for the exam is a one-hour, closed book multiple-choice exam consisting of 40 questions. The pass mark is 26/40 (65%).
If you're taking the exam in a language that is not your native/official language, you are entitled to 25% extra time and are allowed to use your own paper language dictionary to translate during the exam.
Exam and Firebrand developed course materials
Firebrand Training offers top-quality technical education and certification training in an all-inclusive course package specifically designed for the needs and ease of our students. We attend to every detail so our students can focus solely on their studies and certification goals.
Our instructors teach to accommodate every student's learning needs through individualised instruction, hands-on labs, lab partner and group exercises, independent study, self-testing, and question/answer drills.
Firebrand Training has dedicated, well-equipped educational facilities where you will attend instruction and labs and have access to comfortable study and lounging rooms. Our students consistently say our facilities are second-to-none.
We’re currently migrating from printed to digital courseware. Some courseware is already available in digital, while other books remain in printed form. To find out if this course is digital, call us on 080 80 800 888.
There are several benefits of easy-to-use digital courseware: downloads are immediate, and you’ll always have your courseware available wherever you are. You won’t need to wait for a printed book to be delivered before you start learning – and it’s better for the environment. You can choose to download the courseware to your own device, or borrow one of ours.
Considering a Microsoft course? Always have the most up-to-date Microsoft digital courseware with ‘Fresh Editions’. This gives you access to all versions of digital courseware – you’ll receive updates and revisions of your textbook, at no charge, for the life of that course.
Should a student complete a Firebrand Training Program without having successfully passed all vendor examinations, the student may re-attend that program for a period of one year. Students will only be responsible for accommodations and vendor exam fees.
There are currently no prerequiustes for this course
Don’t worry - we’ll discuss your technical background, experience and qualifications to determine whether this accelerated course suits you.
Just call us on 080 80 800 888 and speak to one of our enrolment consultants.
Firebrand is an immersive environment and requires commitment. Some prerequisites are simply guidelines; you may find your unique experience, attitude and determination enables you to succeed on your accelerated course.
Here's the Firebrand Training review section. Since 2001 we've trained exactly 67,286 students and asked them all to review our Accelerated Learning. Currently, 96.64% have said Firebrand exceeded their expectations:
"Excellent. Tailored instruction that suits the course of students to achieve the aim."
Oliver Hawes, Computacenter. - BCS CISMP (4 days) (5/3/2018 to 8/3/2018)
"I find that the training, although intense, is a really good way of learning. Sometimes you may feel that you haven't learned much I have found that on tests you almost subliminally know the answer and with staying onsite you have no distractions from the outside."
N.S., Emeiatec Ltd. - BCS CISMP (4 days) (5/3/2018 to 8/3/2018)
"Firebrand training is very fast paced, but you are able to gain a lot of information in a short space of time. the methods of teaching are very effective and it is evident that all the staff really care. "
Sarah Godlington, THS Inspection Services. - BCS Level 4 Certificate in Data Analysis Concepts (5 days) (22/1/2018 to 26/1/2018)
"Firebrand is a very good way of learning!"
Reece Hutchinson, Department for Education. - BCS Level 4 Certificate in Data Analysis Concepts (5 days) (22/1/2018 to 26/1/2018)
"This is my second course at Firebrand. The first time I came, I was taught at a very fast pace that was too much for me. But this time round with a difference tutor I feel like I have learnt a lot which has changed my perspective on Firebrand completely, in a positive way!"
Alexander Farquharson, Department for Education. - BCS Level 4 Certificate in Data Analysis Concepts (5 days) (22/1/2018 to 26/1/2018)
"Great instructor, content and facilities. I will definitely use Firebrand again."
Wincy Mok, AfaPeople UK. - BCS International Diploma in Business Analysis (6 days) (9/10/2017 to 14/10/2017)
"Intense but rewarding experience for those looking to learn in a fast passed and focused environment."
Ez Balci, New Signature. - BCS International Diploma in Business Analysis (6 days) (9/10/2017 to 14/10/2017)
"Third time at FB and have been pleased with the facilities and training assigned."
Steven Roberts, Leicestershire Police. - BCS CISMP (4 days) (4/9/2017 to 7/9/2017)
"A thoroughly rewarding experience that focus the mind on your course of choice without external distraction."
Anonymous - BCS CISMP (4 days) (26/6/2017 to 29/6/2017)
"Firebrand training gave me more understanding of the subject then was required to pass the exam so i felt confident taking my knowledge into the workplace"
Matthew Corbett. - BCS CISMP (4 days) (19/4/2017 to 22/4/2017)
"Well delivered, engaging training sessions. Easy location to get to. "
Michael Oshodi, N/A. - BCS International Diploma in Business Analysis (6 days) (18/12/2016 to 23/12/2016)
"Firebrand is an incredibly effective and motivational training center. Wyboston Lakes provides a perfect backdrop for study. Relaxing gardens, comfy rooms and a well equipped training center. As well as food and drinks on demand so you have nothing to worry about but getting your head down and studying. With 12 hour days this is exactly what is needed. Would highly recommend Firebrand."
Aaron Surtees, Union Square Software Ltd. - BCS Systems Development Essentials (2 days) (20/6/2016 to 21/6/2016)
"Firebrand Training offers great courses, and is very fast paced. Doing it this way means that I able was to learn a lot in a short amount of time. As an apprentice, the courses that I set were challenging but also very rewarding."
Hannah McEwan, WM360. - BCS Systems Development Essentials (2 days) (20/6/2016 to 21/6/2016)
"Very good course with lots of information to take in, but will help me in the future during my apprenticeship and onwards."
Benjamin Riley, Halton Borough Council. - BCS Systems Development Essentials (2 days) (20/6/2016 to 21/6/2016)
"Quick paced course with lots of information learned in little time"
S.R. - BCS Systems Development Essentials (2 days) (20/6/2016 to 21/6/2016)
"Good experience, relaxed environment."
Anonymous - BCS Systems Development Essentials (2 days) (20/6/2016 to 21/6/2016)
"Learned a lot!"
H.M, MyKnowledgeMap. - BCS Systems Development Essentials (2 days) (20/6/2016 to 21/6/2016)
"Great training and facilities."
Jack Armiger, AVEVA. - BCS Systems Development Essentials (2 days) (20/6/2016 to 21/6/2016)
"Very educational, very welcoming, and above all very helpful.
Firebrand not only just taught me about "Scrum" and "Agile", they taught me essentials about working within teams, such as: the Scrum Master will handle any discrepancies or impediments to aid the teams progress on a project.
Not to mention the knowledge is "free-reign" as it were, if anything is unknown to you, your tutor will easily and helpfully inform you on what you don't know.
I am VERY pleased with this course and I would definitely recommend it to anyone who's thinking of taking it as part of your companies training for you."
Harry Holdstock, Key Intelligence. - BCS Systems Development Essentials (2 days) (20/6/2016 to 21/6/2016)
"Useful course, very informative"
L.S, QFC. - BCS Systems Development Essentials (2 days) (20/6/2016 to 21/6/2016)
"Great location, friendly and very helpful staff. Super facilities, and you will not be disappointed if you book a course."
George Fallis, N/A. - BCS International Diploma in Business Analysis (6 days) (9/5/2016 to 14/5/2016)
"Supportive, accelerated learning in a comfortable environment."
Rochelle Mill, N/A. - BCS International Diploma in Business Analysis (6 days) (9/5/2016 to 14/5/2016)
"Excellent trainer, but course was intensive. Recommended if you are prepared to put this time in. Cannot recommend the trainer enough. "
John Doherty, Atos. - BCS CISMP (4 days) (11/1/2016 to 14/1/2016)
"Hard work but everybody in the class passed the certification exam. Therefore must have been a good course with a great trainer and even better delegates! "
C.H. - BCS CISMP (4 days) (11/1/2016 to 14/1/2016)
"Crash, Bang Wallop! I got my certificate. "
A.S. - BCS CISMP (4 days) (11/1/2016 to 14/1/2016)
"The Firebrand course helped fill my gaps in knowledge and as such has improved my confidence in my own ability."
Melanie Taylor, NCG. - BCS CISMP (4 days) (19/10/2015 to 22/10/2015)
"Great place but long hours."
Anonymous - BCS CISMP (4 days) (19/10/2015 to 22/10/2015)
"It's always amazing how quickly you can learn something with Firebrand"
Ian Jeffs, Mirka (UK) Ltd. - AXELOS PRINCE2® 2017 - Foundation & Practitioner (3 days) (9/4/2018 to 11/4/2018)
"Very intensive course, so be prepared to work hard. It's a great way of achieving results quickly!"
Sara Honey, Anient Ltd. - AXELOS PRINCE2® 2017 - Foundation & Practitioner (3 days) (9/4/2018 to 11/4/2018)
"I am here to resit my practitioner exam. The whole experience and level of detailed explanation has been excellent, which has given me a clearer understanding. "
Sarah Williams, Hartmann. - AXELOS PRINCE2® 2017 - Foundation & Practitioner (3 days) (9/4/2018 to 11/4/2018)
"I would highly recommend training for PRINCE2 with Firebrand. I have gone from having no knowledge of project management to feeling confident in my understanding. "
Anonymous - AXELOS PRINCE2® 2017 - Foundation & Practitioner (3 days) (9/4/2018 to 11/4/2018)
"Very informative and concise. Fast learning."
Anonymous - CIW Internet Business Associate (2 days) (9/4/2018 to 10/4/2018)
"The instructor was hilarious, yet very competent. He went through the course at a relaxed pace, didn't mind expanding on subjects that the class wanted more information and gave us working examples on the materials covered and how they relate in real life. Easily the best trainer I have experienced so far. "
L.H.. - CIW Internet Business Associate (2 days) (9/4/2018 to 10/4/2018)
"The course covered a lot of basic material but was made fun and enjoyable through our instructor."
Cameron Spence, Lloyds Banking Group.
"It is definitely intense and quite hard but its worth it. "
Mohammed Saeed, Joseph Chamberlain College birmingham. - Microsoft MTA Networking, Security & Windows Server Administration (6 days) (9/4/2018 to 14/4/2018)
"Clear and concise, with practical lab examples."
M.W., TfL. - Microsoft MTA: Windows Server Administration Fundamentals (2 days) (9/4/2018 to 10/4/2018)
"An excellent training experience delivered by expert trainers, providing high quality and intense teaching material.
Great environment and I would return to attend future courses. "
Aiden Lockwood , University of Sheffield. - The Open Group TOGAF® 9 certified training (Level 1&2) (3 days) (4/4/2018 to 6/4/2018)
"Excellent to have such condensed training period, it gives you exactly what you need."
Alistair White, Veractiy Projects Ltd. - The Open Group TOGAF® 9 certified training (Level 1&2) (3 days) (4/4/2018 to 6/4/2018)
"I've studied at Firebrand Training several times now and I've never failed an exam."
D.M., Systems IT. - Cisco CCDA (Design) (3 days) (4/4/2018 to 6/4/2018)
"My experience at the Firebrand Training Centre has been comfortable. The environment is peaceful which aids concentration and thinking. Food is good with a variety and range that also meets my dietary requirements. "
P.A., Firebrand. - Microsoft Programming in C# (4 days) (3/4/2018 to 6/4/2018)
"I think the instructor has done really well to deliver a course which is technically demanding. He has a good way of breaking complex theory down to simple terms. "
Anonymous - Microsoft Programming in C# (4 days) (3/4/2018 to 6/4/2018)
"The trainer was brilliant and engaging. He was concise and clearly knew what he was talking about."
George Taylor, FIL International Investments. - Scrum Firebrand's training for Scrum.org's Professional Scrum Master certification (2 days) (5/4/2018 to 6/4/2018)
"It's a lot to take in in such a short time. Be ready for hard work and long days."
Phil Gardiner. - AXELOS PRINCE2® 2017 - Foundation & Practitioner (3 days) (30/3/2018 to 1/4/2018)
"Firebrand is the leading training provider, nothing more to say.
Great learning, great training."
James Sim, N/A. - Data Protection Certified Data Protection Officer - CDPO (GDPR Compliance) (3 days) (30/3/2018 to 1/4/2018)
"Fantastic learning environment, which really helped with the learning journey."
Anonymous, East Coast Driver Training - Data Protection Certified Data Protection Officer - CDPO (GDPR Compliance) (3 days) (30/3/2018 to 1/4/2018)
"Although the training was intensive, our tutor went into detail with everything, which really helped."
Daniel Haastrup, Roundtrip Cars Limited. - Data Protection Certified Data Protection Officer - CDPO (GDPR Compliance) (3 days) (30/3/2018 to 1/4/2018)
"Great course, facilities and location - worth attending."
Anonymous - Data Protection Certified Data Protection Officer - CDPO (GDPR Compliance) (3 days) (30/3/2018 to 1/4/2018)
"While hard work, the course was engaging and very informative. The new skills learnt will be very useful in my role at work and have already given me an appetite to learn more.
The instructor made the subject matter both entertaining and interesting at the same time, breaking up the long days with plenty of demonstrations on the subjects being covered.
I'd recommend Firebrand to anyone who needs to learn a subject quickly and is willing to put in the work to attain their certification."
K.C.. - EC-Council Certified Ethical Hacker (CEH) (5 days) (30/3/2018 to 3/4/2018)
"The scope of course was very comprehensive with lots of useful real world material and concepts even for novice security students or students with limited knowledge and experience. Friendly and helpful colleagues and very knowledgeable tutor. Recommended."
Nicholas Mills. - EC-Council Certified Ethical Hacker (CEH) (5 days) (30/3/2018 to 3/4/2018)
"Reading books and course study notes will get you through the CEH exam. However, the experience that Firebrand and especially my tutor gave me lifted my skills to a new level. I will be back for more training. Thank you"
Barry Starling. - EC-Council Certified Ethical Hacker (CEH) (5 days) (30/3/2018 to 3/4/2018)