Data Analytics

This module sets out essential knowledge and skills relating to data analytics concepts, statistical analysis, data set preparation, data set summarisation and data visualization.


Syllabus

The Syllabus sets out the specific knowledge and skills that make up this module, as informed by input from subject matter experts from a wide range of computer societies, and practising professionals.

 


On completion of this module the candidate will be able to:

  • Understand the key concepts relating to the application of data analytics in business.
  • Understand and apply key statistical analysis concepts.
  • Import data into a spreadsheet and prepare it for analysis using data cleansing and filtering techniques.
  • Summarise data sets using pivot tables and pivot charts.
  • Understand and apply data visualisation techniques and tools.
  • Create and share reports and dashboards in a data visualisation tool.

What are the benefits of this module?

  • Presents the key underlying concepts around data analysis.
  • Develops a practical understanding of how to use data analytics in business.
  • Covers practical skills relating to data set preparation and data set summarisation, and data visualisation.

Who is it for?

Technology is increasingly embedded in every modern job role, generating large amounts of data even in small organisations. This data can be exploited to monitor, improve and innovate but only if organisations apply sound data analytics techniques. Using data analytics in business, applying key statistical analysis concepts effectively in order to create, and share meaningful reports are requirements for everyone whose role gives them access to data. These skills and knowledge are essential not only to carry out specific tasks but also as a foundation for developing further competences in the effective use of technology in the workplace.

Syllabus Overview

CATEGORY SKILLSET
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 visualization
  • Concepts and setup
  • Visualisation
  • Publishing and sharing