Deriving value from disparate data

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.

Our work

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.

Impact

Let's build your future.

Share with your network

Share on twitter
Share on facebook
Share on linkedin
Share on email

You may also enjoy

Case study

Smart data integration drives sustainable growth

Cloud-based data integration makes an upstream oil and gas provider’s data seamlessly accessible

Case study

Explosive growth experienced through a modernized workplace

Building a nonprofit technology infrastructure for seamless collaboration