GitHub ↗ (opens in a new tab)YouTube ↗ (opens in a new tab)LinkedIn post ↗ (opens in a new tab)

Overview

Developed a tourism analytics solution using publicly available Telangana government datasets, with a focus on domestic and foreign tourist activity and regional performance.

Interactive dashboard

Open in new tab (opens in a new tab)

Loading the dashboard…

My contribution

  • Analysed domestic and foreign tourist trends across Telangana’s districts.
  • Compared district-level performance using Compound Annual Growth Rate (CAGR).
  • Identified peak and low-performing tourism months.
  • Examined Hyderabad’s tourism trends and developed visitor and revenue projections.
  • Translated analytical findings into recommendations for tourism planning and administration.

Deliverables

  • Interactive Power BI Dashboard
  • Insight CSV Files
  • Research Presentation

Data source: Open Data Telangana

Tools

  • Power BI
  • Microsoft Excel
  • Microsoft PowerPoint
Codebasics Certificate of Achievement. Arnav Patnaik has won 2nd prize in the codebasics resume project challenge, Provide Insights to Telangana Government Tourism Department. Dated 10 July 2023, signed by the Founder of Codebasics.
Certificate of Achievement, Codebasics, 10 July 2023