Data Visualization for Business With Tableau

ANL201End-of-CourseAssessmentJan2020Semester.pdf

Home >Computer Science homework help >Data Visualization for Business With Tableau

ANL201

End-of-Course Assessment – January Semester 2020 Data Visualisation for Business __________________________________________________________________________________________ INSTRUCTIONS TO STUDENTS: 1. This End-of-Course Assessment paper comprises SIX (6) pages (including the cover page). 2. You are to include the following particulars in your submission: Course Code, Title of the

ECA, SUSS PI No., Your Name, and Submission Date. 3. Late submission will be subjected to the marks deduction scheme. Please refer to the

Student Handbook for details.

IMPORTANT NOTE

ECA Submission Deadline: 12 March 2020, 12 noon

ECA 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 workbook (.twbx file) Please verify your submissions after you have submitted the above TWO (2) items. B - Submission Deadline • The TWO (2) items of Report and Tableau workbook are to be submitted by 12 noon on the

submission deadline. • You are allowed multiple submissions till the cut-off date for each of the TWO (2) items. • Late submission of any of the TWO (2) items will be subjected to mark-deduction scheme

by the University. Please refer to Section 5.2 Para 2.4 of the Student Handbook. C - How the (2) Items Should Be Submitted • The Report: submit online to Canvas via TurnItIn (for plagiarism detection) • The Tableau workbook:

o Save as .twbx file o Submit online to Canvas

• Avoid using a public WiFi connection for submitting large video files. If you are using

public wireless (WiFi) connection (e.g. SG Wireless at public areas), you might encounter a break in the connection when sending large files.

D - Additional guidelines on file formatting are given as follows:

1. Report • Please ensure that your Microsoft Word document is generated by Microsoft Word 2007 or higher.

• The report must be saved in .docx format.

2. Tableau workbook

The workbook must be saved in .twbx format.

E – Please be Aware of the Following: Submission in hardcopy or any other means not given in the above guidelines will not be accepted. You do not need to submit any other forms or cover sheets (e.g. form ET3) with your ECA. You are reminded that electronic transmission is not immediate. The network traffic may be particularly heavy on the date of submission deadline and connections to the system cannot be guaranteed. Hence, you are advised to submit your work early. Canvas will allow you to submit your work late but your work will be subjected to the mark-deduction scheme. You should therefore not jeopardise your course result by submitting your ECA at the last minute. It is your responsibility to check and ensure that your files are successfully submitted to Canvas. F - Plagiarism and Collusion Plagiarism and collusion are forms of cheating and are not acceptable in any form in a student’s work, including this ECA. Plagiarism and collusion are taking work done by others or work done together with others respectively and passing it off as your own. You can avoid plagiarism by giving appropriate references when you use other people’s ideas, words or pictures (including diagrams). Refer to the APA Manual if you need reminding about quoting and referencing. You can avoid collusion by ensuring that your submission is based on your own individual effort. The electronic submission of your ECA will be screened by plagiarism detection software. For more information about plagiarism and collusion, you should refer to the Student Handbook (Section 5.2.1.3). You are reminded that SUSS takes a tough stance against plagiarism or collusion. Serious cases will normally result in the student being referred to SUSS’s Student Disciplinary Group. For other cases, significant mark penalties or expulsion from the course will be imposed.

Tableau Workbook Evaluation Criteria

Effective Communication of Information /6

• Layout, text elements, colour blends, graphical enhancements are effectively used

to communicate information.

Clarity and Coherence /5

• Proper flow - title page, introduction, body, results, recommendations / discussion points, conclusion/summary; quick to understand, free from grammatical errors

Integrity /5

• Information presented is not distorted or misleading.

Creativity /4

• Ability to use creative elements to stimulate viewer’s engagement and enhance understanding and clarity of difficult concepts.

TOTAL

/20

SECTION A (Total 80 marks) Question 1 Imagine you work in the public service and have been tasked to create materials to raise awareness of various topics relating to Singapore. The target audience in this case can either be businesses that are looking to invest in Singapore, or professionals who may be planning to work in Singapore. You are to use Singapore’s Public Data (https://data.gov.sg/) for the creation of the educational materials. Your materials should cover at least two of the following topics: Economy, Education, Environment, Finance, Health, Infrastructure, Society, Technology and Transport. (a) State the topics you will be covering for the materials. Using the Balanced Scorecard

Perspective, suggest one (1) Strategic Objective for each of the four perspectives. Explain how the objectives are related to the perspectives.

(8 marks) (b) For each of the Strategic Objectives listed in part (a), suggest one Business Performance

Measure, as well as a chart that can be used for visualisation of the measure. Assess the effectiveness of your charts.

(8 marks)

(c) The charts in part (b) are to be used in a dashboard. Is your dashboard a strategic, tactical or operational dashboard? Provide reasons for your choice.

(4 marks)

(d) For each chart that you have described in part (b), you are to use at least two (2) of the following items:

(i) Trend line (ii) Reference Line (iii) Parameter (iv) Forecast

Each of the aforementioned items must be used at least once. Provide screenshots of the charts in your report.

(16 marks)

(e) Using the charts created in part (d), develop a dashboard that will highlight your Business Performance Measures described in part (b). You may create more charts if needed to make your dashboard provide a more holistic view of insights from the data.

Discuss how your dashboard has followed the Dashboard Design Principles. Provide screenshot of your dashboard in the report.

(8 marks)

(f) Create two (2) relevant Actions for advanced Dashboard Navigation so that users will be able to perform some of the following actions: filtering, highlighting, drilling down or navigating to an external HTTP link. Provide screenshots of the Action settings.

(8 marks)

https://data.gov.sg/

Mun Teng

Highlight

Mun Teng

Cross-Out

Mun Teng

Cross-Out

Mun Teng

Cross-Out

Mun Teng

Cross-Out

Mun Teng

Cross-Out

Mun Teng

Highlight

bookmarked - operating revenue and expenditure

(g) Develop a storyboard with at least three (3) story points. The story points need to provide insight from the data, as well as highlight the Strategic Objectives from part (a). You may create more dashboards to give a more holistic view of the insights from the data set.

Provide screenshots of the storyboard in your report.

(16 marks)

(h) Explain the insights your storyboard captured from the data. Explain the ways your storyboard are able to bring across your points more effectively than using just a Dashboard.

(12 marks) SECTION B (Total 20 marks) Question 2 Save your Tableau workbook in a single Tableau workbook file in .twbx format and submit to Canvas.

(20 marks)

----- END OF ECA PAPER -----

1. This End-of-Course Assessment paper comprises SIX (6) pages (including the cover page).
IMPORTANT NOTE