Learn Tableau by Working on Exciting Dashboards - KPI (Key Performance Index)

This tutorial guides viewers through creating a KPI dashboard, focusing on total investment, today's gain, and overall gain. It covers setting up placeholders, formatting data, and calculating percentages. The tutorial also explains how to use conditional formatting with arrows to indicate positive or negative gains. The video concludes with final formatting adjustments and a summary of the KPI creation process.

What are the three components of the KPI discussed in the tutorial?

• Total investment, today's gain, overall gain

• Total revenue, today's loss, overall loss

• Total savings, today's expenditure, overall expenditure

• Total profit, today's sales, overall sales

What is the first step in creating the total investment KPI card?

• Formatting the grid lines

• Adding a new column for overall gain

• Calculating today's gain

• Creating a new sheet and renaming it

How is the total investment value displayed on the KPI card?

• As a text label

• As a pie chart

• As a bar graph

• As a line chart

What determines the color of the arrow for today's gain?

• The number of placeholders

• Whether today's gain is positive or negative

• The total investment amount

• The overall gain value

How is the percentage of today's gain calculated?

• By multiplying today's gain by the latest value

• By adding today's gain to the overall gain

• By subtracting today's gain from the latest value and dividing by today's gain

• By dividing today's gain by the total investment

What is the purpose of creating separate fields for positive and negative arrows?

• To reduce the number of placeholders

• To allow for different colors

• To simplify the calculation

• To increase the size of the arrows

Why can't the average of the overall gain percentage be used directly?

• It is not formatted correctly

• It is not a numerical value

• It is already an average and would not be accurate

• It is not available in the dataset

What is the final step in creating the overall gain KPI card?

• Adding grid lines

• Formatting the background

• Calculating today's gain percentage

• Dropping the positive and negative arrows

What formatting change is made to the currency in the final steps?

• Changing to Euros

• Changing to US dollars

• Changing to Indian Rupees

• Changing to British Pounds

What is the main focus of the tutorial's conclusion?

• Explaining the history of KPIs

• Discussing the importance of KPIs

• Introducing a new KPI component

• Reviewing the steps to create a KPI card