Windmill Software customers use TheWorxHub software to track everything across their operation including housekeeping, work orders, inventory, appliance repairs, social activities, medical appointments and detailed financial information. Most of the Senior Living Communities who use the software operate locations across multiple geographies. They were collecting vast volumes of data and FD understood exactly how to unlock that data and transform it into self-serve business intelligence.
FD Solutions knew that power and flexibility would be a critical element contributing to the success of TheWorxHub. Enabling the stakeholder at Living Communities to drill into individual locations and report on a wide variety of data sets as well as to roll-up the data to understand global trending. Where are costs rising? How can quality be improved? What is driving resident satisfaction? How can we improve response times?
In parallel, FD realized that for best results, this data needed to be presented in both a numerical and visual format. Business managers needed to be able to spot trends with a simple glance- graphs and charts would be critical to success.
Using the power of Microsoft SQL Server Analysis Services, the FD team divided the data into cubes which are accessed to render the charts and graphs as queried. Due to the sheer volume of information, the users never query the live database – instead a parallel system is used to drive all of the business intelligence reports – resulting in near real time insight.
Google chart technology was seamlessly integrated so that individuals have a simple interface to work with – one that can tap into multiple data sources. Pre- designed templates enable the users to build their own reports. Microsoft Reporting Services is used to create all of the PDF reporting requirements.
Fully hosted by Windmill, users can now log-on to an online dashboard and quickly see the status of their work-orders including priority queuing and other key elements to managing their business. The scheduling calendar has been modified to make it a drag-and-drop experience which has simplified the coordination and rescheduling of staff as priorities and needs change. And reporting is a breeze, delivering unparalleled insight across all facets of the business, empowering decision-making by key stakeholders.