This article shows how to create a view that shows Key Progress Indicators (KPIs). A Key Performance Indicator is a measurable value that shows how effectively a company is achieving key business objectives. At a high level, the procedure requires you to do the following:
Create a view that includes the field or fields (measures) you want to assess.
Create a calculated field that establishes the threshold that demarcates success from failure.
Update the view to use KPI-specific shape marks to show which values are above the threshold and which are below.
Tableau tutorial for developing business kpi dashboards which is having good color and design for easy consumption of information by end user.Editable Tablea. Tableau Tip: Building KPI Dashboards with Shapes. One of the coolest things to do with dashboards is dynamic shapes for good news/challenges. This is a unique visual cue that I utilized for the Surrey Council Project. I’m going to use the superstore dataset to show you how you can build it too!
A Tableau Prep flow to tie the data together. Sample Tableau Prep flows to inspire you to further automate your data collection. Want to dive deeper? Check out this on-demand webinar, “Gaining critical insight with the Executive KPI Dashboard” or this blog, entitled, “Accelerating understanding with the Executive KPI Dashboard Starter Kit”. Create a Big Number KPI Dashboard in Tableau Public. Start Guided Project. Tableau is widely recognized as one of the premier data visualization software programs. For many years access to the program was limited to those who purchased licenses. Update the view to use KPI-specific shape marks. On the Marks card, select Shape from the drop-down list of views: Drag the KPI field from the Measures area of the Data pane to Shape on the Marks card. Click Shape on the Marks card to open the Edit Shape dialog box. For more about shapes, see Shape in Change the Type of Mark in the View.
Note: When connected to Microsoft Analysis Services, any KPI calculations defined in the cube are not available in Tableau. But as the procedure below demonstrates, you can write your own KPI calculations directly inside Tableau, and then use Tableau parameters to create highly flexible what-if KPI analysis. For more on special considerations for cube data sources, see Cube Data Sources.
The scenario uses the Sample - Superstore data source provided with Tableau Desktop to show how to build a KPI view that displays a green check mark for any sales figure over $25,000, and a red X for any sales figure under $25,000.
Create a view that includes the field you want to assess
In this case, that field is Sales.
Connect to the Sample - Superstore data source.
From the Data pane, drag Sub-Category to Rows and Region to Columns.
From the Data pane, drag Sales to Text on the Marks card.
Create a calculated field that establishes the threshold that demarcates success from failure
In the Analysis menu, select Create Calculated Field to open the calculation editor. Name the calculation KPI and type or paste the following in the formula area
IF SUM ([Sales]) > 25000 THEN 'Above Benchmark' ELSE 'Below Benchmark' END
Tableau Kpi Dashboards Examples
Update the view to use KPI-specific shape marks
On the Marks card, select Shape from the drop-down list of views:
Drag the KPI field from the Measures area of the Data pane to Shape on the Marks card.
Click Shape on the Marks card to open the Edit Shape dialog box.
For more about shapes, see Shape in Change the Type of Mark in the View.
From the Select Shape Palette drop down list, choose KPI.
Now you are ready to associate specific values for the KPI field with specific shapes.
Click Above Benchmark under Select Data Item and then click the green check mark in the palette.
Click Below Benchmark under Select Data Item and then click the red X in the palette.
The Edit Shape dialog box should now look like this:
Click OK to close the Edit Shape dialog box.
The shapes in the view show the correct indicators. Now you just need to hide the sales numbers.
Drag SUM(Sales) on the Marks card to Detail.
Tableau Public Kpi Dashboard Definition
You now have a completed view that show how individual products (sub-categories) are performing across all four regions:
The view may not be terribly exciting on its own, but it would make a nice addition to a dashboard that showed other performance metrics.