BCS - Level 4 Certificate in Data Analysis Tools

Kesto

Kesto:

Vain 4 päivän

Menetelmä

Menetelmä:

luokkahuone / Online / Hybridi

Seuraava päivä

Seuraava päivä:

27/6/2022 (Maanantai)

Overview

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 .

8 syytä, miksi kannattaa hankkia BCS Data Analysis Tools Firebrand Trainingiltä:

  1. Koulutuksen ja todistuksen saaminen kestää vain 4 päivän. Meidän kanssamme saat BCS Data Analysis Tools -koulutuksen ja -todistuksen ennätysajassa. Todistuksen ansaitset koulutuskeskuksessamme osana intensiivistä ja nopeutettua koulutusta.
  2. Hintaan sisältyy kaikki.Kertamaksu kattaa kaikki kurssimateriaalit, kokeet, kuljetuksen, majoituksen ja ateriat ja tarjoaa kustannustehokkaimman tavan hankkia BCS Data Analysis Tools koulutus ja todistus. Ilman mitään lisäkustannuksia.
  3. Suorita tutkinto ensimmäisellä kerralla tai kertaa koulutus ilmaiseksi. Tämä on takuumme. Olemme varmoja, että läpäiset BCS Data Analysis Tools -kurssin ensimmäisellä kerralla. Mutta jos näin ei käy, voit tulla takaisin vuoden kuluttua ja maksaa vain majoituksesta ja kokeista. Kaikki muu on ilmaista.
  4. Opit enemmän.Päivä perinteisen koulutuksen tarjoajan kanssa on yleensä klo 9–17, mihin sisältyy pitkä lounastauko. Firebrand Trainingiltä saat vähintään 12 tuntia päivässä keskittynyttä ja häiriötöntä laatukoulutusaikaa opettajasi kanssa.
  5. Opit BCS Data Analysis Tools nopeammin. Yhdistämme 3 eri oppimistyyliä (visuaalisen|kuuloon perustuvan|kosketukseen perustuvan) tarjotaksemme materiaalin tavalla joka varmistaa, että opit nopeammin ja helpommin.
  6. Opiskelet huippujen kanssa.Olemme kouluttaneet ja sertifioineet 122.183 ammattilaista ja olemme kumppaneita kaikkien alan suurien nimien kanssa ja olemme saaneet lukuisia palkintoja, mm. Microsoftin Danmarki Vuoden koulutuspartneri 2010, 2011, 2012 ja 2013, Institue of IT Trainingin ”Training Company of the Year 2006, 2007, 2008” Englannissa, ISC(2):n ”Highest Performing Affiliate of the Year 2009 & 2010 – EMEA” sekä EC-Councilin ”Accredited Training Centre of the Year 2010 og 2011”, ”Newcomer of the Year 2011” ja ”Instructors Circle of Excellence”.
  7. Opit enemmän kuin pelkän teorian. Olemme kehittäneet BCS Data Analysis Tools kurssia edelleen käyttämällä laboratorioita, esimerkkitapauksia ja harjoittelukokeita varmistaaksemme, että osaat soveltaa uutta tietoa työympäristöön.
  8. Opit parhailta. Ohjaajamme BCS Data Analysis Tools kurssilla ovat alan parhaita. He tarjoavat ainutlaatuisen yhdistelmän asiantuntemusta, kokemusta ja intohimoa opetukseen.

Benefits

Curriculum

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

Exam Track

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.

What's Included

Exam and Firebrand developed course materials

Prerequisites

There are currently no prerequiustes for this course

Arvioinnit

Olemme kouluttaneet kymmenen vuoden aikana yli 122.183 opiskelijaa. Heitä kaikkia on pyydetty arvioimaan pikakurssimme. Tällä hetkellä 96,63% on sitä mieltä, että Firebrand on ylittänyt heidän odotuksensa:

"BCSIDBA is an intensive, but rewarding course and is highly executed very well through the use of Firebrand."
Iman Hussain, Pareto Law. (24/5/2021 (Maanantai) - 29/5/2021 (Lauantai))

"The instructor was excellent at teaching, very knowledgeable and patient with a newbie like myself! I really enjoyed the course and would recommend it!"
S.M., The WOS Group. (19/10/2020 (Maanantai) - 24/10/2020 (Lauantai))

"I had planned on attending the CISMP at the Firebrand training facility but due to the current restrictions the course was changed to online. I was apprehensive on how this would pan out and pleased to say I was pleasantly surprised. The course was very well structured and the instructor very knowledgeable and engaging. The only downside is that I have to wait to sit the exam but feel confident that I will be successful. Well done Firebrand in such challenging times!"
N.W.. (30/3/2020 (Maanantai) - 2/4/2020 (Torstai))

"I found the CISMP course excellent as it gave me all of the relevant information and understanding condensed in a week. The trainer was a subject matter expert and excellent keeping the subject matter interesting and enjoyable. I would be happy to recommend this training."
Philip Gilmore, Northern Ireland Civil Service. (6/1/2020 (Maanantai) - 9/1/2020 (Torstai))

"Great facilities, food was very nice. The content provided was informative and will be majorly beneficial."
J.C,. (25/11/2019 (Maanantai) - 28/11/2019 (Torstai))

Kurssipäivämäärät

Alkaa

Loppuu

Saatavuus

Sijainti

Rekisteröidy

21/2/2022 (Maanantai)

24/2/2022 (Torstai)

Päättynyt - Jätä palautetta

-

 

27/6/2022 (Maanantai)

30/6/2022 (Torstai)

Odotuslista

Maanlaajuinen

 

8/8/2022 (Maanantai)

11/8/2022 (Torstai)

Rajoitettu määrä paikkoja

Maanlaajuinen

 

19/9/2022 (Maanantai)

22/9/2022 (Torstai)

Paikkoja saatavilla

Maanlaajuinen

 

31/10/2022 (Maanantai)

3/11/2022 (Torstai)

Paikkoja saatavilla

Maanlaajuinen

 

12/12/2022 (Maanantai)

15/12/2022 (Torstai)

Paikkoja saatavilla

Maanlaajuinen

 

Uusimmat arvostelut opiskelijoiltamme