Archaios Data Intelligence (A.D.I.) applies modern data science to historical WWII records, turning the U.S. Department of Defense’s THOR dataset into an interactive intelligence platform. This documentation covers the full project — from raw CSV ingestion and EDA, to Power BI dashboards that guide archaeological teams to high-yield excavation zones in Normandy.Documentation Index
Fetch the complete documentation index at: https://mintlify.com/HelenDiMo/archaios-data-Intelligence/llms.txt
Use this file to discover all available pages before exploring further.
Introduction
Understand the project mission, methodology, and how A.D.I. applies data intelligence to military archaeology.
Quickstart
Clone the repo, install Power BI Desktop, and open the dashboard in under five minutes.
Data Model
Explore the THOR datasets, ADI master tables, and the Power BI semantic model schema.
Dashboard Guide
Navigate the three dashboard views — 1943–1944 panorama, June 1–5 softening, and D-Day.
What is Archaios Data Intelligence?
A.D.I. is an analytical consultancy that applies data science to contemporary archaeology. This project transforms digitised Allied aerial bombing records (1943 – June 6, 1944) into a geospatial intelligence model for archaeological prospection across the Normandy theatre. By analysing mission density, bomb tonnage, and target-type distributions, the platform helps archaeological directors identify zones with the highest probability of buried material remains — destroyed bunkers, aircraft fuselages, impact craters, and logistics debris — while minimising prospection costs and mapping unexploded ordnance (UXO) risk.Get Up and Running
Install Power BI Desktop
Download the free Power BI Desktop from Microsoft. No paid licence is required to view and explore the dashboard.
Open the dashboard
Launch Power BI Desktop and open
wwii_analisys_dashboard.pbix from the repository root. The report loads the three ADI master CSV files automatically.Key Capabilities
Geospatial Heat Maps
Interactive maps plot every recorded Allied bombing mission across France, filterable by date, aircraft type, and target city with kilometre-level precision.
Temporal Analysis
Three dashboard views cover the full 1943–1944 campaign arc: the strategic panorama, the five-day pre-D-Day softening phase, and the June 6 assault.
Archaeological Scoring
Target-type classification (airdromes, city areas, transport nodes) provides a scientific basis for prioritising excavation investment.
UXO Risk Mapping
Bomb tonnage density surfaces high-risk zones for unexploded ordnance, a critical safety factor for field teams.
60+ Data Fields
Each mission record in the THOR dataset carries over 60 fields — aircraft series, coordinates, altitude, weapon types, and damage assessment.
Reproducible Pipeline
A Jupyter notebook documents every EDA step from raw CSV ingestion through cleaning, enrichment, and the final master dataset.