5 SQL Patterns Every Data Analyst Should Know
These five SQL techniques show up in almost every analytics project I work on — from window functions to conditional aggregations.


Business Intelligence specialist in Power BI • SQL • DAX — pairing manufacturing operations experience with HSE & Root Cause Analysis to turn operational data into productivity, cost efficiency, and data-driven decisions.
I'm an Operations & Business Intelligence Analyst with 5+ years of hands-on manufacturing experience, complemented by formal Data Analytics training. I bridge the gap between the production floor and the boardroom — turning operational data into KPIs, dashboards, and decisions that improve productivity and cost efficiency.
My toolkit centres on Power BI, SQL, Excel, Power Query and DAX — transforming messy operational datasets into interactive dashboards that surface trends, risks, and improvement opportunities across manufacturing, supply chain, and HSE functions.
I'm particularly interested in Business Intelligence, Operations Analytics, Manufacturing Analytics, Supply Chain Analytics, Process Improvement and HSE/Safety Analytics — with a long-term goal of helping organizations improve operational visibility, risk management, and data-driven decision-making.
Power BI, SQL, DAX, KPI Dashboards
Power Query, SQL, ETL, Data Modelling
Production Monitoring, KPI Reporting, Process Coordination
Incident Analysis, Risk Dashboards, Compliance Tracking
Continuous Improvement, Cost Efficiency, Process Optimization
A selection of data analysis and visualization projects showcasing my technical skills and problem-solving approach.
Interactive Power BI dashboard uncovering how gender, parental education, and test prep shape student outcomes across 100 students.
End-to-end Power BI dashboard uncovering $242K in delivered revenue, 41% revenue leakage, and actionable insights across 1,200 orders — built to drive smarter fulfilment and marketing decisions.
Power BI • DAX • Power Query — Interactive dashboard uncovering channel performance, engagement trends, and user behavior to optimize marketing conversion strategies.
Excel • SQL • Power Query • Power BI (DAX) — End-to-end e-commerce funnel analysis uncovering where 89% of users drop off and which channels, devices, and regions drive $1.18M in revenue.
Octoparse • Excel • Power Query • Power BI (DAX) — Web-scraped Coursera's data course catalog and built an interactive dashboard revealing which providers, courses, and difficulty levels dominate the $734K-review market.
Excel • Power Query • Power BI (DAX) — Built an executive-grade Bank Loan Dashboard that transforms raw lending data into a single-screen command centre: tracking $436M in funded loans, 39K applications, good-vs-bad loan ratios, and default rates by state, purpose, and home ownership.
Power BI • Power Query • DAX — Built a Health & Safety Hub dashboard that turns raw incident, risk, and compliance data into a three-view executive command centre: Overview, Incident Analysis, and Risk Analysis — tracking LTIFR, TRIFR, near-miss ratios, PPE compliance, and noise exceedances by department, site, and shift.
From raw data to boardroom presentation — here's the full stack I use to deliver insights that matter.
Dashboards & visualisation for decision-makers
Cleaning, transforming & modelling operational data
Translating production data into KPIs
How I deliver insights professionally
Get a full overview of my experience, skills, and projects in one document.
Cosmos Isuru — Resume
Data Analyst | HSE & Safety Analytics
Resume not uploaded yet.
Short articles on data analysis techniques, HSE safety findings, and lessons from real-world projects.
These five SQL techniques show up in almost every analytics project I work on — from window functions to conditional aggregations.
A walkthrough of the analytical approach I use to identify high-risk patterns in workplace incident data — before they become serious accidents.
Whether it's building a safety dashboard, cleaning messy data, or turning spreadsheets into clear insights — let's talk.
Contact MeHave a project, job opportunity, or data challenge? I'm available for freelance, contract, and full-time roles. Reach out and let's talk.