how to make a kpi card in tableau

"How to Create Stunning KPI Cards in Tableau"

By Hannah Anderson
AD

Data visualization is a powerful tool in today's business world, enabling companies to communicate complex information effectively. Among the many tools available, Tableau stands out, offering a user-friendly interface and robust features for creating compelling visualizations. One of the most impactful ways to convey key insights is through KPI (Key Performance Indicator) cards. These cards summarize performance metrics in a simple, easy-to-understand format. So, how do you make a KPI card in Tableau? Let's dive into a step-by-step guide.

Before we start, ensure you have a basic understanding of Tableau and have downloaded and installed it on your computer. Once you're ready, let's explore the process of creating a KPI card, which involves several key steps.

Preparation and Design

The first step in creating a KPI card is defining your KPI. This should be a measurable value that demonstrates how effectively you're achieving key business objectives. It could be a sales target, customer satisfaction score, or any other metric that's crucial to your organization's success.

AD
Power BI KPI Cards & Slicers: Build Interactive Dashboards
Power BI KPI Cards & Slicers: Build Interactive Dashboards
Free Tableau Tutorial: Build Data Maps in 2 Clicks - No Coding Required
Free Tableau Tutorial: Build Data Maps in 2 Clicks - No Coding Required
Easy Steps to Create a Dashboard in Tableau
Easy Steps to Create a Dashboard in Tableau

Once you've identified your KPI, decide on the design. KPI cards are typically designed to be simple and minimalistic, with plenty of white space to focus attention on the KPI itself. They usually include the KPI title, the current value, a target value, and a visual indicator of performance, such as a traffic light system or a goal-seeking gauge.

Data Preparation

The next step is to ensure your data is ready for visualization. In Tableau, this involves connecting to your data source - whether it's an Excel file, a SQL database, or a text file - and confirming that the KPI you want to display is already in your dataset. If not, you may need to create a calculated field to define your KPI.

two screens showing how to use excel chart dashboards for dashboarding and data flow
two screens showing how to use excel chart dashboards for dashboarding and data flow
KPI vs Metric vs Dashboard — What's the Difference?
KPI vs Metric vs Dashboard — What's the Difference?
Employee Performance Rating Card and Dashboard in Excel
Employee Performance Rating Card and Dashboard in Excel

For instance, if your KPI is gross margin, you might need to create a calculated field in Tableau that subtracts cost of goods sold from revenue and divides the result by revenue. Once you've created and tested your calculation, you're ready to create your KPI card.

Creating the KPI Card

To create a KPI card, open Tableau and connect to your data source. Once you're in the 'Canvas' view, right-click and select 'Create Card'. This will open the 'Format' pane, where you can customize your KPI card. In the 'Field' dropdown, select the KPI you want to display. Then, use the other formatting options to adjust the size, color, and text style of your KPI card.

AD

One of the most powerful features of a KPI card is its ability to indicate progress towards a goal. To add a goal to your KPI card, right-click on the card and select 'Add Goal'. In the 'Goal' dialog box, specify the target value and choose the goal's format and color. Then, you can add a traffic light or other visual indicator to show how close you are to your goal.

How to Build a KPI Dashboard That Actually Drives Decisions | Stackset
How to Build a KPI Dashboard That Actually Drives Decisions | Stackset
Tableau How-To: Create neat-looking KPI cards - The Data School
Tableau How-To: Create neat-looking KPI cards - The Data School
Sales Performance Tracking Dashboard in Excel
Sales Performance Tracking Dashboard in Excel
IntelliFront BI Release 2.1.4 Now Available
IntelliFront BI Release 2.1.4 Now Available
Monitor all aspects of your sales department with our KPI dashboard!
Monitor all aspects of your sales department with our KPI dashboard!
Tableau vs Power BI: Key Differences You Must Know!
Tableau vs Power BI: Key Differences You Must Know!

Customizing the KPI Card

Once you've created your KPI card, you can customize it further to ensure it's clear, compelling, and easy to understand. There are several ways to do this, including:

Using Pre-Attentive Attributes

Pre-attentive attributes are visual cues that grab our attention without requiring conscious thought. They include factors like color, size, position, and shape. By using pre-attentive attributes, you can make your KPI card more engaging and easier to understand. For instance, you might use color to differentiate between different categories in your data, or size to show the relative importance of different KPIs.

AD

Top Tip: Be cautious when using color to distinguish data. Not everyone can differentiate colors, so it's important to supplement color with other visual cues, such as shape or position.

Steps to Build Your First Dashboard
Steps to Build Your First Dashboard

Formating the Card for Adequate Impact

Top Tip: Remember that less is more when it comes to KPI cards. Keep the design simple and minimalistic to avoid distracting from the KPI itself.

AD

Adding Context to Your KPI

While KPI cards are typically used to display a single metric, they can become more powerful with context. To add context to your KPI card, you might consider adding a comparison, such as the percentage change from the previous period, or a forecast showing where the KPI is headed in the future.

To add a comparison or forecast, you can use Tableau's 'Trend Line' and 'Difference from' tools. These allow you to add a line to your KPI card that shows the trend over time, or the difference from a previous period, for instance.

So, there you have it - a comprehensive guide to creating a KPI card in Tableau. Whether you're a Tableau beginner or an experienced user looking to refine your skills, understanding how to create effective KPI cards can help you communicate complex data points in a clear, engaging, and insightful way. Now go forth and create some compelling KPI cards of your own!

AD