BCS Level 4 Certificate in Data Analysis Tools - Only 2 Days

Seven reasons why you should sit your BCS Data Analysis Tools course with Firebrand Training

Find Out How We Help You To Learn New Skills Quickly

  1. You'll be BCS Data Analysis Tools certified in just 2 days. With us, you’ll be BCS Data Analysis Tools trained in record time
  2. Our BCS Data Analysis Tools course is all-inclusive. A one-off fee covers all course materials, exams, accommodation and meals. No hidden extras
  3. Pass BCS Data Analysis Tools first time or train again for free. This is our guarantee. We’re confident you’ll pass your course first time. But if not, come back within a year and only pay for accommodation, exams and incidental costs
  4. You’ll learn more BCS Data Analysis Tools. A day with a traditional training provider generally runs from 9am – 5pm, with a nice long break for lunch. With Firebrand Training you’ll get at least 12 hours/day quality learning time, with your instructor
  5. You’ll learn BCS Data Analysis Tools faster. Chances are, you’ll have a different learning style to those around you. We combine visual, auditory and tactile styles to deliver the material in a way that ensures you will learn faster and more easily
  6. You’ll be studying BCS Data Analysis Tools with the best. We’ve been named in Training Industry’s “Top 20 IT Training Companies of the Year” every year since 2010. As well as winning many more awards, we’ve trained and certified 64,856 professionals, and we’re partners with all of the big names in the business
  7. You'll do more than study BCS Data Analysis Tools courseware. We use practical exercises to make sure you can apply your new knowledge to the work environment. Our instructors use demonstrations and real-world experience to keep the day interesting and engaging

Think you are ready for the course? Take a FREE practice test to assess your knowledge!

When do you want to sit your accelerated course?

Start

Finish

Status

Location

Book now

22/5/2017 (Monday)

23/5/2017 (Tuesday)

Finished

-

 

25/9/2017 (Monday)

26/9/2017 (Tuesday)

Wait list

Nationwide

 

6/11/2017 (Monday)

7/11/2017 (Tuesday)

Limited availability

Nationwide

 

18/12/2017 (Monday)

19/12/2017 (Tuesday)

Open

Nationwide

 

29/1/2018 (Monday)

30/1/2018 (Tuesday)

Open

Nationwide

 

12/3/2018 (Monday)

13/3/2018 (Tuesday)

Open

Nationwide

 

Here's the Firebrand Training review section. Since 2001 we've trained exactly 64,856 students and asked them all to review our Accelerated Learning. Currently, 96.54% have said Firebrand exceeded their expectations:



"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)

"Firebrand training was really good and I like the format. Learning was at a fast and hard pace but as this is all you are doing for a week it really sinks in. The instructor was very enthusiastic and kept us all involved."
Harry Courtney-Buddle, OCSL. - VMware® vSphere: Install, Configure, Manage [V6.5] (5 days) (11/9/2017 to 15/9/2017)

"The perfect way to get certified fast. Friendly environment and professional instructors. Hard but satisfying work. Thank you all firebrand team!"
Alexander de Vries, Infrastructure Specialist. - VMware® vSphere: Install, Configure, Manage [V6.5] (5 days) (11/9/2017 to 15/9/2017)

"I would not hesitate for a moment to recommend Firebrand Training, the whole environment is conducive to quick, accurate and enjoyable learning"
Darren McDonagh, avis. - The Open Group TOGAF® 9 certified training (Level 1&2) (3 days) (11/9/2017 to 13/9/2017)

"Intensive means just that. Long and exhausting training days but the quality of instruction makes the time fly by. Looking forward to part 2!"
C.P.. - Microsoft Specialist: Implementing Microsoft Azure Infrastructure Solutions (3 days) (9/9/2017 to 11/9/2017)

"This was the full packaged experience - lodging, food, training and test!"
Niranjan Kunwar, Invesco. - (ISC)2 Certified Cloud Security Professional (CCSP) (6 days) (4/9/2017 to 9/9/2017)

"Intensive, focused, professional with an eye for the students comfort and motivating nature. Top!"
Florian Vankuelen , Triveedis LG. - (ISC)2 Certified Cloud Security Professional (CCSP) (6 days) (4/9/2017 to 9/9/2017)

"Really great environment for committed learning!"
Jeff Fimari, Rod 58 LTd. - (ISC)2 Certified Cloud Security Professional (CCSP) (6 days) (4/9/2017 to 9/9/2017)

"Hassle free, well organised operation allowing total focus on the training at hand."
Andy Hunt, Capgemini. - (ISC)2 Certified Cloud Security Professional (CCSP) (6 days) (4/9/2017 to 9/9/2017)

"The instructor was very engaging and knew his stuff! "
Anonymous - Microsoft Specialist: Implementing Microsoft Azure Infrastructure Solutions (3 days) (9/9/2017 to 11/9/2017)

"Dave has taught me in 8 days more about routing & switching networks than 19 years of running mid sized (500 user, multi site) corporate Cisco networks. The trainers are a priceless asset to firebrand. I wont hesitate to come back and do my CCNP."
Mark Boardman. - Cisco CCNA (Routing & Switching) Certification (7 days) (4/9/2017 to 10/9/2017)

"Best training on market. Everything clear explained and friendly trainer with big passion and flexibility. "
A.C., Adler and Allan Ltd. - Cisco CCNA (Routing & Switching) Certification (7 days) (4/9/2017 to 10/9/2017)

"Fantastic instructor, teaching methods are second to none."
Anthony Cummings. - Cisco CCNA (Routing & Switching) Certification (7 days) (4/9/2017 to 10/9/2017)

"Course was interactive, and beneficial with extensive content. Food was plentiful, good facilities with friendly staff."
Roman Hill, Fiserv . - GIAC Global Industrial Cyber Security Professional (GICSP) (5 days) (4/9/2017 to 8/9/2017)

"Very impressed with the details of the course and thanks to the instructor for assisting us and guiding us through the course. "
Anjay Mandalia, WOODGROUP . - GIAC Global Industrial Cyber Security Professional (GICSP) (5 days) (4/9/2017 to 8/9/2017)

"A very informative and enjoyable experience."
I.M.. - GIAC Global Industrial Cyber Security Professional (GICSP) (5 days) (4/9/2017 to 8/9/2017)

"5 Day GICSP is lead by an absolutely brilliant instructor. His wealth of knowledge is evident and his passion for the subject unmatched. He brought to life the training with real world scenarios and practical tips. I would strongly recommend this to any practitioner/aspiring professional within the ICS space."
L.S.. - GIAC Global Industrial Cyber Security Professional (GICSP) (5 days) (4/9/2017 to 8/9/2017)

"A great course backed up by real world experience. The instructor has a great way of delivering the content and injecting fun into the course. I will certainly use the knowledge gained moving forward."
C.S.. - EC-Council Certified Ethical Hacker (CEH) (5 days) (4/9/2017 to 8/9/2017)

"It was a great experience to attend this training. Although it was a lot of information in only 5 days, I have learned about a lot of tools, methodologies, devices. IT Security is a long journey and this was a great start for me. "
Kamil Bosowski, Akamai. - EC-Council Certified Ethical Hacker (CEH) (5 days) (4/9/2017 to 8/9/2017)

"The course was well presented and provided great knowledge. "
Blair Ogilvie, Xenith. - ITIL® Foundation Certification (2 days) (31/8/2017 to 1/9/2017)

"Awesome teacher and great source of information."
Adrian Williams, Utilita. - ITIL® Foundation Certification (2 days) (31/8/2017 to 1/9/2017)

"One of the best trainers I have experienced in 30 years - Top class!"
Mike Fox, FFRC. - ISACA CISA Certification (4 days) (29/8/2017 to 1/9/2017)

"I was so happy when I contacted the Firebrand sales rep. He helped me demystify cyber and information assurance courses and was extremely helpful in advising on the booking process, available locations and dates for your course. Thank you"
Jacqui Stevenson, FSO Services. - ISACA CISA Certification (4 days) (29/8/2017 to 1/9/2017)

"I was given the time needed to focus without distractions from work and family."
Anonymous - CompTIA Security+ Certification (3 days) (30/8/2017 to 1/9/2017)

"My Trainer was very supportive and helpful. I really learned a lot from him. Thank you all."
Norah Alhussain, SABB. - CompTIA Security+ Certification (3 days) (30/8/2017 to 1/9/2017)

"Second time here at Firebrand and it lived up to the first time! Excellent facilities, instructors and just a fantastic place to learn and certify."
J.W.. - CompTIA Security+ Certification (3 days) (30/8/2017 to 1/9/2017)

"I'm glad to have had this training with Firebrand"
Abdulaziz Al-Enezi, ELM. - (ISC)2 CISSP Boot Camp (7 days) (21/8/2017 to 27/8/2017)

"The knowledge anyone will get from Firebrand is valuable and excellent for any Information Security Officer."
Mirah Ahmad, DEWA. - (ISC)2 CISSP Boot Camp (7 days) (21/8/2017 to 27/8/2017)

"I would recommend Firebrand to anyone who is looking for quality training!"
Ahmed Shahid, Dubai electricity and water authority. - (ISC)2 CISSP Boot Camp (7 days) (21/8/2017 to 27/8/2017)

"The best place to study and learn new things and expand your knowledge with the best practices."
Khaleed Al Memari, FDC. - (ISC)2 CISSP Boot Camp (7 days) (21/8/2017 to 27/8/2017)

"The quality of the training at Firebrand is perfect for preparing your for the exams!"
Rachel Hillier, Computer-eye2. - Microsoft MCSA: Windows 10 (6 days) (21/8/2017 to 26/8/2017)

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:

  • Describe the purpose and outputs of data integration activities
  • Explain how data from multiple sources can be integrated to provide unified data
  • Discover programming languages and how they are used to integrate data and prepare it for analysis
  • Explain the nature and challenges of data volumes and types being processed through integration activities
  • Develop testing strategies to test unified data for a range of states
  • Demonstrate an understanding of the capabilities of statistical programming languages and proprietary tools
  • Prepare data for analysis using a series of techniques
  • Carry out data analysis

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 .

Read more ...

Interested? See prices or call 080 80 800 888

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.

Firebrand Training provides instruction to meet every learning need:

  • Intensive group instruction
  • One-on-one instruction attention
  • Hands-on labs
  • Lab partner and group exercises
  • Question and answer drills
  • Independent study

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.

Read more ...

Interested? See prices or call 080 80 800 888

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.

  • Business need for analysis
  • Non-functional requirements (such as speed and time available)
  • Information structure and rules relevant to the business
  • Rationale for using and integrating data from multiple sources
  • Importance of data in a business context

1.2. Explain how data from multiple sources can be integrated to provide a unified view of

the data.

  • Reasons for using data from multiple sources
  • Importance of data source quality to improve the quality of results
  • Filtering data to ensure only relevant data is combined to underpin business
  • objectives
  • Ensure data is selected in line with current legislation
  • Data integration techniques
    • Common user interface
    • Virtual integration
    • Physical data integration (for example ETL (Extract - Transform - Load))

1.3. Discover how programming languages for statistical computing can be applied to data

integration activities to filter and prepare data for analysis.

  • Programming constructs
    • Sequence, selection and iteration
    • Modularisation, coupling and cohesion
  • Commands for manipulating data (for example, but not limited to)
    • Select and Select* statements
    • From
    • Where (such as but not limited to; AND, OR, use of Wildcards and ordering)
    • Joins (inner and outer, right, left, Full, Union and Select into)
    • Joins with duplicate values
    • Joining on multiple fields
  • Single queries
  • Multiple queries
  • Expressions
  • Functions (such as but not limited to; Avg(), Count(), Max(), Min(), Group by,
  • Round(), Cast(), Convert(), ISNULL ())
  • Querying multiple tables in different information
  • Selecting the first/last of occurrences
  • Implicit data conversion

1.4. Explain the nature and challenges of data volumes and types being processed through

data integration activities.

  • Big data sets
  • Qualitative data versus quantitative data
  • Technical requirements for managing large data set (such as, but not limited to; the
  • location of data and challenge of restrictions due to the computer architecture)
  • Data warehousing
  • Data migration
  • Master data management
  • Integration design
    • Business requirements for integration
    • Objectives and deliverable
    • Business rules
    • Support models and SLAs
  • Non-functional requirements
  • Data integration tools (such as future scalability, implementation and support costs)
  • Data synchronisation (such as data ownership, frequency of updates, format,
  • security, data quality, performance and maintenance)

1.5. Develop appropriate testing strategies to ensure that unified data sets are correct,

complete and up to date.

  • Check against business requirements
  • Test for a variety of states (such as, but not limited to; presence, completeness,
  • configuration and format, that data is valued and that data is not fragmented)
  • Business testing & technical testing
    • Technical acceptance testing (TAT)
    • User acceptance testing (UAT)
    • Performance stress tests (PST)

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.

  • Preparation techniques (such as, but not limited to; searching and sorting, grouping,
  • filtering, macros and modelling)
  • Data cleaning to remove a range of data issues (such as, but not limited to; errors,
  • invalid values, data that is out of range, outliers)
  • Processing and analysing:
    • Mean, Median, Mode and Range
    • Probability
    • Bias
    • Statistical significance
    • Linear Regression (simple & multiple)
    • Logistics Regression (simple & multiple)
    • Scatter plots and correlation
    • And/Or probability
    • Stem and leaf plots
    • Factorials
    • Box and whisker plots
  • Methods for presenting results (such as, but not limited to; tables, charts and
  • graphs, correctly arranged and presented using suitable language)
  • Presenting for data analysts
  • Working with people

Read more ...

Interested? See prices or call 080 80 800 888

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.

Read more ...

Interested? See prices or call 080 80 800 888

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 Accelerated Learning Programmes include:

  • Intensive Hands-on Training Utilising our (Lecture | Lab | Review)TM Delivery
  • Comprehensive Study Materials, Program Courseware and Self-Testing Software including MeasureUp *
  • Fully instructor-led program with 24 hour lab access
  • Examination vouchers **
  • On site testing ***
  • Accommodation, all meals, unlimited beverages, snacks and tea / coffee****
  • Transportation to/from designated local railway stations
  • Examination Passing Policy

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.

Firebrand goes digital

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.

Examination Passing Policy

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.

Please note

  • * Not on all courses
  • ** Examination vouchers are not included for the following courses: PMI, GIAC, CISA, CISM, CGEIT, CRISC, CISSP CBK Review and CSX Practitioner Level 1,2 and 3
  • *** On site testing is not included for our PMI, GIAC, CSX Practitioner or ITIL Managers and Revision Certification Courses.
  • **** Accommodation not included on the CISSP CBK Review Seminar

Read more ...

Interested? See prices or call 080 80 800 888

There are currently no prerequiustes for this course

Unsure whether you meet the prerequisites?

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.

Interested? See prices or call 080 80 800 888