Data Analytics – Foundation

Module Description

The Data Analytics module covers the main concepts and skills needed to analyse statistics, prepare data sets, summarise data, and create data visualisations.

As technology is used more and more for everyday activities such as sales, production, logistics, and customer services, organisation are generating large sets of data which can be a valuable resource if evaluated correctly.

This module is suitable for entrepreneurs, managers, or workers who need practical skills in data analysis so that they can deliver business intelligence and insights.

TEST FORMAT

Contents & Skill Set

Concepts and statistical analysis

Key concepts Statistical analysis

Data set preparation

Importing, shaping Filtering

Data set summarization

Pivot table data aggregation Pivot table frequency analysis Filtering pivot tables Using pivot charts

Data visualization

Concepts and setup Visualization Publishing and sharing

Learning outcomes

Successful candidates will be able to prepare data for statistical analysis. After passing this module, candidates will feel confident using spreadsheets and other tools to present data sets in charts or tables, or using visualization techniques. They will be able to:

understand the main concepts of data analytics in business

apply statistical analysis concepts to data sets

know how to import data into a spreadsheet and prepare it for analysis with cleansing and filtering

use pivot tables and pivot charts to summarize data sets

understand data visualization techniques and tools, and how they are used to create reports and dashboards

RELATED EXAMS

GCL 02

OCCUPATIONAL SKILL DIPOMA TEST

Digital skills for employability and productivity.

GECL.ORG

Global Professional Standard in Computing