3 of 3 people found this helpful
I have. I grabbed a year of daily data from wunderground custom data download (e.g. http://www.wunderground.com/history/airport/KBED/2010/4/12/CustomHistory.html?dayend=12&monthend=4&yearend=2012&req_city=NA&req_state=NA&req_statename=NA). There's a CSV link at the bottom. I then used a data blend with my sales data, blended on day,
This allowed me to plot sales vs temp, cloud cover, humidity, rain, etc., add trendlines and look for statistically significant patterns.
How are you joining your sales to this data? Are you manually having to pull down the data?
1 of 1 people found this helpful
Yep, pull the weather data down - there's probably a way to automate this. I then did a data blend usung date.