Creating Actionable POS Dashboards – Retail Sales & Inventory Reporting


By Jim Lewis, CEO Increased Retail Methods LLC

People today really like dashboards. But unless it is actionable or telling them some thing they do not know, they get boring quick. A fantastic dashboard should offer insights that would if not go unnoticed. An even greater dashboard is one particular that supplies a thing that is particularly actionable.

Specially actionable suggests it will have to guide the user to an opportunity or liability that can be acted on. In our world that suggests pointing out products and outlets that are marketed out, merchandise with too a great deal inventory, a shift in measurement or coloration, and so on. It’s extra than just filtering. It should be clever. For case in point, it does not need to clearly show you goods that are marketing out immediately if they are marked down.


The facts offered in a dashboard should reflect the reader’s purpose. For instance, profits executives normally want to appear at things at a higher level with comparative information (TY v. LY, etcetera.). Planners need a lot more depth- a little something that prioritizes difficulties or options and provides them solutions in 1 or 2 clicks. In basic, a very well-manufactured dashboard should contain a harmony of visualizations, effortlessly digestible KPI’s and brief views of qualified information. It may include things like:

  • The Point out of the business over different time durations. The main KPI’s and comparisons.
  • Visualization of inventory and income ratios. Need to be drillable into departments, lessons or whichever hierarchy is utilised.
  • Interactive cards. This is the actionable place. Rank the options and liabilities and have a connection to a template or information feed with calculations on it for uncomplicated implementation. For example, for sold out things, click on on the item and get an allocation, pre-calculated by the method.
POS Sales and Inventory Dashboard

A fantastic dashboard will have to be actionable.

We have Obtained the Electricity (BI)

There are many fantastic visualization equipment on the marketplace to create dashboards. The critical is acquiring the experience to know what to place in it, and how to hook up and extract details at the many concentrations necessary. In several circumstances we personalized layout dashboards from scratch mainly because it gives the greatest degree of customization. For just about anything else we use Microsoft’s Energy BI. It is flexible and if you have a good know-how of programming in Office environment (VBA) you are going to feel proper at house.


Regardless of the platform you pick, a dashboard is ineffective without knowledge. We combine POS sales and stock, if possible at shop amount. For incredibly huge facts sets, you can compact retailer level facts into a summary perspective. You can also integrate other data sets this sort of as a supplier’s wholesale stock (from ERP) or tables that contains promotions or seasonality.

For much more details about how ERS can support you visualize your business, call us.

Leave a Reply