{"id":6487,"date":"2012-09-28T14:44:03","date_gmt":"2012-09-28T19:44:03","guid":{"rendered":"http:\/\/bobbeaty.com\/wp\/?p=6487"},"modified":"2012-09-28T15:56:10","modified_gmt":"2012-09-28T20:56:10","slug":"adding-seasonality-to-the-demand-data","status":"publish","type":"post","link":"https:\/\/bobbeaty.com\/wp\/archives\/6487","title":{"rendered":"Adding Seasonality to the Demand Data"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/bobbeaty.com\/wp\/wp-content\/uploads\/2008\/06\/webdevel.jpg\" alt=\"WebDevel.jpg\" title=\"WebDevel.jpg\" border=\"0\" width=\"128\" height=\"128\" style=\"float:right; margin-left:10px;\" \/><\/p>\n<p>Today my day started out with a rather early meeting for my work here at The Shop - 9:30 am, and it was about an interesting topic - the seasonal adjustment of the demand data we're using in our project. The problem is that the demand data is based on the previous 12-months historical sales data - <em>all annualized<\/em>. This means that boat tours should sell as well in July as December. Nope. So how to do this?<\/p>\n<p>I'd already suggested in an email that we make a simple web app that allows the right people to add the important location and taxonomy data as well as a simple 12-month segmented graph (or even sliders or dials) so that the users could control the seasonality for their division and their sales reps. It makes sense - boats trips in Arizona are not down in December, so we need to really look at all the factors that might contribute to the seasonality of the demand.<\/p>\n<p>Then we need to overlay this on the incoming demand and we're in business.<\/p>\n<p>There's also the need for a <em>manual<\/em> demand entry screen where the users can input demand that <strong><em>they<\/em><\/strong> anticipate, and let them run with that. All sounds pretty decent. Very do-able.<\/p>\n<p>But the proposal was that we base it on some Google Doc and parse out the data from a spreadsheet.<\/p>\n<p>That's a <strong><em>horrible<\/em><\/strong> idea. I've had to do it so many times, and it <strong><em>always<\/em><\/strong> becomes a nightmare. The project manager thought it would be \"easy\" and \"fast\"\u2026 but all it really does is <em>move<\/em> the development effort from building the UI and data integrity checks to the data parsing and processing. There's no savings here. But Holy Cow! That was a 30 min meeting that took 90 min because this guy could <strong>not<\/strong> get the idea out of his head that this wasn't the way to do it.<\/p>\n<p>I consider myself a decent communicator, but I've come to a loss with this guy. I think he's just not a good listener, but who knows. In any case, at the end of the 90 min meeting I was able to get some support from another developer manager and I think we're going to do the \"Right Thing\". But it was not easy.<\/p>\n<p>Now I think I'm going to have to come up to speed on Rails, as I think we're going to build this in Rails, but at least it's going to be done Right.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today my day started out with a rather early meeting for my work here at The Shop &#8211; 9:30 am, and it was about an interesting topic &#8211; the seasonal adjustment of the demand data we&#8217;re using in our project. The problem is that the demand data is based on the previous 12-months historical sales [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,6],"tags":[],"class_list":["post-6487","post","type-post","status-publish","format-standard","hentry","category-coding","category-cube-life"],"_links":{"self":[{"href":"https:\/\/bobbeaty.com\/wp\/wp-json\/wp\/v2\/posts\/6487","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bobbeaty.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bobbeaty.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bobbeaty.com\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bobbeaty.com\/wp\/wp-json\/wp\/v2\/comments?post=6487"}],"version-history":[{"count":2,"href":"https:\/\/bobbeaty.com\/wp\/wp-json\/wp\/v2\/posts\/6487\/revisions"}],"predecessor-version":[{"id":6489,"href":"https:\/\/bobbeaty.com\/wp\/wp-json\/wp\/v2\/posts\/6487\/revisions\/6489"}],"wp:attachment":[{"href":"https:\/\/bobbeaty.com\/wp\/wp-json\/wp\/v2\/media?parent=6487"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bobbeaty.com\/wp\/wp-json\/wp\/v2\/categories?post=6487"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bobbeaty.com\/wp\/wp-json\/wp\/v2\/tags?post=6487"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}