BCS Level 4 Certificate in Data Analysis Tools

- Bara 2 dagar

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.

Läs mer...

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 .

Se Benefits...

Det tar bara ett ögonblick att se hur billig din kurs är...

Här är 8 skäl varför du ska genomföra din BCS Data Analysis Tools hos Firebrand Training:

  1. Du blir utbildad och certifierad på bara 2 dagar. Hos oss får du din utbildning och certifiering på rekordtid, en certifering du också genomför här på plats som en integrerad del av den intensiva, accelererade utbildningen.
  2. Allt är inkluderat. Ett engångsbelopp täcker alla kursmaterial, examen, boende och mat och erbjuder det mest kostnadseffektiva sättet att erhålla din BCS Data Analysis Tools kurs och certifiering på. Och detta utan några oannonserade ytterligare kostnader.
  3. Du klarar BCS Data Analysis Tools certifieringen första gången eller kan gå om kursen kostnadsfritt. Det är vår garanti. Vi är säkra på att du kommer klara din certifiering första gången. Men skulle du mot förmodan inte göra det kan du inom ett år komma tillbaks, delta i hela kursen igen, och bara betala för eventuella övernattningar och din examen. Allt annat är gratis.
  4. Du lär dig mer.Traditionella utbildningsdagar pågår kl. 09.00-16.00 med långa lunch- och fikapauser. Hos Firebrand Training får du minst 12 timmars effektiv och fokuserad kvalitetsutbildning varje dag tillsammans med din instruktör, utan vare sig privata eller arbetsrelaterade störande moment.
  5. Du lär dig BCS Data Analysis Tools snabbare. Vi kombinerar de tre inlärningsmetoderna (Presentation|Övning|Diskussion) så att vi därigenom genomför kursen på ett sätt som säkerställer att du lär dig snabbare och lättare.
  6. Du är i säkra händer.Vi har utbildat och certifierat 72.589 personer, vi är auktoriserad partner med alla de stora namnen i branschen och har dessutom vunnit åtskilliga utmärkelser med bland annat ”Årets Learning Partner 2010, 2011, 2012, 2013 och 2015” från Microsoft Danmark och Gazelle priset 2013 - 1. plats för region Själland i Danmark med en tillväxt om 1.430% sedan 2009.
  7. Du lär dig inte bara teorin. Vi har vidareutvecklat BCS Data Analysis Toolskursen med fler praktiska övningar som ger dig det extra du behöver för att kunna lösa praktiska problemställningar och klara din certifiering.
  8. Du lär dig från de bästa. Våra instruktörer är de bästa i branschen och erbjuder en helt unik blandning av kunskap, praktisk erfarenhet och passion för att lära ut.

Är du redo för kursen? Ta ett KOSTNADSFRITT test för att mäta och utvärdera din kunskap.

Det tar bara ett ögonblick att se hur billig din kurs är...

Senaste BCS Data Analysis Tools recensioner från våra studenter

Är du redo för kursen? Ta ett KOSTNADSFRITT test för att mäta och utvärdera din kunskap.

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

Se Exam Track...

Senaste BCS Data Analysis Tools recensioner från våra studenter

Är du redo för kursen? Ta ett KOSTNADSFRITT test för att mäta och utvärdera din kunskap.

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.

Se What's Included...

Senaste BCS Data Analysis Tools recensioner från våra studenter

Är du redo för kursen? Ta ett KOSTNADSFRITT test för att mäta och utvärdera din kunskap.

Exam and Firebrand developed course materials

Se Prerequisites...

Senaste BCS Data Analysis Tools recensioner från våra studenter

Är du redo för kursen? Ta ett KOSTNADSFRITT test för att mäta och utvärdera din kunskap.

There are currently no prerequiustes for this course

Är du redo för din Firebrand kurs?

Vi intervjuar alla potentiella deltagare om deras bakgrund, utbildning, certifiering och personliga inställning. Om du kommer igenom denna process så har du riktigt goda möjligheter att klara din certifiering.

Firebrand Training erbjuder en ambitiös utbildningsmiljö som förutsätter att du verkligen dedikerar dig till kursen. Ovanstående förkunskaper är endast vägledande, många deltagare med mindre erfarenhet men med en annan bakgrund eller kunskap har framgångsrikt genomfört sin utbildning hos Firebrand Training.

Om du funderar på huruvida du uppfyller rekommenderade förkunskaper vänligen ring oss på (0)8 52 50 01 66 och prata med en av våra utbildningsrådgivare som kan hjälpa dig.

Se När...

Senaste BCS Data Analysis Tools recensioner från våra studenter

Är du redo för kursen? Ta ett KOSTNADSFRITT test för att mäta och utvärdera din kunskap.

BCS BCS Data Analysis Tools Kursdatum

Startar

Slutar

Tillgänglighet

Plats

Registrera

26/8/2019 (Måndag)

27/8/2019 (Tisdag)

Avslutad

-

 

10/2/2020 (Måndag)

11/2/2020 (Tisdag)

Begränsat antal platser

Rikstäckande

 

23/3/2020 (Måndag)

24/3/2020 (Tisdag)

Platser tillgängliga

Rikstäckande

 

4/5/2020 (Måndag)

5/5/2020 (Tisdag)

Platser tillgängliga

Rikstäckande

 

15/6/2020 (Måndag)

16/6/2020 (Tisdag)

Platser tillgängliga

Rikstäckande

 

Senaste BCS Data Analysis Tools recensioner från våra studenter

Är du redo för kursen? Ta ett KOSTNADSFRITT test för att mäta och utvärdera din kunskap.

Vi har utbildat 72.589 kursdeltagare under 12 år. Vi har bett alla göra en utvärdering av vår accelererade utbildning. För närvarande har 96,76% sagt att Firebrand överträffat deras förväntningar:

"Facilities are great for learning and relaxing in-between.The tutor was supportive and available late into the evening. Any queries were answered with extra support and time given as needed. Course content was extensive and covered all aspects."
Deborah Holyoak. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (22/7/2019 till 25/7/2019)

"Firebrand Training courses are a fantastic way to gain the level of knowledge you require to progress professionally. All the staff are very knowledgeable and happy to help. They tailor your learning needs to you as an individual meaning you will really get the most out of your learning. "
Jay Cooper, Bourne Leisure. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (22/7/2019 till 25/7/2019)

"Great course, I gained a lot of understanding about data analysis in its own right, and how to relate it to your own company. "
joanne bowman, mitchells and butler. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (22/7/2019 till 25/7/2019)

"Excellent facilities at Wyboston. Staff were very welcoming and helpful throughout the course. "
M.L.. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (22/7/2019 till 25/7/2019)

"A well organised course. The logistics of the training were good - hotel next to the training center."
G.B., Lloyds Banking Group. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (24/6/2019 till 27/6/2019)

"Good food, nice accommodation and enjoyable course."
J.L.. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (22/7/2019 till 25/7/2019)

"Amazing atmosphere to learn, properly fed and taken care of."
Anonymous. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (22/7/2019 till 25/7/2019)

"Training was mint, accommodation and logistics were spot on, really happy with how everything went. Good job Firebrand!"
T.S., Barclays. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (24/6/2019 till 27/6/2019)

"Very good training course, providing a variety of good knowledge and skills appropriate to my job"
D.C.. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (24/6/2019 till 27/6/2019)

"Firebrand is a great way to accelerate your learning, providing useful tools and skills for you to take back to your workplace and apply them to your day to day duties."
C.S., Kuehne + Nagel. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (24/6/2019 till 27/6/2019)

"Good atmosphere, happy to come back and learn more ! "
Louis Othen, Zurich Insurance Group. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (24/6/2019 till 27/6/2019)

"Great instructor, who provided us with a lot of great insights into the world of data analysis."
J.W.. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (20/5/2019 till 23/5/2019)

"Firebrand surprised me with their teaching techniques. Highly recommended. "
Lenka Wolfova, Kuehne - Nagel. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (20/5/2019 till 23/5/2019)

"Helpful information provided in the course to get through the exam. Days were well structured and included not only talking but activities to take part in too."
Anonymous. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (20/5/2019 till 23/5/2019)

"I appreciated the efficiency of being able to learn everything I needed for the exam in a single week and to take the exam in the same week. The residential experience also helped to maintain the right frame of mind."
Anonymous. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (20/5/2019 till 23/5/2019)

"I have found this a very useful course, set in good accommodation within a friendly environment and would thoroughly recommend it to anyone."
Wayne Brooks, Devon County Council. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (21/1/2019 till 24/1/2019)

"I enjoyed my time here"
Dominic Santaniello, Experteye. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (26/11/2018 till 29/11/2018)

"Firebrand enables you to achieve results as fast as possible with excellent support from the tutors. "
Thomas Eyles, Barclaycard. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (26/11/2018 till 29/11/2018)

"This course ran through the core concepts of data analysis , there was a lot of concepts which hadn’t even crossed my mind & has opened up to more possibilities! "
L.W.. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (26/11/2018 till 29/11/2018)

"I had a great time, I learned a lot from a very skilled instructor."
Anoynmous. - BCS International Diploma in Business Analysis (6 dagar) (12/11/2018 till 17/11/2018)

"Before I came here I was very apprehensive about the course and thought that it might not be beneficial but when we started, I already had a clearer insight into my job role and clarity on certain aspects of it. Through this course it helped me understand processes and techniques that I thought I could not even use so it was an excellent experience. Also through the vast experience of our learning Mentor he showed us also how he used these techniques in his working life and that really showed us how to apply these newly learned techniques in our job role."
Kennedy Okeke, Dasiy Group. - BCS International Diploma in Business Analysis (6 dagar) (12/11/2018 till 17/11/2018)

"As an IT manager with a responsibility for security, I found this course both useful and entertaining. Thoroughly recommended."
Steve Morton. - BCS Certificate in Information Security Management Principles (CISMP) (4 dagar) (29/10/2018 till 1/11/2018)

"Very good and good accommodation provided."
Lee Laverty, Plus Dane Housing. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (24/9/2018 till 27/9/2018)

"Brilliant course, very helpful and knowledgeable trainer who has plenty of real world examples from his years of experience."
N.L., Lewisham Council. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (24/9/2018 till 27/9/2018)

"Firebrand have helped me to achieve various certifications throughout my time as an apprentice."
Naeem Dawood, Corporate Risk Associates. - BCS Certificate in Information Security Management Principles (CISMP) (4 dagar) (14/5/2018 till 17/5/2018)

"Great facilities and thoughtful staff. "
Anonym - BCS Certificate in Information Security Management Principles (CISMP) (4 dagar) (14/5/2018 till 17/5/2018)

"Excellent. Tailored instruction that suits the course of students to achieve the aim."
Oliver Hawes, Computacenter. - BCS Certificate in Information Security Management Principles (CISMP) (4 dagar) (5/3/2018 till 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 Certificate in Information Security Management Principles (CISMP) (4 dagar) (5/3/2018 till 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 (4 dagar) (22/1/2018 till 26/1/2018)

"Firebrand is a very good way of learning!"
Reece Hutchinson, Department for Education. - BCS Level 4 Certificate in Data Analysis Concepts (4 dagar) (22/1/2018 till 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 (4 dagar) (22/1/2018 till 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 dagar) (9/10/2017 till 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 dagar) (9/10/2017 till 14/10/2017)

"Third time at FB and have been pleased with the facilities and training assigned."
Steven Roberts, Leicestershire Police. - BCS Certificate in Information Security Management Principles (CISMP) (4 dagar) (4/9/2017 till 7/9/2017)

"A thoroughly rewarding experience that focus the mind on your course of choice without external distraction."
Anonym - BCS Certificate in Information Security Management Principles (CISMP) (4 dagar) (26/6/2017 till 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 Certificate in Information Security Management Principles (CISMP) (4 dagar) (19/4/2017 till 22/4/2017)

"Well delivered, engaging training sessions. Easy location to get to. "
Michael Oshodi, N/A. - BCS International Diploma in Business Analysis (6 dagar) (18/12/2016 till 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 dagar) (20/6/2016 till 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 dagar) (20/6/2016 till 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 dagar) (20/6/2016 till 21/6/2016)

"Quick paced course with lots of information learned in little time"
S.R. - BCS Systems Development Essentials (2 dagar) (20/6/2016 till 21/6/2016)

"Good experience, relaxed environment."
Anonym - BCS Systems Development Essentials (2 dagar) (20/6/2016 till 21/6/2016)

"Learned a lot!"
H.M, MyKnowledgeMap. - BCS Systems Development Essentials (2 dagar) (20/6/2016 till 21/6/2016)

"Great training and facilities."
Jack Armiger, AVEVA. - BCS Systems Development Essentials (2 dagar) (20/6/2016 till 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 dagar) (20/6/2016 till 21/6/2016)

"Useful course, very informative"
L.S, QFC. - BCS Systems Development Essentials (2 dagar) (20/6/2016 till 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 dagar) (9/5/2016 till 14/5/2016)

"Supportive, accelerated learning in a comfortable environment."
Rochelle Mill, N/A. - BCS International Diploma in Business Analysis (6 dagar) (9/5/2016 till 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 Certificate in Information Security Management Principles (CISMP) (4 dagar) (11/1/2016 till 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 Certificate in Information Security Management Principles (CISMP) (4 dagar) (11/1/2016 till 14/1/2016)

Senaste BCS Data Analysis Tools recensioner från våra studenter

Är du redo för kursen? Ta ett KOSTNADSFRITT test för att mäta och utvärdera din kunskap.