Creating Pie Visualizations in Kibana 7.6

1.5 hours
• 3 Learning Objectives

Pie visualizations are one of the most popular ways to demonstrate the distribution of some metric over a set of values. Visualizing the proportions of values in relation to the sum of values is an intuitive way of communicating significance. In this hands-on lab, we will use pie chart visualizations to answer questions that seek to understand the significance of values within a data set.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Create and Save the Most Delayed Carriers Visualization
1. Create a new pie visualization.
2. Calculate the sum of `FlightDelayMin`, label it as "Delayed Time", and format it as a duration in human-readable form.
3. Split the slices on the top 5 of `Carrier`, ordered by the delayed time in descending order, and labeled as "Carrier".
4. Configure the chart to show labels.
5. Save the visualization as "Most Delayed Carriers".
Create and Save the Flight Status Visualization
1. Create a new pie visualization.
2. Calculate the total number of flights, and label it as "Flights."
3. Split the chart into slices using the following filters:
• Filter 1 is labeled as "On Time" and includes all documents where both `Cancelled` and `FlightDelay` are `false`.
• Filter 2 is labeled as "Delayed" and includes all documents where `FlightDelay` is `true`.
• Filter 2 is labeled as "Cancelled" and includes all documents where `Cancelled` is `true`.
4. Configure the chart to show labels.
5. Color the On Time slice green, the Delayed slice yellow, and the Cancelled slice red.
6. Save the visualization as "Flight Status".
Create and Save the Popular Destinations by Carrier Visualization
1. Create a new pie visualization.
2. Calculate the total number of flights, and label it as "Flights".
3. Split the chart on the top 3 of `Carrier`, ordered by the most flights in descending order, and labeled as "Carrier".
4. Split the slices on the top 5 of `DestCountry`, ordered by the most flights in descending order, and labeled as "Country".
5. Split the slices on the top 5 of `DestCity`, ordered by the most flights in descending order, and labeled as "City".
6. Disable the donut pie setting.
7. Save the visualization as "Popular Destinations by Carrier".

You work as a data analyst for a nearby international airport. You've been tasked with creating the following pie visualizations in Kibana to gain insights into the air traffic passing through your airport.

Most Delayed Carriers

• Calculate the sum of `FlightDelayMin`, label it as "Delayed Time", and format it as a duration in human-readable form.
• Split the slices on the top 5 of `Carrier`, ordered by the delayed time in descending order and labeled as "Carrier".
• Configure the chart to show labels.

Flight Status

• Calculate the total number of flights, and label it as "Flights".
• Split the slices using a filter aggregation with the following filters:
• Filter 1 is labeled as "On Time" and includes all documents where both `Cancelled` and `FlightDelay` are `false`.
• Filter 2 is labeled as "Delayed" and includes all documents where `FlightDelay` is `true`.
• Filter 2 is labeled as "Cancelled" and includes all documents where `Cancelled` is `true`.
• Configure the chart to show labels.
• Color the On Time slice green, the Delayed slice yellow, and the Cancelled slice red.

Popular Destinations by Carrier

• Calculate the total number of flights, and label it as "Flights".
• Split the chart on the top 3 of `Carrier`, ordered by the most flights in descending order, and labeled as "Carrier".
• Split the slices on the top 5 of `DestCountry`, ordered by the most flights in descending order, and labeled as "Country".
• Split the slices on the top 5 of `DestCity`, ordered by the most flights in descending order, and labeled as "City".
• Disable the donut pie setting.

Your lab node has a Kibana instance that can be accessed in your local web browser by navigating to the public IP address of the lab node over port `8080` (example: `http://public_ip:8080`). To log in, use the `elastic` user with the password `elastic_acg`.

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.