Cost Analysis & Home BI

The final layer of the Digital Twin architecture is a Business Intelligence (BI) layer. This system aggregates financial data directly from Obsidian’s Markdown files and visualizes it inside the Astro Starlight interface.

Financial Data Schema

Every asset establishes cost properties to allow programmatic calculation in its YAML frontmatter:

---
purchase_price: 1200.50
currency: "EUR"
purchase_date: "2026-04-17"
expense_category: "Electronics" # Other options: Furniture, Renovation, Infrastructure
---

Aggregation & Visualization in Astro

1. Inventory Summation: A script traverses Content Collections, summing the purchase_price and filtering by tags, categories, or location.
2. Room Investment Summary: Selecting a room in the 3D viewer or sidebar displays the total investment accumulated in that space.
3. Inventory Dashboard: A global overview showing the total inventory value of the property.
4. Structure vs. Content: Differentiates between ‘Structural/Renovation Investment’ (Room notes) and ‘Content Investment’ (Device notes).

Use Cases

• Insurance & Claims: In the event of an incident, a 3D-linked inventory with serial numbers, photos, and exact invoices is ready to export for insurance adjusters.
• Budgeting & Planning: Visualize which rooms have consumed the most budget and plan renovations based on historical cost data.
• ROI Tracking: A custom component calculates the ROI of systems (like Photovoltaic panels) by comparing installation costs against estimated monthly savings.

With this layer, the “Home Operating Manual” becomes architecturally complete: Geometry (BIM) + Technical Specs (Markdown) + Visualization (Speckle/Astro) + Financial Control (BI).