DataWarehouse BI

Centralizing data for reporting/BI — warehouse modeling, dashboards, star schemas.

Why we need this / what value this brings

Centralized, modeled data makes cross-cutting business questions ('revenue by category by month') answerable without ad hoc queries against production.

When to use this

Once querying the production DB directly for reporting starts to hurt performance or the questions being asked span too many tables to reason about live.

How to use or implement this

Start with a simple star schema (fact table = bookings, dimensions = users/services/providers) before reaching for a full warehouse platform.

Research questions

• At what data volume does Localz need a warehouse vs just querying Postgres read replicas?
• Star schema basics: facts (bookings) vs dimensions (users, services, locations).

---

Empty folder — drop notes, links, and findings here as you research.