Author: Justin

Submission Guidelines

Please follow the submission instructions stated below:

A - What Must Be Submitted

You are required to submit the following TWO (2) items for marking and grading:

•	A Report (you should submit this item first as it carries the highest weightage). 

•	The Tableau Dashboard 

Please verify your submissions after you have submitted the above TWO (2) items.

Tableau Dashboard Evaluation Criteria

Format and Style of Dashboard | | /6 |
•   Layout, clarity of text elements, colour blends, graphical enhancements | | |
Clarity and Coherence | | /8 |
• | Proper flow - title page, introduction, body, results, recommendations / | | |
| discussion points, conclusion/summary; quick to understand, free from | | |
| grammatical errors | | |
Creativity | | /6 |

•	Ability to use creative elements to value-add to the dashboard so as to enhance understanding and clarity of difficult concepts 

TOTAL | | /20

SECTION A (Total 80 marks)

Question 1

(a)	Based on the organisation of your choice, state the mission and vision of the organisation and list one (1) of its strategic objective. Make sure you name the selected organisation. 

(5 marks)

(b)	Based on the selected organisation in (a), outline three (3) charts to be placed in a tactical dashboard. Explain how the three charts will help the organisation to monitor whether it has achieved its strategic objective. 
(15 marks)

(c)	Recommend a dashboard filter that will be useful to the organisation to drill down to some particular aspects of the business that will enable the management to have a better understanding of the status of the strategic objective. 
(5 marks)

Using the Generic dataset (generic.xls) provided, construct the dashboard with the proposed charts and filter in (b) and (c). Provide screenshots of the dashboard in your report, and store the Tableau workbook into a single Tableau workbook file with extracted data named “student_number.tbwx”. (Marks for the construction of the dashboard and filter will be awarded in Section B of this paper.)

Variable | Description | Remarks
CustID | ID of the customer |
Age | Age of the customer |
Gender | Gender of the customer: |
| F – Female, M - Male |
Marital Status | Marital status of the customer |
Race | Race of the customer |
Date | Date of Purchase | You can change the dates range
| | accordingly.
Amount | Amount they spent |
Product | Product bought: | You can replace P1-P5 with the
| P1, P2, P3, P4, P5 | products of the organisation that
| | you have selected. For example,
| | if the chosen organisation sells
| | automobile then P1 could be
| | Toyota, P2 could be Honda etc.
Revenue | Revenue that was generated |
| from the sales. |

(d)	Discuss the principles that was used to build the dashboard in (c). 
(5 marks)

Question 2

(a)	The organisation that you selected is keen to embark on a data mining project to build a predictive model with the data that they have collected over the past few years to help achieve its strategic objective stated in 1(a). Describe the data mining project based on the CRISP-DM framework. Do not exceed 350 words. 
(25 marks)

(b)	List the pre-requisites and limitations of data mining so that the management have a better understanding of data mining. 
(5 marks)

Question 3

(a)	The organisation that you selected had collected free format customer feedbacks over the years and will like to do a text mining project to understand their customers better. Explain in less than 200 words the text mining process. 
(10 marks)

(b)	Discuss briefly one Big Data application that will benefit the selected organisation (not exceeding 150 words). Your description should cover the followings: 
(i)	Big Data objective 
(ii)	Big Data application 
(iii)	how the Big Data application will help the organisation achieve the strategic objective in 1(a) 
(10 marks)

SECTION B (Total 20 marks)

Submit the Tableau Dashboard. See page 4 for the evaluation criteria.
(20 marks)