By Jim Lewis, CEO Increased Retail Methods LLC

Folks adore dashboards. But unless it is actionable or telling them anything they do not know, they get uninteresting swift. A very good dashboard ought to offer insights that would or else go unnoticed. An even improved dashboard is a single that supplies something that is especially actionable.

Precisely actionable means it need to guide the consumer to an prospect or legal responsibility that can be acted on. In our globe that implies pointing out items and suppliers that are bought out, objects with as well a great deal stock, a shift in size or color, and so on. It’s more than just filtering. It will have to be smart. For illustration, it doesn’t require to demonstrate you products that are marketing out immediately if they are marked down.


The information offered in a dashboard should really reflect the reader’s part. For example, gross sales executives normally want to glimpse at things at a superior amount with comparative information (TY v. LY, etcetera.). Planners call for far more element- one thing that prioritizes troubles or opportunities and provides them solutions in 1 or 2 clicks. In typical, a properly-produced dashboard need to contain a stability of visualizations, very easily digestible KPI’s and brief views of focused facts. It could possibly incorporate:

  • The State of the business enterprise about distinctive time durations. The core KPI’s and comparisons.
  • Visualization of stock and gross sales ratios. Should really be drillable into departments, lessons or what ever hierarchy is utilised.
  • Interactive cards. This is the actionable region. Rank the prospects and liabilities and have a connection to a template or details feed with calculations on it for quick implementation. For illustration, for marketed out goods, click on the item and get an allocation, pre-calculated by the program.
POS Sales and Inventory Dashboard

A good dashboard have to be actionable.

We’ve Acquired the Electrical power (BI)

There are numerous fantastic visualization tools on the market place to establish dashboards. The critical is obtaining the abilities to know what to set in it, and how to hook up and extract info at the many concentrations required. In several situations we custom made style and design dashboards from scratch because it features the final diploma of customization. For just about anything else we use Microsoft’s Electricity BI. It’s functional and if you have a excellent know-how of programming in Business office (VBA) you will come to feel right at household.


Irrespective of the platform you pick out, a dashboard is useless without the need of data. We integrate POS revenue and inventory, ideally at retailer level. For really large details sets, you can compact retail outlet degree info into a summary see. You can also combine other details sets this kind of as a supplier’s wholesale inventory (from ERP) or tables containing promotions or seasonality.

For extra facts about how ERS can enable you visualize your business enterprise, get hold of us.

Leave a Reply