Telangana-Growth-analysis

Telangana growth analysis :-

Telangana is one of the fastest-growing states in India and one of the states with an open data policy. (They have published all their data online).There are total 33 districts in Teangana. the fiscal year for Telangana is from April to March.
here, I analyse Telangana’s growth among different sectors quantitatively and provide useful Insights to the Telangana government that would help them to make data-informed decisions that would further support the growth of the state.

The dataset consist of three parts:-

Stamp Registration Report :-

This report analyzes the growth of vehicle sales based on the methods of stamp registration. 1)document registration :- 2)Estamps challan registration:- estamp challan registration started at year 2020 and this analysis gives us the effects on sales in different districts. You can find the report here :-(https://github.com/gautam2000/Telangana-Growth-Analysis/blob/main/dashboard%20pdf.pdf)

Transportation :-

this report gives us the information regarding vehicle sales depends on fuel type category, Vehicle class.You can find the report here :-https://github.com/gautam2000/Telangana-Growth-Analysis/blob/main/dashboard%20pdf.pdf

Ts-iPass :-

this report gives us the information of investment of different business sectors in different districts.you can find the report here:- https://github.com/gautam2000/Telangana-Growth-Analysis/blob/main/dashboard%20pdf.pdf

Usage :-

1. Clone the repository
2. Open the Excel files in Microsoft Excel or any compatible spreadsheet software.
3. Navigate to the respective reports to access the analysis and insights.
4. Customize the reports as per your requirements by modifying the data sources or adding additional calculations.
5. Create a visualization dashboard based on the dataset for all three parts:- stamp registration,Transportation and Ts-iPass.then Analysis the report with the help of visualizing dashboard.

Contributing :-

Contributions are welcome! If you have any ideas, suggestions, or improvements, please open an issue or submit a pull request.

Acknowledgements :-

1. The Telangana Dataset downloaded from open data telangana is used for this project.providing valuable sales and financial data.
2. Special thanks to the contributors and developers of Excel and power bi and also related tools for enabling powerful data analysis and reporting capabilities.