I have attached files
MIS771 - Descriptive Analytics and Visualisation Page 1 of 9 MIS771 Descriptive Analytics and Visualisation DEPARTMENT OF INFORMATION SYSTEMS AND BUSINESS ANALYTICS DEAKIN BUSINESS SCHOOL FACULTY OF BUSINESS AND LAW, DEAKIN UNIVERSITY Assignment Three Background This is an individual assignment which requires you to explore a given data set, design an interactive dashboard using the Tableau software, and then convey your results in a website through WordPress platform. Percentage 35% The Due Date and Time 8pm Tuesday 13th October 2020 Submission instructions The assignment must be submitted by the due date electronically in CloudDeakin. When submitting electronically, you must check that you have submitted the work correctly by following the instructions provided in CloudDeakin. Please note that we will NOT accept any paper copies or part of the assignment submitted after the deadline or via Email. Important Note: Extensions and Late submissions are NOT possible for this assessment. You must keep a backup copy of every assignment you submit until the marked assignment has been returned to you. In the unlikely event that one of your assignments is misplaced, you will need to submit your backup copy. Any work you submit may be checked by electronic or other means to detect collusion and/or plagiarism. When you submit an assignment through your CloudDeakin unit site, you will receive an email to your Deakin email address confirming that it has been submitted. You should check that you can see your assignment in the Submissions view of the Assignment Dropbox folder after upload, and check for, and keep, the email receipt for the submission. The assignment uses the file 2020-2019-QS-World-University-Rankings.xlsx, which can be downloaded from CloudDeakin and requires you to utilise techniques/software learned in Module 3. MIS771 - Descriptive Analytics and Visualisation Page 2 of 9 Assurance of Learning This assignment assesses the following Graduate Learning Outcomes and related Unit Learning Outcomes: Graduate Learning Outcome (GLO) Unit Learning Outcome (ULO) GLO1: Discipline-specific knowledge and capabilities - appropriate to the level of study related to a discipline or profession. GLO2: Communication - using oral, written and interpersonal communication to inform, motivate and effect change. GLO6: Self-management - working and learning independently, and taking responsibility for personal actions. ULO 1: Apply quantitative reasoning skills to solve complex problems. ULO 2: Deduce clear and unambiguous solutions in a form that they find useful for decision making and research purposes and for communication to the wider public. Feedback before submission You can seek assistance from the teaching staff to ascertain whether the assignment conforms to submission guidelines. Feedback after submission This assessment will be treated as the final exam. Thus, the assessment mark and feedback cannot be released until the University officially releases the final results. The assessment mark and feedback will be published on Cloud Deakin as soon as the official results are released. Scenario You are an intern at Beautiful Data Inc. The company specialises in developing insightful and dynamic dashboards for their clients. Todd has requested you to come up with an interactive business dashboard for one of their clients, UniSelect – a qualified international education counsellor business. Education Consultants at UniSelect help prospective students to sort through their options to find the right education institution and course for them once students explain to them what kind of institution they are looking for. Thus, they are expected to have an excellent knowledge of reputable university profiles in the world and to keep abreast of any changes in the university ranking landscape. In the memo sent to the analytics team via SLACK (see next page), Todd has provided some guidelines on how to tackle the task. In particular, you are expected to explore the 2020-2019-QS-World-University-Rankings dataset and develop an interactive dashboard using Tableau Desktop software. Then, you should convey your results as an e- portfolio comprised of a process component and a solution component via WordPress platform. MIS771 - Descriptive Analytics and Visualisation Page 3 of 9 Dataset (accessible via 2020-2019-QS-World-University-Rankings.xlsx file) The Excel file contains rankings of 1000+ universities for the years 2019 and 2020 based on 6 key factors: 1. Academic Reputation, 2. Employer Reputation, 3. Faculty to Student Ratio, 4. Number of citations per faculty 5. International Faculty, 6. International Students. Data description is available from the Var_Description worksheet in the Excel file. Hint: You may add additional statistical analysis and/or supporting data of your own (additional Latitude/Longitude data, web links etc.). However, the focus of the assignment should be on the core data provided in the dataset. MIS771 - Descriptive Analytics and Visualisation Page 4 of 9 Todd’s memo sent to the Analytics team via SLACK1 12:50 pm Today Todd Nash 3:17 PM #VisCallenge #2019/20-World-University-Rankings #Project Hey, team DataViz. Let us all start working on #2019/20-World-University-Rankings data and see who can come up with the best interactive visualisations. Remember, our work will be showcased in the upcoming online- marketing campaign. More on this in my next post. Todd Nash 3:20 pm #VisCallenge #2019/20-World-University-Rankings #Project The #Data_Visualisation challenge consists of the following steps: a) Review the #2019/20-World-University-Rankings dataset first. b) Define a #Business/User_Persona that will be the #Audience of your data visualisation, and develop a #story to help focus and guide your data visualisation development process. c) Identify key #Data_Elements in the selected dataset that could be used to explore further using data visualisation methods. d) Discuss why you may use certain #Visualisations e) Keep in mind #Ethical considerations of using #3rdparty_data f) Develop an #Interactive_Dashboard (using the #TableauDesktop) g) Describe key components of your final #Dashboard. h) Deliver your project as #ePortfolio via #WordPress Todd Nash 3:43 pm #VisCallenge #2019/20-World-University-Rankings #Project Team, remember all the points mentioned in my previous comments should be done via #WordPress! Good luck all! Ah, and remember… I expect your projects submitted to me by Tuesday 13th October 2020, 8pm. 1 Slack brings team communication and collaboration into one place so you can get more work done, whether you belong to a large enterprise or a small business. Check off your to- do list and move your projects forward by bringing the right people, conversations, tools, and information you need together. Slack is available on any device, so you can find and access your team and your work, whether you are at your desk or on the go. https://slack.com/?cvosrc=ppc.google.slack&cvo_campaign=&cvo_crid=189416050964&Matchtype=b&utm_source=google&utm_medium=ppc&c3api=5523,189416050964,slack&gclid=CjwKEAjwutXIBRDV7-SDvdiNsUoSJACIlTqlzQSKLaVeXEwZoour-SKRO45OiKchz8HCRQFgIugiihoCwnbw_wcB&gclsrc=aw.ds&dclid=CIfElPmE6tMCFdEZKgodregODg MIS771 - Descriptive Analytics and Visualisation Page 5 of 9 Assignment Deliverables via WordPress The assignment is equivalent to 2,500 words and consists of three main sections (web pages): Process, Solution (accessible via Menu in the WordPress template) and Personal development reflection. You are required to complete all three parts. A) Process Component You are required to complete this section by producing four pre-set web pages under the process menu. Content presented here should be written in a ‘professional’ language and must cover the following four aspects: 1) Describe the audience for your Data Visualisation (to be written under AUDIENCE page) Describe the audience for the Data Visualisation you intend to create. This section should include a general description of the persona, questions they want to be answered, actions/outcomes your dashboard will be supporting, and the feeling you would like to convey. 2) Identify Data Elements (to be written under DATA ELEMENTS page) Using what you have learnt in the lectures and tutorials, first describe each column in the dataset (note: you should describe all columns regardless of whether you will ultimately use them in your visualisation or not). Then classify the data (for example, Categorical, Numerical: Discrete, Continuous / Scales of measurements: Nominal, Ordinal, Interval and Ratio / Time/Date, Location). 3) Describe at a high level what types of charts you might use to display the data. (to be written under THE RIGHT FIT page) Based on the data types you described earlier in this section, along with the objectives of the persona you described, describe what charts and visualisations you think might work well to communicate the information. 4) Finally, describe any data ethics considerations with the data you intend to use. (to be written under ETHICS page) Describe any considerations you think you should keep in mind while developing and sharing your visualisation. Note: While adding content, images, and tables are allowed under these sections (web pages), students are strictly prohibited from moving web page locations, renaming web pages or adding new pages under the PROCESS component. MIS771 - Descriptive Analytics and Visualisation Page 6 of 9 B) Solution Component Under the SOLUTION component (WordPress web page), you are expected to have two deliverables, namely, Live Dashboard and Story Telling. First using the skills, you have developed in the tutorial sessions (and leveraging any additional training and online support provided by Tableau Inc.) develop an interactive dashboard using Tableau Desktop. Then, you should embed your interactive dashboard on the Live Dashboard web page. Note: Instructions on how to retrieve the embed code and the import interactive dashboard to WordPress websites is available in the WordPress Instruction Manual. Under the Story Telling web page, you are expected to capture and describe various screenshots of your interactive dashboard developed using Tableau Desktop. Your descriptions, comments, or annotations of the interactive dashboard should detail how you