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:
Power BI seamlessly served as the reporting platform, delivering dynamic insights crucial for informed decision-making, while Kada provided essential governance and visibility.
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."
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."
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.
Frequently Asked Questions (FAQs)
How did EdgeRed specifically uplift existing reports and enhance reporting capabilities for Circular Economy Systems (CES)?
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.
What role did Kada play in the project with Circular Economy Systems (CES)?
How did EdgeRed's partnership with Circular Economy Systems (CES) extend beyond initial scope and impact other areas of the organisation?
Read more about our end-to-end services,
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 the our latest data analysis and reports directly to your inbox.
Whether you've searched "EdgeRed", "Edge Red" or "Red Edge", you've come to the right place!