Citizen Data Science Certificate Survey

The Tableau 1 project is quick and covers everything you needed to learn to complete this project. Please complete this project before asking for Tableau 2 project help. READ THIS!! When done – there are 2 steps: Check your upload: look at the submission information on the right side of your screen and 1) download a copy a copy of your project FROM Canvas to another folder on your computer. 2) Open this copy, be sure it’s the right project, etc. and then 3) close / save this copy. This is your back up copy and the creation and last modified dates will be retained as long as it is unopened. Khamkon_Tableau2.twbx Natkamon_Tableau2.docx. both files name for the tableau and the document should look like this. Requirements: Please write down the script so that I could do the video part by myself First, submit to the project assignment to THIS assignment: and include your 1) a Word document, 2) a Tableau twbx file (be sure it ends with twbx) and 3) the URL to your YouTube video (copy / paste it to the comment area of the assignment) Next, submit your URL to the “Citizen Data Science Certificate Survey in our Assignment area”. Switch your video to your desktop* and with your Tableau file open, walk through your Tableau project, describing: a) The data b) Each of your 4 (or more) worksheets / visualizations, explaining why each analytic is meaningful. c) Your dashboard(s) – what is included and why you included these visualizations. Your dashboard should be interactive, so demonstrate this. d) Your analysis ‘story’ – what your analysis shows, the conclusions and your recommendations. e) What you learned about Tableau and your data

(Use your Word document above to guide your video script.) Upload your video to YouTube as an unlisted video and test your URL / link. 1. Look at the source data to get an idea of what it’s all about (you can do this either in Tableau or look at it in Excel). If you are using Excel, you can do some filtering or pivot tables to see what is in each field – looking for any outliers or interesting trends. Some things you might want to look at are:§ Dates, any spikes or dips in sales, which brands / departments, which states or regions, profits§ Cities, states or regions, what sells, how much in sales and/or profitBrands or departments – what sells best in which states or regions, at which times, etc In Tableau, create an initial broad visualization (sheet #1) and again, notice some outliers or some trends that may be interesting

2. Create sheet #2 to further explore either the outlier(s) or the trends. For example, depending on your data, this could lead to geographic questions, questions relating to years, specific products, departments, etc. You can do this by duplicating sheet 1 and filtering / drilling down.

3. Create sheet 3 to explore the questions in sheet 2 in more detail – by filtering again and /or showing some different attributes (fields) and using a different visualization format. This will lead to more questions about the trend / outliers that you can further drill down to analyze

4. Sheet 4 (or more) will let you keep looking at the data in more detail until you figure out what triggered the outlier or is most responsible for the trend. Depending on your data, this could be product sales in a specific region or by a specific product or department.

5. When you have figured this out – come up with one or more recommendations. Depending on your data, it could be something like – don’t sell xxx in this state, or this was a bad month for product xxx in state yyy, but they recovered, or… whatever you discover. Create a dashboard or two to illustrate this.

6. Then go back and create a story with your sheets and dashboard(s), be sure to include all of the required Tableau features (see the instructions on this) .