Assignment: Analyze a Data Set Using Excel Pivot Tables and Tableau
Select a data set relevant to something you are interested in learning.
1. Create an Excel Workbook containing at least 3 Pivot tables showing your data arranged in various ways - i.e. complaints by states, complaints by product, etc... You should include your source data as one of the worksheets in your workbook.
2. Create a Tableau workbook based on the data file you select.
3. Create seven data visualizations, one for each type listed on the next page. Each visualization should be on a separate worksheet within the workbook and it should provide an insight into the data set. Label each worksheet in the Tableau workbook as "Name of Visualization 1, Name of Visualization 2," and so on.
Tableau Visualizations:
Visualization 1 Create a treemap
Visualization 2 - Create a single data table
Visualization 3 - Create a bar chart
Visualization 4 - Create a line chart
Visualization 5 - Create a scatter plot
Visualization 6 - Create a geographical map
Visualization 7: Create a dashboard that provides a good overview for someone who needs to make decisions using the data. (note, the dashboard should include some of your above visualizations)
Visualization Write Up:
Provide a one page write up of the data you selected, what you were hoping to discover from the data and indicate whether the data provided you with any surprising results.
Format your assignment according to the give formatting requirements:
1. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the course title, the student's name, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.