Government

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

Objective of this analysis are as follow:
To Analyse the total debt.
To Analyse the total property value.
To analyse the total billing amount.
To analyse total Bad Debt.
To visualise the total debt by Category.
To visualise the Total Debt and Total billing by category.
To Visualise the top category by Property Value and their respective Total Debt.

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.

A quick start.
Streamlined publication and distribution.
Real-time information.
Ability to customize security features.
Cortana integration
Artificial Intelligence.

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

First we use API and python scraping libraries(Beautiful Soup) to extract the data from website.
Cleaned data by performing data analysis using python.
Performed statistical analysis to fill up missing values of data.
Performed calculation to get desired insights.

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.