Firm’s Practice of Excel Data Storage Becomes Unmanageable

Background:
Bridge Talent client owns, controls, and has access to one of the largest terminal networks of petroleum products and renewable fuels in the Northeast. Also known as one of the largest distributors of gasoline, distillates, residual oil, and renewable fuels to wholesalers, retailers, and commercial customers in New England and New York.

Challenge:
The client’s natural gas sector faced significant risk issues related to data storage and utilization. Years of accumulated data and projections were stored in an Excel spreadsheet that had become unmanageable over time. A company-owned SQL database had not been utilized with data never imported.

Goal 1: Utilize SQL data management to full capacity and build custom reporting.
Goal 2: Customize database to provide predictive analytics.
Goal 3: Integrate data from multiple sources to broaden scope of analytics.

Solution:
A Bridge Talent-contracted BI developer revived the SQL database, implemented the data port from Excel and built the framework for necessary reporting functions.

– Improved flow of data quality:

• Streamlined data through multiple processes determined by operations team.
• Built custom reports in SQL using SSIS and SSRS that routed data to other internal software applications.

Results:
Increased Revenue: Immediately able to make accurate industry predictions and increased profits by 10 percent from Q4 to Q1 in the new year.
Improved Asset: Valuable data stored and utilized securely and efficiently.
Industry: Energy
Skillsets: Custom reporting, Custom database, SQL reporting, Predictive analytics, Data integration
Technology: MySQL database/BI tools, SSRS, SSIS
Roles: BI developer