How to Make a KPI Dashboard With Google Sheets

8 Minutes
Table of Contents
  1. How to create a KPI dashboard in Google Sheets
  2. How to create a KPI dashboard in Lido
  3. Conclusion: Try Lido Today

Key performance indicators, or KPIs, are a set of metrics that allow you to assess the state of your business. You can present KPIs through so-called KPI dashboards. In this complete dashboard guide, we will cover exactly how you can make a Google Sheets KPI dashboard in just a few simple steps.

How to create a KPI dashboard in Google Sheets

After finalizing the design of your KPI dashboard, follow these steps to create the dashboard in Google Sheets. You will get a glimpse of a sample dashboard for each step.

Step 1: Connect data sources to Google Sheets

You need to connect your data sources to Google Sheets. Google Sheets offers a diverse set of ways of importing KPI data to Google Sheets:

For our sample dashboard, we use the following sheets:

Raw data in Google Sheets
Raw data in Google Sheets

One good practice is to create separate sheets for each data source and then a seperate sheet or two for consolidating the data.

Step 2: Assemble the dashboard in a new sheet

Some of the Google Sheets features you can use are the following:

Our sample dashboard now appears as follows:

KPI Dashboard in Google Sheets
KPI Dashboard in Google Sheets

We used Pivot Tables for the table of values on the lower-left corner, while we used line charts to visualize the trend in the values. The scorecard chart was used to display the current values.

Click here to see the dashboard in action.

How to Create a KPI Dashboard in Lido

Our app, Lido, requires many of the same steps, but the user interface is optimized for easily importing data and creating simple but effective dashboards. Here are the steps:

Step 1: Connect data sources to Lido

The main strength of Lido is its built-in data import feature. Here are the steps:

1.a: Click Data on the upper-left corner of Lido.

Data import tab on Lido
Data import tab on Lido

1.b: Select the source from the list:

Available Data Sources
Available Data Sources

1.c: Either input access details (such as API keys) or log in through another tab or window:

Adding API Key
Adding API Key

1.d: After successfully connecting, you will be redirected to the Dataset Editor, where you can select tables, or even specific rows or columns, to import.

Dataset Editor
Dataset Editor

1.e: 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.

Data loaded into Lido spreadsheet
Data loaded into Lido spreadsheet

Step 2: Assemble the dashboard

Another strength of Lido is that it has its own Dashboard function.

2.a: Click the Dashboard on the top of the Lido spreadsheet. A blank space will appear where you can add components by clicking the Components tab on the right side and dragging the components into your dashboard.

Empty Lido Dashboard
Empty Lido Dashboard

2.b: Drag-and-drop components from the Components sidebar. Some of the components you can add are the charts, tables, metrics (Lido’s version of scoreboard charts of Google Sheets), and even maps!

Completed Lido Dashboard View
Completed Lido Dashboard View

Once you have finished constructing your dashboard, click Preview on the upper-right corner to see how the dashboard will look once deployed. When you share your dashboard, this is how it will appear to your recipients.

Dashboard Preview
Dashboard Preview

If you are satisfied, click Share to share your dashboard with others! Here is the link to the sample dashboard.

Conclusion

Have you noticed the two main advantages of Lido over Google Sheets?

  1. Easy-to-use data import feature
  2. Built-in KPI dashboard building feature

Lido is simply the superior choice for creating KPI dashboards! From the data import process down to assembling the components, Lido is optimized for your dashboard building project!

Interested? Click here to get started today! 

Enter Your Email Below to Try Lido for FREE!

Experience all of the benefits of the classic spreadsheet with much more powerful features that save users time!
  • One Click Data Imports From Anywhere
  • Transform Spreadsheets into Software in Seconds
  • Pre-built & Custom Templates
  • Visualize Real-Time Data in Centralized Dashboards
100% FREE - No Credit Card Required