By Jim Lewis, CEO Increased Retail Options LLC

Persons enjoy dashboards. But except it is actionable or telling them something they really do not know, they get tedious fast. A excellent dashboard should really supply insights that would or else go unnoticed. An even improved dashboard is 1 that delivers a thing that is particularly actionable.

Specifically actionable usually means it will have to direct the user to an chance or legal responsibility that can be acted on. In our entire world that indicates pointing out things and suppliers that are bought out, objects with also a great deal inventory, a shift in sizing or coloration, and many others. It is far more than just filtering. It ought to be good. For illustration, it does not want to clearly show you items that are selling out rapidly if they are marked down.


The facts introduced in a dashboard must mirror the reader’s part. For example, income executives normally want to appear at points at a higher amount with comparative information (TY v. LY, etc.). Planners involve a lot more element- something that prioritizes complications or options and provides them responses in 1 or 2 clicks. In standard, a very well-constructed dashboard really should include a equilibrium of visualizations, very easily digestible KPI’s and swift sights of targeted information. It may involve:

  • The Point out of the organization above distinct time intervals. The main KPI’s and comparisons.
  • Visualization of inventory and profits ratios. Really should be drillable into departments, courses or what ever hierarchy is utilised.
  • Interactive playing cards. This is the actionable location. Rank the options and liabilities and have a connection to a template or facts feed with calculations on it for quick implementation. For instance, for offered out products, simply click on the product and get an allocation, pre-calculated by the process.
POS Sales and Inventory Dashboard

A good dashboard must be actionable.

We have Bought the Electric power (BI)

There are many great visualization tools on the current market to make dashboards. The crucial is owning the expertise to know what to set in it, and how to hook up and extract info at the different concentrations essential. In numerous situations we custom made style dashboards from scratch for the reason that it provides the best degree of customization. For anything else we use Microsoft’s Energy BI. It’s multipurpose and if you have a excellent know-how of programming in Business (VBA) you are going to sense suitable at house.


Irrespective of the system you select, a dashboard is ineffective without the need of info. We integrate POS product sales and inventory, if possible at keep level. For pretty significant info sets, you can compact shop level information into a summary view. You can also integrate other details sets this sort of as a supplier’s wholesale stock (from ERP) or tables made up of promotions or seasonality.

For additional facts about how ERS can aid you visualize your small business, contact us.

Leave a Reply