Telangana Tourism Analysis

Goals-

Provide Insights to Telangana Government Tourism Department

Business Needs-

Telangana government wants to increase their revenue by improving administrative operations. As a data analyst, my work 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.

Insights-

• Hyderabad has the highest number of domestic visitors (84M) and foreign visitors (1.04M).
• Top 3 city in terms of highest domestic tourist are - Mancherial, Warangal (Rural), Bhadradri kothagudem. Top 3 city in terms of highest foreign tourist are - Nagarkurnool, Jogulamba gadwal, Hyderabad.
• Warangal (Urban), Nalgonda, Karimnagar has low domestic CAGR and Jangaon, Mahbubnagar, Jayashankar Bhoopalpally has low foreign CAGR in term of tourism.
• Domestic visitors- June and December are the peak months because of summer and winter vacations. February and March are the low season because of exams, financial year end. Foreign visitors- December and January are the peak months because during this time climatic conditions are favourable and due to christmas and new year holiday. April and May are the low seasons for hyderabad.
• Hyderabad (53.6%) has highest domestic to foreign tourist ratio followed by Rajanna Sircilla (26.7%) and Warangal Urban (19.6%). Peddapalli (96.98%) has lowest domestic to foreign tourist ratio followed by Kamareddy (3.02%) and Medchal (0%).
• Top cities like- Rajanna sircilla, Bhadradri kothagundam, Medak, Hyderabad, Yadadri bhongir, Nirmal are famous for their religious, natural and historical attractions. Bottom cities that have very least tourist attractions are- Kamareddy, Peddapalli, Nizamabad, Komaram bheem asifabad, Karimnagar.
• Domestic visitors declined at the rate of 6.3M in Hyderabad in year 2025 as comparison to 2019. Foreign visitors rise 0.66M in year 2025 as compared to 2019.
• Projected revenue by domestic tourist is started decreasing after 2017 and it will continue to be decline till 2025 the main reason is due to the COVID pandemic, persons saving habit increases and they avoid travelling. Projected revenue by foreign tourist is start increasing after 2019 and it will continue to rise till 2025.

LinkedIn Post