Comfy Generates Reports with Data from Various Excel Files
“The biggest surprise to me- that not just structured data from systems, but
also all kinds of Excel spreadsheets, however they are structured, can work
Comfy, a Siemens company, is on a mission to create amazing workplace experiences for everyone—from the people who operate the building to the people who fill it. Comfy connects people, places, and systems through one intuitive workplace app, thereby creating great relationships between people and their workplaces.
The finance team at Comfy had a few challenges they were trying to solve. Firstly, they needed support in creating monthly reporting as well as improving budget and forecast processes. Second, they were looking to save time while ensuring data integrity and improving forecast accuracy. They also wanted to blend data from various sources into reports- data from their ERP system, CRM (Salesforce) and revenue recognition platform (Zuora).
The team was conducting a lot of manual copy/paste transfers and quality checks of data to ensure that the numbers match the data in their systems.
Jens, CFO of Comfy, looked towards DataRails to help address his challenges. With DataRails, he can now download actuals out of his system and directly upload them to DataRails, which eliminates the time consuming manual monthly data input process he used to conduct.
Jens uses DataRails frequently for closing data quality checks before submitting data to the corporate level. This way, he can often check the accuracy of numbers in little to no time. He also relies on DataRails for the quick creation of standardized reports.
Jens sites the drill-down lists as his favorite feature within the DataRails system. He explains that in his Excel spreadsheets, he used to have to manually copy/paste data into Excel spreadsheets to get to the underlying data. Now, all he has to do is highlight a line or full column where he thinks there are variances, and then go to the drill down list option. This feature points out the data that is behind each cell and presents it in an easily digestible way. “I couldn’t do that before with my manually created spreadsheets,” Jens says. “To me it’s a big time-saver and gives me quick insights into what happened in different cells in different periods.”
The team at Comfy consistently runs quality checks, and drills into booking data a couple of times towards the end of each month with DataRails to see if they booked the data correctly, and if journal entries in their ERP system make sense.
Jens states that with DataRails, the finance team at Comfy saves anywhere between two to five full working days per month, which they now devote to other tasks like high level analysis.
Overall, data is now better organized, and it’s easy to compare different versions of forecasts and budgets to understand the development- which before took a lot of time to do because the data was in different systems (for example in the corporate consolidation system, local systems, and on Excel). Now, everything is easily accessible in one place.
To this day, Jens is amazed that he can throw into the DataRails system whatever existing Excel file he has and use it as an input file to generate reports. According to Jens, “oftentimes you read about advertised product capabilities online while in reality they’re very different. But with DataRails, that’s not the case. I can provide whatever data source I have and work it into established data collection and reporting processes. That was really the biggest surprise to me- that not just data dumps out of systems (structured data from systems) but also all kinds of Excel spreadsheets, however they are structured, can work with DataRails.”