Case Studies

Case Studies

rss

Case Studies

The Need:

Entergy had been providing Walmart extensive reporting related to energy being used in all stores that were supplied by Entergy throughout the region. Overall, we understood this level of service including the reporting was unique and not being done for other clients other than Walmart. The reporting had to be compiled and presented weekly. This effort required two (2) full-time professional accounting staff, two 2 days each, to pull and organize the data from the Entergy IBM mainframe. The high-level granular tasks included exporting data from the mainframe, in turn, importing "edited" data it into excel, and then followed by integrating the formulas, charts and sparklines to provide a simplified presentation of daily, weekly and on-going energy usage to Walmart.

The Solution:

Overall, we had to develop and deploy a solution that would automate and replace the manual process described above. Our solution included Microsoft's task scheduler. We pulled the the data from the IBM mainframe using Microsoft SSIS. After the data was acquired, we had code in place to manipulate the data to eliminate, reformat, and modify the data prior to importing it into a spreadsheet (for further manual manipulation if needed). We then programmatically added formulas, graphs and more to provide the desired presentation.

Overall, the automation reduced the labor intensive process, which wasn't enjoyed by anyone, to a 5 to 10 minute process. At the end of the day, the professionals that used to gather, organize and build the presentation were freed up to do other things.

The technology:

  • Microsoft SQL Server
  • Microsoft Task Scheduler
  • Microsoft SSIS
  • Datawatch Data Pump
  • Microsoft VBA
  • Microsoft Excel
Since 1993, we've benefited from the trust, enthusiasm, and innovation of our partners. For small business and big business alike, we've provided out-of-the-box and custom Internet marketing solutions, as well as web-based, desktop, tablet, and phone applications—with all focused on results: increased revenue and cost-saving efficiency. Is it time to partner with Epoch Online?