Hi, I am having a data assignment. Deadline is due very soon, so any help would be very much appreciated. The tool this assignment should be done with is Tableau. Here is the instructions: Background You are a data scientist working in the public sector. Your team leader wants to get an understanding of the demographics of members of the Australian population born in certain countries over the past 30 years (1996-2016). The file 1996-2016 Aus ERP.csv contains the estimated resident population (ERP) of Australia from 1996 to 2016 (every 5 years at the census year), separated by states, ages (5-year groups), sexes and the countries of birth (COB), which is sourced from the Australian Bureau of Statistics (ABS). The columns/rows of the dataset should be self-explanatory. Altogether, there are 2 sexes, 5 years, 8 regions (states and territories), 256 COB and 16 age groups. Resource Like the first assignment, this problem is also open-ended. There are no absolutely right/wrong answers, but some analyses/presentations to be more interesting/appropriate than others. Unlike the first assignment, there is only one data set you need to use. However, you might find it useful by doing further research to understand more about the demographic structures of the Australian population. P.S. You may want to use Excel (which you are more familiar with) to perform the data manipulation, and leave the visualization part for Tableau. Your task In the country list.xlsx file, each student has been (randomly) assigned 6 countries of birth: 5 overseas nations/regions and Australia. This assignment consists of two separate tasks: Use Tableau® to create an interactive dashboard allowing the user to interrogate and explore your data, to address basic questions (e.g. temporal trends, demographic distributions) about people from your assigned countries over 1996-2016. (10 marks) Construct a StoryBoard in Tableau® to explain some particular aspect of the data you find interesting, or surprising, or that could be misleading. The first page should be named cover page, which includes your uni id and assigned countries. (10 Marks) Notes: 1. Demographic distribution is basically the percentages of a certain population with respect to some variable. For example, people born in Australia have a distribution of 51% and 49%, for males and females (i.e. the sex variable), respectively. 2. Only ONE dashboard should be presented for the first task. The use of the dashboard should be straightforward and self-explanatory. That is, you should not include any explanatory notes, and the user is expected to know how to interact with the presented functions without instructions. The dashboard should be more descriptive than analytical. Descriptive means you do not need to perform in-depth analyses and are only expected to present the raw data appropriately. The layout of your dashboard should allow the users to see/compare the dynamic (i.e. over time) demographic distributions of people from assigned countries, with respect to as many variables (i.e. age, sex, and region) as possible, without losing its concise/tidy organization. You may consider combining ages to have fewer levels (e.g. young, working force, and retiree) to meet the conciseness requirement. If combined, the labels should be changed according to describe the included groups (e.g., working force (25-65)). 3. The storyboard should be concise and consist of up to 12 pages/slides (excluding the cover page). You may aim to present only ONE particular aspect of the data of the six assigned countries/regions you find worth presenting. That is, the presentation is expected to be insightful, not just a simple description of the dataset. That is, a description of the raw data only is not acceptable for the storyboard. The slides as a whole needs to tell a complete story. For this purpose, you should perform some relevant statistical analyses. An acceptable analysis can be anything we have covered in BUSA2020, beyond the simple data description. For instance, your analyses may answer the following questions (for illustration purpose only, you are not limited to those): Are European migrants growing more (or less?) steadily, compared to Asian migrants? Are there significantly more younger population for mirgrants born overseas, compared to those born in Australia? Submission Instructions Please submit a Tableau Packaged Workbook (.TWBX) file to iLearn. Submitting a .TWB file will prevent others from opening it using a different PC, and will result in a ZERO grade. Tableau, by default, keeps the Tableau program and report in one place and the data in a separate place, so you can update the data easily. For your report, you need to put the data files and program all in to one place so that your report will refer to your data, not some other data, or no data (which would show no graphs!). To do this, you need to export your Tableau submission as a Packaged Workbook. File > Save as > Packaged Workbook Give your report an appropriate name (Book1.twbx is not a good name. Nor is Assignment2.twbx) Packaged Workbooks Tableau packaged workbooks have the .twbx file extension and are marked with the packaged workbook icon. Packaged workbooks contain a workbook along with any supporting local file data sources and background images. This format is the best way to package your work for sharing with others who dont have access to the data. Tips and suggestions Make your Dashboard and Storyboard useful. If you dont have a perspective or a decision to make, then youre just going to take the raw data and then look for eye-catching ways of presenting it all at one time. You may even make it look pretty but its not likely to be useful for anything. Ask yourself so what? with your dashboard and storyboard. If you have to lie to yourself with Umm, I suppose people might have a better idea of blah blah blah then you wont have a submission that you will feel proud of, or that will earn decent marks. The dashboard doesnt try to present everything all at once. Think about the decisions that might be made with the data. You will need to think about to include, and equally what to exclude. Focus on a particular aspect/variable of the raw data, and make the option to show more. Often, you can remove redundant variables, and focus only on those that count. Storyboards tell just one story Think of a short, informative title and make that the focus of your story. Australia is attracting more international younger work force in recent years NSW is the destination for most Asian migrants (We made these up we dont know check the data) Place yourself in the position of a decision-maker or policy-maker in the industry Dont try to create summary graphs for everything all at once. Instead, focus on some more specific issues. Think about Presentation Presentation and ease of use are really important if you want your user to use and enjoy the results of your good work. KISS Keep it Simple, Stupid. Remember that your user has not gone through the same processes of data exploration and experimentation that you have. What is obvious to you is not necessarily obvious to someone else. What is simple for you is not necessarily simple for someone else. Same for what to do next. So the interface should be intuitively simple. If there is any doubt about what to do to interrogate the data or how to understand a graph, then add a textbox or callout to explain. Name all of your worksheets, dashboards and storyboards. Give them names that mean something useful Storyboard_1 is not a meaningful name; More younger migrants are coming is a meaningful name. You are presenting a Dashboard and a Storyboard with up-to-12 slides . We dont need to see anything else. Remove unused worksheets Hide all other worksheets, so that only the Dashboard and Storyboard are visible. Watch the Instructional Videos There are several excellent videos on the Tableau website that explain how to create good Dashboards and Storyboards, each only 2-5 minutes. They are worth watching and learning from. https://www.tableau.com/learn/training Give yourself time to experiment, make mistakes, and try again As you would have discovered in our first assignment, this is a very hands-on unit. You cannot just cram at the end in the hopes that youll retain enough to get through an assessment. This is also true for the final exam. And you cannot write some fiction, an hour or so before the deadline, in order to pass an assignment. Its not primary school, so were not going to reward you just for following step-by-step instructions. You need to think critically and apply judgement, just like a data scientist. If you want to learn data visualisation and Tableau properly, or any skill for that matter, you need to spend time practicing and experimenting. Devote many short chunks of time (as opposed to a multi-hour cram session) to hands-on learning: watch a video and follow along using your own data. Then add something else to the visualisation. Take a break and then do it again, with another addition. Expect to make mistakes. When youve worked out what went wrong, youll learn better what to do next time.