Data Warehouse assignment

Masters
Essay
Technology
Pages 11 (2761 words)
Download 0
The data mart provided in Microsoft Access format was exported to Microsoft Excel and its PivotTable functionality and the entries in the fact table 3 were analyzed. Though it is not possible to perform comprehensive data mining on the data using Excel tools, the data was converted to a customer versus product pivot table displaying total sales amount and total sales quantity…

Introduction


The data was analyzed with respect to the time dimension - week. Sales were analyzed against the customers weekly. It was identified that the sales amount graph for the six weeks of 2005 for ALL the customers generated the following trend:
The above graph displays that there was a drop in sales amount in the third week of 2005. Since this is a graph of cumulative sales, we can assume it to be a fair representation (normalized) of the entire dataset. After the third week, the sales picked up again in the fourth week, however, this was not sustained: there was a consistent drop in the fifth and sixth week of 2005. This pattern is an interesting one from an analytical perspective. It shows the cumulative pattern of the sales of the company for the six weeks. The pivot table capabilities of Excel can allow drilling down to a specific customer too, however, this pattern represented in the graph is an important one for the company to analyze the potential reasons for the rise or drop. Comparing the trend with changes in ther variables, for example, the firms strategies at those times the company can understand the best practices that led to the changes in their sales.
There are several other trends in the comp ...
Download paper
Not exactly what you need?

Related papers

Data Warehouse assignment
The data was analyzed with respect to the time dimension - week. Sales were analyzed against the customers weekly. It was identified that the sales amount graph for the six weeks of 2005 for ALL the customers generated the following trend:…
Data Structures and Algorithms
And therefore, this might be comfortable for usages connected with textual data. Where there is image related data, the exercise might become pretty cumbersome and might not be possible to realize both the spatial and spectral data to be brought under the Huffman Code compression technique. In order to increase the efficiency of coding even while using the text compression techniques. For this…
Data Loss Prevention
Although the number of incidents regarding personal data loss would normally be expected to decrease due to the huge amounts of both financial and social losses incurred, it is still on the rise. According to Mary Monahan, a senior analyst at Javelin Strategy & Research, a Pleasanton research organization, 312 security breaches occurred in 2006 in the United States, giving away 20 million records,…
Data Management
Soumen et al (2009) agree that data quantity surrounding us is humongous and the amount of information bombarding us is increasing. Making sense of this increasing data volume requires data mining skills and techniques that have evolved with increase in computing power. An allied discipline is Competitive intelligence which is a discipline used for improving market standing, improving strategic…
Data Warehousing
It focuses on how well the data is stored for better analysis and reporting of information by the analysts. There are tools that are used to move the data into the storage area and the intelligence tools ensure there is efficiency in delivery of services to the customers. The high changing technology is important for an organization since it integrates data for easier analysis and data reporting.…
Data and Network Security
As far as the location of the company's office is concerned, 'enterprise Training solutions' offices are located in 4 adjacent rooms situated on the ground floor of a 4 storied building. In addition, the company also maintains a single office room in the first floor of the building. Under the existing situation, anyone is allowed access up to the reception area through a shared entrance. This…
Data Base Directives
Collections of facts being made available electronically as databases are prevalent, creators of these databases are claiming on a need to provide adequate legal protection in order to protect their hoards.…