Basic Data

(a) Based on the organisation of your choice in the finance industry, state the mission and vision of the organisation and list one of its strategic objectives.  (5 marks)
(b) Based on the organisation chosen in 1(a), suggest an operation that you think will benefit from an operational dashboard. Explain how the operational dashboard will benefit this operation.  (5 marks)
(c) Propose three (3) charts to be placed in the operational dashboard based on the operation you suggested in 1(b). Elaborate on the reasons for your proposal.  (15 marks)
(d) Recommend a dashboard filter for the proposed charts in 1(c) and discuss how the filter can enable the organisation to drill down to particular aspects of the operations that it is interested in for each proposed chart in 1(c).  (15 marks)
Using the Generic dataset (generic.xls) provided, construct the dashboard with the proposed charts and filter in (c) and (d). The Generic dataset provides the basic data; you can rename and modify the variables and data to suit the needs of your dashboard. The Generic dataset contains the following:

Provide screenshots of the dashboard in your report, and store the Tableau-packaged workbook into a single Tableau workbook file with extracted data named “student_number.tbwx”. Put BOTH items (i.e., the Tableau-packaged workbook and dataset used to construct the dashboard) into a folder, zip it and submit the zipped folder to ECA_PPT. (Marks for the construction of the dashboard and filter will be awarded in Section B of this paper.)