This chapter includes the data analysis and visualization of the given energy data by using open source software, i.e. MATLAB, Cloudera Hadoop and Tableau Desktop. 5.2 Energy Data The energy data is in excel worksheet, containing more than nine (9) thousand entities. This given data will be analyze on the basis of different categories such as element, customer or consumption type, year, data-type and month. The output of this data will be in the form of different types of graphs like pie graph, bar charts, line charts and 3-D graphs. Figure 12 shows the sample of energy data. Figure 12 - Sample Energy Data 5.3 By using MATLAB The data file consists of lots of entities, which needs to extract the data according to the given format. And to do the analysis, an algorithm is developed according to the hierarchy as given in the excel worksheet, and a graphical user interface (GUI) to visualize the output of data. As the file comprises of different elements according to the category and it consists of same customer for each element and for given number of years. Moreover, it contains of three different types of data for each year. So to analyse and visualize the data, only Category, Element, Customer, Year and Data type will be selected from the drop down menu of the GUI. However, the data can also be analysed and visualized in the form of different graphical methods by selecting them from the drop down such as Pie graph, Bar graph, 3-D graph and Line charts. Figure 13 will
Energy has easily become one of the most important necessities for our everyday lives. Without it we would simply not be able to have transportation or be able to gather any of our other resources that we depend on. If at anytime our energy supply ceases or no longer attainable the results may be horrific. However, it is quite easy to keep this from happening, It is crucial that our current population realize the importance of sustaining our present non-renewable resources. An examination of all the present energy issues and human impacts of energy conservation along with the a resource plan will show importance of energy
The file P02_01.xlsx indicates the gender and nationality of the MBA incoming class in two
chart about electricity generation by fuel, for 2040 sixteen percent of the electricity is going to come from
As the global population increases exponentially, having passed six billion in 1999, the world population is expected to be 8.9 billion by the year 2050. The worlds energy consumption will increase by an estimated 54 percent by 2025. Energy demand in the industrialized world is projected to grow 1.2 percent per year. Energy is a critical component of sustained economic growth and improved standards of living. One of the major requirements for sustaining human progress is an adequate source of energy. As the world’s technological enhancements and standards of living improve, so too does their appetite for electricity.
quickly generate the reports and graphs of long statistical data by using different analysis variable. This helps the user to get the desired outcome in short span of time with less use of computing skills and knowledge which means the user doesn’t have to be a computer genius to get the reports that are necessary for the decision-making.
In the data set , the three components x3,x5 x6 (Cost per KW capacity in place, Cost per KW capacity in place, Total fuel costs (cents per KWH) is selected to perform the PCA. We selected the 70% of the variance in the second step of PCA algorithm. As a result, the three components capture the 80 % of the total variance associated with the all eight variables. This suggests that we can capture most of the variability in the data set with less than 26% of the number of original dimension in the data.
This Pareto analysis chart is rather easy to produce in Microsoft Excel, which is a good thing because I am fairly competent with the process using MS Excel. We simply put in a table the consumption values during the determined period of study and then turn it into a chart and you have a visual of the consumption periods. We can then find the highest consumption periods and compare them to any changes or patterns differences from the lower periods. Then these values can be re-charted in another analysis chart to visually compare the major causes of energy consumption.
From the moment we wake up in the morning and turn our alarm clock off, to the moment we turn the lights off and fall asleep, we are using energy. Throughout the day an average person will use a cell phone, a computer, a television, an oven or microwave, and many will ride in a car or bus: all of this takes energy. Energy is even being used while we sleep to power the same alarm clock that wakes us up each morning. Individuals in first world countries are large consumers of energy, but where does it all come from? What powers most of our modern day conveniences? The United States Energy Information Administration (EIA) estimates that as much as eighty-two percent of the United State’s energy demand is met by using fossil fuels (Fossil Fuels), and in 2012, fossil fuels made up eighty-seven percent of the energy consumed worldwide (Gonzalez & Lucky, 2013). What are fossil fuels then?
From the moment we wake up in the morning and turn our alarm clock off, to the moment we turn the lights off and fall asleep, we are using energy. Throughout the day an average person will use a cell phone, a computer, a television, an oven or microwave, and many will ride in a car or bus: all of this takes energy. Energy is even being used while we sleep to power the same alarm clock that wakes us up each morning. Individuals in first world countries are large consumers of energy, but where does it all come from? What powers most of our modern day conveniences? The United States Energy Information Administration (EIA) estimates that as much as eighty-two percent of the United State’s energy demand is met by using fossil fuels (Fossil Fuels), and in 2012, fossil fuels made up eighty-seven percent of the energy consumed worldwide (Gonzalez & Lucky, 2013). What are fossil fuels then?
The charts show changes of different types of energy in the USA between 1980 and 1990.
Data is very important thing in every business, especially in today’s dynamic world where optimal use of data leads to success in shorter span of time as lots of companies are struggling for truthful and accurate data. These data must be analyzed in exact time and in a proper way so that the decision is more effective, but the data we receive are very redundant and carry lot of space in our system. This creates a challenge for the Analytics people to remove the redundancy and bring out only those relevant data that aids in decision making process. Master Data Management is a solution for such Analyst who wants to eliminate the redundant and inconsistent data of the organization (Vinculum, 2016).
There are many ways to present the collected data. The information should be presented in a way that is visual to the user of analytical software. This can be done using spreadsheets, charts or graphs.
During the summer of 2014 I took part in the Energy Project programme, I was paired with a small heating-engineering company, Global Celsius solutions. The company had recently developed a cheap, rugged and reliable water boiling system, the “Jompy” boiler. The system itself took advantage of compact heat exchanger design principles incorporating a high surface area, minimising the footprint of the system without sacrificing overall performance, the boiler was capable of producing water in excess of 70oC within a matter of 5-7 seconds(from my own experience with the boiler). The overall aims of the project included:
According to the case study written by Jurek, Bras, Guldberg, D’Arcy, Oh, and Biller, energy costs were steadily rising and were predicted to continue this trend going into the future. At the same time, utility companies were beginning to implement Smart Grid technologies to increase the efficiency of energy distribution. One resulting program to emerge from
Energy is the key determinant of economic development and prosperity of the society’s quality of life. The human civilization started with the historic revolutionary invention of fuel energy which today has become a universal concern. Energy plays a vital role in human development and welfare, since all the important economic activities of present civilization are dependent on availability and level of consumption of energy (Rajgopal and Mishra, 1994).