Business Intelligence Dashboard

Why should you use a business intelligence dashboard?

Gives a bird's-eye view of your business - it helps you see how your business performs in the market.
Easy-to-use - if you use Lido, you can easily assemble a dashboard in a few clicks even if you do not know any programming language!
Saves time whenever you need data - the data is crucial in assessing the performance of your business. A dashboard gives you access to data in a short notice.
Uncovers market insights and trends - business intelligence is mainly used to stay ahead of the competition, and one way is to be able to identify first the market trends.
Helps you forecast future sales and revenue - Easily forecast future revenue by tracking not just sales but also other relevant metrics across several channels.
Improve your business processes - You can identify the strong and weak points of your business, leveraging your strengths and minimizing your weaknesses to further the growth of your business
Helps decision-making - Helps companies visualize their real time data so they can keep track of KPIs, draw key insights, and make the best decisions.

Most common KPIs to include

Customer satisfaction

Customer satisfaction score: Often appearing as “N out of 5 stars” it describes how happy the customers are with the product

Net promoter score: How likely your customers will recommend your product to others

Number of support tickets a month: Number of customers requesting product support per month

eCommerce

Average order value: the average total price per order

Conversion rate: percentage of the total number of visits to a website that result in a purchase

Lifetime value: the total amount of money a customer is expected to spend on your products during their lifetime

Finance

Cash conversion cycle: how long it takes a company to convert a dollar invested in inventory into cash from its sales

Net working capital to assets ratio: how much capital you have at your disposal to invest in the business (or payout to the owners/shareholders) at any point in time

Operating cash flow margin: how much cash your business is generating as a percentage of revenues, also another way of representing how much capital you can invest

How to create a business intelligence dashboard with Lido

After creating an account in Lido, you are now only two steps away from setting up your dashboard for business intelligence:

Step 1: Connect data sources to Lido

Click 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.

Do this again for each source you need.

Step 2: Set up the dashboard business intelligence

Set up the formulas for the KPIs you want to include. Lido functions are similar to that of Google Sheets, so you can apply to Lido what you have learned in our previous Google Sheets tutorials.

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.

If you need to feature more aspects of your business, you can create a new dashboard and add the components. Once you have finished placing the components, click Preview on the upper-right corner to see how it will look once deployed.

Do it a few more times for each aspect you want included.

Once you completed the dashboard business intelligence, click Share to share your report with others!