Goal : In this assignment, we are interested in analyzing how average student debt changed from 2004 in 2014 in various states in the country. More specifically, we will be examining the percent change in average student debt over these ten years using maps. The Data: The data is in an excel file called Student Debt. Open the excel file and examine the data. While the data itself is fairly clean, two things to notice are: 1) All the descriptive text at the beginning and end of the file, and 2) the Spanning headers like "Ten Year Change, Average debt" etc. We will clean this data in Tableau Cleaning the Data in Tableau: Connect to this data in Tableau. When you look at the data in the Data Source tab, the fields are not clean with null lines etc. This is because of the text at the beginning of the Excel file. Check the box called "Data Interpreter". Tableau will clean the data. Step 1: Symbol Map We are going to focus on the measure "Ten Year Change Average Debt Percent Change 2004 to 2014" and examine how this varies across the different states. In a new sheet, multiselect State and Ten Year change, click on show me and select the symbol map. Which states appear to have the biggest increases? Smallest? Can you say this by just looking at the symbols without interactivity (hovering)? Would it be difficult to judge if you give your colleague a paper copy or use it in a report? Step 2: Choropleth Map. We are going to recreate the same map but as a Choropleth Map. Open another sheet in Tableau, Use the same variables but create a filled map instead. Experiment with color palettes. Remember, big increases are "Bad" while selecting a palette - colors have meaning! Try to answer the same questions as in Step 1. Think about which map you personally prefer and which you would share with a colleague - with and without interactivity. Step 3: Hex Map We are now going to create a hex map to show the same data. This is going to involve a few steps, please do them in sequence. I am giving very detailed instructions for those who are unfamiliar with Tableau. If you are comfortable with Tableau, just blend the Hexmaps zip file with the Student Debt file and use it to create a hex map. Step a: Download the following zip file. It contains four files, all four are needed to create a hex map, so keep them in the same folder. Step b: Go back to the same Tableau Worksheet with the Student Debt. Add a new data connection (go to Data > New Data Source or click on the canister). Select Spatial File and then click on your HexStates.zip file. The zip file has three fields - State, State Abbr, and Geometry. Step c: Blend the two datasets. The two datasets, Student Debt and HexStates have a field in common - the state abbreviation, so we can blend the two. The field is called "Abbreviation" in Student Debt and "State Abbr" in HexStates. Open a new sheet. Go to the Data menu and say Edit Blend Relationships. Select Custom blend. Select and remove the row with States States in it. Then select Add. You will see a primary and a secondary data source listed - these are you two sources. Select the appropriate fields. If Student loan is the primary data set, you should have Abbreviation selected. If HexStates is the secondary dataset, you should have State Abbr selected. Or vice versa. Step d: You will see a link next to "Abbreviation" in the student loan data. Click on it to activate the blend Step e: In your empty sheet, select the hexmaps data and drag "Geometry" into the sheet. You should see a hex map of the US but with Africa in the background. We must remove Africa. Step f: Go to the map menu, select map layers and slide Washout to 100%. Africa should disappear and leave only the hex map. Step g: Go back to the student loan data and put the measure Ten Year Average on color. If nothing changes, go to the HexMaps data and double click on State Abbr. Your hex map is ready. Step h: Put Abbreviation on Label. Use the same color palette as for the choropleth map. Hex Map is done!! I HAVE ATTACHED ALL FILES. THANK YOU!!
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
