Skip to content
View ayseguldahi's full-sized avatar
3 followers · 22 following
  • Vancouver

Block or report ayseguldahi

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
ayseguldahi/README.md

Hi, I'm Aysegul Dahi

Data analyst based in Vancouver, Canada. I turn public and business data into clear, decision-ready insights using Python, SQL, and modern BI tools. I'm especially interested in projects with social and environmental impact.

Featured Projects

BC Electoral Geography: Assigning Places to Districts PostgreSQL + PostGIS analysis of British Columbia's electoral geography: point-in-polygon assignment of voting places to electoral districts, the impact of the 2023 redistribution (87 → 93 districts), and the razor-thin 2024 election margins — Surrey-Guildford decided by just 22 votes, computed from 2.1M valid votes with window functions. PostgreSQL PostGIS Spatial SQL GIS Window Functions

BC Surgical Wait Times: What Averages Hide PostgreSQL + Python analysis of 16 years of BC surgical wait times. Window functions, data-quality auditing, and hypothesis testing reveal that post-pandemic improvements reached the median patient but not the longest-waiting 10%. PostgreSQL Window Functions Python SciPy Hypothesis Testing Healthcare Analytics

Climate Forecast Canada Forecasting Canada's temperature change, sea ice loss, precipitation, and global CO₂ emissions (1968–2030) with Random Forest, Gradient Boosting, and Prophet. Includes an interactive Streamlit dashboard with animated maps. Python scikit-learn Prophet Streamlit

Canada Hate Crime Dashboard Interactive D3.js dashboard visualizing police-reported hate crimes across Canadian provinces (2014–2023), built on Statistics Canada data — geospatial map, time-series trends, and comparative views.🔗 Live Demo: https://ayseguldahi.github.io/canada-hate-crime-dashboard/ JavaScript D3.js HTML/CSS

Canadian Unemployment Analysis Machine learning analysis of Canadian unemployment trends, with insights on pandemic impact and differences by gender, age, and education. Python Jupyter Random Forest Ridge KNN

Climate Trends NLP Scrapes and analyzes Reddit discussions on climate change using Playwright and GPT models — extracting summaries, sentiment, and emerging topics. Python Playwright NLP LLM APIs

Also on my profile: a Power BI sales & profitability dashboard and a Tableau sales & shipping cost analysis.

Skills & Tools

  • Languages: Python, SQL, JavaScript
  • Data & ML: pandas, scikit-learn, Prophet, NLP
  • Visualization & BI: Tableau, Power BI, D3.js, Streamlit, Matplotlib
  • Databases: PostgreSQL, MongoDB
  • Other: Git/GitHub, Jupyter, web scraping (Playwright)

Contact

Pinned Loading

  1. bc-electoral-geography-analysis bc-electoral-geography-analysis Public

    A PostgreSQL/PostGIS analysis of British Columbia's electoral geography: spatial assignment of locations to electoral districts, the impact of the 2023 electoral redistribution (87 → 93 districts),…

  2. bc-surgical-wait-times-analysis bc-surgical-wait-times-analysis Public

    PostgreSQL + Python analysis of 16 years of BC surgical wait times. Window functions, data-quality auditing, and hypothesis testing reveal that post-pandemic improvements reached the median patient…

    Jupyter Notebook

  3. canada-hate-crime-dashboard canada-hate-crime-dashboard Public

    Interactive D3.js dashboard visualizing hate crimes in Canada (2014–2023) with maps, line charts, and comparative visualizations.

    HTML

  4. canadian-unemployment-analysis-ml canadian-unemployment-analysis-ml Public

    Forecasting Canadian unemployment trends using machine learning (Random Forest, Ridge, KNN, etc.) with insights on pandemic impact, gender, age, and education.

    Jupyter Notebook

  5. climate-trends-nlp climate-trends-nlp Public

    Scrapes and analyzes Reddit posts about climate change using Playwright and GPT models. Extracts summaries, sentiment, and trends to reveal how climate is discussed online. Ideal for researchers, j…

    Python 1

  6. climate-forecast-canada climate-forecast-canada Public

    Forecasting CO₂, temperature, and sea ice loss in Canada using ML & time-series models (1968–2030)

    Python