Delivered Automated Reporting Across Work.Life's Different Locations.
Objective
Implement core reporting across every business function.
Obstacle
Siloed data inside of niche tools that needed extracting.
Outcome
Granular operational analytics on office, and meeting room use.
Background
Work.Life is a fast-growing co-working space provider dedicated to delivering exceptional office environments tailored to modern businesses. As their operations expanded, their team encountered significant challenges in consolidating data from various sources, including Nexudus, Xero, ACT, and Excel. This fragmented data landscape created inefficiencies, making it difficult to gain real-time visibility into financial performance, occupancy rates, and overall operational health. To optimise operations, Work.Life needed an integrated data solution that would streamline reporting, enhance data accuracy, and provide actionable insights to drive business growth.
Challenges
Data Silos: Work.Life’s critical operational data was spread across multiple disconnected platforms, including Nexudus, Excel, and ACT, making it difficult to gain a holistic view of business performance. Each system stored valuable information independently, creating data silos that prevented teams from accessing insights. The lack of a unified data source not only slowed down decision-making but also increased the risk of inconsistent reporting across departments.
Manual Processes: Teams had to manually compile and reconcile data from various sources, increasing the likelihood of human errors and discrepancies. This labour-intensive approach not only delayed the availability of critical business insights but also made it difficult to scale operations efficiently. As the company grew, the need for an automated, reliable, and scalable reporting solution became essential.
Solution
Business Knowledge: The foundation of any successful data project begins with a deep understanding of how the business operates. At Work.Life, we collaborated with multiple stakeholders across the organisation to gather insights into the core elements that drive their operations. This involved mapping out the different customer journeys, membership types, and various purchase activities that were central to their business model. By working closely with teams from sales, marketing, and operations, we identified critical touchpoints and business processes that needed to be captured in the data strategy.
Data Stack: Once we had a comprehensive understanding of Work.Life’s business, we moved forward with the next phase: building a robust data model and setting up the data stack. This step a involved recommending and setting up the best tools and technologies to ensure data integrity, processing, and seamless integration across various platforms.
The Proof Is In The Numbers
4
25
12
Implementation
Automated Pipeline: To streamline Work.Life’s data operations, we implemented automated data extraction and integration from several key platforms, including Nexudus, Excel, and ACT. These systems were essential for managing the day-to-day operations across over 20 properties, each with its unique set of data. By automating the extraction process, we eliminated manual data entry and reduced the risk of errors.
Data Modelling: We designed and implemented structured models that covered crucial business areas, including bookings, memberships, renewals, and revenue. These models ensured that data was organised in a way that aligned with Work.Life’s business objectives and was easy to analyse. Additionally, we developed specialised occupancy and session models, which provided accurate insights into space utilisation and customer engagement.
Dashboards: To make the integrated and modelled data easily accessible, we developed interactive Metabase dashboards that delivered real-time insights into both operational and financial metrics. This dashboard became a central tool for stakeholders across Work.Life, offering immediate visibility into key performance indicators.
