Real-Time Reporting for One of the UK’s Leading Waste Management Companies
The Challenge:
- Existing waste reporting processes overly manual and time-consuming, consuming more than 70% of staff time
- Customers lacked access to clear, real-time data regarding their waste activities
- Need for 24/7 self-service access to waste data, reports, and compliance paperwork
- Required profile-based views for different user types (CEO vs Site Manager)
- Handle complex data relationships with drillable reporting capabilities
Our Solution:
Developed a real-time reporting portal using PearDrop framework, Azure SQL, Data Lake, ADF, and Power BI for a £90M turnover business. Built on PearDrop, the portal uses Azure SQL, Data Lake, ADF, and Power BI for secure, scalable performance, integrated with AMCS and Samsara systems.
Key Features and Benefits:
- Real-time dashboards displaying key metrics like tonnage, revenue, and carbon output
- Role-based access providing tailored views for CEOs, site managers, and compliance teams
- End-to-end tracking of collections, recycling routes, and compliance documents
- Branded experiences for each customer with intuitive, self-serve navigation
- Integration with existing systems (AMCS, Samsara, Carbon Mark)
- Flexible, customizable, and visual reports via Power BI in near real-time
- £90M turnover business supported
- Serving 4,000+ customers
- Handling 16,000+ weekly transactions
- 70% reduction in manual reporting time for staff
