top of page
photo_2025-11-28 15.12_edited.jpg

Welcome
to
Data Analytics Portfolio

From Raw Data to Meaningful Insights

I am a data analyst working at the intersection of BI dashboards and applied research analytics. My work combines Power BI, SQL, Python and GIS to turn complex, multi-source datasets into clear insights and decision-support tools.

 

Projects on this site span urban mobility safety, energy systems, e-commerce and product analytics — demonstrating applied analytical thinking across different domains and data types.

 

My approach: designing meaningful metrics, integrating heterogeneous data sources, and translating findings into actionable insights for decision-makers.

​

Tools:    Power BI · SQL · Python · Tableau · QGIS · dbt

Methods:  EDA · Multi-source Integration · Statistical Analysis · Dashboard Design

Featured Research Project

E-Scooter Safety Analytics · Israel & Tel Aviv (2013–2025)

​

A multi-phase longitudinal study integrating 12.5 years of national crash data (CBS Israel) with municipal GIS layers, rider surveys, and enforcement records into an interactive Power BI system for the Tel Aviv municipality.

 

Core analytical contribution: the study introduces a systematic framework for analyzing crash volume and severity as two distinct dimensions across multiple axes simultaneously — time, location, road conditions, demographics

and crash type. This approach reveals contrasting patterns that standard single-indicator analysis misses.

 

Key findings:

  · Crash volume and severity follow distinct, often opposing patterns

  · ES passengers face dramatically higher injury risk (~23% severity rate) vs. riders (~7.5%) — despite representing only 2.5% of those involved

  · Helmet law compliance rose from ~52% to ~70% after 2021 legislation, but passenger protection remains critically low

  · Official statistics capture only ~5% of real solo crash events

  · BI dashboards enable non-expert municipality staff to explore 13 years of crash data without technical assistance

 

The BI system was presented to Tel Aviv municipality and at the ISTRC Conference, Technion, January 2026.

​​​

               Power BI  ·  SQL  ·  Python  ·  QGIS  ·  Longitudinal Analysis  ·  Public Data  ·  Policy Analytics​​​​​

Phone

+972545332188

Follow Me

  • LinkedIn

Location: Haifa, Israel
Open to remote / hybrid roles · English working environment

© 2025 By Nina Garmash.
Powered and secured by Wix

bottom of page