Analytics for decision-making | Business & Finance homework help

    

Question 1 

This scrutiny requires you to attend an organisation that you keep previously worked for, or any organisation that you are conversant delay. In the subjoined tasks, you close scarcity to apprehend about the role of a dashboard that could co-operate-after a while managers delay able postulates anatomy and despatch. Build such a dashboard on your own, and connect a screenshot of the dashboard. 

(a) Sift-canvass the fitness of using strategic, tactical or operational dashboards in this 

 

context. 

(10 marks) 

 

(b) The government believes that the dashboard can be advance improved by having further interactions to acceleration users to criticize postulates at irrelative granularity. Propose one (1) or further 

 

filters to elevate interactivity. 

(10 marks) 

 

(c) Recommend the desired charts that close acceleration repair the dashboard. Justify your recommendations. 

You may use or shift the Collective postulatesset (generic.xls) granted, or any publicly adapted postulates sources (e.g., https://www.gapminder.org/data/), to frame the dashboard delay the recommended shifts in Scrutiny 1(c). Provide screenshots of the new charts and the frameed dashboard in your announce, and garner the Tableau workbook into a only Tableau workbook perfect delay extracted postulates. 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 standing of the customer 

   

Race 

  

Race of the customer 

   

Visit_Time 

  

Date of Purchase 

  

You can shift the dates place consistently. 

   

Visit_Type 

  

Online or garner 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 

1. (a)  Based on the organisation chosen in Scrutiny 1, say the sidearm and anticipation of the
   organisation and catalogue one (1) of its strategic objectives.
    
2. (b)  Identify diverse measurable metrics (e.g., KPIs) that can acceleration to close the strategic
   objective sayd in Scrutiny 2(a) and sift-canvass your rationale.
    

Question 3 

The organisation that you keep chosen in Scrutiny 1 had composed customer feedback (written in free-format citations) balance the years and would approve to direct citation mining in adjust to apprehend their customers emend. Explain the benefits of the plan and sketch five (5) challenges that the organisation is approvely to countenance delay analysing citationual postulates. Suggest matching citation mining functions that can be applied to balancecome the challenges signed. 

(15 marks) 

 

(10 marks) (20 marks) 

  

SECTION B (Total 20 marks) 

Submit the Tableau Dashboard.
Save your Tableau workbook in .twbx format (expression perfect dimension to 20MB). 

(20 marks)