Overview
Delivering a superior transport experience
Macutex is a leading service provider in the property and facility asset industry across Australia. The company plays a crucial role in assisting both government and private-sector owners and managers of multi-site asset portfolios.
By offering comprehensive support, Macutex helps these stakeholders gain a deeper understanding of their risks, identify potential opportunities, and prioritize their actions effectively.
The Macutex team was on a mission to optimise their existing data automation processes. Their goal was to enhance data integrity, boost overall productivity, and modernise their workflows. To achieve this, they aimed to develop a custom-built application tailored to their specific needs.
Challenge
Streamlining Macutex projects
Macutex undertakes projects of considerable scale, exemplified by one initiative that integrated 1,500 sites and necessitated the transport of a substantial number of data assets. To enhance efficiency and ensure consistency across future projects, the Macutex team aimed to automate workflows through a centralised database.
This approach was intended to provide improved governance, greater control, and the ability to replicate workflows seamlessly. Recognising the complexity of their needs, Macutex sought a reliable partner to offer expert advice on their requirements and assist in managing the entire data lifecycle.
Solution
An innovative approach to data management
Macutex engaged Telstra Purple to investigate alternative solutions to data storage and data management through spreadsheets and micro-coding. The Telstra Purple team interviewed key stakeholders within the business to review current processes for inefficiencies, gaps and risk.
The team developed a hybrid product to transition users to the new application smoothly, offering the opportunity to input, store and manage data processing in the backend. A spreadsheet format user interface was also developed to maintain front-end consistency.
The solution was built using a centralised SQL server database to manage large volumes of data and a Web API for greater access to data and integration across applications.
As part of the process we:
- built a business case outlining the importance of this project and how it could be funded
- partnered with Macutex to develop the software specifications through an agile working model which provided access to the minimum viable product (MVP) at the end of each sprint
- created a suitable backend solution to improve reporting speed, accuracy, and quality.
Impact
Enhancing data quality and efficiency
During the two-month process, Telstra Purple developed a solution for Macutex that refines the quality of recorded data, reduces inconsistencies, and improves the recommendations they can provide to their customers.
The application improves data storage options and increases team productivity through automated data cross- checking. Macutex has enlisted Telstra Purple as a managed service provider to continue to upgrade the application, as well as monitor for any potential security risks or technical issues.
The solution delivers:
- better access to data and integration across applications
- improved quality control through a centralised and automatic data import and transformation process
- increased efficiency through automation and data accuracy, freeing up team resources for other projects.
Macutex was able to lock data down with a sense check that was unavailable before this project. We’re working with 1,500 sites across Victoria, and much of the data we require is similar in format but with different data inputs. We can now automate the repeatable tasks, saving considerable time and ensure the quality of the product we offer to our customers. It’s been a learning curve, but our team are now fully on board with the new application. It’s a game-changer.
Louise Martin
Manager - Project Optimisation, Macutex.
Related solutions and capabilities
Network solutions
Uncover our network solutions, engineered to optimise connectivity and enhance efficiency across your operations.
Partner program
Discover the benefits of the Telstra Partner program, and how you can contribute to fostering growth and collaboration for a connected future.
Cyber essentials
Assess, monitor and respond to cyber threats with Telstra Cyber Essentials, our comprehensive cyber security solution for Australian businesses and government agencies.
