Data Analytics

Print Page

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

  • 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 visualization techniques and tools
  • Create and share reports and dashboards in a data visualization tool
  • Creates awareness of the key concepts of data analytics
  • Develops a practical understanding of how to use data analytics in business
  • Developed with input from subject matter experts and practicing professionals

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 organisations.



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
  • Visualization
  • Publishing and Sharing