Samadhi Pathirathna

Data Analyst | SQL • Power BI • Python

Data Analyst with experience transforming raw datasets into actionable business insights. Skilled in SQL querying, data modeling, dashboard development, and exploratory analysis to support data-driven decision-making.

Samadhi Pathirathna

Professional Profile

BSc Information Technology graduate with hands-on experience in data cleaning, SQL analysis, KPI tracking, and dashboard development. Experienced in transforming structured and semi-structured datasets into business intelligence reports that improve visibility and performance monitoring.

10+

Analytics Projects

5+

BI Tools Used

1+

Years Industry Exposure

Technical Expertise

Data Querying & Processing

  • SQL (Joins, CTEs, Window Functions)
  • Data Cleaning & Transformation
  • Exploratory Data Analysis
  • Data Validation

Data Visualization

  • Power BI (DAX, Data Modeling)
  • Tableau
  • Excel Dashboards
  • KPI Development

Programming

  • Python
  • Basic Machine Learning
  • Feature Engineering

Analytics Projects

Habit Tracker App

MindMap

Enhanced memory via habit tracking and machine learning. Delivered personalized activity-based recommendations with 83% prediction accuracy using Random Forest.

Demo Website GitHub Docs

E-Commerce Revenue & Customer Analytics

Performed RFM, cohort, and funnel analysis on transactional data to identify high-value customers, revenue concentration, and conversion drop-offs. Delivered actionable insights through an interactive Power BI dashboard to support retention and revenue optimization strategies.

View Project

Power BI Sales Dashboard

Built an interactive sales performance dashboard using Power BI. Implemented DAX measures, data modeling, and dynamic filtering to track revenue trends and KPI performance.

View GitHub

SQL Covid Data Analysis

Cleaned and analyzed global COVID datasets using advanced SQL queries including joins, CTEs, and window functions to identify infection trends and regional comparisons.

View GitHub

Airbnb Revenue Dashboard (Tableau)

Analyzed occupancy rates, pricing patterns, and seasonal revenue variations using Tableau dashboards to highlight revenue drivers.

View Tableau

Excel Customer Purchase Analysis

Developed Excel dashboards using pivot tables and KPIs to analyze customer purchase patterns and segment buying behavior.

View GitHub

Get In Touch