Acterys accelerates Star Group’s data processes—automating warehouse creation, consolidating reports from diverse sources in under a week for heightened efficiency.

Background

Star Hotels was running a spreadsheet-based process to consolidate results from 30 hotels. This was an error-prone, labor-intensive process that took finance staff weeks to prepare. This process left little time for analyzing results and often took away time for responding to urgent matters.

Key Challenges

• The manual, spreadsheet-based consolidation process took two to three weeks.
• The finance team had limited time for data analysis, hindering the ability to make quick decisions and respond to urgent matters.

Acterys Consolidates Star Group Data with One Click

Using Acterys, the process to create and maintain the Star Hotels data warehouse, which loads data from 30 Xero companies, was automated with just one click. Automatically generated Power BI reports and dashboards were extended with POS and HR systems and other data sources and customized to the exact requirements in less than a week.

Results

Acterys proved to be a transformative solution for Star Hotels, providing real-time access to up-to-date information and improving analysis accuracy by 37%. By automating data consolidation and reporting processes, the organization overcame the challenges of time-consuming manual tasks, enabling real-time access to up-to-date financial information. The integration of data from various sources and customization of Power BI reports further enhanced analytical capabilities. As a result, Star Hotels now operates with increased efficiency, quicker decision-making and improved responsiveness to urgent matters, ultimately driving better financial management and performance.