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.
Challenges:
- 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