This repository contains the datasets, icons, and Jupyter Notebook (.ipynb) file used to develop the Telangana Growth Analysis Dashboard in Power BI. The dashboard provides transparent insights into the economic landscape of Telangana, specifically focusing on e-STAMPS and Transportation data.
This project is a submission for Codebasics Resume Project Challenge.
Here's the dashboard: Telangana Growth Analysis PBIX
Datasets: The datasets directory contains the raw data used for the analysis, including e-STAMPS revenue, documentation registrations, and transportation statistics.
Icons: The icons directory includes the icons used in the Power BI dashboard for visual representation.
Telangana_Growth_Analysis.ipynb: This Jupyter Notebook file documents the data cleaning, exploration, and transformation processes before importing the data into Power BI.
The Power BI dashboard is designed to offer concise insights into key economic indicators, including total revenue, e-STAMPS contributions, and transportation statistics. The dashboard comprises two main sections: e-STAMPS and Transportation.
KPI Cards: Overview of total districts, document registration revenue, e-STAMPS revenue, and current month statistics.
Charts: Stacked horizontal bar chart for overall revenue by districts, donut chart for top 5 districts by e-STAMPS revenue, area chart for total revenue by year, and a map chart displaying revenue across districts.
KPI Cards: Summary of total vehicles sold, new and pre-owned vehicles, and a breakdown of transport and non-transport vehicles.
Charts: Stacked area chart for monthly vehicle sales, stacked horizontal bar charts for vehicle class segmentation, and transport vs. non-transport vehicles in top 10 districts, donut chart for vehicles sold by fuel type, and a map chart for revenue across districts.
Datasets: Download the datasets from the datasets directory.
Icons: Access the icons from the icons directory for visual enhancements.
Telangana_Growth_Analysis.ipynb: Refer to the Jupyter Notebook for insights into data preprocessing and transformation.
Metadata: Refers to the description of each dataset.
telangana_district_map.json: Refers to a customer shape map for dashboarding.
You can feel free to contribute by opening issues or creating pull requests for improvements or additional analyses.
This project is unlicensed. All rights are reserved.