BI Gateway

The Whitespace BI Gateway enables secure access to Whitespace operational data from external reporting tools such as Microsoft Power BI and Excel. It allows councils and contractors to work with both live and historical data, supporting clearer insight and more informed operational decision-making.

By connecting Whitespace data directly into existing BI tools, teams can extend their reporting capability without duplicating systems or introducing additional complexity.

Key capabilities

Access to live and historical data
View operational data in real time where required, or use scheduled data updates for reporting and analysis.

Simplified data structures
Pre-built data profiles bring together relevant Whitespace datasets into structured, easy-to-use feeds, reducing the need for complex data preparation.

Secure connectivity
Data is accessed through secure endpoints and controlled credentials, allowing teams to connect BI tools such as Power BI and Excel directly to Whitespace.

Flexible update options
Choose between live data or scheduled daily updates, depending on reporting needs and operational use cases.

Benefits

Trusted data access
Designed with security and data governance in mind, ensuring operational information is protected.

Practical and accessible
Enables reporting teams to work with Whitespace data without specialist technical knowledge.

Works with existing tools
Supports Microsoft Power BI, Excel and other BI platforms already in use, reducing change and overhead.

Many councils already use Microsoft Power BI for performance reporting. The Whitespace BI Gateway extends this capability by providing controlled access to Whitespace operational data, enabling more connected and consistent reporting across services.

BI Appliance

BI Appliance

For councils with limited BI expertise or resources, the Whitespace BI Appliance provides pre-built dashboards and a hosted data warehouse—making business intelligence accessible from day one.

The BI Appliance delivers:

• Dual Data Modes: Access both live data for real-time monitoring and historical data for performance tracking.
• Pre-Built Dashboards: Out-of-the-box reports designed for waste and environmental services.
• Exportable Data: Easily generate reports for audits, reviews, and service performance tracking.

Example dashboards include worksheets by due date, missed collections (with assisted vs. non-assisted filters), repeat missed collections by address, hotspot reports with mapping overlays, and round count summaries.

This ready-made solution empowers councils to monitor day-to-day operations while also planning strategically for the future. With accurate, timely, and actionable insights, councils can improve service quality, benchmark performance, and optimise resource allocation.