The role of projects in the public sector has become increasingly important in recent years. This is due to the fact that governments are under constant pressure to deliver results in a efficient and effective manner. One of the main reasons why projects have become so important in the public sector is because they offer a way to measure and track progress. In addition, projects can be used to gauge the impact of government policies and programs. Another reason why projects are important in the public sector is because they offer a way to attract private investment. By investing in projects, the private sector can help to finance public infrastructure and services. The public sector is under pressure to deliver results in a efficient and effective manner. Projects offer a way to measure

Client Background:

Government Municipal

Project Title

Municipal Debt Analysis

Project Objective

Project Description

This is a government Municipal Debt analysis data. Where client want to visualise the data of their debt owners by sector. They want to categorise the total entities like (Total Debt , Total Billing, Total Bad Debt, Total Property Value).

Our Solution

We have used Power BI to visualise the data. Perform several EDA and statistics analysis to get desired output from raw data.

Why Power BI ?

Power BI is a new cloud-based Business Intelligence service from Microsoft that builds on the company’s years of experience with relational databases such as Access, SQL Server, and others. It is a business intelligence platform that enables organisations to clean and completely transform raw data into meaningful data. It thoroughly analyses data and provides insightful results.

Tools used

Databases , Power BI

Language/techniques used

Python , DAX

What are the technical Challenges Faced during Project Execution

How the Technical Challenges were Solved

Business Impact

Client can now visualise the Total property and Total Billing amount. They have flexibility to filter out the dashboard according to Account Category. They can see Bad debt according to account category so that they will change their policy toward that particular sector.

In this visualisation they can see their Total Debt and Total Billing in line graph to check the trend.

Client can visualise these two KPIs to check total insights according to category. They can see Property value ,Total Debt and Bad Debt in same pivot table where values are distinguished by heatmap. 

Project website url

Featured Technology Partners