novsto

Home
Archive
About
When to take a shower during war time
How I created a Tableau dashboard analyzing when rocket alarms are more and less likely to disturb people in Israel, using Pikud HaOref's data, Excel…
Account Takeover: Fraud Series #1
Pattern Analysis; Bonus- SQL: DATEDIFF, TIME ZONE, LAG & more.

September 2023

The ultimate office space playlist: The data way
SQL: INTERSECT (and how UNION is different); Excel: Get data from JSON file
SQL Tic Tac Toe Challenge
Find the winning move with SQL, for any combination!

June 2023

Tibia SQL Data Analysis: Practice #3
SQL, Excel, Tableau
Tibia SQL Data Analysis: Practice #2
SQL, Excel, Tableau
Tibia SQL Data Analysis: Practice #1
SQL, Excel, Tableau

April 2023

SEO boost: Analyzing My Website's Google Search Performance Report (April 2023)
SQL, Excel (analysis), Excel (visualization)
Happy Unicorns? One Billion+ StartUps and the UN's World Happiness Report
SQL (analysis) & Excel (visualizations)

December 2020

Data-based Decision-making Tool for Proportionality Appraisals in Israeli Targeted Killing Operations (sneak peek)
Sneak peek: Data-based decision making tool for proportionality assessments in Israeli targeted killing operations. (Security Studies Review…

August 2020

Spotting the 2018 R9X Libya Strike - Reconstructing the Data Analysis & Research Process in Hindsight
16 August 2020
U.S. Police Kills, African-Americans v. Others
originally posted: 7 June 2020 on my personal website; Excel-only. Useful as a reference to visualizations & message-conveying improvement throughout…
© 2024 Shahaf Rabi
Privacy ∙ Terms ∙ Collection notice
Start WritingGet the app
Substack is the home for great culture