Data Journalism Backup Site

Here is my optional tagline

Updating Data

by | Dec 1, 2018 | Fall2018_class

Data Updates

All — CollegeScorecard has put out updated data that requires us to update our data visualizations. Many of the charts were built with Sept. 26 data. There is an Oct. 30 dataset that makes enough changes on default rates, debt and other metrics that we should use it. These differences became apparent in the editing process. Everyone used College Scorecard data so we all have to deal with the update.

Second, anyone using Debt_Mdn should be using GRAD_DEBT_MDN instead in their charts. The reason? Debt_Mdn is artificially reducing the scale of the student loan debt.
Debt_Mdn is aggregated by institution. 
GRAD_DEBT_MDN is aggregated by individuals. So someone who transferred from Hendrix to UofA would have that Hendrix debt factored in when they graduate from UofA.

Below is a video on how to update your CollegeScorecard visualizations in Tableau.
Here are the basic steps:
1) Create a new Tableau workbook and import the Oct30 data. It is here:ARDebt10-30-18
2) Open your existing Tableau workbook that used the Sept 26 data. Select the visualization, select its tab, left click and copy
3) Move to the new Tableau workbook with the Oct30 data. Select a blank worksheet. Left click and paste
Your visualization has now been pasted with the Sept. 30 data
4) On the Tableau toolbar, Select Data | Replace Data Source. It will say existing source is Sept 26. Select Oct 30 data as replacement
5) BOOM. You are done.

Things that can go wrong:
–Ensure your data that you want to chart is listed in the measures pane. Grad_Debt_Mdn or CDR3 may need to be converted to measures for this to work properly.

Deadlines Extended to Midnight Sunday:
I set Saturday deadlines for revisions on graphics for just about everybody. Those deadlines for everybody now are extended to Sunday, 11:59 pm. 

We will debug and review in class. Email me if you have questions.

These are the sorts of updates that will happen when editing a data project and when you get to see the entirety of the project at once. This is coming together. I appreciate your hard work.