Odoo data marts
A data warehouse and data marts for Odoo, built with Putki: sales, invoices, the CRM pipeline, projects and timesheets, accounting, purchases and stock, in a dimensional model that keeps history and is checked against Odoo on every load.
Sign in with any Google account. We keep a record of who signs in and when, to see who uses the demo; nothing else about you.
Nine dashboards
One per data mart, and one for problems in Odoo's own data. Every dashboard has a Company filter; amounts are untaxed and in one reporting currency unless a panel says otherwise.
Sales
Quotations and orders, revenue, margin, conversion, top customers and productsInvoicing
Invoiced revenue, credit notes, open and overdue receivables, agingPipeline
Open and weighted pipeline, win rate, lost reasonsProjects
Hours logged, open and overdue tasks, milestones, the daily backlogProject profitability
What is sold, invoiced and spent per projectAccounting
Profit and loss, balances, cash, payables and their agingPurchase
Purchases, receipts on time, orders still to receive or billInventory
Stock on hand and its value, moves, transfers on timeData quality
Customers without a country, duplicates, orders below cost, and a worklist of the recordsHow it is built
- Odoo
JSON-2 APIRead-only; only what changed since the last load - Staging
odoo_stagingOdoo's records as they are - Warehouse
odoo_warehouseDimensions that keep history, facts per process - Data marts
odoo_datamartsViews per subject, the interface for every tool - Grafana
/dashboardsOr any SQL client
- History. When a customer moves country or a product changes category, the warehouse keeps a new version. Last year's sales stay with last year's details.
- Checked on every load. The marts against staging, and each month's totals against Odoo's own Sales, Invoice and Purchase Analysis, timesheet hours and opportunities. A load that does not match fails, and the dashboards keep the last good data.
- Several companies and currencies. Amounts in each company's own currency and in one reporting currency, converted the way Odoo converts.
The demo data
Odoo 19's demo database with 18 months of history added through Odoo's own business logic: salespeople and customers in several countries, orders, invoices and payments, opportunities won and lost, timesheets, purchases and receipts, stock, expenses, and a second company in euros. It is not a real company. The dashboards show a snapshot of it: overdue, expired and aging are measured against the day the snapshot was taken, so the figures do not move.
Every view and column is described in the data dictionary.