Data Analyst · Calgary, AB

Ghassen Yahia

Turning raw data into decisions.

PhD in Physics turned data analyst. I bring scientific rigour to messy real-world datasets — from 6.6M civic records to live job market intelligence. Currently building towards Business & Data Analyst roles in Calgary's tech, energy, and financial sectors.

6.7MRows analysed
4Tools mastered
9Projects shipped
SQL · Data Cleaning Power BI · DAX Tableau · Data Storytelling MySQL · Window Functions Calgary Open Data · 6.6M Records KPI Reporting · EDA Google Data Analytics · Certified PhD Physics · Analytical Rigour SQL · Data Cleaning Power BI · DAX Tableau · Data Storytelling MySQL · Window Functions Calgary Open Data · 6.6M Records KPI Reporting · EDA Google Data Analytics · Certified PhD Physics · Analytical Rigour
01 //

Featured Projects

SQL · MySQL ★ Flagship

Calgary 311 Service Requests
— Civic Operations Analysis

End-to-end SQL analytics project on 6.67 million civic service records from the City of Calgary Open Data Portal. Designed a staging→analytics mart pipeline, built 30-day recurrence detection logic, and identified geographic hotspots to inform municipal resource allocation.

Processed 6,672,894 records across 4 modular SQL scripts (temporal, efficiency, geographic, trends)
~41–46% of resolved issues recur within 30 days — revealing systemic gaps in municipal maintenance
Identified Downtown, Beltline & Bowness as top hotspot communities by recurring incident density
Seasonal demand peaks in June (730k+ requests); Tuesday–Thursday see highest weekday volume
Dataset size6.67M rows
SQL scripts4 modules
Years covered2012–2025
Recurrence rate41–46%
Avg response time19+ days
CTEs Window Functions ROW_NUMBER() Temporal Aggregation 30-day Recurrence Logic Staging Tables GIS-ready coords
Power BI · Python New

Canadian Data Analyst Job Market
— Feb 2026 Intelligence Report

Live market intelligence dashboard built in Power BI, analysing Data Analyst job postings across Canada (February 2026). Scraped and structured real posting data to surface demand patterns, required skills, salary signals, and geographic concentration — directly informing job search strategy.

Self-directed research: collected, cleaned, and visualised real posting data from LinkedIn & Indeed
Identified top skills, experience thresholds, and industries driving DA hiring nationally
Interactive Power BI dashboard with filters by province, seniority, and skill requirements
Data sourceLinkedIn / Indeed
ScopeCanada-wide
Snapshot dateFeb 26, 2026
ToolPower BI + Python
Power BI Python (scraping) Data Cleaning Market Analysis Interactive Filters
Tableau · Data Storytelling

Fraud & Cybercrime in Canada
— Demographic Analysis (2021–2024)

Interactive Tableau dashboard analysing national fraud and cybercrime data, exploring geographic distribution of losses, victim age demographics, and solicitation method trends across Canada's provinces from 2021 to 2024.

Ontario: 82,896 reports · $671.7M in losses — highest concentration nationally
Mapped regional loss distribution alongside demographic vulnerability by age group
Published LinkedIn article translating visual findings into policy-relevant narrative
Understanding Fraud Trends in Canada (2021–2024): A Deep Dive into Solicitation Methods and Victim Demographics
Ontario leads with $671.7M in losses across 82,896 reports. The analysis reveals how digital platforms have concentrated fraud in Canada's most populated provinces — and which demographics are most at risk.
Read on LinkedIn →
Period2021–2024
ProvincesAll Canada
Top loss (ON)$671.7M
OutputDashboard + Article
Tableau Geographic Maps Demographic Analysis Data Storytelling LinkedIn Publishing
02 //

Technical Stack

SQL / MySQL
Proficient
Excel
Proficient
Power BI
Intermediate
Tableau
Intermediate
Python
Learning
Data Cleaning
Strong
03 //

About

I hold a PhD in Physics and spent several years in technical support and customer experience — roles that sharpened my ability to diagnose problems systematically, communicate findings to non-technical audiences, and deliver under pressure.

I'm now applying that same analytical foundation to data. My projects aren't chosen for their aesthetic appeal — they're questions I actually wanted answered: how does Calgary's civic infrastructure perform at scale? What do local employers actually demand? Where is fraud hitting Canadians hardest and why?

Based in Calgary. Targeting Data Analyst, Business Analyst, and Operations Analyst roles in Alberta's energy, finance, and technology sectors. Bilingual in English and French.

PhD
Doctor of Philosophy — Physics
Quantitative research · Statistical analysis · Scientific method
GDAC
Google Data Analytics Certificate
Google · Coursera · Data lifecycle & tools
CX
Technical Support — Tier 2
Stakeholder communication · Problem diagnosis · KPI reporting
EN
FR
Bilingual — English & French
Professional proficiency in both languages
Let's connect

Open to Data Analyst, Business Analyst, and Operations Analyst roles in Calgary. Always happy to talk data, SQL, or career transitions into analytics.