KeralaTourismAnalytics
Interactive intelligence for regional tourism planning.
A Business Intelligence dashboard using Power BI to analyze trends, COVID impact, and visitor demographics for Kerala Tourism.
Project Information
Client
Dept of Tourism
Year
2023
Role
BI Developer
Scope
- Power BI Development
- Data Modeling
- Government Tech
Overview
Created an interactive dashboard to analyze data from 13M+ domestic and 522k international visitors, aiding in policy making.
The Challenge
Fragmented data and manual reporting made it impossible to track accurate visitor trends or the real impact of the pandemic.
The Solution
Built a Power BI dashboard with Power Query for ETL and DAX for complex metrics. Designed views for high-level overviews and deep-dives into time-series trends.
Technology Stack
Tool
- Microsoft Power BI
Logic
- DAX
- Power Query
Data
- Python
Key Impact
Reduced reporting time by 90%. Highlighted domestic tourism recovery in 2023. Identified key source markets (UK, USA) for targeted campaigns.
Visitor Overview
Yearly Analysis
"Seeing the post-pandemic recovery with a few clicks gave us the confidence to allocate our promotional budget effectively."
