Blog > Dashboards

Inventory Dashboard

Harness the power of Lido and create an inventory dashboard in minutes. Enter your details below to get started!

  • Pull in Inventory Data from Multiple Sources
  • Get Real Time Data for all SKUs
  • Highlights Low Inventory or Over-Supply
  • Connects to all Major Warehousing and 3PL Platforms
100% FREE - No Credit Card Required
Lido dashboard

What is an Inventory Management Dashboard?

An Inventory Management Dashboard gives you real time data on the state of your inventory so you can see things like inventory being close to out of stock or inventory with excess supply.

Why Use an Inventory Dashboard?

What KPIs Should You Include?

Some of the KPIs you can use to monitor your inventory are the following:

Stock to Sales Ratio: the ratio of stock available for sale versus the stock that has been sold

Sell-through rate: compares the inventory that enters your store and the inventory that you sell within a period of time

Inventory turnover ratio: how fast the inventory is “turned” or sold over a time period

On-time orders: the percentage of the time that customers receive their orders on time

Rate of returns: the percentage of shipped items that are returned to you

Cost of Carrying Inventory: the percentage representing cents per dollar that is spent on inventory overhead each year

3 simple steps to Monitor your Inventory with Lido

Here are the steps in setting up a dashboard in Lido:

Step 1: Create Lido Account

Sign up through either Google authorization or by specifying a username and a password.

Step 2: Connect data sources to Lido

This could be a database where your inventory is tracked or through an integration for your warehousing company or 3PL.

Clicking Data on the upper-left corner of Lido to select the source.

Follow the instructions on entering access info and selecting the data columns to import in the Dataset Editor. Once you have finished selecting your data, click Save dataset & edit view in the top right corner.  The data is now loaded to your Lido spreadsheet.

Step 3: Set up a dashboard

First set up the formulas for the inventory-related KPIs. Lido functions are similar to that of Google Sheets, so you can apply to Lido what you have learned in the tutorials in this site.

After loading the data, click the Dashboard on the top of the Lido spreadsheet, then click the Components tab on the right side. Drag-and-drop components and add data to them. 

Once you have finished constructing your report, click Preview on the upper-right corner to see how it will look once deployed. 

Share your dashboard with team members and company executives so you stay on top of your inventory.

Click the Button Below to Try Lido for FREE!

  • Pull in Inventory Data from Multiple Sources
  • Get Real Time Data for all SKUs
  • Highlights Low Inventory or Over-Supply
  • Connects to all Major Warehousing and 3PL Platforms
100% FREE - No Credit Card Required