Reference no: EM133566937

Tableau Assignment

The objective of this assignment is to develop a complete, cohesive, and cogent set of visualizations to convey meaningful insights regarding the differences in the nature of the impact that two exogenous phenomena that have had significant impacts on all aspects of individual, social, and economic life in the United States and across the world.

Assignment Topics: These are the Great Recession (Dec 2007-Jun 2009) and the COVID pandemic in 2020.

To manage scope,

Identify two dimensions of interest to you (for example - education, employment, public health, real estate, or financial markets).

Discuss the relative impact on these dimensions, using data from any 3 US states (or 3 countries if you wish) that have distinct characteristics in terms of population, employment, and exposure etc.

For example, a valid argument is that the population characteristics (such as age, size, density, and diversity) are very different between California, Florida, and North Carolina. Hence it is reasonable to compare the impact of the phenomena on these states.
You should justify your choice of dimensions and states in your submission.

Specific objectives include:

1. Build experience working with a variety of different data sources, formats, etc.
2. Develop visualizations that explore multiple aspects of a problem context.
3. Group visualizations into dashboards to inform and generate insights about specific aspects of the problem context.
4. Link visualizations and dashboards into Tableau Stories that describe the impact and the nature of recovery of the US socio-economic landscape.

Requirements:
Use maximum (at least 6) visualizations on your dashboard to tell your story. Annotate liberally and use the dashboard to highlight the explanations and themes you want to communicate. In your dashboard, look to communicate time series analysis and trends from related data from multiple sources, which together communicate and explain (not correlate or cause) the concurrent or cascading nature of the economic phenomenon, both national and individual - macro and micro.

To Do:
0. Conceptualize:
Conceptualize the nature of the story you want to tell from the data - form initial hypotheses/ideas and support them with evidence from the data expressed as Visualizations. You should leave this phase with 3-5 hypotheses you want to investigate or 3-5 questions that you want to answer in your narrative, with support from your data.

1. Collect and Process Data:

Collect all your data from the relevant sources. The identification of the data and its sources will be guided by the dimensions you identify.

Clean and process the data for analysis and developing visualizations. Keep in mind the units (of time and measurement) that the data are available in (Monthly, Quarterly, etc) and are appropriate for comparisons. To the extent possible, keep a uniform unit of time and measurement of data to make appropriate comparisons.

Also note the nature of the data - discrete, continuous, nominal, ordinal, or ratio scale. Your choice of visualizations will be affected by this.
You may need to come back to this step a few times during the process of completing your assignment in order to collect more or different data that better answers your questions.

Please keep in mind that to appropriately investigate the impact of any external phenomenon, it is important to collect data for BOTH before and after the event. I suggest that you collect data for 2 years before and after the specific event in order to examine trends and distributions that constitute your descriptive statistics. Ideally, the length of the before and after periods should be the same.

2. Build your visualizations:

Build your visualizations in the form of charts and graphs in tableau. While not required, I strongly recommend that you build individual visualizations along each of the dimensions/questions you have identified before you begin to create dashboards.
Use the resources in your tableau modules to select appropriate types of charts.
Use annotations liberally to identify the takeaway from each visualization you develop. These should specifically address What is the visualization telling the audience?; and What do you want the audience to take away from the visualization?
Generally speaking, you should expect to build around 3-4 visualizations for each major dimension of the story you are trying to tell. This is a VERY ROUGH guideline - not a minimum or maximum requirement by any means. The idea is to communicate the central themes and trends you see in the data and communicate the themes through annotated visualizations.

3. Build Dashboards and collect them into stories:

Build dashboards to communicate answers in the form of visualizations for each of the central themes of the context that you are investigating.

These include, but are not limited to, what and when was the great recession and how do we know? What are the real estate data trends and impacts, micro-economic impacts, macro- economic impacts, social impacts, etc. of the Great Recession?

Collect the visualizations you have developed in step 2 to build the dashboards. Be mindful that you may need to add visualizations and additional data to convey a cogent picture of the central theme for which you are building the dashboard.

Think about what you want to communicate and how you want your audience to interact with your dashboard(s). Collect your dashboards into stories to communicate your overall perspective of the nature and impact of the great recession. Here you should consider the collective and multi-dimensional narrative your dashboards are conveying.

Package your Tableau data into a single Packaged (txbx) Tableau WorkBook. (Please Note: This is NOT A TABLEAU WORKBOOK FILE).

Collect your narratives and related annotations into a report (Word or PDF) and communicate the process and findings. Make sure your report addresses the initial questions you started with and what answers you found.