Introducing Sharperlight 4: Low maintenance, highly flexible business intelligence platform

Sharperlight allows you access to data across multiple enterprise systems helping to make truly intelligent and timely business decision 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 intelligence.

Explore Product Features

Live, Dynamic & Refreshable Reports

Through Sharperlight's Bidirectional Writeback system, your data is securely shared between all your enterprise locations, updated and validated in real-time via the intuitive data entry and reporting interface.

  • Excel® Addin with secure and direct access to data sources – refresh with current data
  • Web channel displays tabular html and rendered charts using Kendo UI for beautiful graphical presentation with drilldown
  • Refresh chart data in real time
  • Enterprise wide access to sources
  • Rapid report creation, publication and delivery
  • Low maintenance
  • No embedded SQL encourages central Datamodel
Explore Enterprise Reporting

Fully Customised & Fully Secure

Use Sharperlight Foundry to create new operational data applications that plug into existing Sharperlight solutions and the dynamic Sharperlight Datamodel Layer. Present data with ease across mobiles, tablets and desktop browsers. Capture date into the new solution - All with Sharperlight tools. Each new application is secured using the Sharperlight security layer and single sign-on access.

  • Use CUSTOM licence to create connections over new data sources to create a fully dynamic and secure interface
  • Use Sharperlight Foundry to build completely new operational data systems that seamlessly plug into the Sharperlight Enterprise Reporting solution
  • Presents data on multiple platforms, mobile, tablet and browser
  • Foundry will build the new database, relationships, Datamodel, web pages for reports and data entry forms and writeback solutions – all in one hit.
Explore Customised Solution Development

Capture Data Anytime, Anywhere

Track and share from anywhere. Secure and configurable platform-optimised apps turn any smart device into a powerful data entry system. Connect all your enterprise business systems with intelligent, context-sensitive tools, ensuring clean & valid data every time.
Use the Sharperlight Excel® Addin to bulk load data or the Web-Channel to capture data in a browser.

  • Configure Data sends and writeback operational data into solutions using secured and configurable Interface layer
  • Enter data using enhanced tools like ADE that extend Excel® to deliver touch screen data entry
  • Capture data on mobiles and tablets using configurable Web forms, from basic forms to custom advanced Java script support
Explore Data Capture

Build Your Own Datamodel

Create highly specialised, business-aware datamodels designed to fit the needs of your organisation. Sharperlight Studio provides detailed features for comprehensive datamodel and connection template development.

  • Dynamic Datamodel creation interface
  • Build access to Custom systems or even create new systems using Sharperlight Foundry then extend them further in Studio
  • Create your own Datamodel over the systems in your company or your client
  • Build extension datamodels with new functionality for well used systems like modules for Dynamics® GP (Great Plains) and SAP® Business One, MYOBEXO and many others
Explore Datamodel

Fresh Reports When You Want Them

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.

  • Configure reports to run automatically with built in process flow options
  • Send emails and notifications, RSS feeds and Exceptions
  • Create dynamic schedules and multi burst reports that optionally deliver reports based current calculated values
  • Save PDF and Excel® reports to disk
  • **Requires at least 5 User Licences
Explore Reports
Prev Feature Next Feature

Suite of Components

Each core feature of Sharperlight 4 is made up of a suite of individual components. They can be used independently to help you shape and refine your information to exactly how you want.

Web Reporting

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.

  • The web content delivered through Publisher can be graduated with basic HTML4 tables, more complex HTML4 with Javascript automation, all the way to sophisticated HTML5 visualisations.
  • The core charting engine renders the graphics in HTML5.
  • Every published query has a unique web address referencing the query and the output style. This means each query can be uniquely referenced in a webpage, or in an email, or bookmarked in a web browser.
  • For pixel perfect report layouts, Publisher has a WYSIWYG report designer that can output reports to PDF, HTML and Microsoft Word.


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.

  • Tiles have a default content view and an expanded view that can be displayed by double clicking on the tile title bar.
  • A single dashboard can mashup content from multiple data sources.
  • Every dashboard has a unique URL address and thus, they can be embedded into any browser interface that supports a URL.
  • Tiles can auto align to each other or overlap, each can have different colour scheme and tooltips can be added to the tile title bar.

Excel Reporting

The Sharperlight Excel® Add-in gives end-users easy access to the Query Builder and a drilldown data explorer. The Sharperlight queries are ancored 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 Microsoft Excel Add-in is compatible with Excel 2007, 2010, 2013 and 2016
  • Cell, Table and Sheet formulas.
  • Filter with cell referencing and automatic lookup windows appear when double clicking referenced cells.
  • Query Manager for managing and re-using seed queries in the same workbook.
  • The Sharperlight formulas are drilldown points which can loaded into Explorer for slice and dice analysis.

Data Capture

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. The 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.

  • All data updates are managed through the secure datamodel layer where rules and constraints are enforced.
  • Extensive control on lookup and validation lists to ensure that incomplete or erroneous information is caught in the data entry and not during the data load.
  • Data capture uses the Sharperlight Web Service to interface with the target data store and therefore, the data entry does not need a direct connection to the target system.

Query Builder

The Query Builder is a user interface with separate panes for filters, field selection and output. Simple enough for the infrequent user but it does have 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 datamodel acts as a presentation layer between the complexity of the data source and presents to the users a unified view of query tables, with available fields and relationships.
  • The Query Builder uses drag and drop to select filters and outputs, most fields can be a filter and/or an output. The query engine will construct the query on the fly and optimise the syntax.
  • The filters can inherit and display lookup lists from the datamodel and there are standard lookup wizards for dates and periods.
  • Query results can be previewed in the Query Builder to assist in query design and Preview grid supports drill for further analysis.


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.

  • Optionally and conditionally execute reports that can store, save and email content.
  • Include expression based logic to drive multiple scenarios.
  • Send notification and exception reporting.
  • Create, collate and deliver Board Report packs.

Agile Datamarts

It is sometimes useful to have the ability to stage query data into a physical data set that can be summarised for performance or fixed to allow consistent reporting. Often referred to as Agile Datamarts, Sharperlight has a simple end-user interface called Materialised Query for designing and populating physical tables based on a query.

  • The data can be refreshed at will or on a schedule, or it can be held indefinitely as an audit history.
  • Materialised queries are presented to the end-user as just another datamodel and they can be queried using all the standard Sharperlight functionality and presentation tools.

Solution Development

Sharperlight is an application framework for interacting with complex operational databases and it controls all data interactions using an abstraction layer called a Datamodel. These models are developed and maintained using a Studio designer and at the lowest level they encapsulate data structures, relationships and business rules.

The data definition is only part of the story, datamodels have a rich command language and data access can be controlled and modified based on system, user and data events. Datamodels are also fully multi-lingual, just like the Sharperlight application, and a datamodel can combine .NET code and package WinForms and web content.

Whilst many Sharperlight customers utilise it for spreadsheet integration, self-service reporting, web reporting and dashboarding; it has a much bigger picture. Sharperlight has a secure gateway and a web service, a datamodelling concept that can unify information from numerous data sources and the tools to quickly develop datamodels and user content.


Datamodel and application interfaces are secured on the server using Site Setup. User authentication is available as a native login, using Windows Authentication, Active Directory Groups and LDAP Groups. A datamodel can have its own data security layer which secures the visible query objects and enforces record level security.

Report Designer

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.

  • Uses the Query Builder to construct the data sets and it automatically integrates the query as a report data source.
  • Allows pixel perfect control of field and object placement for reports and business documents.
  • Reports can be accessed through the Sharperlight Web Service and run locally on computers that have the Sharperlight rich client.
  • In the web the reports use the common filter bar to feed parameters back to the underlying reporting engine.
  • The reports can be rendered into PDF and native HTML, it also supports output to Microsoft Excel and Word.

Supported Connectors

Sharperlight has been developed for advanced business integrations and tested with over 50 data model connectors to provide as much flexibility for your needs as possible.

Simplifying Your Business Intelligence, regardless of sector

The Sharperlight framework is used in many business sectors, including Finance, Government, Farming and Mining, Healthcare, Retail, Sports and Education. Sharperlight is not dependent but rather will adapt to your vertical.
With the concept of Custom Connectors you can quickly and easily add a new connector to the framework.

Aged Care/Health Care

Featured Case Study

Ocean Grown Abalone

A sophisticated yet easy-to-use Abalone Management System (AMS)

OGA are the world leaders in Sea Ranching technology for the culture of Greenlip Abalone. Tracking abalone stocks is critical, requiring assessment of mortality and size growth to establishing underwater biomass estimates of both shell and meat weight.

Sharperlight stepped in to provide comprehensive on-water tablet and mobile phone entry and access to cloud-stored data, following every aspect of underwater abalone movement. AMS reports project theoretical growth rates for business forecasting and, as the data becomes available, tracks against actual results.

Featured Case Study


ATG drives productivity and gross profit through competition between sales staff.

Each sale that is made through their ICE system gets reflected in the ATG solution, aggregating into a Dashboard that shows all products and employees per store.

Customer Overview

ATG uses Sharperlight to target, track and report progress of shop floor sales staff; reporting from actual POS, financial and targeting systems, to generate in-shift data to drive gross profit margins.

Sales staff are driven through incentives, as directed on a monthly basis, through targets defined by Australia’s leading telecommunication company Telstra®.

ATG services T-Life® shops with targets and incentives as the sales happen, and assists store managers with reporting requirements made easy with Sharperlight.

Featured Case Study

Oil and Gas

This industry leader embarked on an asset management system upgrade but while doing so discovered their reporting tool was being sun-setted. They decided to replace the tool and seize the opportunity to address their poor cost management visibility and inability to access reports via the web.

Sharperlight by philight was chosen; working together, the new reporting framework was implemented in a short period of time over a large database of 60 million transactions processing 450,000 – 500,000 transactions per month. It was all successfully completed on time and with no adverse effects.

Significant benefits were achieved immediately; improved asset management; accurate tracking of both asset maintenance & costs vs. budget; government compliance; improved productivity, less duplication and less rework. In addition, the framework has been so successful that the IT department want to replace their SQL reports with SharperLight versions to reduce rework and improve security.

Featured Case Study

Higher Education

The University of Western Australia (UWA) decided to upgrade their asset management system, Maximo®, but found their existing reporting tool was not compatible. With multiple databases; a focus on quality & compliance; and a need to easily generate accurate key reports in Excel®, Word® and HTML, they started a search for a replacement system.

Sharperlight by philight was chosen; working with the UWA team, the new reporting framework was implemented in a relatively short period of time.

UWA reaped significant benefits; more accurate information, improved data security, time and resource savings, compliance, and happy staff.

Enquire now to see how our revolutionary business intelligence can help your customers