The Power BI dashboard is the primary analytical deliverable of the Archaios Data Intelligence (A.D.I.) project. It is structured as three chronological pages — 1943–1944, 1 A 5 JUNIO, and DIA-D — each backed by its own dedicated table in the A.D.I. master semantic model (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.
adi_master_1943_1944, adi_master_1_5_junio, and adi_dataset_master respectively). The semantic model is defined in the desembarco_normandia_dashboard.SemanticModel folder for Microsoft Fabric deployment, but for day-to-day analytical use the report is distributed as wwii_analisys_dashboard.pbix, opened directly in Power BI Desktop.
Opening the Dashboard
Open the .pbix file
Launch Power BI Desktop and open
wwii_analisys_dashboard.pbix from the root of the cloned repository.Wait for data refresh
The report loads data from the three local CSVs at the repository root:
adi_master_1943_1944_CLEAN.csv, adi_master_1_5_junio.csv, and adi_dataset_master.csv. Allow the automatic refresh to complete before interacting with any visual.Switch between the three views
Use the page tabs at the bottom of the Power BI Desktop window to navigate between 1943–1944, 1 A 5 JUNIO, and DIA-D.
Dashboard Pages
1943–1944 Panorama
Strategic overview of Allied bombing across the European and Mediterranean theatres from August 1943 through June 5, 1944. Identifies macro-objectives and high-concentration impact zones for archaeological prioritisation.
June 1–5, 1944
Detailed analysis of the five-day logistical softening phase immediately before the Normandy landings — targeting bridges, rail yards, and supply routes to isolate the beaches.
D-Day (June 6)
Mission-level breakdown of every recorded Allied air operation on June 6, 1944, enriched with A.D.I.’s
weapon_type classification for ordnance profiling.Cross-Filter Interactions
Every visual on a dashboard page participates in Power BI’s native cross-filter engine. Clicking a city on the map propagates a filter to all charts on that page — the mission-count bar chart, the target-type distribution, and the tonnage timeline all respond instantly to the geographic selection. Conversely, selecting an aircraft type in a slicer narrows both the map markers and the tonnage charts to only those missions flown by that aircraft series. Cross-filter behaviour is bidirectional between the master semantic model tables: a selection in any visual derived fromadi_master_1943_1944 will cascade through all other visuals on the 1943–1944 page, and the same principle applies to adi_master_1_5_junio on its page and adi_dataset_master on the D-Day page. Because each page is bound to a single table, cross-page filtering is not automatic — use the page tabs to move between temporal contexts.
Power BI Version Notes
Thewwii_analisys_dashboard.pbix file is the self-contained Power BI Desktop format and is the recommended entry point for local analysis. The desembarco_normandia_dashboard.Report and desembarco_normandia_dashboard.SemanticModel folders are Microsoft Fabric item definitions (JSON/TMDL) intended for deployment to a Fabric workspace or a Power BI Premium capacity. These Fabric definitions expose the full semantic model — column lineage tags, measure DAX, and relationship graphs — but cannot be opened directly in Power BI Desktop. For any local analytical work, always open the .pbix file.