Link Analysis with Spreadsheets: Identify Nodes of Interest Without a Graph Tool
Three powerful formulas to identify which nodes to look at first. Full method and workbook included.
Hello from the OJ Team,
This week we continue with spreadsheets. Whether you are looking at disinformation networks or suspicious transactions, these formulas will help you identify nodes of interest without using graph tools like Gephi.
Plus, the latest OSINT job opportunities, tradecraft tips and industry news.
Three formulas that count mentions in both directions: who mentions the most, and who gets mentioned the most.
Missed Last Week?
Job Opportunities
OSINT Investigator, RedPoints, Spain | Read the full listing here
Security Specialist I&A, International SOS, UK | Read the full listing here
OSINT Tradecraft Tips & Industry News
Everything you need to know from the past seven days.
The OSINT tool company ShadowDragon compiled a list of of 45+ OSINT resources by investigation stage, covering both free and paid resources | access the list here
The OSINT Output’s latest blog post argues OSINT success depends on critical thinking and diverse backgrounds more than on any specific college major, though technical foundation and hands-on practice remains essential | read the blog post here
Tom Jarvis argues on his blog that Google Earth Pro’s shift to web-only threatens OSINT workflows because the web version may not preserve complex case files and the local investigative control some depend on | read the full post on his blog
From the OSINT Jobs Team: Google offers step-by-step tutorials for working with maps, e.g. annotating maps, creating image overlays, adding legends, and narrated tours in Earth Desktop and Web | explore all tutorials here
Nico Dekens argues for the AI Journal that AI accelerates OSINT collection, but human critical thinking is now essential for verifying information amid rising synthetic content and adversarial manipulation | read the full article
Identify Nodes of Interest with Spreadsheets
Documenting events of interest is one of the most common OSINT tasks. An event can be anything from a social media post, transaction or an event in a war zone.
This week, we show you how to use spreadsheets for such a task with an analytical layer on top to help you identify nodes of interest.
