auto-updated data feeds + data joining + calculated variables == power
Jason Y. whipped up a fascinating chart this afternoon that shows off the power of our new data feeds when combined with joined data and calculated variables.
He started with a data set of the monthly closing price of the S&P 500 Index. Then he joined that with another monthly data set of the 10-year Treasury yield. Then he created two new calculated variable series representing the monthly change in each (which is not explicit in the original data).
Finally, he plotted them together on the X and Y axes of a point chart, in the typical “four-quadrant” style, annotated some interesting outliers, and colored all the data by date.
Total time spent: 30 minutes.
It’s interesting data, well-visualized.
- Peter C., Verifiable.com
PS: He also made this small-multiple view of the same data.
