BIS301 Business Intelligence Assessment 2 – Individual Report Overview The aim of this assessment is to apply the concepts learnt from week 1-6 to design an interative dashboard to deliver data-driven insights. Students will work individually on this assessment where they will select a data set (preferably from the sample data set list). After understanding the data, each student will employ effectives charts and visualisation to create an interactive dashboard. Timelines and Expectations Students are expected to work individually to prepare a report that details the dashboard creation process based on a selected data set. The aim of this assessment is to enable students to create a dashboard that evaluates the use of data visualisation techniques applied to a given case. Students are required to select a data set and answer the followings: - Discuss the purpose of the data set, and provide a brief description of the data set. - Design an interactive dashboard using 5-6 charts/graphs/illustrations to represent the insights/patterns/findings from the data. - Describe the different techniques (joins, blends, filtering, calculations, parameters, ad hoc calculations etc.) that have been applied to create the dashboard. - Discuss the findings/insights/patterns found from the dashboard that can be useful for decision making. Case Study Report (30%) Individual Report Due (8 th May Week 7 Sunday 11:59pm) Expected word count 1,500 words Students are expected to submit their assessments via Turnitin on Moodle. Minimum time expectation: 15 hrs Learning Outcomes Assessed The following course learning outcomes are assessed by completing this assessment task: LO.2 Demonstrate data story telling skills to communicate insights based on real world data LO.3 Demonstrate a thorough understanding of and apply different visualisation charts LO.4 Apply business intelligence tools to assist in business decision-making Assessment Details For this assignment, students are required to write 1,500 words report on a specific case study and explain the use and applications of data visualisation techniques on a selected data set to create a dashboard. Students can choose any suitable data set that is publicly available on the internet. In week 7, students will be required to submit their report on moodle. Students are expected to work individually and undergo their own research without collaboration with any other student. Students are expected to prepare a comprehensive report on the application of their knowledge of data visualisation on a given case study. TEQSA: PRV14311 CRICOS: 03836J Australia Advance Education Group Pty Ltd. trading as Sydney International School of Technology and Commerce ABN XXXXXXXXXX |ACN XXXXXXXXXXLevel 14/233 Castlereagh Street, Sydney NSW 2000 P a g e | 2 1. All reports must include at least 5 academic references which must be done using APA7 reference style. 2. The case study must assess the value propositions of the chosen data set and discuss what types of business questions can be answered using the data set. It must highlight the suitability of data visualisation techniques for the selected data set. Students must also highlight how an interactive dashboard can be designed for the chosen data set to communicate the data effectively. 3. This unit requires you to use APA system of referencing. See Sydney International’s quick reference guide. It should be used in conjunction with the online tool Academic Writer: https://extras.apa.org/apastyle/basics-7e/#/. 4. A passing grade will be awarded to assignments adequately addressing all assessment criteria. Higher grades require better quality and more effort. For example, a minimum is set on the wider reading required. A student reading vastly more than this minimum will be better prepared to discuss the issues in depth and consequently their report is likely to be of a higher quality. So before submitting, please read through the assessment criteria very carefully. Submission All assessments must be submitted through Turnitin on Moodle. Marking Criteria / Rubric Refer to the attached marking guide. Feedback Feedback will be supplied through Moodle. Authoritative results will be published on Moodle. Academic Misconduct To submit your assessment task, you must indicate that you have read and understood, and comply with, the Sydney International School of Technology and Commerce Academic Integrity and Student Plagiarism policies and procedures. You must also agree that your work has not been outsourced and is entirely your own except where work quoted is duly acknowledged. Additionally, you must agree that your work has not been submitted for assessment in any other course or program. Individual report sample structure - Coversheet (mandatory) - Title page - Table of content 1. Introduction 2. Overview of the data 3. Dashboard Design 4. Description of the applied techniques 5. Findings from the Dashboard 6. Conclusions TEQSA: PRV14311 CRICOS: 03836J Australia Advance Education Group Pty Ltd. trading as Sydney International School of Technology and Commerce ABN XXXXXXXXXX |ACN XXXXXXXXXXLevel 14/233 Castlereagh Street, Sydney NSW 2000 P a g e | 3 7. References 8. Appendix Note: Students are allowed in include other sections as they deem necessary based on their case study. Sample data set for case study: Personal Key Indicators of Heart Disease Superstore Dataset Population of China (2020 and historical) World Energy Consumption Nutritional Facts for most common foods House Pricing Melbourne Students Performance in Exams TEQSA: PRV14311 CRICOS: 03836J Australia Advance Education Group Pty Ltd. trading as Sydney International School of Technology and Commerce ABN XXXXXXXXXX |ACN XXXXXXXXXXLevel 14/233 Castlereagh Street, Sydney NSW 2000 P a g e | 4 Case Study Report Marking Guide – Marks 100 Weighting: 30% Student IDs: Assessment Criteria: Score Very Good Good Satisfactory Unsatisfactory Presentation Information is well Information is Information is somewhat Information is somewhat /Layout organised, well written, organised, well written, organised, proper organised, but proper and proper grammar with proper grammar grammar and grammar and and punctuation are and punctuation. punctuation mostly punctuation not always used throughout. Correct layout used. used. Correct layout used. Some elements of /05 marks Correct layout used. used. layout incorrect. Structure Structure guidelines Structure guidelines Structure guidelines Some elements of Enhanced followed exactly mostly followed. structure omitted /05 marks Introduction Introduces the topic of Introduces the topic of Satisfactorily introduces Introduces the topic of the report in an the report in an the topic of the report. the report, but omits a extremely engaging engaging manner which Gives a general general background of manner which arouses arouses the reader's background. the topic and/or the the reader's interest. interest. Indicates the overall overall "plan" of the Gives a detailed general Gives some general "plan" of the paper. paper. background and background and indicates the overall indicates the overall /10 marks "plan" of the paper. "plan" of the paper. Overview of the data /10 marks Information is well organised, well written. Information is organised, well written, Information is somewhat organised Information is not organised Description of the applied techniques All techniques are discussed in Consistently detailed organised, proper Inadequate discussion Depth coherently. discussion. Displays adequately discussed. of issues Little/no Significant evidence of sound understanding Displays some demonstrated Critical analysis and with some analysis of understanding and understanding or Reflection. techniques. analysis of issues. analysis of most issues and/or some irrelevant /20 marks information. Dashboard design /30 marks Dashboard is well designed. Used appropriate charts. Dashboard is well designed. Used appropriate charts mostly. Dashboard is somewhat designed. Used appropriate charts mostly. No dashboard/ poor design. Rarely used appropriate charts. Findings from Dashboard /10 marks An interesting, well written findinds of the main points. A good findinds of the main points. Satisfactory findings of the main points. Poor/no findings of the main points. Summary & Conclusion An interesting, well A good summary of the Satisfactory summary of Poor/no summary of the written summary of the main points. the main points. main points. main points. A good final comment A final comment on the A poor final comment on An excellent final on the subject, based subject, but introduced the subject and/or new comment on the on the information new material. material introduced. subject, based on the provided. /05 marks information provided. Referencing Correct referencing Mostly correct Mostly correct Not all material correctly (APA7 Style). All quoted referencing (APA7 Style). All referencing (APA7 Style) acknowledged. material in quotes and quoted material in Some problems with Some problems with the acknowledged. All Quotes & acknowledged. quoted material and reference list. paraphrased material All paraphrased material paraphrased material acknowledged. acknowledged. Some problems with the Correctly set out Mostly correct setting reference list. /05 marks reference list. out reference list. TEQSA: PRV14311 CRICOS: 03836J Australia Advance Education Group Pty Ltd. trading as Sydney International School of Technology and Commerce ABN XXXXXXXXXX |ACN XXXXXXXXXXLevel 14/233 Castlereagh Street, Sydney NSW 2000 P a g e | 5 SubTotal-/100 marks Total out of 30