Using Retail Market Intelligence Data in Dashboard Reporting

Recently, we were working with an Illuminate user in London. The task ? To help them sell more, profitably.

We performed a lot of deep analysis of the markets in which they operated, in particular their on-line stores, bricks-and-mortar sales, and their EBay and Amazon stores. We gained an understanding of their problems and way of working. We decided to build an on-line platform to help them to understand their data and make better decisions, with Illuminate’s dashboard reporting (based on Power BI) and the DAX language.

A lot of data is now gathered by the business. This is market intelligence data from various on-line platforms, gathered largely through APIs, plus in-house data from the Illuminate system. This data is formatted, clean and enriched, before being loaded into a data warehouse, from where it can be analyzed in Illuminate dashboards.

Product data is generally analyzed according to its sell-through rate and profit margin (albeit, sometimes very small profit margins). These thin profit margins are maintained by AI algorithms that set prices by deep analysis of a product’s selling rate, its price and what competitors are selling it for.

The result ? Increased profits ! Keeping on top of the market and knowing what to sell and at what price is crucial in today’s tough, competitive retail market. By utilizing a correctly designed data warehouse, continuous data feeds, Illuminate and its Power BI dashboards, you stand a much better chance of keeping ahead of your competitors.

If you’d like to know how we can help your retail business, please get in touch on 0207 720 6531.

Customer E- Mail Communication

Illuminate streamlines dealing with customer e-mail messages by integrating all messages into one central location, and messages are sorted so that those which relate to live orders are prioritised. This means that the most important messages (from paying customers) are dealt with first, and those which are product questions or general enquiries (still important, but less so than live customers) are dealt with later.

Customer E-Mails

Messages relating to an order, such as a return request, are associated with the order, ensuring that a complete history is available.

Customer E-Mails

Templates for message replies can be set up, together with mail-merged fields from the order, making replying to customers quicker and more consistent. This ensure that all customer communications adhere to company best-practice policies. Parcel tracking numbers  can also be e-mailed to customers,  allowing them to view their order progress at all stages.

if you’d like to know more, please see our full product video below. Or give us a ring on 0207 720 6531. We’re very friendly.