Home » Posts tagged '#DataVisualizations'
Tag Archives: #DataVisualizations
Sankey Visualizations
The Sankey Energy Data Visualization shows energy systems and it’s flows. It provides additional information on each category and is interactive.
After looking through this visualization for a while, I think that it is very effective for representing a basic knowledge of energy flows. I think anyone could look at this data and understand what it means.
At first, while looking at this data it seemed like a lot of lines that I could not tell where exactly they went. Making this chart interactive was a great decision by the makers because it clarifies where the lines are going, and provides additional information.
The only critique I have for this visualization is that I wish it would have provided more information and visuals on energy losses. Maybe a hyperlink with an additional visualization about energy losses and where or when they occur.
Sankey Visualizations
Needtoknow.nas.edu provides many visualizations about energy usage in the United States. I learned that the flow of energy in the U.S. is complex and comes from numerous different sources. More than half of energy supplied is lost as waste heat or through inefficiencies.
This Sankey visualization breaks down our energy system from the source all the way to its usage. As you can see, Oil is the largest source of energy with a total output of 36% and total CO2 emission of 43% in the U.S. Although this visual is interactive and provides a large amount of information/data, I find Sankey visualizations to be difficult to interpret. There is a lot of data being displayed within a single visual, and it would be more effective to break it down into multiple different visualizations. For example, the data regarding % of Total Output and % of Total CO2 Emissions could be visualized as a Side-by-Side Column Graph. Another example could be the use of a Pie Chart to compare the % of energy used and unused.
This visual of Lumens per Watt for different types of lightbulbs is highly effective. The visualization clearly shows which lightbulb they are talking about and its lm/W. Viewers can interpret the graph efficiently due to its simplicity. This particular chart is a good example of a Large Number With Icons, as we have learned in the textbook.
Another good visualization is this Back-to-Back Bar Graph displaying the efficiency of energy on the road. You can compare energy used, gasoline burned, CO2 vented, and fuel economy between the two different types of vehicles. Again, the simplicity of this chart makes it more effective.
I believe this site would highly benefit from simplifying their visualizations. The data they want to explain would be easier to interpret, therefore, more effective if they were to take a more minimal approach.
Sankey Interpretations
Lamar Miller
Based on what I learned about Sankey visualizations, it appears coal is our largest resource contributing to electricity production. In addition, oil is used primarily for transportation. Overall, I would say this is a good use of a Sankey visual. The color coding within the visuals allows the viewer to decipher between the different resources. The thickness of each bar indicates the quantity. The flow of each resource to its intended use case shows which resources flow into which utility. Source
In the MD, OH, PA, WV region there is a large amount of coal production.
California has very minimal coal production but uses natural gas as an energy source more commonly.
Pie Charts
Shown above is a pie chart I created based on the percentages of total energy use. Knowing when to use a pie chart can be a difficult skill to master. The following link including provides evidence as to why this type of chart is best for this data. The given data set represents different parts of whole adding the percentages of each data variable adds up to 100% as a whole. Additionally, a pie chart shouldn’t be used when you have too many different data points. This infographic only uses 5 which means a pie chart is a perfect fit for this data set. This pie chart has the appropriate amount of data points and data labels to make it effective at relaying this information to the reader.
Podcast: Play in new window | Download
Pie Charts
The ideal uses for pie charts are to illustrate the corresponding ratios of components to a whole and to demonstrate how a whole is divided into its individual pieces. When properly sized categories are present pie charts can be used for straightforward, equal comparison. For more in-depth comparisons a bar graph would work better than a pie chart. Labeling, ordering, and limiting slices are some tips when creating a pie chart. When labeling, verify that the appropriate number or percentage is written on the label of each slice. To keep a pie chart organized slices can be arranged from largest to smallest or smallest to largest. Use a different chart type if the chart includes more than five slices to limit clutter. There are certain cases where pie charts are not the ideal option. When there are too many categories in the data or the data values are too similar a pie chart would not be the best fit. If the data contains any values that are not positive integers, a pie chart is not the right choice.
Below I have included a good example of a pie chart that is properly labeled, ordered, and contains limited data.
Pie charts provide a clear visual representation of percentages and proportions, which makes it easier to understand data distribution. Making judgments based on data representation is simple with the use of pie chart analysis. Pie charts offer an immediately comprehensible visual depiction. Pie charts make it simple to compare different areas and provide information about those with the greatest impact. Pie charts are very helpful in the business world. They can guide investments and have an impact on plans for advertising and the creation of products. Decision-making based on data can be substantially improved by the use of pie charts and their interpretations.
Below is a pie chart that I created in excel. It represents college graduates in New Jersey by fields.
Pie Charts
What is a Pie Chart?
A Pie Chart is a common type of visualization that demonstrates parts of a whole. Each section represents a value in relation to the entire composition. The slices should be proportionate to the amount in each data set so that the viewer can compare each section by size to determine its value.
When should I use a Pie Chart?
A Pie Chart is a great visual for a part-to-whole relationship. It should be used when displaying the “percent of…” or “part of…” something. StorytellingWithData provides two primary use cases for a pie chart:
- having a general sense of the part-to-whole relationship is more important than comparing the precise sizes of the slices
- to convey that one segment is relatively small or large in comparison
The percentages should sum to 100% so that the visual is relative in size to its value.
The Perfect Pie
I created the “perfect pie” in Excel using 2024 Coffee Statistics by DriveResearch. I will break down what makes this a perfect use case as well as design tips for creating an effective pie. You can click on the image below to open my Excel spreadsheet.
The data in this set is great for a pie chart because it equals 100% and one value is significantly larger than the others. It is also split up into 2-5 categories which is not too overwhelming for the viewer. The coffee preferences are all parts of a whole, making a pie chart the best choice over bar charts and other visualizations. To make it aesthetically pleasing to look at, I used different shades of brown throughout the entire chart which correlates with the coffee theme. I deleted the legend for a more minimalistic appearance, which the author of our textbook reiterates throughout each chapter. Because the values for Light Preference and No Preference are very similar, I added data labels to each segment so it is easy to comprehend. I also increased the font size for the numbers to make them stand out. Stephanie D.H. Evergreen suggests “unwrapping the pie” by making the largest slice start at noon and run clockwise in descending order (as seen above). When creating this chart, I was sure to avoid 3D and exploding effects in order to increase legibility. For more information, I suggest checking out this article on Tableau, which provides more examples of effective and ineffective pie charts.
Lollipop Charts
A lollipop chart is a data visualization tool similar to a bar chart but with the shape of a lollipop. It shows data points at the end of a line that attaches to the chart’s baseline. This chart effectively compares values from a small data set where numbers aren’t very far apart. It makes it much easier to understand the differences in these values at a quick glance. These charts are best used when you need something the provides a simple look and wants to highlight the comparability of certain data points. These types of charts are also very good if you want to emphasize a certain data point. This is because you can highlight or change the appearance of each data point to make it stand out more or less. The given example shows different types of devices and how much online data they use. While some data points there are obvious differences. Some with closer values can be hard to distinguish without this chart.
Lollipop Charts
What is a Lollipop Chart?
A lollipop chart is another way to make lengthy bar charts less visually overwhelming. It is very similar to your standard bar chart, just without the “extra ink.” Instead of using a solid bar, the data is visualized using a lollipop shape (a thin line with a circle on top). After all, the main focus in a bar chart is the endpoint. The lollipop chart allows viewers to easily digest the data by focusing in on the values.
Examples…
The two images above are examples of lollipop charts that I created. The data shows the percentage of each MBTI personality type within the general population. Lollipop charts can be both horizontal or vertical. The main point of the graph is to focus in on the endpoint values. I created my charts in Excel, and provided hyperlinks to my spreadsheet which includes my data and formatting. The vertical version was definitely easier to create. It only took a couple minutes, while the horizontal version had more steps and precise settings.
How to create a vertical lollipop chart:
- Insert a line graph with markers
- Delete the line
- Add Drop Lines
- Add data labels to center of markers
…and that’s it!
When to use a Lollipop Chart
A lollipop chart can be used for any kind of data that would work in a bar graph. It is simply an alternative that is more simplistic. Its “ink-friendly” design can impact readability of the data and lead to faster response times and greater accuracy (Gillan & Richman, 1994). It is especially useful when the visualization includes many data points that can become overpowering due to the solid bars.
Lollipop Chart
Lollipop charts are used to compare several objects or groups, similar to the purpose of bar graphs. They can be very useful in analyzing and visualizing trends. A lollipop chart can work well for comparing the values of different groups while accentuating individual data points, especially if some values are extremely high or low. They make it easier to identify deviations or substantial differences between data points. Lollipop charts should not be used for distribution or relationships in data. The Lollipop chart that I created in excel is shown below.
Lollipop charts are modified bar charts with dots representing points and thin lines for bars so that more data may fit in a smaller space. A lollipop chart is a good option for placing or focusing on specific values within a dataset because it minimizes visual clutter from crowded bars. The line helps guide the viewer’s eyes directly from the data labels on the x or y-axis straight to the data point value. The image shown below is a good example of how sometimes bar graphs can look cluttered with too much data. Using a lollipop chart takes some excess color off the screen making it easier to visualize the values of each data point for analysis or comparisons.
Benchmarks
An important element in any display of data is a benchmark– this can be a target, long-term goal, average, or standard. Oftentimes, benchmarks are written down in memos, but aren’t included in the actual data visualization. This can potentially help an audience visually the data in a more informed and efficient manner. The stories that can be told include:
“Our key indicators met the preestablished targets in three out of seven areas.”
“Regions A and B did not meet quarterly benchmarks”
“Here is how our groups compared to the national norm”
“Students in the Chemistry Department are above average on final exams this year.”
“We did not meet our fundraising goal, but we got very close.”
“Our click rate was 25.6%, while the industry standard is 4.3”
There are many different ways to include benchmarks in data presentations. The most common form is a simple line.
Another example is a bullet chart, which has gray shaded area of comparisons behind a bar of column.