# lvgalvao/imersaocontroltower architecture

> Architecture diagram of the GitHub repository lvgalvao/imersaocontroltower, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-18). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/lvgalvao/imersaocontroltower
- Repository: https://github.com/lvgalvao/imersaocontroltower

## Overview

Projeto Farol is a Databricks training repository whose product workflow turns heterogeneous project, workforce, finance, and contract data into a control-tower app: generate/load source data, curate lakehouse tables, calculate portfolio and risk metrics, expose them through dashboards/Genie, then simulate and record staffing decisions. The README documents ingestion, silver/gold, metric views, a 30-day overrun model, contract analysis, Genie, and Lakebase; several of these implementations are unsampled, so those branches are shown only at documented subsystem level. Sampled app routes confirm decision persistence and score access; UI/API wiring beyond indexed imports is not inferred.

Main entry points: [`aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/App.tsx`](https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/App.tsx) (App navigation), [`aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/projetos/ProjetosPage.tsx`](https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/projetos/ProjetosPage.tsx) (Risk portfolio), [`aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/simulador/SimuladorPage.tsx`](https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/simulador/SimuladorPage.tsx) (Staffing simulator), [`aulas/aula-04-produtos-de-dados-ia/torre-app/server/routes/decisoes.ts`](https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/server/routes/decisoes.ts) (Decision API)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Data generation"]
  node_generator["Dataset generator<br/>[gerar_dataset.py]"]
  node_formats["XLSX and PDF writers"]
  node_sources["Project and business files"]
end

subgraph group_lakehouse["Lakehouse analytics"]
  node_load["Bronze setup"]
  node_bronze[("Bronze tables")]
  node_silver[("Unified silver")]
  node_gold[("Gold KPIs")]
  node_metric["Metric views"]
end

subgraph group_insights["Risk and answers"]
  node_ml["Overrun model"]
  node_contracts["Contract analysis"]
  node_genie["Genie answers<br/>[gerar_genie.py]"]
end

subgraph group_app["Control tower app"]
  node_entry["App startup<br/>[main.tsx]"]
  node_router["App navigation<br/>[App.tsx]"]
  node_projects["Risk portfolio<br/>[ProjetosPage.tsx]"]
  node_simulator["Staffing simulator<br/>[SimuladorPage.tsx]"]
  node_decisions["Decision history<br/>[DecisoesPage.tsx]"]
  node_ask["Ask Genie page<br/>[GeniePage.tsx]"]
  node_server["App API server<br/>[server.ts]"]
  node_decisionapi["Decision API<br/>[decisoes.ts]"]
  node_scoreapi["Score API<br/>[score.ts]"]
  node_lakebase[("Lakebase decisions")]
  node_appkit["Databricks AppKit services"]
  node_helpers["Display utilities<br/>[dados.ts]"]
end

node_owner(("Business owner"))

node_generator -->|"writes files"| node_formats
node_generator -->|"generates"| node_sources
node_sources -->|"loads files"| node_load
node_load -->|"creates"| node_bronze
node_bronze -.->|"curates into"| node_silver
node_silver -.->|"builds"| node_gold
node_gold -.->|"defines KPIs"| node_metric
node_gold -.->|"trains scores"| node_ml
node_gold -.->|"supports analysis"| node_contracts
node_gold -.->|"answers over"| node_genie
node_entry -->|"renders"| node_router
node_router -->|"routes to"| node_projects
node_router -->|"routes to"| node_simulator
node_router -->|"routes to"| node_decisions
node_router -->|"routes to"| node_ask
node_projects -->|"formats values"| node_helpers
node_simulator -->|"formats values"| node_helpers
node_owner -.->|"reviews risks"| node_projects
node_owner -.->|"plans staffing"| node_simulator
node_server -->|"registers routes"| node_decisionapi
node_server -->|"registers route"| node_scoreapi
node_decisionapi -->|"reads and writes"| node_lakebase
node_server -->|"configures plugins"| node_appkit
node_projects -.->|"fetches score"| node_scoreapi
node_simulator -.->|"submits decision"| node_decisionapi
node_decisions -.->|"loads history"| node_decisionapi
node_ask -.->|"asks questions"| node_genie
node_owner -.->|"approves actions"| node_decisions

click node_generator "https://github.com/lvgalvao/imersaocontroltower/blob/main/material/gerar_dataset.py"
click node_formats "https://github.com/lvgalvao/imersaocontroltower/tree/main/material"
click node_load "https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-01-analista-sql/00-carregar-dados.py"
click node_ml "https://github.com/lvgalvao/imersaocontroltower/tree/main/aulas/aula-03-modelagem-claude-code/claude-code/vertice/src/ml"
click node_contracts "https://github.com/lvgalvao/imersaocontroltower/tree/main/aulas/aula-04-produtos-de-dados-ia/bonus/agente"
click node_genie "https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-03-modelagem-claude-code/claude-code/vertice/scripts/gerar_genie.py"
click node_entry "https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/main.tsx"
click node_router "https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/App.tsx"
click node_projects "https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/projetos/ProjetosPage.tsx"
click node_simulator "https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/simulador/SimuladorPage.tsx"
click node_decisions "https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/decisoes/DecisoesPage.tsx"
click node_ask "https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/genie/GeniePage.tsx"
click node_server "https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/server/server.ts"
click node_decisionapi "https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/server/routes/decisoes.ts"
click node_scoreapi "https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/server/routes/score.ts"
click node_helpers "https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/lib/dados.ts"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_generator,node_formats,node_sources toneBlue
class node_load,node_bronze,node_silver,node_gold,node_metric toneAmber
class node_ml,node_contracts,node_genie toneMint
class node_entry,node_router,node_projects,node_simulator,node_decisions,node_ask,node_server,node_decisionapi,node_scoreapi,node_lakebase,node_appkit,node_helpers toneRose
class node_owner toneIndigo
```

## Components

### Data generation

- [Dataset generator](https://github.com/lvgalvao/imersaocontroltower/blob/main/material/gerar_dataset.py): `material/gerar_dataset.py`
- [XLSX and PDF writers](https://github.com/lvgalvao/imersaocontroltower/tree/main/material): `material`
- **Project and business files**

### Lakehouse analytics

- [Bronze setup](https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-01-analista-sql/00-carregar-dados.py): `aulas/aula-01-analista-sql/00-carregar-dados.py`
- **Bronze tables**
- **Unified silver**
- **Gold KPIs**
- **Metric views**

### Risk and answers

- [Overrun model](https://github.com/lvgalvao/imersaocontroltower/tree/main/aulas/aula-03-modelagem-claude-code/claude-code/vertice/src/ml): `aulas/aula-03-modelagem-claude-code/claude-code/vertice/src/ml`
- [Contract analysis](https://github.com/lvgalvao/imersaocontroltower/tree/main/aulas/aula-04-produtos-de-dados-ia/bonus/agente): `aulas/aula-04-produtos-de-dados-ia/bonus/agente`
- [Genie answers](https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-03-modelagem-claude-code/claude-code/vertice/scripts/gerar_genie.py): `aulas/aula-03-modelagem-claude-code/claude-code/vertice/scripts/gerar_genie.py`

### Control tower app

- [App startup](https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/main.tsx): `aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/main.tsx`
- [App navigation](https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/App.tsx): `aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/App.tsx`
- [Risk portfolio](https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/projetos/ProjetosPage.tsx): `aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/projetos/ProjetosPage.tsx`
- [Staffing simulator](https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/simulador/SimuladorPage.tsx): `aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/simulador/SimuladorPage.tsx`
- [Decision history](https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/decisoes/DecisoesPage.tsx): `aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/decisoes/DecisoesPage.tsx`
- [Ask Genie page](https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/genie/GeniePage.tsx): `aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/genie/GeniePage.tsx`
- [App API server](https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/server/server.ts): `aulas/aula-04-produtos-de-dados-ia/torre-app/server/server.ts`
- [Decision API](https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/server/routes/decisoes.ts): `aulas/aula-04-produtos-de-dados-ia/torre-app/server/routes/decisoes.ts`
- [Score API](https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/server/routes/score.ts): `aulas/aula-04-produtos-de-dados-ia/torre-app/server/routes/score.ts`
- **Lakebase decisions**
- **Databricks AppKit services**
- [Display utilities](https://github.com/lvgalvao/imersaocontroltower/blob/main/aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/lib/dados.ts): `aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/lib/dados.ts`

### Other components

- **Business owner**

## Connections

- Dataset generator → XLSX and PDF writers: writes files (evidence: `material/gerar_dataset.py`)
- Dataset generator → Project and business files: generates
- Project and business files → Bronze setup: loads files (evidence: `aulas/aula-01-analista-sql/00-carregar-dados.py`)
- Bronze setup → Bronze tables: creates (evidence: `aulas/aula-01-analista-sql/00-carregar-dados.py`)
- Bronze tables → Unified silver: curates into
- Unified silver → Gold KPIs: builds
- Gold KPIs → Metric views: defines KPIs
- Gold KPIs → Overrun model: trains scores
- Gold KPIs → Contract analysis: supports analysis
- Gold KPIs → Genie answers: answers over
- App startup → App navigation: renders (evidence: `aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/main.tsx`)
- App navigation → Risk portfolio: routes to (evidence: `aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/App.tsx`)
- App navigation → Staffing simulator: routes to (evidence: `aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/App.tsx`)
- App navigation → Decision history: routes to (evidence: `aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/App.tsx`)
- App navigation → Ask Genie page: routes to (evidence: `aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/App.tsx`)
- Risk portfolio → Display utilities: formats values (evidence: `aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/projetos/ProjetosPage.tsx`)
- Staffing simulator → Display utilities: formats values (evidence: `aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/simulador/SimuladorPage.tsx`)
- Business owner → Risk portfolio: reviews risks
- Business owner → Staffing simulator: plans staffing
- App API server → Decision API: registers routes (evidence: `aulas/aula-04-produtos-de-dados-ia/torre-app/server/server.ts`)
- App API server → Score API: registers route (evidence: `aulas/aula-04-produtos-de-dados-ia/torre-app/server/server.ts`)
- Decision API → Lakebase decisions: reads and writes (evidence: `aulas/aula-04-produtos-de-dados-ia/torre-app/server/routes/decisoes.ts`)
- App API server → Databricks AppKit services: configures plugins (evidence: `aulas/aula-04-produtos-de-dados-ia/torre-app/server/server.ts`)
- Risk portfolio → Score API: fetches score
- Staffing simulator → Decision API: submits decision
- Decision history → Decision API: loads history
- Ask Genie page → Genie answers: asks questions
- Business owner → Decision history: approves actions
