Data Warehouse assignment - Essay Example

Only on StudentShare

Extract of sample
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:
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 ...Show more

Summary

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…
Author : scorkery
Save Your Time for More Important Things
Let us write or edit the essay on your topic
"Data Warehouse assignment"
with a personal 20% discount.
Grab the best paper

Related Essays

Data Loss Prevention
This report investigates the causes of the growing number of incidents regarding personal data loss, demonstrates the heat of this problem through various examples, analyses the existing IT legislation and the need for improvement, and throws some light on the duties of the IT manager responsible for data control in different organizations.
8 pages (2000 words) Essay
Data Management
Data storage space has become less expensive and data collection tools have become more and more sophisticated. Data warehousing concept has evolved from early days of data collection to archiving of data from where data is increasingly being analyzed for pattern recognition and identification of knowledge that can be used for knowledge discovery in databases (Norton 1999).
8 pages (2000 words) Essay
Management Of Technology Cellular Phones
Every link, or discussion, needs its own devoted frequency, and the total numeral of accessible frequencies is about 1,000. To maintain more than 1,000 instantaneous dialogues, cellular systems allot a set numeral of frequencies for every cell. Two cells can use the similar frequency for dissimilar conversations so extended, as the cells are not contiguous to each other.
7 pages (1750 words) Essay
Data Warehousing
Data warehouses and business intelligence assists in transforming the raw data into information and knowledge that is essential for any decision making process. Data warehousing refers to an area within a computer where data is stored in an organized and centralized way.
10 pages (2500 words) Essay
Data and Network Security
In addition, the company's office at Leeds has around 20 networked computers that provide training to its customers. Incidentally, the company's web, email and database servers are located in the Leeds office. The Edinburgh office of the company currently employs 20 staff who are involved in Administration, training and sales staff.
7 pages (1750 words) Essay
Data Base Directives
Intellectual property law always have a special position for the collections of facts. Usually only original or creative expressions were protected under the protection for collections of facts. This made all the more difficult for producers of databases which have pure factual information to protect their databases from third parties copying their database.
4 pages (1000 words) Essay
Safety at construction sites
Instead, the entire conduct of the project would have to be considered. Among the important aspects of project management is the concern for the safety of people working on the project and the people who will be going to visit the project - whether regularly or not - as soon as it is occupied by its owners and their clients.
3 pages (750 words) Essay
How Technology Changes and Changed Criminal Law
According to the report computer use has greatly changed in the area of criminal law. Computer deals can involve hardware, software and other services. Courts asses the customer software cases under the current tests which include element test, bi-figuration test and final product concrete and movable test.
11 pages (2750 words) Essay
Find out how much would it cost
to get a custom paper written by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT