Services – Data & Reporting
We understand the value of good quality data and reporting and have numerous solutions to help you. These solutions not only get your data to where you want it but also keep on top of it. All solutions have a pdf document containing the details. If there is also a presentation or recording available, the links are provided.
PDFs open in a new tab, where you can view, print, and download from your browser.
Recordings are accessed via KB articles in the Support Portal. These provide links to the videos. You need a portal login to access this.
TIP: You can share a link to this page by using the email button at the bottom of the table. You can also share links to individual solutions by clicking on the Service Offering and using the email button on each page.
| Service Offering | Summary | Details | Presentation | Recording |
|---|---|---|---|---|
| Address Cleaning | Addresses are a fundamental part of the One system. High-quality address data is of critical importance to many of the services which rely on the system for their day-to-day processes. As more services move towards using self-service portals, poor-quality address data can also be exposed to members of the public or external organisations which can be damaging to the Local Authority’s reputation and cause confusion for the end user. | |||
| Admissions In-Year Dashboard | The Admissions in Year Dashboard provides a set of reports to manage In-Year Admissions, without the need to use further spreadsheets or reports to modify that information. This serves as a complete dashboard to help manage applications and work within the Admissions Code of Practice. | |||
| Archive and Delete | The aim of the solution is to provide authorities with an overview of the Archive and Delete functionality within One, system defaults and alerts, and provide training on the use of the functionality. | |||
| Attendance | This report pack contains the main reports that will help to monitor pupils’ attendance and absences. The reports assume that Authorised Absences use codes F I R M C H E S T and unauthorised absence codes of G U N O. Attendances include Approved Education Activities and Lates. | |||
| Crystal Beginner | Crystal has been a vital tool for One users and support staff. Delegates will learn the basics of Crystal from the setup of options to being able to create a basic report. | |||
| Crystal Intermediate | Crystal has been a vital tool for One users and support staff. Delegates will learn the more advanced functions, building on the learning from the beginner training, to create powerful, well-presented reports. | |||
| Crystal to SSRS Conversion | Conversion of Crystal reports to SSRS reports to allow for better presentation, more flexibility, and dynamic parameters. Linked reports can also be converted, and steps are provided on how to embed the report. | |||
| Data Quality Dashboard | The Data Quality Dashboard offers a comprehensive solution to improve data quality, ensuring accurate reporting and compliance with regulatory requirements. Contains over 30 reports that have been developed based on our previous experience with LAs. Understanding their requirements and ensuring the reports provide the necessary information to support decision-making. | |||
| Early Years Financial Dashboard | The Early Years Financial Dashboard is designed to provide a detailed level of your data from your database, without the need of using further spreadsheets or reports to modify that information. Therefore, this should serve as a complete dashboard against all your Early Years Financial needs. | |||
| Power BI | Power BI is an extremely powerful reporting tool aimed at Management Level to allow managers to easily get information on Reports via a visual interface. There is a built-in analytical tool that provides automatic insight into various trends of the data. As Power BI is a Microsoft product, we don’t support the install side, but can offer advice on our own experience of setup, along with reports. | |||
| Reporting on Timelines | Timelines are very useful for completing involvements forms and sticking to time limits set by the timeline. The course shows how you can report on the timeline events to provide management reports or personal monitoring reports on the progress of all active timelines. | |||
| SQL Advanced | SQL is the basis of all reporting options within the One system. A working knowledge is a significant advantage to anybody required to extract information from the database. This session takes you through the fundamentals of SQL using One data. Providing an overview of how SQL can help with your wider report writing or alert requirements. | |||
| SQL Basic | SQL is the basis of all reporting options within the One system. A working knowledge is a significant advantage to anybody required to extract information from the database. This session takes you through the fundamentals of SQL using One data. Providing an overview of how SQL can help with your wider report writing or alert requirements. | |||
| SSRS Advanced | SSRS (SQL Server Reporting Services) is a powerful and flexible reporting option available to LA’s who want to make the wealth of information in their One system more accessible to operational staff and senior leaders. This session provides an advanced look at the SSRS functionality and how it can be used with the One system to publish advanced reports. | |||
| SSRS Beginners | SSRS (SQL Server Reporting Services) is a powerful and flexible reporting option available to LA’s who want to make the wealth of information within their One system more accessible to operational staff and senior leaders. This session introduces SSRS functionality and how it can be used with the One system to publish basic reports. |