Accessible Business Intelligence
Over the years Dessa have been involved in the development and implementation of solutions for many retailers and have seen organisations struggle to deal with the volumes of data generated by, for example, point-of-sale systems. In fact, several companies have just given up and do not capitalise on this valuable resource. Many organisations merely scratch the surface of the potential benefits such information can deliver when fully exploited.


i-Spi is a cross platform application designed to take the huge volumes of data typically generated in a retail or wholesale organisation and convert it into valuable information.


Dessa have, in the past, developed and implemented analytical systems as part of an integrated ERP solution. The problem with this approach is that most retail companies already have administrative, financial and often merchandising / pricing applications implemented and running satisfactorily. This is why i-Spi has been designed to co-exist with these other applications rather than try to replace them. For example, SQL views of the retailer's merchandising database are typically used to provide the reference data for i-Spi rather than creating a duplicate database with all the associated problems of synchronisation.

The content of the i-Spi analytical database is limited only by the availability of source data within a particular organisation. Retailers vary in the type of data they collect and monitor apart from basic sales information. i-Spi is easily configured to accommodate whatever information is most relevant to a particular business.
An intuitive user interface


This sample shows a basic analysis of sales including comparison against another time period usually but not necessarily the equivalent period last year.

Most companies will start with a requirement to analyse Sales, Margins and perhaps Stock looking at profitability of various product groups and suppliers and also monitoring stock levels and projected stock cover based on sales trends. Having covered these fundamental elements of the business they can move on to other less obvious but often equally important measurements such as promotions and the promotional supports provided by suppliers, staff costs and productivity and performance against budgets and forecasts. They can also bring in purchase information and analyse both on-invoice and off-invoice discounts such as retrospective discounts, long term agreements and volume based buying thresholds.