Powerful Automated Report Generator
Increase the reporting capability within your business. Point our report manager at folders of data, and watch it go to work.
Reduce the amount of time spent developing reports in software such as Jasper Reports, Dundas, SQL Server Reporting Services, Power BI.
Get data into a better format for custom reporting libraries automatically.
Reduce time spent building reporting suites and dashboards. Allow the Report Manager to transform and classify report data for presentation.
We currently use our Report Manager to classify data for Tabular, Maps, and Charts, for automated data reporting.
Declutters your tech
The more processes and applications your business has to develop to manage its data for analysis and reporting, the more complexity it creates.
Simply deliver data to folders and the report manager will automatically process and classify your data.
How does the Report Manager work?
The Report Manager looks at multiple folders of json data files. The Report Manager decides how that data should be classified and displayed. This data is saved to a database, and stored with options/list of values. This data and its dimension data is then available to applications to query.
We currently use a small library called LiteDB to manage the persistence and retrieval of our data. We can switch this for a more enterprise based Database Management System such as Oracle, SQL Server, MongoDB if scalability is a concern.
The report manager permits query data to be passed to it, and translates that to a query - such as SQL, and expects data back. This may not sound that ground-breaking, but the beauty is in classifying datasets, allowing it to be queried.
The focus is on metadata and intention. More advanced users can configure the report manager to finely tune how data is classified. Indeed, we use Dependency Injection and thus the application is extensible.
The problem we were trying to solve?
You may see we have been working on a property platform. It searches multiple websites and pulls this into data which was intended for a data warehouse. Indeed, we have written software to do this dynamically. However, one of the key observations was that a lot of time was spent configuring datasets to be displayed within our website. Indeed, traditional Model View Controller website development focuses more on restful endpoints which are per dataset.
We wanted a platform which was versatile and extensible without the need to rebuild and deploy the website every time a new report was added.
We noticed that datasets have a preferred display output. Our work on the Report Manager helps interrogates data and places it into a preferred display type.
We know the Report Manager is incredible, you can know it too
The Report Manager sounds amazing - we want this
If you want to hear more, please contact us about the Report Manager.
A real world example?
Reports and Dashboards within our Web Data Platform
The WDP - in brief
Our WDP runs on .Net Core and makes content and data easy to consume and publish to website users. The WDP represents a powerful shop-front to a business looking to provide their audience with a more powerful view on their data. Our WDP moves the effort away from continually managing content, to small maintenance and powerful data automation.
We embedded our Report Manager into our Web Data Platform. In addition to doing substantial heavy lifting of the data loading, the WDP stores these reports into the memory cache to make it far faster to access than roundtrips to the database.
The dashboard view
Our Dashboard View contains tables, galleries, articles, and charts. A key part of making this possible is the integration of our Report Manager component.
The power of our dashboard view is it loads data in page - asynchronously, bringing data in by common data items to allow users to view related data easily.
The Reports view
The WDP contains a tabbed display categorised by report type. It displays a list of reports which, when clicked, navigate the user to a filterable report. This view is made possible by our Report Manager processing data delivered to our website.
The Maps view
We identify reports which are mappable. Map based reports are given a higher priority than tabular reports, meaning our default is to show mappable data.
A powerful addition to our maps view is the linking of icon sets to child datasets. We can show different icons and colours for different data items. One map shows London, ranked by price value - coloured.
The Tables view
Data is available to be filtered and viewed within the tables view. The user's preferred options are sent to the Report Manager, and data is returned. This data is displayed within DataTables.Net to give a neat user experience.
This is perfect for relatively small datasets.
This Report Manager library sounds great - how do we get it?
We are still deciding the best way to offer this to our clients. Some clients may want to write their own code on top of the Report Manager, some may want this as a service.
As you will know, the RM is integrated into our Web Data Platform, but you may not wish to use our WDP.
We are looking to offer this as a cloud based multitenant solution.