Elevating decision-making: A success story with CES and EdgeRed
In the dynamic landscape of data utilisation, EdgeRed embarked on a transformative journey with Circular Economy Systems (CES) to revamp their data architecture. The goal? To empower CES with sharper insights for informed decision-making while enhancing their reporting capabilities.
1. Context and Background
EdgeRed’s collaboration with CES aimed to modernise their data infrastructure, fostering advanced reporting and strategic decision-making. Key initiatives included uplifting existing reports, developing a centralised data model, implementing an end-to-end data pipeline, as well as applying advanced analytics.
The project team consisted of,
1 Data Engineer
2 Data Analyst
0.5 Analytics Lead
2. Introduction to CES
CES operates an innovative container refund scheme aimed at reducing environmental impact by encouraging recycling. With partnerships in QLD (Container Exchange), WA (WARRRL) and VIC (Vic Return), they manage a network that spans consumers, businesses, and recycling points, playing a crucial role in promoting sustainable practices across Australia.
Their efforts have diverted over 800,000 tonnes of material from landfills and facilitated more than $A1 billion in refunds, showcasing their commitment to environmental stewardship.
3. Tech Stack
The tech partner of choice included Snowflake for cloud data warehousing. Notably, CES’s outstanding achievements were recognised with the prestigious Snowflake Award in 2023. Watch the Snowflake video for more information:
4. Approach
EdgeRed adopted a methodical and agile approach with a focus on providing incremental value to the client. Starting with thorough reviews and stakeholder interviews to tailor data models to CES’s needs. Recommendations were crafted to incorporate transformed business rules, ensuring alignment with CES’s reporting requirements.
Our understanding of industry best practices and advanced analytics techniques enabled us to remain as CES’ trusted analytics partner to extend and expand the initial scope of work into other areas, supporting the marketing, finance and operations teams.
5. Business Outcome & Client Testimonial
The new data models resulted in a sea change for CES. Reports that were once cumbersome to access and view could now be accessed with speed and accuracy. This sharpened CES’s ability to make astute business decisions and reinforced their commitment to environmental stewardship.
“EdgeRed is a cross functional team, bringing with them commercial and technical expertise across analytics, data engineering, visualisation, and consulting. They have worked alongside our data team to deliver a multitude of complex data initiatives which have delivered valuable business impact.” – Tim Reid, Director of IT
The project’s success was recognised by senior execs including Tim Reid, Director of IT at CES, who praised EdgeRed’s expertise, highlighting the transition to a high-performing, low-maintenance reporting platform.
“We had over 100+ reports which were high maintenance, poor performance with low usage. Using Snowflake, dbt, Power BI and Kada.ai, EdgeRed successfully transitioned us to a high performing, low maintenance reporting platform. This has increased dashboard adoption and engagement across the business, driving more data driven decisions. We look forward to our continued engagement with EdgeRed.” – Tim Reid, Director of IT
This case study is a shining example of how EdgeRed’s analytical expertise can significantly enhance our clients’ data capabilities, leading to measurable business improvements and operational efficiencies. In addition to this, we are committed to delivering value-for-money to our clients through our blended model.
“EdgeRed’s unique value proposition provides us with access to a wide range of skills tailored to our project needs. From expert Lead Consultants to BI Specialists and Data Engineers, the breadth of expertise available ensures exceptional value for money.” – James Gouletsas, Data Product Manager
Frequently Asked Questions (FAQs)
EdgeRed uplifted existing reports by redesigning them for improved performance, usability, and accessibility. This transformation allowed CES internal and external users to access reports with greater speed and accuracy, enabling sharper insights for informed decision-making.
Kada played a crucial role in providing end-to-end data governance and visibility over CES’s data and reporting processes. This ensured data integrity, compliance, and transparency in analytics operations, supporting CES’s strategic decision-making.
EdgeRed’s partnership with CES extended beyond data infrastructure modernisation to support marketing, finance, and operations teams. This involved leveraging advanced analytics techniques and industry best practices to deliver impactful data initiatives, such as customer analytics, supporting marketing initiatives, and providing anomaly detection models.
About EdgeRed
EdgeRed is an Australian boutique consultancy specialising in data and analytics. We draw value and insights through data science and artificial intelligence to help companies make faster and smarter decisions.
Subscribe to our newsletter to receive our latest data analysis and reports directly to your inbox.
