Case study

Creating a Unified Tracking Dashboard on LPG Applications

Part 2 of how we powered one of India's fastest executed schemes

Overview

As part of the Ujjwala Yojana scheme, the Ministry of Petroleum and Natural Gas needed to track how effectively LPG applications were being processed. They partnered with SocialCops to unify all LPG application data in a unified real-time tracking dashboard.

Partners

Ministry of Petroleum and Natural Gas

Bharat Gas

Indian Oil

Hindustan Petroleum

Sectors

Government

Business

Location

India

20 mil.

LPG connections tracked

640

districts covered

2,560

process indicators

21

dashboard widgets

Background

Bringing clean cooking fuel to 50 million women below the poverty line

In May 2016, the Ministry of Petroleum and Natural Gas launched Pradhan Mantri Ujjwala Yojana, its flagship scheme to ensure access to clean cooking fuel. The scheme aims to provide free LPG (liquified petroleum gas) connections to 50 million women under the poverty line by 2019.

The Ministry of Petroleum and Natural Gas partnered with SocialCops to use data intelligence to carry out the scheme effectively. We focused on three aspects of the scheme; after tackling the problem of where to open new LPG centers, we set out to track, analyze, and find gaps in the LPG application process.

Learn more

Poverty sees no barrier of caste, creed or religion... We ensured that the PM Ujjwala Yojana also remains above these barriers.

Dharmendra Pradhan

Union Minister, Ministry of Petroleum and Natural Gas

Government of India

The Problem

Understanding the LPG application process

Having more LPG centers is important, but it's equally important to make sure these centers run effectively. This was hard for the Ministry of Petroleum and Natural Gas to assess.

India's 17,00 distributors generated thousands of data points on applications and connections every day — 27 million applications and 20 million connections in just the first 11 months of the scheme. Moreover, each oil marketing company tracked this data in separate systems.

The Solution

Using data intelligence to proactively find and fix problems

The Ministry of Petroleum and Natural Gas and India's 3 oil marketing companies partnered with SocialCops so we could bring all data about India's LPG application process into a single place. We continuously pull, merge, and analyze all LPG data, visualizing it in a single dashboard.

Officials use this dashboard to understand key metrics — how many new applications were received, how many were accepted or rejected, and how many women finally had LPG connections in their houses — and identify where processes are breaking.

Collect

Our data transformation engine was essential for automatically pulling, cleaning, and analyzing data from each 3 oil marketing company's data systems every day.

Collect

The analyzed data is visualized in an interactive dashboard with important high-level metrics, deep dives into important indicators, and a integrated view of the entire LPG application process in a single page.

Implementation is as vital as the scheme itself. The implementation and ground level reach of Ujjwala Yojana is commendable.

Narendra Modi
Narendra Modi

Prime Minister

Government of India

Our Deployment Strategy

1

Data aggregation

We set up our platform to automatically pull data from all 3 oil marketing companies on a daily basis.

2

Data analysis

As data comes in, our platform automatically cleans and analyzes it before feeding it into the dashboard.

3

Data visualization

Data insights are visualized to help officials discover where LPG application process are breaking.

View overall metrics

All the key metrics about LPG applications that officials need were available through interactive charts and graphs.

Dive into the details

Officials can explore the details of high-level metrics to better understand issues and identify problems.

How this dashboard is driving better policies

How this dashboard is driving better policies

How this dashboard is driving better policies

One day, the Ministry of Petroleum and Natural Gas noticed on the dashboard that lots of women were getting rejected by distributors.

After digging into the data, we found that it was happening because those women didn’t have bank accounts — a mandatory requirement for getting a connection. The minister immediately asked this:

"Why can’t we carry out Jan Dhan Yojana camps in those areas?"

The government set up the camps (which help people get bank accounts), bringing together two of India's most important schemes. Now the number of women getting rejected due to lack of bank accounts is nearly non-existent.

Zoom into any geography

Users could drill down on all dashboard widgets from national to district-level data.

Identify process gaps

The entire LPG application process was visualized in a single page, making it easy to identify where processes were breaking.

Use data intelligence to make better decisions at any level of government.

Request a demo