Data Analytics
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.
Module overview
Concepts and statistical analysis
- Key concepts
- Statistical analysis
Data set preparation
- Importing, shaping
- Filtering
Data set summarisation
- Pivot table data aggregation
- Pivot table frequency analysis
- Filtering pivot tables
- Using pivot charts
Data visualisation
- Concepts and setup
- Visualisation
- Publishing and sharing
Main 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 visualisation 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 summarise data sets
- understand data visualisation techniques and tools, and how they are used to create reports and dashboards
Get in touch with us for any enquiry
- ICDL certification is internationally recognised by employers and institutions.
- ICDL modules are developed with input from computer users, subject matter experts, and practising professionals from all over the world.
- The regularly updated syllabus content reflects day-to-day tasks and responsibilities typical of job roles.
- ICDL modules focus on skills acquisition as well as an understanding of concepts.
- ICDL syllabus content is vendor-independent so that skills and knowledge are transferable.
- ICDL has rigorous Quality Assurance Standards (QAS) and regular quality audits are conducted internally and externally.
The detailed syllabus for the Data Analytics module is publicly available, so that there is complete clarity about what is covered.
The syllabus document, which sets out the specific skills and knowledge that you will learn and against which you will be certified, can be downloaded here.
Offer ICDL at your Institution or Organisation
If you are interested in offering ICDL to students, candidates, clients or employees or if you are considering partnering with ICDL for a project or initiative, click on the appropriate button below.