Data Marts driven Analytical Reporting for Energy Sector

Engagement Details

Leading oil and gas corporation, India

Associated since: 2019

Service Type:
Application development & implementation

Service Model: 
Professional services

Status: Completed

Methodology: Agile

Scope/Challenges/Key objectives

Business Case:

Customer wanted an implementation of a reporting solution and its associated services leveraging SAS technologies.


  • No analytical insights from the data 
  • Lack of expertise to generate analytical reports/dashboards
  • Huge data residing in SAP suite which need to be analyzed
  • Unstructured data resulting in time consumption for integration activities.
Solution, Technical Environment, Benefits

Solution / Project Engagement:

  • Performing requirement assessment on historical data from SAP, SQL DB access microsoft excel, CSV files
  • Installation & configuration of SAS software components (e.g. SAS servers, SAS clients etc.) on development / QA, production environments
  • Executing data integration activities
  • Designing & building access to the source system to extract data and populate the reporting datamart
  • Designing & building of 10 analytical/standard reports. With a maximum of 3-6 sections in each report
  • Provision of support activities for a period of one month post go live
  • Provision of training and knowledge transfer on SAS solution to IOCL team
  • Deployment of 4 SAS experts for the implementation as well as technical support phase


Technical Environment:

  • SAS data management
  • SAS visual analytics (VA)
  • SAS enterprise miner with SAS analytics pro
  • SAS O/R
  • SAS access
  • SAS ETS add on

10+ analytical dashboards

Automated production plan

Order met with minimum slippage and cost

Optimum production cost