The largest oil producer in Manitoba (and long-time partner) contacted Imaginet to implement a unified data warehouse. They needed to report on data from several sources, including PVR (oil production volume reporting system), InterSystems IRIS (financial data system), P2 Qbyte (financial data system), AccuMap (oil and gas mapping software), and WellView (well information management system). While the client had many valuable data points for current and historical perspectives, it was disjointed, time-consuming, and difficult for them to report across the different systems and see the insights that correlated data could reveal.

Imaginet used SQL Server Integration Services to load and transform the data into a data warehouse hosted on SQL Server (on-premises). We created an analysis cube using SQL Server Analysis Services that loads data from the data warehouse. The client connects to the cube from Microsoft Excel to build pivot tables and charts or, with the help of Power BI, can easily compile robust reports. We have also helped the client start the transition to cloud-based services. When they switched from IRIS to Qbyte for their financial tracking, we used Azure Data Factory to coordinate the data movements and replaced their Essbase cube with Power BI. The introduction of Azure DevOps helped us increase efficiency and collaboration in creating and tracking work items for the project.

Imaginet successfully connected the data from multiple systems so the client could get a better idea of production, broken down to each oil well. With the new system, weekly reporting is simplified and expedited. Up-to-date information is readily available, so the client can review and adjust production times and volumes as needed.