Home » Uncategorized (Page 11)
Category Archives: Uncategorized
Pivot Table
Carlita Holloway
What is a pivot table?
A pivot table is a type of visualization that let the user lay out huge samples of data in one sheet for the user to analyze and examine. They are typically used for all kinds of business practices or financial consultations. Here is an example of one.
With a pivot table like this, a user can take data and organize or “pivot” the information to reconstruct and look at the information differently. That is where the word “pivot” in pivot table comes from.
That is one reason pivot tables are so handy with working with large groups of numbers; being able to organize large complex sets of data and organize them into more comprehensible forms of data makes it much easier for both the reader and presenter to digest. Attached is a video describing how to create a pivot table of your own.
Pivot Tables
Created by: Victoria Valenzuela
What Is a Pivot Table?
Pivot Tables are used to calculate and analyze data. It allows you to see a change in your data with trends, patterns, and comparisons. They are super helpful especially when you have a large data set. You can categorize your set to differentiate one data from the other.
How can you use a Pivot Table?
This particular pivot table includes a data set describing batches of home items. The data shows separation between the price, quantity, region, etc. The link posted shows exactly how to create a pivot table on Excel.
Why Is It Helpful?
Pivot Tables are helpful because they allow users to understand their data, have it organized into one block, and manage all of the numbers. You can clearly see all of your data split into rows and columns correlating to which it relates to. This will answer many questions any professor or outsider will have while analyzing your data set.
Sankey Visualizations
I think the Sankey graphics have some upsides and downsides. I like the interactivity of the website, and I feel like in certain ways it can give you a good perspective of the energy breakdown nationally and regionally but other places it starts to faulter. In particular I don’t like the vagueness of how certain energy streams translate to used and unused power. In the first picture you can see that geothermal energy accounts for an extremely low percentage of total energy usage nationally, but then the avenues that it goes down have varying degrees of how much power is unused. When you have this discrepancy it’s hard to tell how efficient each power source actually is.
I do like the energy breakdowns for the regional map because I think this chart makes it easy to draw some conclusions about the plausibility of renewable energy reliance. As a disclaimer I am a large proponent of sustainable energy conversion, however, I think from the below two pictures you can see that this isn’t an easy task. Especially when you look at where the sources are going. The transportation sector is still dominated by oil, so there is a significant amount of progress that needs to be made in creating more efficient energy systems that can support the use of clean energy.
In conclusion I think that this website does some things right and some things wrong. A chart is supposed to guide the audience through the data that’s compiled, but I found myself questioning how accurate the numbers were, and without a lot of context for how much energy “.9” or “300” meant, it was hard to see the magnitude of differences. In terms of layout I thought the chart did a good job of graying out what wasn’t being actively clicked on, and that helped guide my eye through the different pathways that would otherwise be tangled up with each other.
-Jack Swenson
Sankey: Our Energy System
This interactive data visualization tool was very fun to explore. There was a lot of really good information all packed neatly into a tight and organized visualization. It was also a really good tool to compare energy sources from different areas.
California is very anti-coal use and this graph really shows it. It gets more interesting to me when you can see the coal use in other stats such as OH, MD, WV, Pa regions.
Using those same comparisons, it is also interesting to see how much more oil California uses than Md, OH, PA, WV region.
SANKEY
After playing around with the simulators within our energy system on National Academics: What You Need To Know About Energy, I am actually quite shocked. Within their page, there are multiple different walkthroughs of how to conserve wasted energy at home and even on the road. When I first started going through the pages, the first one that popped up stuck out to me.
The picture above is one of the simulators on their website that shows you our energy system. Each category of energy is on the left side and it shows you where it goes to. What blew my mind was in the end, there were 38.4 Quads of useful energy, but there were 59.4 Quads of unused energy. Keep in mind “quads” is really quadrillion BTU. This is more than the used energy! I also liked how within this visualization, each category had a different color so you could see exactly where it goes to. For example, Natural Gas which is the color green goes to Industrial, commercial, and residential.
Another part of this website that I thought was beneficial, was the ways to conserve energy at home and on the road. Within the at-home section, you could choose between television, lightbulbs, and washing machines. I decided to play around with the washing machines page, which I thought was really cool. Washing machines were reported to use 36% of the original energy. You can turn the dial to either one load of laundry or 1 week of laundry. You could do the same with 1 month, and 1 year. You can see on each one how much energy you use, how much coal burns, and the CO2 vented between Top-loading and front-loading. This website is definitely beneficial to someone who could be looking to learn more about ways to conserve energy and interact with different pages of useful information.
Sankey Visualizations
By John Wickham
As a person who likes a good chart, I am always open for suggestions that can make work better. This is why the use of Snakey would catch my eye to know if I could use it.
The chart above shows the information of the use of power that people from California use. You can see the huge amount of oil that people use in the largest state. There is the fact that there is only small string for Coal use, which is important to notice for coal supporters. The main source of worry is the small amount of power that is generated from alternative sources like wind, water, or solar. It worrys me.
The one complaint that I have is that this chart is very busy. It is hard to interpret data without taking some time to understand. You can get it, but it takes some effort.
Sankey Visualizations
With Sankey Visualizations being a technique that helps the user to displays flows within data, it is a very helpful tool when trying to string many different charts and diagrams regarding the same topic together.
While reading through the site talking about our energy system I noticed how many different pieces of information were available to me on just one of the pages. I did like how this site was formatted but there was one thing that I feel like could make the site too crowded.
Within just this page from the complete site there are 17 different things that the reader can click on that reveal even more information to them. While I do understand that this is the information they are provide, I feel that separating it even more will help the reader not miss any points of information if they don’t click on every single tab per page.
SANKEY VISUALIZATIONS.
Sankey Diagram is a visualization technique that allows the display of flows. Many experts argue that Sankey diagrams do a better job than pie charts, visualizing flows in their proportions. The things connected are called nodes and the connections are known as links. Sankey diagrams are also perfect for showing many-to-many mapping relationships.
They are very good at showing particular kinds of complex information:
- Energy flow
- Budget flow ( where the money came from and went to
- Number of people migrating from one country to another
- The flow of goods from one place to another
SANKEY VISUALIZATIONS – OUR ENERGY SYSTEM
A Sankey diagram was used to visualize the primary energy source supply directly to the residential, industrial, commercial, and transportation sectors in the USA. It also showed how electricity was generated from a list of primary sources.
The diagram appeared complex at first view but very with careful observation, it gives out detailed information.
The Sankey diagram shows the primary sources of energy: solar, nuclear, hydro, wind, geothermal, natural gas, coal, biomass, and oil. The colored links show the flow of energy from these primary sources to their destinations: residential, commercial, industrial and transportation uses. The width of the links shows the proportion of energy flow to its primary source.
The visualization allows you to click on a primary “source of energy” to examine its “flow of energy.” It places the other categories in the rear and reduces the clutter of information. The use of labels also helps ascertain the value of the amount of energy flowing from the primary source to its destination.
Sankey diagrams can be very effective in displaying visual information about complex data. The caveat is to be very cautious of cluttering information due to its complexity.
Sankey
Sankey is a chart or a visualization that shows off the gradual progress of something. this type of chart is ideal for showing off the process of an event, the history of a certain topic, or the rise of a movement. It is a good way to show the continual progress of something in an interactive way.
This visualization is showing the audience how energy is used throughout the US.
The site has a tab that shows in great detail the nuances of the US energy system and all the intricate parts attached to it. For example, one of the visualizations shows off how much energy overall the US population consumes in one year.
Overall, Sankey Visualizations create an innovative and new way to present presentations. They give the audience a chance to dive into the subtopics of a subject and weave passageways of information. I believe that this is the kind of presentation that would be excellent for an audience that is eager to comprehend the complexities of a topic.
Sankey
This Sankey Visualization is in interaction visualization that shows how our energy system works in the US and how how it is used throughout the company. This tool is a great way to display this type of information. Being that it is interactive, you are able to click your way through and learn about the Energy System.
The column on the left side is interactive and shows information bases off of each tabs topic. Depending on which tab you click on, the information is unique that that tab and shows different numbers and links to the column in the middle. This shows which tabs down the left are connected to the tabs down the middle. While clicking through all the tabs, little blurbs pop up explaining each tab and the number in detail.
Sankey Visualizations are great tools to use to display this type of data such as how things work, and how subcategories of certain topics are linked to each other and all equate to one thing. Sankey Visualizations show how a topic’s information can relate to other topics that show the general idea of something. I think they are very easy and simple to follow. They are also not overwhelming to look at because there is information hidden in each tab with a link to explain the information in more detail.