Data Warehouse Console
Unified data storage and analytics
Live Data Mode
Businesses
0
Revenue Records
0
Expense Records
0
Labor Records
0
Inventory Records
0
Debt Records
0
Total Records
0
Last Successful ETL Run
Never - run ETL to populate warehouse
Revenue & Profit Trend (6 Months)
No data available yet. Add jobs, expenses, or timesheets to see analytics.
Labor vs Operating Expenses
No data available yet. Add jobs, expenses, or timesheets to see analytics.
Business Revenue Distribution
No business data available
Business Performance Summary
No business data available
AI Integration Ready
The Data Warehouse exposes unified snapshots for AI analysis. Use the endpoints:
GET /api/warehouse/ai/snapshotComplete business data snapshot
GET /api/warehouse/ai/summaryQuick risk assessment
GET /api/warehouse/ai/promptFormatted data for AI prompts
Available Data Cubes
Revenue Cube
/cube/revenueExpense Cube
/cube/expensesLabor Cube
/cube/laborInventory Cube
/cube/inventoryDebt Cube
/cube/debt