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
- Create a new pie visualization.
- 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.
- Save the visualization as "Most Delayed Carriers".
- Create and Save the Flight Status Visualization
- Create a new pie visualization.
- Calculate the total number of flights, and label it as "Flights."
- Split the chart into slices using the following filters:
- Filter 1 is labeled as "On Time" and includes all documents where both
CancelledandFlightDelayarefalse. - Filter 2 is labeled as "Delayed" and includes all documents where
FlightDelayistrue. - Filter 2 is labeled as "Cancelled" and includes all documents where
Cancelledistrue.
- Filter 1 is labeled as "On Time" and includes all documents where both
- Configure the chart to show labels.
- Color the On Time slice green, the Delayed slice yellow, and the Cancelled slice red.
- Save the visualization as "Flight Status".
- Create and Save the Popular Destinations by Carrier Visualization
- Create a new pie visualization.
- 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.
- Save the visualization as "Popular Destinations by Carrier".
