Operations and Asset Management
Plan and track maintenance, failures and work orders by asset.
Solution
Data and Reporting
Data and reporting means combining data from ERP, the data warehouse, business intelligence tools and field applications in a single self-service layer to give managers timely and consistent reports.
Organizations that trust Butterfly
Today
With Butterfly
ERP, database and Excel sources are combined in a single data model; on Excel import only the column names are used as a template, and data transformation runs through the platform’s own flows.
OutcomeManual merging and version confusion end; every time a report opens, it pulls from the current source.A storage and query layer optimized for time series data is set up; heavy calculations are prepared in advance.
OutcomeAt a transportation operator, a query that took 30 minutes dropped to 3 seconds.Reports are generated automatically by a scheduled job and sent to a subscriber list; an alert is raised when a threshold is crossed.
OutcomeThe reporting team has time for analysis; alerts aren’t late.Dashboards drill down from 'total → who → what'; clicking a number in a report opens the related records, and actions such as sending a record for approval or opening a task are taken on the same screen.
OutcomeYou move from monitoring to acting; reports become tools for decisions and action.A scope band on the screen shows which records are counted and which are left out; filter rules are managed through settings, not code.
OutcomeThe debate shifts from discrepancies to rules; you can see where each number comes from.The process end to end
One flow, 6 steps.
Every step moves forward on the same record; who did what and when is visible at all times.
ButterflyData and ReportingRecordSample record · #2048
Step 1 / 6In this step · 1 / 6
Connect the sources
ERP, data warehouse/cube, relational databases, field and HR applications
In this step · 2 / 6
Define the data model and business rules (calculated fields, score and target formulas)
In this step · 3 / 6
Build self-service dashboards and reports; grant role- and row-level permissions
In this step · 4 / 6
Turn on scheduled reports and threshold alerts
In this step · 5 / 6
Move from report to action
drill into the record, send for approval, open a task
In this step · 6 / 6
Export and share
Excel/PDF, subscription emails
Building blocks
This solution is built with these parts of the platform.
Butterfly connects to your existing sources; it builds its own data warehouse when needed, reads directly from the source when needed, and lets you move from report to action on the same screen.
From the field
Results measured in the field.
Figures from this solution’s use in the field. Customer names are not shared for confidentiality reasons.
30 min → 3 secreport query time after time series optimizationtransportation
11database adapters; connect to multiple databases at once from a single installationplatform
Frequently asked
Data and Reporting in brief.
Do we have to build a data warehouse for reporting?
No. Butterfly works in a hybrid way. It builds its own data warehouse when needed, or reads directly from your existing database or data warehouse cubes.
When we upload Excel files, does our data go to an AI model?
No. When building the data model, only the Excel column names are used as a template. The data itself is processed inside the platform through transformation flows.
Do changes in the ERP show up in reports automatically?
Yes. Because the report reads from the source, an update made in the ERP shows up in the report automatically. No separate report refresh is needed.
Can you move our existing dashboards to Butterfly?
Yes. Dashboards can be rebuilt by connecting to your existing database. During the move, filter rules are carried over exactly, along with the screens.