Data Ingestion

Pipeline

Connect directly via API or import a file from any source

6 Agents

YTD IT Spend

$14.6M

++3.2% vs. budget

Cloud Spend

$2.4M

AWS · Azure · GCP

External Labor

$1.1M

12 contractors YTD

Headcount

16 / 26

7 open reqs

Critical Risks

5

13 total flags

Running in local mode (SQLite) — no Databricks credentials set. Add DATABRICKS_HOST, DATABRICKS_TOKEN, and DATABRICKS_HTTP_PATH to .env.local to connect to Databricks.

Ingest Financial DataConnected source · Import file

How would you like to bring in data?

Connect directly via API or upload a file from any source

Pipeline ReferenceWhat happens when you upload a file
1

Parse

CSV / Excel parsed into rows

2

Map

Fields mapped to Nexora data model

3

Clean

Dates, amounts, dupes, anomalies

4

Write

MERGE into fact_transactions / dims

5

Refresh

Dashboard pages reload live data

Supported Delta TablesData model populated by the ingestion pipeline

fact_transactions

All actuals, budgets, and forecasts by cost center and period

dim_vendor

Vendor contracts, spend, risk level, and renewal dates

dim_cost_center

Cost center master — name, BU, owner

dim_contractor

External labor engagements and burn rates

dim_headcount

Position roster, fill status, and salary budgets

data_quality_log

Audit trail of all cleaning actions per ingestion run