Module Code

CSI-7-DAT

Module Title

Data Management

Lecturer

% of Module Mark

60%

Distributed

Nov 2025

Submission Method

Submit online via this Module’s Moodle site

Submission Deadline

18:00 on 10 Dec 2025

Release of Feedback & Marks

Feedback and provisional marks will be available in the Gradebook on Moodle within 15 working days of submission.

Type:

Report on Prototype Database Development task

Word Count:

No formal word count is required but no more than 3000 words would be expected.

Footnotes will not count towards word count totals but must only be used for referencing, not for the provision of additional text. The bibliography will not count towards the word total.

Presentation:

Any quoted material must be referenced, and a bibliography provided, however, formal referencing is not an assessed criterion – however the identification of technical resources consulted in order to solve specific described problems is an assessed criterion (see main task specification)

Work must be submitted as a Word document (.doc/docx)

Course work must be submitted using Arial font size 11 (or larger if you need to), with a minimum of 1 line spacing

Your student number must appear at the front of the coursework. Your name must not be on your coursework.

Referencing:

Harvard Referencing should be used, see your Library Subject Guide for guides and tips on referencing.

Regulations:

Make sure you understand the University Regulations on expected academic practice and academic misconduct. Note in particular: Your work must be your own. Markers will be attentive to both the plausibility of the sources provided as well as the consistency and approach to writing of the work. Simply, if you do the research, practical and reading, and then write it up on your own, giving the reference to sources, you will approach the work in the appropriate way and will cause not give markers reason to question the authenticity of the work.

All quotations must be credited and properly referenced. Paraphrasing is still regarded as plagiarism if you fail to acknowledge the source for the ideas being expressed.

TURNITIN: When you upload your work to the Moodle site it will be checked by anti-plagiarism software.

Moderated (internal)

Moderated (CSI lead)

Signed off by (HoD/DHoD)

Changes required to CW?

No *

Examples of good practice

List of changes required

N/A

ML Response

[ML response, date]

Moderator Response

[ML response, date]

TASK

Mark

Weight

TOTAL

1

Subject Knowledge - Design

Use Dimensional Modelling Technique to design a prototype data warehouse schema. Use the data on invoices for Spend over £25,000 in the Department for Business, Innovation and Skills (https://data.gov.uk/dataset/financial-transactions-spend-data-bis) for data from the year April 2015 to Mar 2016 inclusive).This involves downloading 4 data sets (1 file per month). Negative values in the AMOUNT column represent refunds and as such are valid and must be kept.

All Suppliers records recorded as “Personal Expense, Name Withheld” replace the supplier with your LSBU student number.

 10

 1

 10

2

Subject Knowledge - Design

Use T-SQL to perform ETL combine/merge the 4 files and cleansing the invoice data to populate the data warehouse, in doing so you should demonstrate the use of transformations via T-SQL queries/procedures where appropriate. Download from the VLE an XML file: suppliers_invalid.xml this contains a list of invalid suppliers whose records must be removed from the invoice data using T-SQL only.

You must provide relevant transformations/T-SQL screenshots for ETL & creation of star schema tables & test data.

10

1.5

15

3

Critical Analysis – Transforming design to implementation.

Discuss and critically evaluate any data understanding issues that you

encountered. Explain and critically evaluate how specific examples of transformations were resolved.

10

0.5

5

4

Testing and Problem-Solving Skills

Set-up and test all the following queries using T-SQL stored procedures. Provide screenshots of all code including any examples appropriate for each task and the task output):

a

Show the top three Suppliers and the total amount spent on these for the whole 4 month period and separately for each month. Ensure that any refunds are appropriately deducted in your calculations.

10

0.5

5

b

Show Expense Types that have an individual 2 month total spend amount greater than the average 2 month Expense Type spend of all Expense

Types. Export the output as a JSON file.

10

0.5

5

c

Show a monthly top 10 ranking for spend on Expense Areas. For each Expense area indicate the number of places it has moved (up/down the rankings) since the previous month. The ranking must be in ascending order.

10

0.5

5

d

Create a fourth complex query utilizing a time related hierarchy of your own design that demonstrates some supplier analysis using the full complexity of your understanding in terms of analytic query writing. Export the output as a

CSV file.

10

0.5

5

5

Practical Competence

Produce a dashboard combining the 4 query tasks above (in a single view) as visualized elements, that can be used to tell an effective story about the business in your scenario. Use Power BI/Tableau

10

1

10

6

Personal and Professional Development

Use MS Teams to record a video demo (10 mins max) of the tasks: 2, 4 and

5. During the video you demonstrate your live execution of Task 4 in your implementation environment(s) and Task 5 in PowerBI/Tableau.

Include the URL to the Video Demo clearly on the front cover of your final report. Ensure your lab tutor can access the video.

Any video not accessible at the time of marking will score zero (no exceptions). It’s your responsibility to ensure your video link is live and

working before you submit.

10

4

40

100%