Purpose and benefit of using Pivot Tables and Pivot Charts PDF

Preview

Summary

Purpose and benefit of using Pivot Tables and Pivot Charts some answers for questions on final test. good luck!...

Description

Purpose and benefit of using Pivot Tables and Pivot Charts: Purpose: Pivot Table is an interactive table used to group and summarize a range of data or an Excel table into a concise, tabular format for analysis and reporting. Pivot Chart is a graph presented in a Pivot Table that gives the visualization of the data from chosen area or Excel tables to collect information for further decision-makings. Benefit: Using Pivot Tables and Pivot Charts is the transforming from raw data to valuable information stage. By doing so, the data can be expanded or collapsed to direct and focus users to the target results. The layout of pivot tables creates attractive reports for the user so they can easily compare the values in data sets, thereby, gathering useful information (e.g.: trends (increases, decreases), minimum or maximum values, ratio of components, etc.) to, for example, apply business intelligence to make decisions in the operation or development of the business. Providing examples that could be relevant to DRAX Consulting, explain how you would distinguish data, information and knowledge: Data are raw facts gathered from the setter(s) and categorized into types of information. They are unprocessed and pre-analyzed figures. For example, they might be Excel tables or Databases. For DRAX Consulting, data might be users’ emails/phone numbers/… Information is the result of data processing. It gives the meaning of data to the users. for example, converting data from Excel tables into charts in order to find trends, minimum maximum values, ... With the DRAX company, the information they can collect from the data could be which services, products are loved and used the most; and the increase or decrease in income streams, etc. Knowledge is the combination of information, experience and insight. This is concluded when users choose useful information to serve their purposes, especially in making decisions. For a company like DRAX Consulting, they can look at the information they have from their statistics, for example, the service with the highest profit should be focused on growing stronger. The process of converting from data to information then knowledge is also known as a method of applying business intelligence (BI), which is used by businesses to bring benefits to their growth. What are some of the likely benefits of integrating information, data and knowledge throughout the DRAX Consulting organisation? Realizing the troubles in the company's operation, DRAX Consulting applied 2 methods of Knowledge Management and Business Intelligence to bring the company into order and make it more developed. With Business Intelligence, they have applied the functionality, scalability, and reliability of modern database management systems to build ever-larger data warehouses and utilize data mining data techniques to exploit business advantages from the vast amount of business data available. Applying knowledge management technology on accurate and timely knowledge, the decision they make is to combine today's content management systems and the Web with improved text search and mining in order to get more value out of the explosion of documented information. Considering how

DRAX is distributed across Asia, it is important to be able to harness knowledge to have a complete advantage. They take advantage of proficiency in information technology, creating platforms that improve business-to-user interactions in order to fulfill their needs. In an effort to improve their online presence, DRAX has decided to redesign their main website and develop a social network channel. To assure that customers’ needs are being met by these measures, the effectiveness of these actions needs to be measured. Identify and elaborate on two (2) measures that a web analytics tool and two (2) measures that a social network analysis tool could identify to improve engagement and effectiveness of their new online presence.

The measures that a web analytics tool and a social network analysis tool can identify to improve engagement and effectiveness of DRAX’s new online presence: Web Analytics tool:  

 

New vs. Repeat Visitors: A comparison of your unique visitors vs. the number of visitors who came back more than once. Most/Least Popular Pages: A comparison of the pages on the site that receive the most and least traffic. Social Network analysis: Vertex or Nodes: the people who are part of a network communicating (or not) to each other Degree is the sum of all edges tied to a node. The higher the degree the more social a person is

Take Google Analytics as an example for web analytics tool and NodeXL as an example for social network analysis....