Analytics for Decision-Making

    
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)