KPI dashboards
One indicator, its source, the dashboard that comes out of it.
Each page starts from one KPI and from where its data really lives: an ERP on SQL Server, a CRM, a purchasing team's files, the PLCs of a line. It explains how the number is defined, what the dashboard shows, which data it needs and how to get there in Muvia, step by step.
Muvia: company data
Margins, sales, customers, receivables, stock and suppliers, from the databases, CRMs and files the company already uses.
- SQL Server · Management, finance and ESGA margin dashboard by customer and product, from an ERP on SQL ServerContribution margin by customer and product from the invoice lines of an ERP on SQL Server: the formula, the data to copy, the steps and common pitfalls.
- Salesforce · Management, finance and ESGA sales pipeline dashboard, from Salesforce opportunitiesTotal and weighted pipeline, stage conversion and target coverage from Salesforce opportunities, joined with the revenue recorded in the ERP.
- HubSpot · Management, finance and ESGChurn rate and customers at risk, from HubSpot companies, deals and ticketsCustomer churn, lost value and risk signals from HubSpot companies, deals and tickets: the definition, the data you need and the steps in Muvia.
- Oracle · Management, finance and ESGDSO and receivables aging, from the open items of an ERP on OracleCountback DSO and receivables aging by past-due bucket, from the open items of an ERP on an Oracle database, refreshed every morning.
- MySQL · Retail and consumer goodsDays of stock coverage per item, from an online shop's MySQL databaseDays of coverage per item and variant from the orders and stock of an online shop on MySQL, with a low-stock alarm that closes when the goods arrive.
- SharePoint · Logistics and supply chainSupplier OTIF, from goods-receipt logs in Excel on SharePointSupplier OTIF from goods-receipt logs kept in Excel in a SharePoint folder, with data rules that set aside impossible rows before they reach the ranking.
- PostgreSQL · Logistics and supply chainDemand forecast and its error, from sales history on PostgreSQLA demand forecast per item with a band, from sales history on PostgreSQL, and forecast error measured every week with WAPE and bias, item by item.
Muvia Industrial: machine data
OEE, failures and energy use, read from PLCs and line meters through an edge node.
- Siemens S7 · AutomotiveOEE per machine and shift, from the part counts and states of Siemens S7 PLCsOEE per machine and shift from the part counts and states of presses with Siemens S7 PLCs, read by an edge node: the data, the steps and counter pitfalls.
- OPC UA · Manufacturing and machineryMTBF and MTTR per machine, from the states and fault codes read over OPC UAMTBF, MTTR and availability per machine from the states and fault codes read over OPC UA by an edge node: definitions, data, steps and usual pitfalls.
- Modbus TCP · Manufacturing and machineryEnergy per line, shift and piece, from meters read over Modbus TCPkWh per line, shift and piece from energy meters and power analysers read over Modbus TCP, joined with pieces produced: registers, steps and pitfalls.
Bring us a question you can't answer today.
We start from a real question your business has and walk the path from source to dashboard with your systems, not a demo dataset.