Market Basket Items Dashboard

Use this dashboard in conjunction with the Market Basket Associations and Market Basket Categories dashboards.  You'll be able to work through your analysis with a variety of detail using these dashboards, understanding the volume of activity that includes each category or item, and the associated activity that your customers transact.

It is important to note that the data considered begins with the date on the heading panel of the dashboard, under Earliest Transaction Date.  This means that your trends and filtered data will start with the transactions on this date.

You will see a link to this document in the heading of the dashboard, click on Dashboard Help to access the document.

On the right side of the dashboard you will use the filters to select the item you want to analyze and the date range for the analysis.  You must choose a single item for the analysis. You are able to select specific stores and also whether the sales are web based, store based or both.

KPIs

At the top of the dashboard are KPIs (Key Performance Indicators) that show for the selected date range, item & locations: total sales $ in the adjacent items, total quantity in adjacent items and the average item value of the adjacent items.  This will help you understand your customer buying habits when they purchase the item you are analyzing.  You may want to look at this information over a long time period, or perhaps during a special marketing or incentive drive. Was there a special display or marketing effort to promote a particular item - and what other sales did that produce? Is there a strong correlation between an item you are considering increasing or reducing in your inventory, and items that are regular sellers for your business? How can you merchandise your stores or website differently to promote the purchase of these items?

Graphics

Below the KPIs are graphics that represent the same information, by item.  Of the additional sales $ and quantities, you will see the allocation to each of the adjacent items.  This will inform you at the most granular level what your customers are putting in their basket when they purchase the item you selected to analyze. You may be studying this dashboard when you are considering a reduction or elimination of a particular item - you can see here if the balance of these transactions include other items that are high-sellers for you - perhaps the item you are analyzing provides a low margin, yet is often purchased at the same time as your best seller.  Maybe a new item sold fast & furiously when it hit the market - what else sold with it? Was that similar across your locations?  Are there similar items that can be marketed along side this new item to help your customers find something they don;t yet know that they want?

The mini data table below the item value KPI shows you the sales $, quantity and item value by item.  You are able to sort this table by using the up & down arrows at the top of each column.

On the pie charts, if your distribution contains "Other" as a grouping, this represents the smaller sections of item sales - click on the "Other" section to expand that section; to revert back to the initial graphic, click on the "Back" button that appeared when you clicked on "Other".

The next set of graphics illustrate the top adjacent items in sales $, quantity and item value. Is a single item outpacing the others?  Are there a few items that are purchased together - understand how this might have been suggested to your customers, or if they naturally purchased certain items to compliment the others. Is there a high-value item that makes the list that you can suggest to future customers? Maybe there is a combination discount you can offer if certain items are purchased together.

Next you will see a correlated sales table for the other items purchased, including the sales $, quantity and transactions per customer.  In each column you will see a highlighted value, where the correlation is the highest. Average Sales $ and Quantity per Customer will show you the appetite of your customer base - and filtering by location could lead you to valuable insights about merchandise allocations in different geographic areas, or calendar ranges.  Remember that these metrics are correlated to the item you selected to analyze - so they are included in the same transaction as the item you selected.

The polar chart below the table draws your attention to the correlation of sales $ in each item.  Here you can see at a glance whether there are few, or many, high selling items in the same purchases. Hovering over the markers will reveal the detail of the sales $.

Any of the data tables can be exported to work with the data outside the dashboard. Do this by clicking on the 3 dots at the top right corner of the widget, choose Download and export an image or file.  The recommended file type for a spreadsheet is CSV.