Designed and developed Revenue/Municipal Admin Dashboard for Telangana Govt. Tourism Dept. Used Power BI to analyze tourism data, provide data-driven recommendations, optimize operations, boost revenue, and drive strategic decisions.
Telangana is one of India’s leading states and has published its tourism data under its open data policy.
As a data analyst, Peter Pandey saw this as an opportunity to expand his skills and show his work on a bigger scale. Peter Pandey’s idea is to find the patterns in the given data, do additional research, and give data-informed recommendations to the Telangana government which can be used to increase their revenue by improving administrative operations.
Peter began his work by framing some primary, and secondary research questions and recommendation ideas.
Imagine yourself as Peter Pandey and perform the following task:
• Check ‘research_questions_and_recommendations.pdf’. You can use any tool of your choice (Python, SQL, PowerBI, Tableau, Excel, PowerPoint) to analyze and answer these questions. More relevant instructions are provided in this document.
• The target audience is top-level officials - hence you need to create a convincing presentation to provide insights/recommendations.
• You can add more research questions and answer them in your presentation that suits your recommendations.
• Be creative with your presentation, audio/video presentation will have more weightage.
• You can use additional data based on your own research to support your recommendations
The dataset is taken from Open Data Telangana. Thanks to Telangana Government for providing real-time datasets for public access which is a great learning asset - feel free to explore them here. Refer This
• Hyderabad attracts the highest number of visitors, followed by Rajanna Sircilla and Warangal Urban, showcasing the diverse tourism potential of these destinations.
• Mancherial district demonstrates the highest compound annual growth rate (CAGR) in tourism, followed closely by Warangal Rural and Bhadradri Kothagudem districts.
• Karimnagar district exhibits the lowest CAGR in tourism, with Nalgonda and Warangal Urban districts showing similar trends, highlighting the need for targeted strategies to boost tourism.
• Rajanna Sircilla district witnessed the highest population to tourist footfall ratio in 2019, indicating its appeal as an attractive destination for visitors.
• Kamareddy district had the lowest population to tourist footfall ratio in 2019, presenting opportunities for further tourism development and promotion.
• Nirmal district stands out with the highest domestic/foreign tourist ratio, with Nalgonda and Adilabad districts following suit.
• Mulugu district demonstrates the lowest domestic/foreign tourist ratio, with Warangal Rural and Hyderabad districts following closely.
• Domestic visitors prefer to visit Hyderabad in June, October, and December, coinciding with major cultural and festive events.
• Foreign visitors prefer to visit Hyderabad in January, February, and December, drawn by pleasant weather conditions and cultural celebrations like Makar Sankranti and Christmas.
• By the year 2025, Hyderabad is projected to attract approximately 63.22 million domestic tourists with a negative annual growth rate of -4.44%, resulting in an estimated domestic tourism revenue of 75.87 billion.
• By the year 2025, Hyderabad is projected to witness a significant influx of approximately 1.22 million foreign tourists, experiencing a robust annual growth rate of 24.74%, leading to an estimated foreign tourism revenue of 6.82 billion.
https://github.com/harshmehta01/Telangana-Tourism-Data-Analysis.git
git init
git add README.md
git commit -m "first commit"
git branch -M main
git remote add origin https://github.com/harshmehta01/Telangana-Tourism-Data-Analysis.git
git push -u origin main
git remote add origin https://github.com/harshmehta01/Telangana-Tourism-Data-Analysis.git
git branch -M main
git push -u origin main