Telangana Growth Analysis

Telangana's economic growth is a story of success. In a short period, the state has transformed itself into one of the leading economies in India. What are the factors that have driven this growth, and what challenges remain? This article will explore these questions using data from Open Data Telangana. It is also a resume project challenge run by Codebasics.

Dataset

The dataset provided consists of five files:

dim_date
dim_districts
fact_stamps
fact_transport

Objective

Explore Stamp Registration, Transportation and Ts-Ipass Datasets. Understand their attributes, categories and period.
Analyze trends and patterns within each department.
Identify growth opportunities and areas needing attention.
Find correlations among these departments and report the overall growth of the state through insights and relevant visuals such as shape maps.

By doing the above, we'll have to answer the primary and secondary research questions which we'll see later in this article.

Tools & Technologies Used

Below are the tools and technologies used to complete this project.

Microsoft Excel (To explore the data)
Microsoft Power BI (To create a dashboard and analyze data)
SQL (To verify the correctness of the solutions derived in Power BI)
Microsoft PowerPoint (To create presentation slides)
OBS Studio (To capture screen and record video of presentation)
Adobe Premier Pro (To edit the video presentation)

Video Presentation

Interactive Dashboard

To view the Power BI dashboard in full screen. Click here

Primary Questions

Below are the primary questions & their answers asked as part of the challenge.

How does the revenue generated from document registration vary across districts in Telangana? List down the top 5 districts that showed the highest document registration revenue growth between FY 2019 and 2022.

Document registration revenue is highest in districts closer to the state capital, Hyderabad. Rangareddy district generated ₹108.2 billion, the highest among all districts between FY2019 and FY2022.

The document registration revenue data for Jayashankar Bhupalpally is missing in the dataset.

The top 5 districts that showed the highest document registration revenue growth between FY 2019 and 2022 are:

Mulugu (170.94%)
Adilabad (122.84%)
Karimnagar (92.75%)
Mancherial (91.75%)
Medchal-Malkajgiri (91.68%)

Medchal-Malkajgiri district is the second-highest revenue earner from document registration in Telangana, and its revenue is growing at a compound annual growth rate (CAGR) of 91.68%.

How does the revenue generated from document registration compare to the revenue generated from e-stamp challans across districts? List down the top 5 districts where e-stamp revenue contributes significantly more to the revenue than the documents in FY 2022.

The revenue generated from document registration and e-stamp challans is almost evenly distributed.

The e-stamp revenue data for Jayashankar Bhupalpally is missing in the dataset.

The top five districts in Telangana where e-stamp revenue contributed significantly more to revenue than document registration revenue in FY 2022 are:

Rangareddy (₹651.6 mn)
Hyderabad (₹108.3 mn)
Khammam (₹30.5 mn)
Hanumakonda (₹29.6 mn)
Yadadri Bhuvanagiri (₹17.7 mn)

E-stamps seem to be most popular in and around the state capital.

Is there any alteration of the e-Stamp challan count and document registration count pattern since the implementation of the e-Stamp challan? If so, what suggestions would you propose to the government?

Since the launch of e-stamp challans in December 2020, the number of e-stamp challans has been slightly higher than the number of document registrations. The government can increase awareness and adoption of e-stamp challans by running campaigns and offering incentives, such as discounts on registration fees.

Categorize districts into three segments based on their stamp registration revenue generation during the fiscal year 2021 to 2022.

Districts can be categorized into three segments as above based on their stamp registration revenue during the fiscal 2021 to 2022.

Investigate whether there is any correlation between vehicle sales and specific months or seasons in different districts. Are there any months or seasons that consistently show higher or lower sales rates, and if yes, what could be the driving factors? (Consider Fuel-Type category only)

Vehicle sales typically increase slowly from August to October, peak in October, and then decline slowly until December, when they drop drastically. This is likely due to the festive season in Telangana, which includes Diwali in October or November, and Christmas in December.

How does the distribution of vehicles vary by vehicle class (MotorCycle, MotorCar, AutoRickshaw, Agriculture) across different districts? Are there any districts with a predominant preference for a specific vehicle class? Consider FY 2022 for analysis.

Agricultural vehicle sales in Telangana ranged from 20 vehicles in Hyderabad to 2,599 vehicles in Nalgonda in FY 2022.

The top five districts in Telangana where the most agricultural vehicles were sold are:

Nalgonda (2,599 vehicles)
Siddipet (2,437 vehicles)
Suryapet (2,188 vehicles)
Khammam (2,121 vehicles)
Bhadradri kothagudem (2,013 vehicles)

Autorickshaw sales in Telangana ranged from 69 vehicles in Rangareddy to 8,392 vehicles in Hyderabad in FY 2022.

The top five districts in Telangana where the most Autorickshaws were sold are:

Hyderabad (8,392 vehicles)
Sangareddy (3,381 vehicles)
Khammam (2,690 vehicles)
Vikarabad (2,046 vehicles)
Bhadradri kothagudem (1,388 vehicles)

Motor Car sales in Telangana ranged from 479 vehicles in Kumarambheem Asifabad to 71,832 vehicles in Rangareddy in FY 2022.

The top five districts in Telangana where the most cars were sold are:

Rangareddy (71,832 vehicles)
Medchal-Malkajgiri (61,071 vehicles)
Hyderabad (51,447 vehicles)
Sangareddy (14,565 vehicles)
Khammam (5,880 vehicles)

Motorcycle sales in Telangana ranged from 6,433 vehicles in Kumarambheem Asifabad to 206,819 vehicles in Hyderabad in FY 2022.

The top five districts in Telangana where the most motorcycles were sold are:

Hyderabad (206,819 vehicles)
Medchal-Malkajgiri (164,626 vehicles)
Rangareddy (154,186 vehicles)
Sangareddy (40,784 vehicles)
Nizamabad (28,105 vehicles)

Based on the sales of agricultural vehicles, autorickshaws, cars, and motorcycles in the top districts, it is clear that Hyderabad has a strong preference for motorcycles.

List down the top 3 and bottom 3 districts that have shown the highest and lowest vehicle sales growth during FY 2022 compared to FY 2021. (Consider and compare categories: Petrol, Diesel and Electric)

Above are the top 3 and bottom 3 districts that have shown the highest and lowest vehicle sales growth across petrol, diesel and electric vehicle categories during FY 2022 compared to FY 2021.

Electric vehicle sales are growing in all the districts of Telangana.

List down the top 5 sectors that have witnessed the most significant investments in FY 2022.

The top 5 sectors that have witnessed the most significant investments in FY 2022 are:

Plastic and rubber (₹5,855.61 cr.)
Pharmaceuticals and chemicals (₹2,181.63 cr.)
Real estate, Industrial parks, and IT Buildings (₹2,127.30 cr.)
Solar and other renewable energy (₹2,052.99 cr.)
Engineering (₹1,877.45 cr.)

List down the top 3 districts that have attracted the most significant sector investments during FY 2019 to 2022. What factors could have led to the substantial investments in these particular districts?

The top 3 districts that have attracted the most significant sector investments during FY 2019 to 2022 are:

Rangareddy (₹42,706.33 cr.)
Sangareddy (₹12,366.76 cr.)
Medchal-Malkajgiri (₹19,394.56 cr.)

The growth of real estate, pharma, plastics & rubber, engineering and R&D in these districts could be the reason for substantial investments in these districts.

Is there any relationship between district investments, vehicle sales and stamp revenue within the same district between FY 2021 and 2022?

Rangareddy
Hyderabad
Sangareddy
Karimnagar
Medchal-Malkajgiri

districts with positive growth in investment, vehicle sales, and stamp revenue suggest a correlation between the three.

Are there any particular sectors that have shown substantial investment in multiple districts between FY 2021 and 2022?

Plastic & Rubber
Solar and other renewable energy
Automobile
Paper & Printing
Agro based
Engineering

sectors have shown substantial investment in multiple districts between FY 2021 and 2022

Can we identify any seasonal patterns or cyclicality in the investment trends for specific sectors? Do certain sectors experience higher investments during particular months?

Most investments are made in the last four months of the fiscal year, from December to March.

Secondary Questions

Below are the secondary questions & their answers asked as part of the challenge.

What are the top 5 districts to buy commercial properties in Telangana? Justify your answer.

Most people would say Hyderabad when asked where to buy commercial property in Telangana, but here are five other districts with the potential for a better return on investment(ROI) in no particular order:

Bhadradri Kothagudem
Karimnagar
Medchal-Malkajgiri
Sangareddy
Rangareddy

Bhadradri Kothagudem has experienced rapid economic growth in recent years, attracting 20 times more investment last year alone. It is also a strategically located district, with easy access to two to three neighboring states.

Karimnagar is a major industrial hub in Telangana, and the government's proposed industrial corridor presents a significant growth opportunity and the potential for high ROI on commercial properties.

Medchal-Malkajgiri, located near the state capital, has a locational advantage for rapid growth. Its well-planned infrastructure and upcoming metro project make it a compelling destination for commercial property investment.

Sangareddy, a commercial hub with strong recent economic growth, is also a strategically located district with easy access to neighboring states.

Rangareddy, a well-positioned district near the state capital with well-developed infrastructure and booming industries, is a prime destination for commercial property investment.

What significant policies or initiatives were put into effect to enhance economic growth, investments, and employment in Telangana by the current government? Can we quantify the impact of these policies using available data?

TS-iPASS – Single window clearance, deemed approval (attracted ₹991bn)
MANA OORU MANA BADI – School infrastructure development (Benefited 19.84 lakh students)
RYTHU BANDU – To enhance agricultural productivity & income for farmers
TASK – To improve the skills of graduates
T-HUB - Synergies startups, corporations, governments, academia and investors to drive transformative change

Provide top 5 Insights & 5 recommendations to the Telangana government for sustained growth in the next 5 years based on your analysis.

Below are the top 5 insights followed by the top 5 recommendations to the Telangana government for sustained growth in the next 5 years.

Top 5 Insights:

Medchal-Malkajgiri is one of the top revenue-generating districts in Telangana in terms of revenue and growth percentage between fiscal year 2019 and fiscal year 2022.
E-stamp revenue is higher in and around the state capital, Hyderabad. Total stamp revenue is also high in the same areas.
Khammam district is among the top 5 districts in sales of agricultural vehicles, autorickshaws, and motor cars. Hyderabad district has the highest sales of motorbikes.
Khammam district's electric vehicle sales in the fiscal year 2022 were four times higher than in fiscal year 2021. Warangal district saw a decline of approximately 50% in petrol and diesel vehicle sales and a 58% increase in electric vehicle sales.
Rangareddy, Sangareddy, and Medchal-Malkajgiri have attracted more investments between fiscal year 2019 and fiscal year 2022, with most of the investments going into real estate, pharmaceuticals, plastics, engineering, and research and development.

Top 5 Recommendations:

Promote tourism: Telangana has a rich history and culture, which can be a major source of tourism revenue. The government should focus on promoting tourism by developing tourist destinations, improving infrastructure, and providing marketing support.
Improve the quality of education and healthcare: The quality of education and healthcare are important determinants of the state's human capital. The government should focus on improving the quality of education and healthcare by providing better infrastructure, training, and facilities. The government should also focus on making education and healthcare more accessible to all sections of society.
Encourage R&D: Research and development is essential for innovation and economic growth. The government should encourage research and development by providing funding, tax incentives, and other support to researchers and scientists.
Partner with the private companies: The government should partner with the private companies to develop the economy. This can be done by collaborating on projects and sharing resources.
Empower women: Women play a vital role in the economy. The government should focus on empowering women by providing them with education, skills training, and access to credit.

Acknowledgments

I would like to thank the people from the Telangana Government

Kalvakuntla Taraka Rama Rao (KTR) - Minister for IT, Industries and Municipal Administration
Jayesh Ranjan - Secretary, Information Technology (IT); Government of Telangana
Dileep Konatham - Director at Government of Telangana
Venu Panjarla - Open Data Telangana

I would also like to thank people from the Codebasics Team
Dhaval Patel - Founder, Codebasics
Hemanand Vadivel - Co-Founder, Codebasics.

If you also want to participate in this challenge, you can click on this link and participate in this or upcoming Codebasics resume project challenges.