How lvgalvao/imersaocontroltower works
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: App.tsx App navigation · ProjetosPage.tsx Risk portfolio · SimuladorPage.tsx Staffing simulator · decisoes.ts Decision API
Components 24
Data generation
- Dataset generator
material/gerar_dataset.py - XLSX and PDF writers
material - Project and business files
Lakehouse analytics
- Bronze setup
aulas/aula-01-analista-sql/00-carregar-dados.py - Bronze tables
- Unified silver
- Gold KPIs
- Metric views
Risk and answers
- Overrun model
aulas/aula-03-modelagem-claude-code/claude-code/vertice/src/ml - Contract analysis
aulas/aula-04-produtos-de-dados-ia/bonus/agente - Genie answers
aulas/aula-03-modelagem-claude-code/claude-code/vertice/scripts/gerar_genie.py
Control tower app
- App startup
aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/main.tsx - App navigation
aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/App.tsx - Risk portfolio
aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/projetos/ProjetosPage.tsx - Staffing simulator
aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/simulador/SimuladorPage.tsx - Decision history
aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/decisoes/DecisoesPage.tsx - Ask Genie page
aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/genie/GeniePage.tsx - App API server
aulas/aula-04-produtos-de-dados-ia/torre-app/server/server.ts - Decision API
aulas/aula-04-produtos-de-dados-ia/torre-app/server/routes/decisoes.ts - Score API
aulas/aula-04-produtos-de-dados-ia/torre-app/server/routes/score.ts - Lakebase decisions
- Databricks AppKit services
- Display utilities
aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/lib/dados.ts
Other components
- Business owner
Connections 28
- Dataset generator → XLSX and PDF writers: writes files
material/gerar_dataset.py - Dataset generator → Project and business files: generates
- Project and business files → Bronze setup: loads files
aulas/aula-01-analista-sql/00-carregar-dados.py - Bronze setup → Bronze tables: creates
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
aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/main.tsx - App navigation → Risk portfolio: routes to
aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/App.tsx - App navigation → Staffing simulator: routes to
aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/App.tsx - App navigation → Decision history: routes to
aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/App.tsx - App navigation → Ask Genie page: routes to
aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/App.tsx - Risk portfolio → Display utilities: formats values
aulas/aula-04-produtos-de-dados-ia/torre-app/client/src/pages/projetos/ProjetosPage.tsx - Staffing simulator → Display utilities: formats values
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
aulas/aula-04-produtos-de-dados-ia/torre-app/server/server.ts - App API server → Score API: registers route
aulas/aula-04-produtos-de-dados-ia/torre-app/server/server.ts - Decision API → Lakebase decisions: reads and writes
aulas/aula-04-produtos-de-dados-ia/torre-app/server/routes/decisoes.ts - App API server → Databricks AppKit services: configures plugins
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