Programme/Approved Electives for 2025/26
None
Available as a Free Standing Elective
No
The use of data analytic techniques is now pervasive in organisations. All business functions have been impacted in some way. Marketing teams use data to identify and target key customer groups, Supply chain managers use data to identify efficiencies, finance teams use data to identify financial risks. In this module you will look at the data available to organisations, the issues it can be used to address and the techniques that can be used. You will use industry standard software tools to undertake your own analysis of data and develop your skills as a data communicator.
Aims
This module aims to introduce students to the techniques of analytics that can be deployed to understand common organisational issues. The module will introduce students to the sources of organisational data and the ways it can be stored, managed and summarised prior to use. The ethical, security and privacy issues linked to data will be addressed. Common analytic techniques using supervised and un-supervised learning methods will be introduced in theory. The module will then introduce students to the practical aspects of analytics focussing on the extraction of useful messages from data sets and the communication of these to organisational users.
Intended Learning Outcomes
Critically evaluate the use of analytics tools to inform business decision making: 1,2Select, apply and evaluate common analytics techniques and implement them using appropriate software tools: 1,2Communicate complex data to a range of users and to critically evaluate visual data communications: 2
12 x1 hour theory lectures12 x1 hour practical workshops.126 hours guided independent learning. Of this 30 hours will be used for the assignment task and a further 60 hours for the portfolio of analytics tasks. The remaining time will be used undertaking on-line self teaching based on materials available from Tableau and LinkedIn Learning. Students will be given guidance on the materials to use.
Description of Module Assessment
1: Group Assessment weighted 50%Analytics task portfolio and group presentationIn this assessment, you will work in groups of 4 to analyse a dataset from one of the provided sectors: Superstore, Restaurant, Retail Fashion, Electronics, Pharmacy, and Hotel
All the above data sets are uploaded on KLE.
Each group will receive or select a dataset and perform the same set of analytics tasks using Microsoft Excel and Power BI. The goal is to explore data, visualize patterns, identify trends, and provide actionable recommendations.
Group presentation 10-15 minutes duration.
Tasks to Complete:
1. Data Cleaning and Preparation (Excel)
2. Descriptive Statistics (Excel)
3. Trend Analysis (Excel)
4. Regional/Store/City Analysis (Excel / Power BI)
5. Category/Product/Service Analysis (Power BI)
6. Customer Satisfaction Analysis (Power BI)
7. Dashboard Creation (Power BI)
8. Insights and Recommendations (Portfolio + Presentation)
2: Assignment weighted 50%Practical analytics project - 1000 word equivalentBased on topics covered in Weeks 1–10, you are required to produce a 1000-word report on the hypothetical company, CresysX, an online retail company seeking opportunities for business improvement through both survey and sales data analysis.
CresysX is an online retail company. Students must analyse the customer survey (n = 347) with SPSS (Part A) and compute & visualise website sales (Excel → Power BI) (Part B). Deliver a single Word report containing interpreted results, only relevant SPSS tables, screenshots of the Power BI dashboard and a URL to the published dashboard. Make sure to insert Power BI analysis files link in the report (.pbix).