A Pivot Table is used to summarize, sort, reorganize, group, count, total or average data stored in a table. It allows us to transform columns into rows and rows into columns. It allows grouping by any field (column), and using advanced calculations on them. They give us the ability to get a summary or recap of the data rather than scrolling down to find each subtotal.

Here are some examples of Pivot Tables.

An important advantage of pivot tables is that it is easy to use. You can easily summarize data by dragging the columns to different sections of the table. The columns can also be re-arranged as you wish with the click of a mouse. With the help of excel pivot tables, you can handle large quantities of data in one single go. These tables allow you to take a large amount of data and work on it in such a way that you need to view only a few data fields. This helps in the easy analysis of large amount of data.

What I found:

I discovered that not all energy supplied is actually used, and that more than half is lost as waste heat or through inefficiencies. I’m sure I’ve heard that before sometime in my life but being reminded through this website really opens my eyes on how crazy the world works. So much energy wasted and we can’t do much about it.

I learned that we divide our energy use among four economic sectors: residential, commercial, transportation, and industrial. Things such as heating and cooling our homes, lighting office buildings, driving cars and moving freight, and manufacturing the products we rely on in our daily lives are all functions that require energy. Without energy, we can’t do any of the things listed above as well as many many more. Energy is a key tool and necessity in life and without it we would struggle a lot just like humans used to in the stone age.

I really liked how interactive their website was, even letting us choose what we want to click on in order to show that it’s our choice to choose what we want to know more about. It doesn’t throw in unneeded information or tries throwing a bunch of summaries at you, it lets you choose what you want to see and read next and that works really well. Their graphs were perfect, all very colorful and perfectly organized with the data and labels that they need. Also on these charts like I said before they would have these interactive tags to have use choose what we want to learn about next which was cool.

Wow this website was amazing, how it asks exactly what you’re looking for in terms of exact numbers of statistics or rather just an estimate, then once completing the questions a bunch of interesting graphs about all you can think of show up and you are just sitting there wondering which one you want to click on first. It has so many options between the risks you want to see, what you want to see of such as health conditions, as well as the data they provide, you can choose anything you want and you’ll have the information pop up for you.

Here is a screenshot of a data graph I chose on side effects of health conditions. Look how much information is provided! Incredible, it tells you how it is affected, what’s special about the graph itself, as well as how it does. Great website.

https://gyazo.com/bea7d93c77869db43e18a94505ef5d54

Pie charts are used to represent the proportional data or relative data in a single chart. The concept of pie slices is used to show the percentage of a particular data from the whole pie. Making them different colors can help the reader to differentiate each result. Pie charts show the proportion of the whole that is taken by various parts.

A lollipop chart is a variation of a bar chart where the bar is replaced with a line and a dot at the end. Just like bar graphs, lollipop plots are used to make comparisons between different items or categories. They are also used for ranking or for showing trends over time.