Overview
Crimsafe is Australia's most trusted name in security screens, protecting homes for 30 years through a network of more than 190 authorised suppliers across Australasia. Behind the scenes, however, sales reporting was split across separate financial-year data models built over their MYOB Acumatica ERP, refreshed manually and increasingly difficult to maintain. Report Simple rebuilt the solution from the ground up, centralising Acumatica data in Google BigQuery and redeveloping the Power BI model to best practice. Crimsafe now has a single multi-year sales report that refreshes automatically twice a day, with accurate measures, richer filtering and drill-through to transaction-level detail.
Challenge
Before partnering with Report Simple, Crimsafe's sales reporting had grown organically over their MYOB Acumatica ERP and was showing its limits:
Fragmented Financial Years: Reporting was split across separate financial-year data models, making year-on-year comparison and long-term trend analysis difficult.
Manual Refreshes: Reports depended on staff manually refreshing the data, creating key-person dependency and the risk of decisions being made on out-of-date numbers.
Model Design Debt: Business logic was spread across DAX calculated columns, calculated tables and measures, making the model hard to maintain, validate and scale.
Generic Inquiry Dependency: Heavy reliance on Acumatica Generic Inquiries limited flexibility and made changes to the reporting structure slow and difficult.
Limited Detail and Dimensions: Users could not easily drill into the transactions behind reported figures, and restricted dimensions reduced the ability to filter and segment results.
Accuracy and Presentation Concerns: Key measures needed review to confirm they matched agreed business definitions, and inconsistent formatting undermined confidence in the reports.
Solution
Report Simple designed a layered reporting architecture spanning Google BigQuery and Power BI, placing each piece of logic in the layer where it belongs:
Centralised Data Warehouse: MYOB Acumatica data was extracted and loaded into Google BigQuery, creating a scalable single source of truth and reducing dependency on Generic Inquiries.
Structured Transformation Layer: Data cleaning, business logic and dedicated reporting views were built in BigQuery, with Power BI Dataflows and Power Query handling additional logic where required.
Best-Practice Star Schema: The Power BI data model was rebuilt with clear relationships, reusable dimensions and measures separated from calculated columns and tables.
Consolidated Multi-Year Model: All financial years were brought together into a single model, enabling year-on-year and long-term trend analysis in one place.
Automated Refreshes: The sales report was configured to refresh automatically twice each day, removing the manual refresh process entirely.
Redesigned Reporting Experience: Additional dimensions, drill-through pages to transaction-level detail, standardised measures and a refreshed layout delivered a consistent, professional report.
Result
The rebuilt solution has changed how Crimsafe works with its sales data:
Year-on-Year Insight in One Place: Users analyse performance across every financial year without switching between separate reports or datasets.
Always-Current Data: Twice-daily automated refreshes mean the latest figures are available without relying on anyone to run a manual process.
Faster Investigation and Reconciliation: Drill-through pages take users from headline results straight to the supporting transaction-level detail.
Deeper Analysis: New dimensions give users far greater flexibility to filter and segment sales performance across the business.
Trusted Numbers: Reviewed and standardised measures now align with agreed business definitions, restoring confidence in the figures.
Built to Grow: With logic in the most appropriate layer of the solution, future updates, troubleshooting and new report development are significantly easier.
Conclusion
By moving from fragmented financial-year reports to a centralised BigQuery and Power BI architecture, Crimsafe has turned sales reporting from a maintenance burden into a reliable decision-making asset. The partnership with Report Simple has delivered a solution that is accurate, automated and built to best practice, giving one of Australia's most recognised brands a reporting foundation that will scale with the business for years to come.
Report Simple consolidated our fragmented sales reporting into a single automated platform powered by BigQuery and Power BI, creating one trusted source of truth across all years. While accuracy and efficiency have significantly improved, the greatest benefit is the ability to rapidly analyse sales performance, uncover trends, and make informed, data-driven decisions. The flexibility to slice and dice sales data across multiple dimensions gives us greater visibility, agility, and confidence in driving strategic business outcomes.
Catherine Edwards | Head of Sales