Raj HamalData Analyst
Analytics Case Studies

Data Analytics & Applied AI Projects

Verified project evidence utilizing official government statistics, retail datasets, and market research intelligence.

Tourism AnalyticsApr 2026

Nepal Tourism Industry Analysis

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

End-to-end business analytics project analyzing Nepal's international tourist arrivals, revenue patterns, and post-pandemic recovery using official government statistics.

Core Analytical Insight

10x Macro Expansion: Tourist arrivals expanded from 93,000 (1975) to a peak of 1.197 million in 2019.

Google SheetsGoogle SheetsTableau PublicTableau PublicGoogle DocsData Modeling
Market AnalysisMay 2026

Ecotourism Market Analysis 2025

Deciphering the 51-Point Intention-Action Gap in the $286B Sustainable Travel Market

Business analysis case study investigating why 84% of travelers express demand for sustainable travel but only 33% book it, identifying trust barriers and pricing myths.

Core Analytical Insight

The Price Myth Shattered: Certified sustainable accommodations are actually 39% CHEAPER on average than conventional luxury options, disproving the consumer perception that eco-travel is inherently cost-prohibitive.

Tableau PublicTableau PublicGoogle SheetsGoogle SheetsGoogle SlidesPDF Case Study
Business IntelligenceApr 2026

Sales Performance Dashboard – Superstore

Profit Margin & Regional Retail Analysis Across 10,000 Transactions (2014–2017)

Exploratory analysis of 4 years of retail transaction data from the US Superstore dataset to pinpoint underperforming product categories and geographic profitability drivers.

Core Analytical Insight

Top-Line vs Bottom-Line Divergence: Technology generated the highest total profit margin (~17.4%), while Furniture suffered from severe margin compression (~2.4%).

Google SheetsGoogle SheetsTableau PublicTableau PublicFeature Engineering
In ProgressApplied AI / Capstone

Bellabeat Smart Device Usage Analysis

Google Data Analytics Capstone – Smart Device Health Data Exploration (In Progress)

Google Data Analytics capstone project analyzing public Fitbit smart device health and activity usage data in BigQuery to recommend growth strategies for Bellabeat wellness products.

Google BigQueryGoogle BigQuerySQLSQLFitbit DatasetR Exploration