Augury is a pioneer in machine health and industrial intelligence. The Frost & Sullivan’s 2023 Company of the Year for Global Industrial Analytics Solutions, has helped manufacturers eliminate downtime, boost efficiency, and ensure production reliability for more than 15 years.
The Finance Problem: Manual overload with no source of truth
Gal Lazar, FP&A Manager at Augury, has 15 years of experience in finance roles. He wanted to move his team beyond manual, time-consuming Excel workflows and towards streamlined budgeting, analysis, and reporting.
The main challenges for the Augury team were four-fold:
- Time-consuming data consolidation: “Creating a Budget versus Actual report required extracting P&L data from NetSuite, exporting detailed reports, and manually combining everything in Excel,” Gal says. This process alone took four full business days every month–time that could have been spent on analysis and strategy.
- Version control nightmares: The team juggled dozens of Excel files (labeled V1 through V50). With no efficient way to track changes or validate data integrity, even simple updates meant opening multiple files, creating a significant risk for errors.
- Limited visibility and analysis: Without drill-down capabilities provided by Datarails, that is, allowing users to dive deeper into their data by selecting specific data points and breaking them down using different filters and dimensions identifying discrepancies was nearly impossible. “Before Datarails, I couldn’t have caught a 2% variance discrepancy in our budgets.”
- Broken linked Excel spreadsheets: Almost every time the team would send a file, it would break because the linked file was password protected or located on someone else’s drive. “It was a complete nightmare,” Gal adds.
The Solution: One source of truth with insights at your fingertips
Gal led the Datarails implementation which allowed him to tailor models and workflows to Augury’s needs with guidance from a supportive implementation team from Datarails.
“Our customer success manager was incredible. He helped me when needed but also taught me to be self-sufficient in Datarails and build out everything myself.”
– Gal Lazar
FP&A Manager
The implementation focused on three main areas:
- Automated data consolidation: Connecting their NetSuite financial data directly to their planning processes eliminated days of manual work.
- Modular financial models: Breaking their massive Excel model into manageable components with individual ownership by department leads improved accountability and accuracy.
- Visual data connections and analysis: Datarails’ Dataflow feature provides a comprehensive and structured overview of data processes and their dependencies. This provided Gal with clear visibility into how information flowed between systems and reports. Coupled with the drill-down capabilities, it became easy to uncover valuable insights.
The Results: Transformation beyond time savings
- 75% reduction in report preparation time:
“We went from four days just to prepare Budget vs Actual reviews to less than one.”
– Gal Lazar
FP&A Manager
That extra time is now invested in quality work—sitting with managers and analyzing numbers instead of manipulating spreadsheets.”
- 90-minute forecast updates: Creating new forecast versions that previously took days now takes under 90 minutes, enabling more agile financial planning.
- Enhanced error detection: “The drill-down feature is remarkable,” Lazar explains.
“I can now immediately identify issues like unexpected severance expenses or budget surpluses that would have taken hours to catch in Excel—if we caught them at all.”
– Gal Lazar
FP&A Manager
- Improved stakeholder engagement: With 20 stakeholders now accessing live dashboards, budget owners come to meetings with real-time visibility, leading to faster and more productive decisions.
- Complete audit trail: “With Datarails’ version control, we can trace any change at any point.
“Datarails has added a new level of transparency we never had before.”
– Gal Lazar
FP&A Manager