Information Visualisation / Data Analytics / Data Science
1,500 words
Information Visualisation Project Using Power BI and Python
Assignment overview — ready to paste This Information Visualisation project requires students to design, implement and critically evaluate effective data visualisations using two different technological approaches: Microsoft Power BI and Python. The assessment focuses on the practical application of information-visualisation principles, including data preparation, visual design, interaction, audience requirements and the extraction of meaningful patterns and insights from complex datasets. Assignment 002 Coursework 2025-… Task 1 focuses on interactive visualisation using Power BI. Students work with the UK Department for Transport's Road Safety Open Data (STATS19), which contains information relating to road traffic accidents, casualties, vehicles, locations, times and contributing factors. Students may analyse one year or multiple years of data depending on their visualisation objectives. Assignment 002 Coursework 2025-… The Power BI work requires students to identify an appropriate target audience and report type, select relevant variables, clean and transform the data, develop an appropriate data model and create analytical measures using Data Analysis Expressions (DAX). The resulting dashboard should communicate the context of the data and reveal meaningful trends, patterns and insights. Assignment 002 Coursework 2025-… Task 2 requires students to develop visualisations programmatically using Python, with Jupyter Notebook recommended as the implementation environment. Students independently select a real-world, publicly available dataset containing at least 10,000 observations and more than five variables. Unlike Task 1, visualisation tools that automatically construct visualisations, such as Tableau or Power BI, cannot be used for this component because programming is an explicit requirement. Assignment 002 Coursework 2025-… Assignment 002 Coursework 2025-… The submitted Jupyter Notebook should operate as an educational technical report explaining the selected dataset, preprocessing procedures, visualisation choices and resulting insights. Students are expected to justify their visualisation techniques, critically evaluate findings and discuss challenges encountered during development. The textual content of the notebook is limited to 1,500 words, excluding code and visualisations. Assignment 002 Coursework 2025-… The complete assessment contains several deliverables, including a maximum 6-minute Power BI demonstration video, a maximum 2-page Power BI report, the .pbix file, an 8-minute Python/Jupyter visualisation demonstration, the Jupyter Notebook, dataset and README file. All materials must ultimately be packaged into a single ZIP submission. Assignment 002 Coursework 2025-… Assignment 002 Coursework 2025-… Important: the brief does not specify a named referencing style or academic level, so I would select Not specified for those two portal fields rather than guessing. It also explicitly states that generative AI must not be used to create any part of the assessed submission, including code, debugging, writing, paraphrasing or bibliographies. Assignment 002 Coursework 2025-…
Read Model Answer →
Data Warehousing and Big Data
Data Warehousing and Big Data – Inventory Management Data Warehouse
This individual coursework for CS7079 Data Warehousing and Big Data requires students to design, implement and test a data warehouse based on a business case scenario and then export and migrate data to a Big Data platform for further processing. The assessment focuses on the inventory management business process of ABC Consumer Electronics Outlet Ltd, a multi-channel consumer electronics retailer operating from six stores around London and conducting online business across the UK and Europe. The company manages more than 10,000 products across approximately ten categories and more than 200 brands. The company already uses cloud-based and business applications including Vend, Linnworks and Xerox, which generate large volumes of transactional data. However, these datasets are stored separately by the individual applications, making it difficult for managers to produce integrated reports and perform analysis to support business decision-making. A business analyst has therefore recommended the development of a data warehouse capable of meeting the company's reporting and analytical requirements. For this coursework, the solution is focused specifically on the inventory management business process. The inventory management case involves three main business activities: sending purchase orders to suppliers when stock reaches minimum levels, receiving purchase orders and storing stock in appropriate locations, and controlling and maintaining stock levels including adding new products and adjusting existing stock. The required analysis includes daily stock levels for the previous month, weekly identification of products at minimum stock levels, analysis of stock levels by brand, product type and supplier, daily and weekly sent and received stock orders, and analysis of received stock orders by supplier and month. Students must analyse and design a dimensional data model that represents these business activities. This includes defining the grain of three central fact tables, identifying appropriate dimensions, defining dimension attributes and fact measures, and producing simple star schemas showing the relationships between fact tables and dimensions. The design must be justified according to the available data sources and the reporting and analysis requirements. The implementation stage requires students to create the relational database using Microsoft SQL Server Management Studio. Students must create the database, dimension tables and fact tables, establish appropriate primary-key and foreign-key constraints, and demonstrate implementation and testing through SQL commands and their results. Test data must then be populated into the data warehouse. The Big Data component requires migration of test data from the data warehouse to an Apache Hadoop platform using the Hortonworks Data Platform. Students must export the data warehouse data to an external data file, migrate the file into Apache HDFS, create a suitable data structure for loading the data into Hive, and demonstrate Apache Pig for manipulating the loaded data. Implementation and testing of the Big Data storage environment must also be demonstrated through commands and results. The coursework concludes with a personal reflective section in which students discuss what they have learned throughout the overall coursework and the challenges encountered during the process. The final submission is expected to be a well-written, structured and well-presented report combining data warehouse design, database implementation, testing, Big Data migration and reflective learning.
Read Model Answer →