Open Sky Data Systems

iWaste+: An Advanced Municipal Waste Data Analytics Platform

iWaste+, waste data analytics, supports a Council or Suppliers existing data management system by adding an Analytical tool bringing in both waste and external data and providing new ways of both reviewing existing elements and providing forecasting and 'what if' predictions for future working.


  • Real Time analytics
  • Remote access for Users
  • Statistical Forecasting Module
  • Uses both waste and external data sets
  • Dashboards and Charting


  • Tracking of Waste movements from collection to disposal
  • Track waste against external influences
  • Forecast from historic data
  • Plan using what if scenarios
  • Analytical Dashboarding on Tonnage and Performance


£0 to £0 per unit

  • Free trial available

Service documents

G-Cloud 9


Open Sky Data Systems

Michael Cronin


Service scope

Service scope
Software add-on or extension No
Cloud deployment model Private cloud
Service constraints Some configuration may be required to work with the Councils existing data sources to ensure format capability with this application
System requirements
  • System is Completely Browser based, works with any modern browser
  • Microsoft Power BI Licenses for Users

User support

User support
Email or online ticketing support Email or online ticketing
Support response times Opensky Support Service Desk consists of both E-mail and Online Ticketing support. Response and resolution times are determined by Issue/Query classification based on agreed SLA terms, ranging from 30 minute initial response time for Severity/Priority 1 issues to a maximum of 4 hours initial response time for lowest Severity/Priority issues.

Helpdesk will coordinate with the customer and/or Senior Support to classify the request and will assign a severity/priority (if not already set by the Client), which will determine the SLA response timeframes.

Support hours are from 09:00 – 17:30 Monday to Friday.
Extended support options are also available on request.
User can manage status and priority of support tickets Yes
Online ticketing support accessibility None or don’t know
Phone support Yes
Phone support availability 9 to 5 (UK time), Monday to Friday
Web chat support No
Onsite support Yes, at extra cost
Support levels Opensky offer a complete support & maintenance service providing 'Level 3' break/fix support and query resolution for the data uploads and visualisations and this is included in the cost.

opensky’s support service comprises of the following:
• Support Manager:
Manage Overall Support process, Escalation point, Knowledge Transfer to support from Dev teams, Quarterly Service Review customer meeting and reporting
• Support Lead
Manage Day to Day Support process and customer communications, Escalation point, Regular Customer Meeting and Reporting
• Helpdesk
Telephone support, first contact, manage support issue lifecycle
• Support technicians
2nd Level troubleshooting, dataset administration, Hardware issues, coordinate with development support, Monitoring tasks
• Support engineers
3rd Level S/W fixes, Deployment, documentation
• Developers
3rd Level of support comprises of development resources that provide backup to the Support Engineer.
Support available to third parties Yes

Onboarding and offboarding

Onboarding and offboarding
Getting started Initially opensky will conduct an on-site analysis session with users to fully review and understand the user business requirements. This will also cover the publicly available data-sets and those that may be owned by the Council to look at usage for both forecasting and analysis potential.

From there, the opensky data scientists will deliver a practical robust solution of the capabilities of the analysis followed by an onsite results-oriented training program for our service, providing users with the skills and knowledge to use the system simply and efficiently.

Each session can accommodate up to 10 attendees, includes all manuals and is delivered on-premise.

During warranty/transition period, opensky project team remains available. There is expected to be a higher level of queries as the Customer's operational team become familiar with the system/support.
Service documentation Yes
Documentation formats
  • PDF
  • Other
Other documentation formats Docx
End-of-contract data extraction Complete data accessibility will be provided to the client by providing access to the system data-store made available in Excel.

These will be made available to the user through a secure FTP connection or via an encrypted data transfer.

When the contract ends opensky will work with your to:

(a) Identify whether any user data requires migration;

(b) Identify the systems and processes required for the extraction and transfer of the user data; and

(c) Return the user data in above mentioned format.
End-of-contract process In advance of the contract ending opensky will work with the client to determine if they would wish to renew the contract. If so then opensky will conduct a review of the account and provide a quote for renewal.

Should the client not wish to renew the contract then opensky will seek an onsite debrief with the client.

The outcome of this meeting will be to determine the method of data transfer and the format requirements for the data transfer.

For standard provision of previously described user data transfer there is no additional cost.

If alternative data extraction or data migration to another system is desired by the client then opensky will review and quote for this work at standard daily rates.

Once the data transfer is completed the support team is available to add extra information or enhance the data at standard daily rates.

Using the service

Using the service
Web browser interface Yes
Supported browsers
  • Internet Explorer 10+
  • Microsoft Edge
  • Firefox
  • Chrome
  • Safari 9+
  • Opera
Application to install No
Designed for use on mobile devices Yes
Differences between the mobile and desktop service While all the Dashboards, Charts and Reports will work on Mobile, some may look better with some specific mobile amendments.
Accessibility standards WCAG 2.0 AA or EN 301 549
Accessibility testing Covered by Microsoft Accessibility Declaration of Conformance
What users can and can't do using the API Using any programming language that supports REST calls, you can create a business solution that updates a Power BI dashboard in real-time.

With the Power BI REST API, you can:

* Authenticate Power BI REST operations with Azure Active Directory
* Create and get datasets
* Set a retention policy to automatically clean up old data
* Get and update table schemas
* Add and delete rows
* Get groups
* Import PBIX or Excel files
* Get tiles
API documentation Yes
API documentation formats HTML
API sandbox or test environment Yes
Customisation available Yes
Description of customisation Additional data sets can be added to the system allowing further reporting and dashboarding.

The existing data sets can be complemented by additional dashboards, reports or drill throughs as required by the Council and the users.

User can select their own dashboards and default landing pages from the selections offered.


Independence of resources Our application is hosted by Microsoft within their Office365 delivery infrastructure.

The scalability of this architecture is delivered and guaranteed by Microsoft in their data centres.


Service usage metrics Yes
Metrics types A Runbook will be available which will detail solutions to common issues encountered. The information gathered will be from resolved tickets within the helpdesk system and any troubleshooting carried out by engineers.
A Quarterly Service Management meeting is also held to review both system performance and availability with any service unavailability statistics as a cornerstone.
Reporting types Regular reports


Supplier type Not a reseller

Staff security

Staff security
Staff security clearance Other security clearance
Government security clearance Up to Security Clearance (SC)

Asset protection

Asset protection
Knowledge of data storage and processing locations Yes
Data storage and processing locations United Kingdom
User control over data storage and processing locations No
Datacentre security standards Complies with a recognised standard (for example CSA CCM version 3.0)
Penetration testing frequency At least once a year
Penetration testing approach In-house
Protecting data at rest Physical access control, complying with SSAE-16 / ISAE 3402
Data sanitisation process Yes
Data sanitisation type Deleted data can’t be directly accessed
Equipment disposal approach Complying with a recognised standard, for example CSA CCM v.30, CAS (Sanitisation) or ISO/IEC 27001

Data importing and exporting

Data importing and exporting
Data export approach Data from within the system may be exported from the on screen data views into Excel. Data can be filtered as per user requirement, and is only available to users with the appropriate permissions as per the solution security model.
Data export formats
  • CSV
  • Other
Other data export formats Excel
Data import formats
  • CSV
  • Other
Other data import formats Excel (*.xls, *.xlsx)

Data-in-transit protection

Data-in-transit protection
Data protection between buyer and supplier networks TLS (version 1.2 or above)
Data protection within supplier network TLS (version 1.2 or above)

Availability and resilience

Availability and resilience
Guaranteed availability Opensky commit to 99.9% uptime service availability level between the core hours of 09.00 to 17.30 Monday to Friday, excluding planned maintenance windows which will be agreed with client.

Service availability is tracked and measured against SLA and performance against KPIs are outlined in the monthly service reports.
Where targets have not been reached, agreed service credits can be applied.
Approach to resilience This information is available on request.
Outage reporting Email alerts on outages are used to notify users of any disruption, actions being taken to restore service and extent of the issue.
Follow up alerts convey actions taken and resolutions made

Identity and authentication

Identity and authentication
User authentication needed Yes
User authentication Username or password
Access restrictions in management interfaces and support channels Each user is assigned to a 'Role' by the system administrator.
Each role has assigned access levels in line with their responsibilities and the application ensures a clear definition of what they can do and also what they can see within the system
Access restriction testing frequency At least every 6 months
Management access authentication Username or password

Audit information for users

Audit information for users
Access to user activity audit information Users have access to real-time audit information
How long user audit data is stored for Between 6 months and 12 months
Access to supplier activity audit information Users have access to real-time audit information
How long supplier audit data is stored for User-defined
How long system logs are stored for Between 1 month and 6 months

Standards and certifications

Standards and certifications
ISO/IEC 27001 certification Yes
Who accredited the ISO/IEC 27001 Certification Europe
ISO/IEC 27001 accreditation date 26/08/2015
What the ISO/IEC 27001 doesn’t cover All controls from the Statement of Applicability are relevant
ISO 28000:2007 certification No
CSA STAR certification Yes
CSA STAR accreditation date 29/09/2016
CSA STAR certification level Level 2: CSA STAR Attestation
What the CSA STAR doesn’t cover Provided by Microsoft
PCI certification No
Other security accreditations Yes
Any other security accreditations Certification Europe – ISO 9001:2008 – Quality

Security governance

Security governance
Named board-level person responsible for service security Yes
Security governance accreditation Yes
Security governance standards ISO/IEC 27001
Information security policies and processes Information is a critical asset of opensky . Accurate, timely, relevant, and properly protected information is essential to the success of the company activities. Opensky is committed to ensuring all accesses to, uses of, and processing of company information is performed in a secure manner.

Our ISO27001 accredited Information Security Management System (ISMS) is applied to the development and support of iWDMS:
- Provision of a ISO27001 compliant Information Security Management System
- Organizational management which champions security
- Written information security policy properly derived from national standards
- A development methodology with adequate security checkpoints and activities
- Secure release and configuration management

The CTO is responsible for ensure that the ISMS is implemented according to this policy and for ensuring all necessary resources. - The Operations Manager is responsible for operational coordination of the ISMS as well as its maintenance. This includes carrying out risk assessments, review all risk assessments completed by other parties and highlight any measures needed to reduce risk in information security areas across the organisation.

Third party audits will be carried out by Certification Europe twice a year or at intervals as deemed necessary by the external auditor.

Operational security

Operational security
Configuration and change management standard Supplier-defined controls
Configuration and change management approach All changes will be logged at project level and raised at project board meetings, if changes can be dealt with within the initial project scope they will be fully documented and specification altered appropriately.
If changes are analysed and found to be outside the original scope of the project, the cost of these changes will be estimated and communicated to the customer by the opensky project manager.

All changes are assessed across a range of criteria, including financial, functionality, impact, security and risk. System configurations are baselined and backed up, and are associated with each system release.
Vulnerability management type Supplier-defined controls
Vulnerability management approach Implementation of best practices in developing secure software will mitigate most common software vulnerabilities. The goal of software security is to maintain the confidentiality, integrity and availability of information resources in order to provide successful software functionality.

Here are some of the main areas that are used in secure requirements definition:
a. Staffing requirements
b. Policy on data protection
c. Authentication and password management
d. Authorization and role management
e. Data and operations audit
f. Network security and data access
g. Third party components security audit.
h. Cryptography and key management
i. Data validation
j. Serviceability
k. Ongoing education.
Protective monitoring type Supplier-defined controls
Protective monitoring approach Our security analysts and our data centre partners perform schedule vulnerability tests, and when an incident is found, the following steps occur.

P1 – Critical
Onsite Helpdesk:
• escalate to Support Manager, Support Lead and Support Development Lead
• provide hourly status updates
Support Lead
• prioritise resources
• engage with business user team
• engage with third parties if required
• manage P1 incident management procedures.
• escalate to Support Manager as required
Support Development Lead
• assess issue and advise stakeholders of requirements
• prioritise developer resources
• resolve issue
• provide recommendations to prevent recurrence
Incident management type Supplier-defined controls
Incident management approach Users may report incidents via phone, email or the online ticketing system.

Each may be monitored through the online and email alerting facility

An Incident Report is completed for all incidents categorized and resolved as a Severity 1 issue.
investigations to determine what exactly caused the issue in the first instance are carried out and the report will suggest corrective and preventative steps to be put in place as a result.

These reports are shared with the users to ensure actions are taken and followed up.

Secure development

Secure development
Approach to secure software development best practice Independent review of processes (for example CESG CPA Build Standard, ISO/IEC 27034, ISO/IEC 27001 or CSA CCM v3.0)

Public sector networks

Public sector networks
Connection to public sector networks No


Price £0 to £0 per unit
Discount for educational organisations No
Free trial available Yes
Description of free trial Trial versions can be made available for a limited period depending by prior agreement with the customer.

Core system with standard waste streams and simple data mapping model.

Free 2 Days Data Science on 3-5 Years Historical Waste Transaction Data with 1/2 Day Visualisation Workshop (requires customer data)


Pricing document View uploaded document
Skills Framework for the Information Age rate card View uploaded document
Service definition document View uploaded document
Terms and conditions document View uploaded document
Return to top ↑