The student will select a real-world problem or phenomenon that can be analyzed with data that is publicly available. Then, using that data, the student will analyze the data using spreadsheet analysis and data visualization. Finally, the student will write up their findings in a short paper.
- Begin the project by identifying an area of interest that you would like to analyze. Then, begin researching public data sets that are available in that area. Focusing on the data that is available, select a specific problem or phenomenon that you would like to analyze. Select a minimum of two data sets to download and use for your analysis.
- Load your data into a spreadsheet for analysis. Review the data to be sure you understand the different values and to be sure it all aligns with your expectations. Make any edits necessary to improve your data for analysis.
- Create a new statistic from your data that will help you in your analysis. Do a brief analysis of this statistic and find the descriptive statistics for it: mean, median, standard deviation, max, min.
- Using Tableau, create four visualizations that help you understand the phenomenon or problem. At least one visualization must include data from both data sets. At least one visualization needs to include the new statistic you developed in the previous step. You may want to peruse Tableau public or other visualizations to help you determine the best visualizations to use. Create a Tableau dashboard that links all of these visualizations together.
- Write up a paper that describes your finding as follows: (5 pages)
- Describe the real-world problem or phenomenon that you selected.
- Describe the data sources that you are using, including details on how to access them. How difficult was it to find them and to use them together?
- What new statistic did you create to highlight the focus of your study?
- Describe the four visualizations you developed. Include them as figures in your paper.
- Summarize your findings and new insights you may have found.
To turn the project in, turn in the Tableau Packaged Workbook (twbx) file, the spreadsheet, and the writeup.
0 comments