Sharperlight allows access to data across multiple enterprise systems helping you to make truly intelligent and timely business decisions ahead of your competition. It's a secure "Out of the Box" solution, featuring personalised dashboards, report packs and a powerful engine and integration framework delivering simplified business intelligence.
Sharperlight can present dynamic tables, charts, pivot tables and presentation reports using its own web service. It has an application called Publisher, for managing and configuring these published queries. Each query can be filtered and refreshed in the web, and it will return the latest data.
Sharperlight dashboards are created and maintained using an HTML5 interface in a web browser. A dashboard consists of a page and each page can contain multiple rectangular tiles. The tiles can be resized and re-positioned, the tile can display published content from Publisher or display any valid web address.
The Sharperlight Excel® Add-in gives end-users easy access to the Query Builder and a drilldown data explorer. The Sharperlight queries are anchored in the worksheets, using formulas and the construction of these formulas is wizard driven through the Query Builder. These formulas fully support cell referencing and automatic recalculation, so results will refresh as filters are changed or when a recalculation is forced.
The Query Builder is a user interface with separate panes for filters, field selection and output. Simple enough for the infrequent user and with deep functionality with menus on each pane title and fields have right hand click menus. In the filter pane the user can select between different query styles using the mode filter and when the user selects the table, it becomes the focus for the query structure and it populates the fields and relationships in the selection pane.
The Scheduler is an automation interface for the execution of tasks on a recurring and ad-hoc basis. Each task can have many actions and a task can be executed manually or a schedule. To allow concurrent activity, the Scheduler is only available on installations that have five or more full licenses.
Enterprise reporting at a fraction of the cost**. Get detailed and accurate, real-time reports, sent automatically on individually configured schedules for each stakeholder. Works out of the box, with full customisation options and on-demand delivery.
The report designer provides more control on the positioning and layout of report pages, and it addresses many of the printing limitations inherit in web browser rendering. It uses a third party component library to provide the reporting engine and a graphical What You See Is What You Get (WYSIWG) designer interface.
Sharperlight has multiple methods of data capture. From within Microsoft Excel, the Sharperlight Add-in can validate and bulk load records using its template driven Writeback interface. There are also Writeback formulas where the Sharperlight formula can be over-written, the input value is interpreted and updated in the data source whilst the cell is reverted back to the formula. In the web Sharperlight can generate web entry forms and entry grids. Typical uses of this feature include creating budgeting templates with built in business rules and validation.