{"id":18,"date":"2015-02-13T16:49:08","date_gmt":"2015-02-13T22:49:08","guid":{"rendered":"http:\/\/www.garymeisner.com\/?p=18"},"modified":"2015-02-22T16:05:04","modified_gmt":"2015-02-22T22:05:04","slug":"business-intelligence","status":"publish","type":"post","link":"https:\/\/garymeisner.com\/cfo\/business-intelligence\/","title":{"rendered":"Business Intelligence"},"content":{"rendered":"

The Problem:\u00a0 Lack of information<\/h2>\n

The company had over a dozen divisions, most of which were experiencing declining sales, but had no way to assess overall trends by geographic market, distribution channel or customer.\u00a0 They also had no way to share information on customer accounts between the divisions and were missing opportunities to leverage their individual customer relationships on a company-wide basis.<\/p>\n

The Solution: Business Intelligence<\/h2>\n

I sponsored and directed the acquisition and implementation of a business intelligence tool.\u00a0 The base software cost less than $30,000 but provided a platform for top management of this multi-billion dollar company to access company-wide sales analytics.\u00a0 I developed the design specifications for the data base and developed the reporting applications to give views of the data down to the zip code level, providing analytics by metropolitan statistical areas, distribution channel, customer and time period.\u00a0 Even though data had to be gathered into a common SQL data base from a dozen companies, this entire project was completed on time in about three months.\u00a0 Because it was browser-based, users required little training and were provided with dynamic menu options to select data that met their specific needs.<\/p>\n\n\t\t