and tedious data
Network security company ForeScout Technologies was looking for a solution to manage time more efficiently.
Every month, the company’s finance department reviewed numerous revenue statements in the form of Excel files. Some of the reports needed to be reformatted and loaded into other systems. Others had to be interpreted, validated and analyzed by staff before reporting to C-level execs.
“In my job, I have to do a lot of data validation, and the best way to view the data is to drop it into Excel,” explains Will Lederer, ForeScout’s senior finance manager of business systems.
It was very difficult and time-consuming to always have to manually compare multiple spreadsheets to make sure that there were no mistakes.
The constant reviewing, checking and comparing of data became an unwieldy chore. Lederer began searching for a better option, and then he discovered DataRails.
Rapid data validation
and analysis detecting
changes and trends
ForeScout’s reporting and review processes improved dramatically once the company started working with DataRails. As soon as they connected their files to the DataRails platform, Lederer could immediately compare data to determine if the correct changes had occurred. Since DataRails automatically identified revisions, he no longer needed to manually search for them.
“I’m not a stranger to using Excel,” says Lederer, “but DataRails opened my eyes to what it can do.”
In addition, DataRails ensured that there was a single version of truth, so that it was always possible to determine which file was the most recent. Team members could easily check files before Lederer even received them. At the same time, executives were quickly able to review prior versions.
Finally, ForeScout tapped into DataRails’ visualizations capabilities to create high-level reports for analysis that could provide a snapshot of the data.
The beauty of DataRails is being able to compare one version with another and see what the differences are.
These major enhancements to the reporting process were accomplished even though ForeScout employees continued to work as they always had, using the same Microsoft Excel with which they were familiar. DataRails increased the team’s speed and accuracy—and their value.
In addition, says Lederer, “DataRails maximized the power of me as a professional, because I no longer have to spend so much time doing repetitive work.”