BI Merge Solution Using SSRS Solution

Leading Oil & Gas supply retailer onboards Microsoft based reporting solution for real time reporting

Client
Client is a national leader in the dynamic North American energy supply, logistics and services enterprise.
Industry
Oil Retailing & Distribution

The Client

A national leader in the dynamic North American energy supply, logistics and services enterprise. From petroleum products to CNG, LNG, specialty in chemicals and renewable fuels, their expertise spans all channels of transportation fuel and energy services.

The Challenge

  • The Client had 2 complex Supply Chain System.
    • System 1 (Legacy) : LTL and FTL Orders.
    • System 2 : DEF Orders.
  • The Client required a single Report Portal to see all kind of Orders.

The Solution

JKT has provided a SSIS and SSRS Solution through this BI Merge Project.

  • SSIS Solution to migrate their LTL & FTL transactional data and Master Data.
  • SSRS Solution to migrate their Legacy SSRS Report and create new SSRS Report and Dashboards.
  • Implement ANA and DLP Logic in our Reporting Solution.
  • Power BI Solution to create User Interactive Dashboards.
  • Created Decision Support System through DW Project based on migrated data and existing Entinuum Data.

The Benefits

  • The Client uses new BI Report Portal to access all kind of report show DEF, LTL and FTL data.
  • BI Merge Reports will use ANA Module to handle Report Permission.
  • BI Merge Reports will use Data Level Permission.
  • Due to that It was too easy to create Decision Support System (Data warehouse and AS Solution) for our Client.
  • Data mining solution based on our DW as future enhancements.