Question 1
This question requires you to consider an organisation that you have previously worked for, or any organisation that you are familiar with. In the following tasks, you will need to think about the role of a dashboard that could assist managers with effective data analysis and communication. Build such a dashboard on your own, and attach a screenshot of the dashboard.
(a) Discuss the appropriateness of using strategic, tactical or operational dashboards in this
context.
(10 marks)
(b) The management believes that the dashboard can be further improved by having more interactions to help users to explore data at different granularity. Propose one (1) or more
filters to promote interactivity.
(10 marks)
(c) Recommend the desired charts that will help enhance the dashboard. Justify your recommendations.
You may use or change the Generic dataset (generic.xls) provided, or any publicly available data sources (e.g., https://www.gapminder.org/data/), to construct the dashboard with the recommended changes in Question 1(c). Provide screenshots of the new charts and the constructed dashboard in your report, and store the Tableau workbook into a single Tableau workbook file with extracted data. Name the workbook as “student_number.tbwx”.
Variable
Description
Remarks
CustomerIndex
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
Visit_Time
Date of Purchase
You can change the dates range accordingly.
Visit_Type
Online or store visit
Amount
Amount they spent
Product
Product bought:
Revenue
Revenue that was generated from the sales.
Revisit
Either new or returning customer
(15 marks)
Question 2
(a) Based on the organisation selected in Question 1, state the mission and vision of the
organisation and list one (1) of its strategic objectives.
(b) Identify several measurable metrics (e.g., KPIs) that can help to achieve the strategic
objective stated in Question 2(a) and discuss your rationale.
Question 3
The organisation that you have selected in Question 1 had collected customer feedback (written in free-format texts) over the years and would like to apply text mining in order to understand their customers better. Explain the benefits of the project and outline five (5) challenges that the organisation is likely to face with analysing textual data. Suggest matching text mining functions that can be applied to overcome the challenges identified.
(15 marks)
(10 marks) (20 marks)
SECTION B (Total 20 marks)
Submit the Tableau Dashboard.
Save your Tableau workbook in .twbx format (limit file size to 20MB).
(20 marks)