The model comes first, the chart second
Most disappointing dashboards fail below the surface. The visuals were fine, but each one pulled from a different extract with its own idea of what revenue, a customer or an overdue invoice means. So we start with definitions. We sit with finance, sales and operations, write down each measure in plain language, and only then build a star-schema model that every report reads from. A change to a definition happens once, in the model, and every dashboard follows.
The best source of truth is usually your ERP and CRM, joined to the invoice data that already passes through ZATCA e-invoicing. Invoices carry the tax figures and the buyer details finance has to defend anyway, so a sales dashboard reconciled to them survives an audit conversation. We connect to Odoo, SAP, Dynamics 365, Salesforce and HubSpot through their official interfaces, and to databases or flat files when that is what you have.
