In this assignment, you will create a dashboard using Tableau (Public or Academic versions will both work). The goal is to analyze the data provided in a simulated business that sells pool toys....

Need help with this tableau dashboard assignment please. It involves an excel file. I have attached excel data set, and instructions for assignment.


In this assignment, you will create a dashboard using Tableau (Public or Academic versions will both work). The goal is to analyze the data provided in a simulated business that sells pool toys. Dataset: Dashboard dataset -- student.xls located in the files area Procedure: Examine the data in Excel to learn about the contents of the file. This simulated data includes the kinds of recording errors and bad data-collection practices that you will find in the real life coorporate world. Know the limitations of the data before you go to Tableau. You may choose to transform/edit the data before loading it into Tableau. Import the data. Load into Tableau. Analyze the data. This is the key step. In order to present something about this dataset, you will need to find insights worth telling. Use Tableau's features to understand and analyze the data. Consider audience and tasks. You are creating this dashboard for the top executives in the company. What questions will they be asking? What decisions will the dashboard help them make? How do you best present the data to help them make that decision? Sketch ideas. Once you have explored the data with Tableau and decided upon your analytic questions, walk away from Tableau and use pen and paper to sketch possible storyboards of ways to tell your story. Keep your user and tasks in mind. A storyboard is the same tool directors use to plan a movie; you create a "comic" of several panels and fill them in with sketches of your planned content. Create your Tableau dashboard. Once you have found some views of your data that you like (as worksheets), you should construct a Tableau dashboard using them. I expect that Brushing will be active in your dashboard -- changing one graphic will effect others. The graphics should be explorable, including filters, and the ability to grad details on demand, but without losing the overview. What to submit: Tableau file Sketches from early designs (scanned if hand-drawn); and Write up a narrative addressing following questions: What questions will your executives ask (at least four of them), and how do your graphics answer those questions? (4-6 sentences) How does the interactivity of the dashboard help answer at least one of the questions? Please outline a question an executive might ask that your dashboard WON'T answer, and why weren't you able to address that question? Remember: Use appropriate labels and titles to remind your executives of the definitions of the data variables. Look at existing Tableau Public dashboards to get an example of how to best structure yours.