Raj HamalData Analyst
Technical Matrix

Skills & Tool Stack

Categorized breakdown of analytical tools, database languages, spreadsheets, business intelligence platforms, and domain competencies.

Data & Analytics Methodology

Core analytical skills honed through professional experience and Google Data Analytics training.

Data Cleaning & PreparationProficient

Cleaning messy datasets, handling null values, and standardizing schemas in SQL & Excel.

Exploratory Data Analysis (EDA)Proficient

Identifying distributions, anomalies, correlations, and business patterns.

Trend Analysis & ForecastingProficient

Historical time-series analysis for tourism recovery and sales seasonality.

KPI & Performance ReportingProficient

Designing metric dashboards for profit margins, conversion rates, and booking pipelines.

Business Problem TranslationProficient

Formulating business questions and framing quantitative analytical workflows.

SQL & Technical Languages

Database querying, data manipulation, and programming languages.

SQLProficient

Multi-table JOINs, GROUP BY aggregations, window functions, and filtering in BigQuery & relational DBs.

RFoundational

RStudio data manipulation with tidyverse and basic ggplot2 visualization.

PythonDeveloping

Data science libraries (pandas, numpy) through MSc Applied AI coursework.

Visualization & Analytics Tools

Industry-standard business intelligence tools, spreadsheets, and reporting platforms.

Power BIProficient

DataCamp certified in Power BI report design, custom visual formatting, and interactive dashboard creation.

Tableau & Tableau PublicProficient

Building interactive dashboards, calculated fields, parameters, and dual-axis charts.

Google Sheets & ExcelProficient

VLOOKUP/XLOOKUP, Pivot Tables, conditional formatting, and operational pipeline trackers.

Google Data Studio / Looker StudioProficient

Web metrics dashboards and interactive client performance summaries.

Google AnalyticsProficient

Tracking web traffic, user behaviour, and campaign performance.

Google BigQueryProficient

Cloud data warehouse querying for large-scale transaction and device datasets.

Developing AI & Data Science Capability

Active postgraduate studies at the University of Bradford.

Machine Learning FundamentalsDeveloping

Supervised and unsupervised learning models for classification and regression.

Applied Artificial IntelligenceDeveloping

Integrating AI techniques into business automation and analytical pipelines.

Process AutomationDeveloping

Automating repetitive data aggregation and reporting workflows.

Operational & Transferable Skills

Proven leadership, logistics, and consulting capabilities from 3+ years in tourism operations.

Structured Problem SolvingProficient

Deconstructing complex operational challenges into actionable analytical steps.

Stakeholder CommunicationProficient

Translating technical data findings into clear B2B executive reports.

Cross-Functional LeadershipProficient

Leading teams of 10+ and managing international client expectations under pressure.

Budget & Cost ControlProficient

Managing logistics budgets, vendor invoices, and financial reconciliations.