Unified Data Analytics Platform for Advanced Dashboard Development
Case Studies
Challenges & Solutions
Technical Environment
Results
Executive Summary
Client
Ministry of Gas
Industry
Gas and Oil
Business Problem
In pursuit of a robust data management system, the client initiated the development of advanced data analytics. The client sought a platform designed to gather, filter, and present data in a unified format to facilitate the analysis process and support the creation and deployment of advanced analytical dashboards.
Outcome
- Automated Claim Report.
- Sanity Check while Data Upload.
- Reduced Time to process claims.
Challenges
- The data from multiple sources was unorganized and required critical attention, both for legacy information and newer datasets.
- There were significant data security concerns, isolated data silos, and issues with data duplication and overall quality.
Solutions
- A solution was deployed to allow stakeholders to upload data in various formats according to their access privileges.
- ETL activities were executed for existing data sources, including those from divisions such as Demand, Supply, Marketing, Gas, Finance, PMUY, and PMGKY.
- Data processing involved applying various business rules to generate reports.
- BI reports were created and built, including an automated claims report.
- Additionally, sanity checks were performed during data uploads.
Technical Environment
- Apache Hadoop, SAS, Excel.
Results
- 20+ Analytical Dashboards
