preview

Data Analysis And Visualization Of The Energy Data

Decent Essays

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

Get Access