Weather as a DB

,
1

At the 2017 PUG Conference someone referenced the ability to bring in weather and now that I am firmly entrenched into this Phocas thing, I am ready.

I would presume this would be done using Sync, but being somewhat unfamiliar with all that Sync has to offer I am trying to get a hold of First Steps. Such as:

  1. Choice of weather API (ie. Dark Sky, WU)… is an API available;
  2. Limiting the data received through the API call (only need rain total and rain forecast)

Anyone try anything this crazy yet?

1 Like
2

Hi Jdogg,

We did something similar where we regressed our Sales$ by HDD, CDD, Weather (Sunny, Cloudy, Precipitation), Weekday?, and other independent variables. Is this what you’re looking to do?

3

More or less yes. The first question was leveraging a DB that would easily connect to sync that would allow me to build a DB putting weather against sales.

4

@wayne.chen How were you able to regress sales dollars by weather?

5

Hi @kmurphy . I’ll answer in Wayne’s place for that. He had created an Excel document with historical weather data and ran analysis with some formulas and charts to see if certain temperatures correlated to certain levels of sales, as well as whether certain quantities of subsequent HDD or CDD correlated to higher sales volume.