Skip to content

Telangana Growth Analysis Report- #7 Resume Project challange Codebasics

Notifications You must be signed in to change notification settings

monikam25/Telangana-growth-analysis-report

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 

Repository files navigation

Telangana-growth-analysis-report

7-Resume-Project-Challenge

Codebasics

Power Bi Report

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

The project was on the Telangana Growth in which we have to analyse the data and provide important and meaningful insights to the Telagana Government. Excited to showcase my Project-building skills in this real-world. 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.

🌟Introduction--> I have worked on a project as a Data Analyst. My task was to analyse Telangana Growth among different sectors quantitatively and providing useful insights to the Telangana government.

🌟Task--> As a Data analyst, my role was to analyze the data and extract meaningful insights that would help the Telangana Government to make data-informed decisions that would further support the growth of the state.

🌟Approach--> I utilize Mysql for conducting various queries, Power-Bi for visual analysis and powerpoint for engaging video presentation. with these tools I discovered key findings to drive future actions.

🌟Key Findings--> ↪ The count of e-Stamp challans registration is comparitavely more than the document registration count. ↪ In Q4 Of FY 2021-2022 the e-Stamp REvene generation was highest. ↪ The total no. of vehicles sold were anout 4 Million from 2019 to 2022.
↪ About 2 Million vehicles were sold together in FY 2021 & FY 2022. ↪ Plastic & Rubber sector have attracted maximum investement of around 1599 crore. ↪ Rangareddy district attracted the highest investement. Revenue generation & vehicle sales were also higher in this district of Telangana.

🌟Insights-->

  1. Investor confidence
  2. Economic health indicator
  3. Urbanization & Infrastructure needs
  4. Diversification of industries Digital
  5. Transformaton

🌟Recommendations-->

  1. Strengthen Regulatory
  2. Framework Data-Driven Decision-Making
  3. Sustainable Urban Planning
  4. Promote Innovation Ecosystems
  5. Environmental Responsibility

🌟Conclusion--> The current Gov. in Telangana has implemented several significant policies and initiatives to enhance economic growth, investment and employment.

It's an honour to be a part of this learning experience and to have the chance to showcase my skills in a real-world context. Grateful for the opportunity to learn, grow, and connect with fellow participants. 🌟codebasics #codebasics #codebasicsresumeprojectchallenge #powerbi #dataanalytics #ResumeProjectChallenge #LearningAndGrowing #CareerAdvancement.