Raj HamalData Analyst
Back to All Projects
Tourism AnalyticsCompletedApr 2026

Nepal Tourism Industry Analysis

10x Historical Growth, COVID-19 Impact & Recovery Analysis (1964–2023)

Project StatusCompleted
CategoryTourism Analytics
Primary ToolsGoogle Sheets, Tableau Public
AuthorRaj Hamal

Business Problem & Objectives

Nepal's economy relies heavily on international tourism. Following the devastating 80.7% arrival crash during COVID-19 in 2020, industry stakeholders required evidence-based insights on historic growth drivers, source market volatility, and strategic recovery priorities.

Dataset Overview

Official Nepal Tourism Statistics dataset (1964–2023) published by the Ministry of Culture, Tourism & Civil Aviation (MoCTCA), encompassing annual arrival counts, entry modes (air vs land), nationality demographics, average length of stay, and foreign exchange earnings.

Data Preparation & Cleaning Steps

  • Extracted raw tables from Ministry PDF reports and compiled a structured 60-year historical dataset.
  • Standardized country and regional names across changing geopolitical definitions.
  • Engineered calculated fields in Google Sheets for Year-over-Year (YoY) Growth %, Compound Annual Growth Rate (CAGR), Revenue per Tourist, and Air-to-Land Transportation Ratios.
  • Handled missing values and audited outlier years (e.g., 2015 earthquake, 2020 pandemic).

Analytical Methodology & Core Insights

Methodology Framework

  • •Time-series trend analysis spanning 1964–2023 to evaluate long-term macro growth trajectories.
  • •Comparative cohort analysis focusing on 1990–2023 in Tableau to track structural shifts in source markets (India, China, Western Europe, North America).
  • •Economic yield evaluation comparing gross arrival volume against per-tourist expenditure and average stay duration.

Analysis Highlights

  • •10x Macro Expansion: Tourist arrivals expanded from 93,000 (1975) to a peak of 1.197 million in 2019.
  • •Unprecedented Pandemic Crash: 2020 experienced an 80.7% collapse in international arrivals—the single worst disruption in recorded Nepalese tourism history.
  • •High-Volume vs High-Yield Disparity: India remains the largest volume source market, while European and North American travelers demonstrate significantly higher average lengths of stay (>13 days).
Interactive Tableau Dashboard: Nepal Tourism Industry Analysis
Open in Tableau Public
Loading interactive Tableau Public visualization...
Interactive features: Hover over data points, select region filters, and explore category metrics.Full Screen View

Key Findings

  • Air travel dominance: Over 85% of non-Indian arrivals enter via Tribhuvan International Airport, highlighting infrastructure sensitivity.
  • Post-pandemic recovery trajectory: 2023 data demonstrates a strong 80%+ rebound toward 2019 pre-pandemic baselines.
  • Seasonality bottleneck: Peak arrival volume is heavily concentrated in autumn (Oct-Nov) and spring (Mar-Apr), creating severe off-season capacity underutilization.

Business Recommendations

  • Diversify market targeting: Expand marketing initiatives in emerging regional markets (Southeast Asia) to mitigate reliance on traditional seasonal windows.
  • Promote high-yield ecotourism: Shift focus from raw arrival numbers to per-tourist spend by incentivizing longer stay itineraries in rural community homestays.
  • Digital tracking integration: Implement real-time visitor sentiment and booking pipeline tracking to optimize air capacity allocation.