Tools used in this project
State Growth Analysis

State Growth Analysis

About this project

Project Overview

This Power BI + SQL project aims to analyze Telangana's growth across various sectors using publicly available open data. Telangana, as one of the fastest-growing states in India, has embraced an open data policy, making its information accessible online. The goal of this project is to derive quantitative insights to support data-informed decision-making by the Telangana government, fostering further growth within the state.

Access to SQL query and addition information of the project :

GitHub Link:

Data Model view in Power BI:


Project Details

There are three areas for analysis

  1. E- stamp Analysis
  2. Transportation Analysis
  3. TS-iPASS Analysis

Key Insights:

E-Stamp Revenue Analysis:
  • Uncovered revenue trends, identifying peak periods for enhanced financial planning.
  • Provided actionable insights to optimize e-stamp processes for increased revenue.
Transportation (Vehicles Sold and Vehicle Type) Analysis:
  • Analyzed the dynamics of vehicles sold, highlighting trends in the automotive sector.
  • Classified vehicle types to understand market preferences and inform future transportation planning.
TS-iPASS Impact Analysis:
  • Explored the impact of TS-iPASS on industrial growth, providing crucial data-driven insights.
  • Facilitated informed decision-making for sustained economic development.

Additional project images

Discussion and feedback(0 comments)
2000 characters remaining