Deriving value from disparate data

Client Snapshot

In less than four months, Blueprint designed and built an on-prem data warehouse for a midstream energy services company to combine disparate financial and projection data into one location, giving the company better financial visibility. Blueprint then used Power BI to create dashboards the company can use to view and analyze all its data for better corporate performance management.

Work Summary

The problem

A leader in the midstream oil and gas industry needed to access and analyze numerous large data sets to generate financial and forecasting reports. The company had accounting data from its ERP, forecast data and volumetric operational information all being managed with different storage and reporting tools. To generate reports, individual staff members uploaded data into spreadsheets and shared files, so by the time reports were generated, the data was already old. In an industry where financial performance is often determined by razor-thin profit margins as well as futures and derivatives, companies need up-to-date information to succeed.

“Large transaction ERP systems are designed for transactions; they are not designed for analysis,” said Blueprint Director of Solutions Development Eric Vogelpohl. “It is a natural tension in the world of databases. Databases either want to be high performance transactional systems or they want to be analytical systems. They are rarely both.”

The Blueprint Way

Blueprint began by designing and building a Tabular BI engine, which allowed the company to combine financial and projection data previously stored in programs such as Peoplesoft and Hyperion, into one on-prem data warehouse, giving the company vastly improved financial visibility. This analytical business intelligence system uses a fundamental, repeatable design pattern on the Microsoft BI technology stack that marries directly with Power BI to quickly design and launch dashboards and graphical reports.

To ensure the program’s ongoing success and scalability, Blueprint also staffed a position at the company to troubleshoot any potential problems and build future enhancements into the solution.

For the first time, time the company was able to analyze all its data together and in near real-time, discovering trends, patterns and correlations that not only improve corporate performance management, but give the company the ability to consistently operate at a profit and outperform their competitors.


Share with your network

You may also enjoy

Blueprint collaborated with our client’s engineering and data teams to acquire and organize this data for analytics, leveraging the Lakehouse Optimizer to ensure cost transparency and continuous improvement within their Databricks platform.
With a focus on migrating from Cloudera to Databricks within a tight timeframe, the Blueprint team executed a seamless transition while addressing critical challenges surrounding data silos, and heavy storage costs.