Business Intelligence and Reporting for Enterprises

1. Module number

CSI11800/CSI11100/CSI11200

2. Module title

Business Intelligence and Reporting for Enterprises

3. Module Leader (first point of contact for students)

Debbie Meharg ([email protected])

4. Module tutors & assessors

Debbie Meharg and Ben Guthrie

5. Assessment

Coursework 2 – Dashboard and Presentation

Learning Outcome 3 and 4 in the Module Descriptor are assessed in this assignment.

6. Weighting

50% of module assessment

7. Size and/or time limits for assessment

15 minute Presentation and Power BI materials

8. Deadline of submission

Your attention is drawn to the penalties for late submission

Trimester 2, Wednesday 27th April at 5pm

9. Arrangements for submission

You should submit online using the assignment drop-box on the Moodle site for the module. No paper submissions are required and submission by email will not be accepted.

You must also keep your own copy of the submission.

10. Assessment Regulations

All assessments are subject to the University Regulations.

11. The requirements for the assessment

Follow normal academic conventions for acknowledging sources. Assessment details are described in section 4.0 & 5.0 below.

12. Special instructions

None

13. Return of work

Feedback will be provided within three weeks of submission

14. Assessment criteria

Assessment criteria are described in section 6.0 below.

CSI11800 Business Intelligence and Reporting for Enterprises

COURSEWORK ASSIGNMENT 2– Dashboard creation and demonstration (First Diet)

1.0 Coursework Aim

To enable students to critically evaluate business intelligence tools and technologies for a suitable scenario and to construct, from a given dataset, a performance dashboard and business intelligence report. And to demonstrate their knowledge and understanding during a presentation.

2.0 Assessment

The following module learning outcomes are assessed in this coursework assignment:

LO3 Critically compare, analyse and evaluate business intelligence and reporting technologies.

LO4 Construct a performance dashboard and business intelligence report from a given data set using industry standard tools and techniques.

3.0 Coursework Assignment

This coursework assignment is an individual piece of work. Copying from any source and collusion between two or more students are serious offences and will be dealt with through Academic Conduct procedures. Reference all sources using the guide in Moodle. Details of the marking scheme are detailed in section 6.0 below, use this as a guide to the content you will include when preparing your report.

4.0 Submission requirements

Your coursework grade will be determined from the individual performance dashboard and business intelligence report you create and the PowerPoint presentation/ demonstration.

Marks are awarded for your PowerPoint presentation, Performance Dashboard, the BI suite of reports (individual BI charts/graphs/visualisations).

If you have any questions about what is required, please ask the Module Leader during class time or you may contact the Module Leader by email.

5.0 Case-study

Your assignment is to be based on the following adapted business scenario and builds from the information given in assignment 1 (this is available in Moodle for reference).

Background

HomesForAll have recently upgraded their IT system and now have improved data at their fingertips. They would like to understand the benefits that data mining could bring to the company. Like much of the data that other companies store in data warehouses, interest in this historically lies in trying to discover patterns within it. The updated systems retain records of construction sites, clients, costs, risks, contractors and employees.

Currently monthly programme and project reports are prepared manually, taking on average 4 working days to collate, draft review and coordinate. This means that the information presented at the monthly scheduled project meetings is at least 1 working week out of date. This has led to known critical issues not being reported at appropriate times and innovative business opportunities being missed.

Dashboard Objectives

Developing standardised programme and project level dashboard report templates which use live data will increase confidence of senior management team and enable project resources to be proactively directed to managing the projects. It is also hoped it will enable project managers to deploy their skills to adding client value, rather than reporting out of date information.

It is envisaged that the reports should not only display data but also develop sufficient depth of data that insights and analysis of trends will become possible. Enabling earlier risk identification and a focus on mitigation actions. In addition, quicker decisions will aid budgets being spent efficiently and ensure people are being used productively.

Dashboard Requirements

The company board would desire the report to have a separate page for the programme level (i.e. ALL projects), enabling a drill down into project levels information and are open to any additional pages which provide insight to Time / Cost and Quality.

The programme and project level reports should serve as a summary and do not need to contain all of the information from every table. Instead they might show just summary data. As a starting point, a detailed cost spreadsheet for the Dalkeith project has been supplied. The HomesForAll board expect the Dashboard to be aimed primarily at Board/SMT for strategic decision making. The Project Reports should be aimed more are PMs / Programme Managers for Project Management & Governance.

You will be supplied with a data set

Your task:

Produce a suitable performance dashboard and business intelligence reports using the dataset provided. This should provide insight for the HomesForAll board and allow them to shape their activities going forward to better serve their clients.

Produce a PowerPoint presentation which compares, analyses and evaluates suitable business intelligence and reporting tools for HomesForAll .

6.0 Marking grid and award of marks

The marking grid for awarding points for each of the assessment criteria is as follows:

BI tools and technologies (LO3)

None

0 points

Substantial work required

4 points

More work required

8 points

Satisfactory

12 points

Good

16 points

Very good

20 points

Excellent

24 points

Exemplary

28 points

Outstanding

30 points

Dashboard

(LO4)

None

0 points

Substantial work required

6 points

More work required

11 points

Satisfactory

15 points

Good

19 points

Very good

23 Points

Excellent

27 points

Exemplary

31 points

Outstanding

35 points

BI Suite of Reports (LO4)

None

0 points

Substantial work required

6 points

More work required

11 points

Satisfactory

15 points

Good

19 points

Very good

23 points

Excellent

27 points

Exemplary

31 points

Outstanding

35 points

5.1 Marking Scheme

The award of points in this grid is based on the following general guide:

None – this criterion has not been met.

Substantial work is required – An attempt has been made but there is a significant lack of detail and missing information. The dashboard and report are not fit for purpose and/or the evaluation of BI and reporting is weak.

More work is required – Greater details is required to demonstrate knowledge and understanding the specific topic. The content and layout of the dashboard and report require more work.

Satisfactory (Pass) – The items produced demonstrate satisfactory skill in the use of the tool and have resulted in an appropriate dashboard and report. Greater understanding of the dataset, the design and implementation could have resulted in a higher grade.

Good – There is good evidence of knowledge and understanding of the theory and the appropriate BI tools.

Very good – There is strong evidence of knowledge and understanding of the theory and the appropriate BI tools.

Excellent – Excellent outputs which demonstrates knowledge and understanding of relevant area. Excellent evaluation of suitable BI tools.

Exemplary – Exemplary knowledge and understanding of the theory and practice of the subject material which is backed up with a high quality Dashboard and Report. The presentation/demo show a high level of critical and creative thinking and practice. The student demonstrates a significant contribution to their own learning.

Outstanding – Outstanding knowledge and understanding of the theory and practice of the subject material which is backed up with a high quality Dashboard and Report. The presentation/demo show a high level of critical and creative thinking and practice. The student demonstrates a high level of initiative and analytical and innovative thinking.