Ephraim Shochat

Business Data Analyst — Financial, Operational & BI Analytics

Data Analyst with practical experience building dashboards, SQL/Python pipelines, and analytical tooling from real and simulated datasets. Skilled in data modeling, KPI design, visualization, and reproducible workflows (pandas, Power BI, Looker Studio). Adept at translating business questions from finance, operations, and support into metrics and concise insights.

Skills & Tools

Core Tools & Languages

Python
SQL
Excel
Power BI
Looker

Libraries & Frameworks

Pandas
NumPy
Matplotlib
Seaborn
Streamlit

Databases & DWH

PostgreSQL
BigQuery
SQLite

Languages

Russian / Ukrainian (native)
Hebrew (fluent)
English (professional working proficiency)

Projects

Savings Plans Analysis Dashboard

Savings Plans Analysis Dashboard

Oct 2025

Processed 51K+ official savings-rate records into 1.1K clean analytical entries using Python
Built a two-page Looker Studio dashboard comparing banks, plans, and age groups with rate-volatility metrics
Found negative-yield programs (Yahav −5.5%) and confirmed overall market stability within ±0.1%

View Project

Business Scenario Calculator

Business Scenario Calculator

Oct 2025

Built a dynamic Google Sheets model simulating Base, Optimistic, and Pessimistic cases with monthly detail.
Automated revenue, OPEX, and tax flows with live XLOOKUP aggregation and summary dashboard
Visualized scenario outcomes through comparative Revenue, OPEX, and Net Income charts

View Project

Excel dashboard preview for customer support tickets

Customer Support Insights Dashboard

Oct 2025

Simulated one year of support activity (~50 K tickets) using Python (pandas, faker)
Built Excel dashboard with KPI pivots for escalation rate, channel load, and resolution speed
Identified stable volume but high escalation (~33 %), showing need to improve first-contact resolution

View Project

Streamlit loan amortization visualizer interface

Loan Repayment Comparison Tool

May 2025

Created Streamlit + Plotly app comparing annuity vs linear repayment models
Engineered pandas pipeline to clean and normalize Hebrew-labeled amortization data
Visualized principal-interest breakdowns and repayment curves for quick comparison

View Project

Power BI visuals showing Aliyah trends 2015-2023

Aliyah Trends Dashboard (2015–2023)

Jun 2024

Consolidated 2015–2023 immigration datasets with SQL; standardized schema and translated headers
Built Power BI dashboard showing aliyah by year, origin, and age group to reveal demographic shifts
Exported unified dataset as reusable CSV for future analysis

View Project