
Quick Summary
Data analysis using Tableau has proven to be a valuable tool for the State Government of India in monitoring plot allocation and managing outstanding amounts. The insights gained through visualizations aid in decision-making, resource allocation, and timely recovery of dues. By leveraging data analysis, the State Government effectively drives industrial infrastructure development in the State and contributes to the state’s economic growth.

About the Customer
The State Government of India responsible for developing industrial infrastructure in the State plays a vital role in driving infrastructure and industrial development in the state, contributing to overall economic growth. The corporation provides state-of-the-art infrastructure and startup support to new enterprises.

Problem Statement
The State Government responsible in driving infrastructure and industrial development in the state faced multiple challenges with regards to allotment of plots. Some of the challenges faced by the State Government was:
- Managing and tracking a large number of plots and their categorization.
- Ensuring efficient allocation of plots to maximize utilization.
- Collecting and monitoring principal default and outstanding amounts for effective financial management.

Solution
To address challenges of
- Tracking the status of allotted and unallotted plots in the State across various property types and districts.
- Monitoring the principal default and outstanding amounts at district and estate levels.
Data analytics tool Tableau was utilized for visualizing the information. The data was obtained from the organization’s database (Maria DB). Through maps, bar charts, and tabular charts, the required information was presented in a clear and meaningful manner:
The analysis of data provided valuable insights, including:
- Identification of the percentage of plots allotted and unallotted based on property types, with the highest percentage belonging to industrial plots and the lowest to institutional plots.
- Determination of districts and estates with the maximum and minimum numbers of unallotted plots, helping prioritize allocation efforts.
- Examination of the outstanding and default amounts, highlighting the districts and estates with the highest and lowest values.
- Understanding the distribution of outstanding and default amounts across different property types.

Business Benefits

Leave a Comments
You must be logged in to post a comment.