Data Analytics

Learning Outcomes

Subject Specific Practical Skills

Having successfully completed this module you will be able to:

• Use SQL to create, update and query a database
• Be able to use tools to produce graphs and visualisations of data
• Be able to use tools to compute appropriate statistics from data
• Gain facility in using computational tools to inspect, process, filter and refine data for different types

Knowledge and Understanding

Having successfully completed this module, you will be able to demonstrate knowledge and understanding of:

• Know how to choose appropriate statistical measures or graphical diagrams to answer simple questions about data
• Demonstrate knowledge of appropriate techniques for pre-processing, filtering, and refining data for analysis
• Understanding of different types of data and knowledge of different ways of representing that data

Subject Specific Intellectual and Research Skills

Having successfully completed this module you will be able to:

• Understand the broader context of EDA (Exploratory Data Analysis) as a part in solving questions involving data
• Choose the most appropriate approach to analyse a dataset for a given problem

Types of data and their representations, including:

• Structured vs unstructured
• Text vs binary
• Graphs
• Streams
• Tables
• Images, sequences & volumes
• Encodings (e.g. JSON, XML)

Slicing data:

• Regular expressions
• Filtering
• Data pipelines
• Tools (e.g., grep, sed &awk, python scripts, pandas)

Extracting information:

• Descriptive statistics
• Introductory data visualisation
• Tools (e.g. numpy, scipy, matplotlib/seaborn)

Relational data:

• The relational model

+ Relations, domains, attributes, keys, dependencies

+ Normalisation

• Practical SQL

+ querying

+ simple joins

The wider context:

• Understand the role of EDA as an initial step in understanding data related to a problem

The module consists of:

• Lectures
• Guided self-study
• Labs as part of the AICE Lab Programme which will cover practical aspects

Summative

This is how we’ll formally assess what you have learned in this module.

Referral

This is how we’ll assess you if you don’t meet the criteria to pass this module.

Repeat

An internal repeat is where you take all of your modules again, including any you passed. An external repeat is where you only re-take the modules you failed.