Hetang Patel

Data Analyst & Business Intelligence

Power BI reports and SQL models built from official data, with every number traced to its source.

View WorkDownload Résumé (opens in a new tab)
  • Halifax, Nova Scotia
  • Authorized to work in Canada
  • Open to opportunities across Canada

Selected Results

Verified against source files

  1. Rent outpaced income, 2019–2024, NS Housing Monitor19 pp
  2. Transit records modelled, Halifax Transit663,788
  3. Lower forecast error than baseline, F1 Regulation Impact42%
  4. People on the team I led at BIOMEX, BIOMEX10
  5. Race laps modelled, F1 Strategy Simulation86,000+

Network Map

Each line is a project and each station a tool it ran through. Where lines meet, the tool was used on more than one project.

Store & queryTransformAnalyse & modelDeliverSQLPostgreSQLSnowflakeExcelPower QuerydbtPythonDAXRDESeq2XGBoostPower BIStreamlitFastAPIDockerReactHRTPSB

Select a station to see every project that stops there.

Selected Work

All Projects
H

Nova Scotia Housing Affordability & Rental Pressure Monitor

Business Intelligence & Data QualityMay–Aug 2026

Did Halifax rent rise faster than people’s ability to pay it — and did supply have anything to do with it?

Rent outpaced income, 2019–2024
19pp
Official sources in one model
5
Suppressed observations preserved
24.5%
  1. Power BI
  2. Power Query (M)
  3. DAX
  4. Excel
  5. Git
Power BI executive page showing average two-bedroom rent of $1,826, a 2.4% vacancy rate, a 31.9% rent-to-income ratio, Halifax CMA population of 545K, and a chart of rent versus income indexed to 2019 = 100 in which the two lines diverge after 2021.
The Executive page: headline measures and the indexed rent-versus-income divergence.
T

Halifax Transit Service Equity Analysis

Spatial & Operational AnalyticsDec 2025

Where is Halifax’s transit network leaving riders underserved?

Transit records analysed
663,788
Stops served by a single route
41%
Query time, down from 4 s+
<1s
  1. SQL
  2. PostgreSQL
  3. PostGIS
  4. Python
  5. Streamlit
Stacked bar chart of the top 15 Halifax Transit routes, splitting each route’s departures into morning peak (7–9 AM), evening peak (4–6 PM) and off-peak service.
Peak versus off-peak service distribution across the fifteen busiest routes — Route 1 carries roughly 50% more departures than any other.
R

F1 Regulation Impact Analyzer

Causal Inference & Analytics EngineeringJan–May 2026

Did Formula 1’s 2022 regulations actually make the competition closer?

Estimated regulation effect
+0.068
Lower forecast error vs baseline
42%
Seasons modelled
2019–2026
  1. Snowflake
  2. dbt
  3. Power BI
  4. Python
  5. statsmodels
  6. scikit-learn
Power BI dashboard showing competitive balance, treatment vs control, and the 2026 forecast tracker.
The three-view Power BI dashboard connected live to Snowflake mart tables.

Machine Learning Projects

Two F1 models, each shipped with a live demo & a public repository.

Experience

Full Experience

  1. –

    Project Lead

    BIOMEX — Dalhousie University

    Led a 10-person cross-functional team rebuilding a legacy desktop bioinformatics workflow as a self-service web platform for a faculty stakeholder, delivering a working DESeq2 pipeline as proof of concept.

  2. –

    Software Developer

    Radius Research & Development — Dalhousie University

    Improved sprint delivery and onboarding by introducing structured Scrum ceremonies, Jira tracking, and GitLab CI automation, and by authoring onboarding documentation.

About

I’m a data analyst in Halifax with a computer science degree from Dalhousie. I like messy public data, careful questions, and results that someone who didn’t build them can still check.

I use Formula 1 data to practise forecasting and causal inference.

Education
BCS, Dalhousie University, 2025
Certificate
Google Advanced Data Analytics, 2026
Based in
Halifax, Nova Scotia