How to Create a Performance Dashboard in Notion

Embedding a performance dashboard within Notion allows employees to analyze progress in the same application that they use for their core workflows.
Taylor Risner
Taylor Risner
Director of Ops at Superchart
April 13, 2023
how to create a dashboard in notion

Performance dashboards are powerful analytics tools that allow teams to measure progress toward key objectives and achieve business goals.  Many organizations leverage a business intelligence (BI) software vendor to meet internal reporting needs, but with the rise of low-code and no-code software applications, teams can create analytics dashboards without needing a complicated backend data infrastructure or expensive frontend BI application (closer to ad hoc reporting or ad hoc dashboards). 

For users of the productivity software Notion, it’s possible to embed a no-code performance dashboard within your team’s existing workspace. Notion is an all-in-one SaaS platform where many companies manage their daily tasks, collaborate, and stay informed on company progress. 

Given that many businesses leverage Notion as a centralized repository for team activity, embedding a performance dashboard within existing Notion pages allows employees to analyze progress without having to navigate to a different application. 

chart dashboard in Notion analytics ai visualization
sample dashboard in Notion, created using Superchart

This article will discuss how to:

  • Identify Key Performance Metrics
  • Create a Database With No-code Tools
  • Design a Performance Dashboard
  • Embed Data Visualizations in Notion
  • Share an Embedded Performance Dashboard

Identify Key Performance Metrics

The first step in creating a performance dashboard is to identify the key metrics that will help measure your team’s success.  Often, teams have key performance indicators (KPIs) that enable managers to proactively identify issues and make business decisions that drive individual contributors toward desired outcomes.  

Defining the right metrics for your team can be cumbersome.  It can be helpful to start small and consider both long term and short term goals.  For example, if a team has a quarterly sales goal of $100,000 in new revenue, consider the number of contributing sales reps, the amount that needs to be sold per month, and brainstorm the types of reports that would be beneficial in tracking progress toward this goal. While this is a simple example, it’s important to keep your reports straightforward and easy to interpret by all members on the team.  

While metrics will vary by team and industry, some examples include:


  • Gross & Net Profit Margin
  • Operating Cash Flow Ratio
  • Monthly Recurring Revenue (MRR) 
  • Burn Rate
  • Inventory Turnover

Customer Support

  • Average Resolution Time
  • Number of Open Tickets
  • Customer Satisfaction Score (CSAT)
  • Net Promoter Score (NPS)

Sales CRM

  • Win Rate %
  • Average New Customer Value
  • Opportunities Won by Month
  • Revenue by Industry
  • Revenue by Rep

In this article, we will focus on Sales CRM metrics to design a sample performance dashboard in Notion.

Create a Database with No-Code Tools

With the rise of low-code and no-code software, there are numerous ways to organize critical business data using simple, no-code databases.  Even if your organization has a sophisticated data pipeline and data engineering team, a no-code database enables teams to create their own reports without depending on technical engineering teams.  

Popular no-code database options include: 


While notion is known primarily as a robust documentation and team collaboration tool, Notion can also be used as a database.  To do so, simply create a new page and select one of the options in the database section.  We recommend using a table, which provides a spreadsheet-like structure to manually enter or import data.  

no code database of sales crm pipeline in Notion
Notion Database Example


  • Inline capabilities: A notion database can exist as a standalone page or as inline content—allowing users to view source data within the same page as the performance dashboard. This can help teams better understand and verify the source data represented in reports. 
  • Customization: The database structure itself can be changed from a table to a calendar, board, list or gallery—providing multiple viewing options for your performance dashboard’s source data. 
  • Rows are pages: Unlike a static spreadsheet or database, each row in a Notion database is its own page—meaning distinct rows can contain their own subset of customizable data, comments, or notes. 
  • Linked databases: Notion provides the ability to link databases between multiple pages.  For example, a database that contains data for both the sales and marketing teams can be linked on each team’s respective pages and filtered to only include applicable data for each team. This functionality ensures individual teams can only view their own data, even if a database contains cross-functional information. 


  • Limited integration options: While Notion can integrate with other applications, it was not built to handle large-scale data transfers.  If syncing data from another application into a Notion database, there are limits on how much data can be synced depending on your plan type.  
  • Slow load time with larger databases: Given that Notion was not built as a large-scale database tool, larger databases can cause slower page load times. Additionally, if Notion is used for all team processes and workflows, adding large linked databases into existing pages can hinder performance. 
  • Primary field is text only: Unlike a traditional database, the first column in a Notion database must be a text field.  This can be problematic if users desire a numeric value as a primary key. 


At its core, Airtable was designed to allow organizations to create databases within a low-code/no-code architecture.  Unlike Notion—a content management system that has some database capabilities—Airtable was designed to provide a user-friendly alternative to traditional spreadsheets and backend databases. 

no code airtable database sales crm pipeline data
Airtable Database Example


  • Linked records across tables: Just like a traditional database, a record can be linked from one table to another.  For example, multiple tables might include the column ‘Company’.  By linking the Company field between tables, data remains consistent and provides a relational data model similar to any traditional database. 
  • Robust integration offerings: Given that Airtable was designed as a user-friendly database option, the tool can integrate with over 1,000 websites and apps.
  • Handles massive amounts of data: Airtable was built to handle data.  Compared to Notion, users will likely experience faster load times and can sync more data into a table without hitting limits. 
  • Customizable primary key: The first column in any database is considered a row's primary key or record that differentiates the row from any other.  While Notion requires this field to be text-based, Airtable allows this field to be formatted in any of their supported data types. 


  • Less flexible for non-data use cases: While Notion supports both documentation and data in a single place, Airtable records are not designed to support large amounts of text.  Airtable really shines as a database vs a documentation tool, which could be a detractor depending on your team’s use case. 
  • Learning curve: For non-technical users that are unfamiliar with relational databases, Airtable will likely have a higher learning curve than Notion and Google Sheets.  
  • Price: Airtable’s Pro Plan is more expensive than Notion’s team plan and Google Sheets.

Google Sheets

Google Sheets can also be used as a no-code database. For anyone that’s used Microsoft Excel, the platform has a very shallow learning curve.  Like Airtable and Notion, Google Sheets takes traditional spreadsheets online and allows for real-time collaboration between teammates. 

no code database google sheets sales pipeline crm data
Sheets Database Example


  • Free: While Notion and Airtable require subscription fees for accounts that require large-scale data integrations, Google Sheets provides a free alternative for any users with a Google account.  
  • Small learning curve: Sheets provides an online, collaborative spreadsheet that will be familiar to any Microsoft Excel user. 
  • Convenience with Google Suite: For organizations that use Gmail, Google Slides, and other G-Suite tools, Sheets is convenient and easy to integrate with other use cases.  


  • No relational data model: Unlike Airtable, there is no connection or link between data contained in disparate Google Sheets.  This can lead to inconsistencies and errors in the data. 
  • Limited functionality and scalability: While Sheets allows for real-time collaboration between teammates, the service does not provide much functionality beyond that of a traditional spreadsheet.  Additionally, Google Cloud Storage limits can make it difficult to integrate large amounts of data without incurring costs or experiencing slow load times. 

Design a Performance Dashboard

After brainstorming key metrics and selecting a database provider, it’s important to consider the layout and design of your performance dashboard. Consider these key questions:

What’s the clearest way to order data visualizations on a dashboard? What visualization types work best for each report? What type of data do you want to include? 

Thinking about these questions helps to create a well-thought-out performance dashboard that logically tells a compelling story from your data. To design a clear and consistent performance dashboard consider the following best practices. 

Creating a Mockup

While mockups can be intricately designed in front-end user-interface (UI) applications, they can also be as simple as drafting your dashboard design with pen and paper.  Start with a lightweight rendering of the types of reports you want on your dashboard and think about the logical order in which they should appear.  You can draft and change a mockup as many times as you need.  This is simply a starting point to help determine the general layout of your performance dashboard, as well as the types of visualizations that are needed.

data visualization dashboard mockup online embed
sample dashboard mockup on pen and paper

Choosing Logical Visualization Types

Each data visualization type has a purpose and some can be better suited to display certain information over others. Consider the following as a general guide:

Single Value Metrics

A single-value metric should showcase a KPI that is a single, standalone value.  These should typically be formatted at the top of a performance dashboard and provide a quick gauge on how the team is progressing.  This number is often a percentage (e.g. % toward goal) or a total (e.g. 55 total opportunities).  Additionally, color coding these metrics can help users quickly understand team performance.  If a single-value metric contains a red value, this universally signifies that a metric is performing below a predetermined expectation.  Green, on the other hand, can indicate the team is on track.  

Comparison Visuals

Comparison visuals can consist of bar/column charts, pie/donut charts, area charts, ribbon charts, and shape maps.  These visualization types make it easy to compare the differences and similarities between values.  For example, a column chart that showcases revenue by sales rep can quickly highlight which rep is leading in sales for a designated time period. 

Embed Data Visualizations in Notion

After brainstorming your performance dashboard’s design, you’ll need to select a data visualization tool to create reports from your chosen database.  While Notion does not have native chart functionality, it’s easy to embed reports from other applications into existing Notion pages. 

To embed a report in Notion, simply leverage the ‘/embed’ command in an existing Notion page.  Almost any public-facing URL can be embedded within Notion, though the product has supported Embed blocks with the following applications: 

  • Abstract
  • Audio
  • CodePen
  • Excalidraw
  • Figma
  • File
  • Framer
  • GitHub
  • Google Drive
  • Google Maps
  • Images
  • InVision
  • Loom
  • Miro
  • PDF
  • Sketch
  • Tweet
  • Typeform
  • Video
  • Whimsical

sample of embedded visualization created using superchart

Some data visualization options include: 

Google Sheets

If Google Sheets is serving as your database, the service is an obvious (and free) choice for data visualizations as well.  Additionally, Notion has a preconfigured embed block for Google Drive, making it easy to copy a report’s share-URL and embed the data within Notion.  

The downside: Google Sheets doesn’t offer the sleekest visualization options.  It can take a significant amount of time to format reports and there are limited design options.  Charts are only a small portion of Google Sheets’ functionality, so the experience of creating visualizations can be inferior and time-consuming compared to more robust data visualization tools.  


Tableau is an extremely robust data visualization tool and the sky's the limit for the types of reports and dashboards that can be configured in the application.  Tableau is masterful at processing large amounts of data and dashboards can be customized to meet the look and feel of any organization’s branding. 

The downside: A Tableau subscription is expensive and has a steep learning curve for non-technical users. It can certainly be overwhelming, making it inaccessible to many business users, especially in the no code community. There are also compatibility issues with low-code/no-code services; for example, it’s often necessary to use a supported third-party embed block like CodePen to ensure tableau dashboards render properly in Notion.


Superchart is a new data visualization tool that was designed to be embedded in no-code tools like Webflow and Notion. The application integrates with Airtable and Google Sheets to easily import business data. Superchart’s data visualization options include modern, customizable elements that look professional, follow design best practices, and have a fresh appeal.  Additionally, changes in base data or chart design update automatically between Superchart and Notion. 

The downside: This new product has limited visualization types and database integrations. Their visualization types currently only include tables, pivot tables, bar charts, line charts, and column charts. And their database integrations currently only include Airtable and Google Sheets. 

Share an Embedded Performance Dashboard

Once your performance dashboard has been embedded into a Notion page, you’ll want to share the dashboard with others.  Before sharing broadly, it’s important to audit the dashboard and verify that the data is accurate.  It may even be worthwhile to create internal processes by which the data is reviewed, or assign an analyst to provide quality assurance (QA) on the dashboard before it’s released publicly. 

Additionally, after putting in the work to create your embedded performance dashboard, you’ll want to ensure processes are in place to leverage the data.  Use your performance dashboard in team meetings and standups to establish the data as an integrated part of your daily workflows. 

Finally, once the dashboard is ready to share, leverage the ‘Share’ settings in the top right corner of your Notion page.  This will allow you to invite new users and dictate relevant access levels for your teammates.  You can also share your Notion page publicly by selecting ‘Share to web’. This can allow your performance dashboard to be viewed by applicable parties outside of your organization. 

Free Template

Check out this performance dashboard we made using Superchart! 

Video Tutorials

How to Use Airtable, Superchart, and Notion to Create a Live Performance Dashboard

How to Use Google Sheets, Superchart, and Notion to Create a Live Analytics Dashboard

Want to give Superchart a try? Try it out for Free!

Woohoo! You have joined our waitlist.
Oops! Something went wrong while submitting the form.
Try it Free

Level up your skills

Check out our latest guide.

Other Blog Posts You Might Like