Blog > Dashboards

Dashboard Pivot Table

Use the power of Lido to create a dashboard pivot table and visualize your data in minutes. Enter your email in the box below to get started!

  • Aggregate Data from Multiple Platforms
  • Import Data in One Click
  • Easily Visualize Key Performance Indicators
  • Simple to Share & Embed Dashboards
100% FREE - No Credit Card Required
Lido dashboard

What is a Dashboard Pivot Table

A dashboard pivot table is a tool that allows you to take large amounts of data and group it together so you spot key insights and track key performance indicators.

Why use one?

Displays data clearly - if you need to visualize data, a pivot table is the perfect solution for you!

Data is summarized by categories - your data is organized into categories to make them readable and easy to analyze.

Can aggregate data - basic aggregation operations such as COUNT and SUM are automatically included in the pivot table.

Saves time whenever you need data: the data is crucial in assessing the performance of your products. A dashboard gives you access to data in a short notice.

Helps you in decision-making: the time you gain from using the dashboard means you have more time for making important business decisions.

2 Simple Steps to Creating a Dashboard with Lido

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.

Step 2: Set up the dashboard

Set up the KPI formulas for each project. Lido functions are similar to that of Google Sheets, so you can apply to Lido what you have learned in our tutorials. 

After loading the data, click the Dashboard on the top of the Lido spreadsheet, then click the Components tab on the right side. For this case, you want to use the Table component in particular. 

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

Click Share to share your dashboard with others!

Click the Button Below to Try Lido for FREE!

  • Aggregate Data from Multiple Platforms
  • Import Data in One Click
  • Easily Visualize Key Performance Indicators
  • Simple to Share & Embed Dashboards
100% FREE - No Credit Card Required