ions/
├── @plan/                              # Planning docs (not a workspace package)
│   ├── architecture.md
│   ├── analytics.md                    # DuckDB, dbt layers, mart definitions
│   ├── glossary.md
│   ├── model.md
│   ├── registry.md
│   ├── domains/
│   └── discussions/
│
├── @repo/                              # Shared infra packages
│   ├── typescript/                     # Shared tsconfig presets
│   └── lint/                           # Shared ESLint flat config
│
├── @packages/                          # Business-logic packages
│   ├── db/                             # Drizzle schema + migrations (operational layer)
│   │   ├── @source/
│   │   │   ├── schema/
│   │   │   │   ├── core.ts             # core_group, core_entity, core_unit
│   │   │   │   ├── db.ts               # db_person, db_organization, db_account, db_relation
│   │   │   │   ├── catalog.ts          # catalog_brand, catalog_item, catalog_item_variant, pricing
│   │   │   │   ├── commerce.ts         # commerce_order + lookups
│   │   │   │   ├── finance.ts          # finance_transaction + lookups
│   │   │   │   ├── marketing.ts        # marketing_channel, marketing_agenda, marketing_activity
│   │   │   │   └── target.ts           # target_item, target_metric
│   │   │   ├── client.ts               # LibSQL client + Drizzle instance
│   │   │   └── index.ts
│   │   ├── drizzle.config.ts
│   │   ├── migrations/
│   │   └── package.json
│   │
│   ├── sync/                           # Extract + Load layer
│   │   ├── @source/
│   │   │   ├── adapters/
│   │   │   │   ├── base.ts             # Abstract SyncAdapter interface
│   │   │   │   └── xlsx.ts             # XlsxAdapter — loads raw rows into DuckDB
│   │   │   ├── duck.ts                 # DuckDB connection + raw layer setup
│   │   │   ├── seed.ts                 # Seeds LibSQL lookup tables from registry
│   │   │   └── index.ts
│   │   └── package.json
│   │
│   ├── transform/                      # dbt project — analytical transform layer
│   │   ├── models/
│   │   │   ├── staging/                # stg_* — clean and rename raw columns
│   │   │   │   ├── stg_transactions.sql
│   │   │   │   ├── stg_students.sql
│   │   │   │   └── stg_organizations.sql
│   │   │   ├── intermediate/           # int_* — join, classify, resolve FKs
│   │   │   │   ├── int_orders.sql
│   │   │   │   └── int_enrollments.sql
│   │   │   └── marts/                  # mart_* — analysis-ready aggregations
│   │   │       ├── mart_revenue.sql
│   │   │       ├── mart_program_progress.sql
│   │   │       ├── mart_channel_marketing.sql
│   │   │       └── mart_school_progress.sql
│   │   ├── tests/
│   │   ├── dbt_project.yml
│   │   ├── profiles.yml
│   │   ├── pyproject.toml              # uv project file
│   │   └── requirements.txt            # dbt-core, dbt-duckdb
│   │
│   └── format/                         # Format layer — marts -> report.json
│       ├── @source/
│       │   ├── sections/
│       │   │   ├── revenue.ts          # Reads mart_revenue
│       │   │   ├── orders.ts           # Reads mart_program_progress
│       │   │   ├── marketing.ts        # Reads mart_channel_marketing
│       │   │   └── schools.ts          # Reads mart_school_progress
│       │   ├── report.ts               # Assembles full report.json
│       │   └── index.ts
│       └── package.json
│
├── @services/                          # Deployable apps
│   ├── present/                        # PPTX + PDF generator
│   │   ├── @source/
│   │   │   ├── slides/
│   │   │   │   ├── cover.ts
│   │   │   │   ├── revenue-comparison.ts
│   │   │   │   ├── key-comparison.ts
│   │   │   │   ├── program-progress.ts
│   │   │   │   ├── school-progress.ts
│   │   │   │   └── channel-marketing.ts
│   │   │   ├── generator.ts
│   │   │   └── index.ts
│   │   └── package.json
│   │
│   └── dashboard/                      # TanStack Start web app
│       ├── src/
│       │   ├── routes/
│       │   │   ├── __root.tsx
│       │   │   ├── index.tsx
│       │   │   ├── _app.tsx
│       │   │   └── _app/
│       │   │       ├── revenue.tsx
│       │   │       ├── orders.tsx
│       │   │       ├── marketing.tsx
│       │   │       ├── schools.tsx
│       │   │       ├── students.$id.tsx
│       │   │       └── organizations.$id.tsx
│       │   ├── components/
│       │   └── styles.css
│       ├── app.config.ts
│       ├── vite.config.ts
│       ├── tsconfig.json
│       ├── components.json
│       └── package.json
│
├── source/                             # Raw xlsx files — untouched input data
├── output/                             # Generated reports — gitignored
│   ├── monthly/
│   └── weekly/
│
├── atlas.db                            # DuckDB file (analytical) — gitignored
├── atlas-ops.db                        # LibSQL file (operational) — gitignored
├── bun.lock
├── package.json
├── turbo.json
└── tsconfig.json

CREATE OR REPLACE TABLE raw_transactions AS
SELECT * FROM read_xlsx(
  'source/LAPORAN EVALUASI IONs 2026 TM-WLC.xlsx',
  sheet := 'FEBRUARI'
);

interface SyncAdapter {
  readonly source: string
  connect(): Promise<void>
  extractToRaw(db: DuckDBConnection, targetTable: string): Promise<void>
  disconnect(): Promise<void>
}

bun run sync --source xlsx --path source/ --entity IONS --year 2026
bun run sync --source odoo --entity EPN  # future

cd @packages/transform

uv run dbt run            # run all models
uv run dbt run --select marts
uv run dbt test           # run all tests
uv run dbt docs generate  # generate lineage docs

type Report = {
  meta: {
    entity: string        // e.g. "IONS"
    period: string        // e.g. "2026-02"
    generated_at: string  // ISO timestamp
    scope: string[]       // unit codes included
  }
  units: Record<string, UnitReport>
}

bun run format --entity IONS --period 2026-02
bun run format --entity IONS --period 2026-02 --unit TM,WLC_NON_ENGLISH

bun run present --report output/monthly/2026-02-report.json
bun run present --entity IONS --period 2026-02  # runs Format then Present

# Local development
DATABASE_URL=file:atlas-ops.db

# Remote (Turso)
DATABASE_URL=libsql://<db-name>.turso.io
TURSO_AUTH_TOKEN=<token>

bunx drizzle-kit generate   # generate migration from schema changes
bunx drizzle-kit migrate    # apply to database
bunx drizzle-kit push       # push schema directly to dev DB

// LibSQL — entity scoping at query layer
const orders = await db.select().from(commerceOrder)
  .where(eq(commerceOrder.entityId, entityId))

-- dbt — entity variable passed at runtime
SELECT * FROM stg_transactions
WHERE entity_code = '{{ var("entity") }}'

# Seed LibSQL lookup tables
bun run sync:seed --entity IONS

# Load xlsx into DuckDB raw layer
bun run sync --source xlsx --path source/ --entity IONS

# Run dbt transforms
cd @packages/transform && uv run dbt run

# Generate monthly report
bun run format --entity IONS --period 2026-02

# Generate PPTX + PDF
bun run present --entity IONS --period 2026-02

# Start dashboard
bun run dev --filter @services/dashboard