Tableau dashboard facilitated direct communication with applicants under Nagar Darshan portal

Quick Summary

Data analysis has greatly benefited the government in tracking the status of applications received through the Nagar Darshan portal. The analysis has enabled effective processing of applications, identification of pending applications, and understanding the reasons behind the delays. By addressing the pending applications in a timely manner, the government can enhance citizen satisfaction and improve the efficiency of the application process.

About the Customer

Nagar Darshan, a portal developed by the Directorate of Urban Local Bodies, of the Indian State in the north, where citizens can raise demands, suggestions, and complaints related to their cities. The portal aims to streamline the application process and provide a platform for citizens to interact with the Government.

Problem Statement

The main challenge faced by the Government was managing and tracking the large volume of applications received through the Nagar Darshan portal. Ensuring timely resolution of pending applications and effective communication with applicants and officers posed challenges.

The objective became impertinent to analyze the status of applications received through the Nagar Darshan portal. To identify pending applications, categorize them based on pending days, and reach out to applicants or officers to address the pending applications.

Solution

Tableau was used to analyze the application status at various levels. Data was extracted from the Government’s Maria DB database and visualized using bar charts, maps, and tabular charts. The application status was categorized by department, Municipal Corporation (MC), and district, providing a comprehensive view of the pending applications. The dashboard also allowed for drill-down to the application level to view details and facilitated direct communication with applicants or officers.

The analysis of Nagar Darshan data revealed that approximately half of the applications were submitted by citizens, while the other half were submitted by government employees (ER). At each level of application processing, the status was categorized as feasible, not feasible, pending, or not required. The pending applications were further classified based on the number of days they had been pending. The dashboard provided a direct contact option to reach out to applicants or officers for further information.