We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Nobody downloaded yet

Data Warehouse assignment - Essay Example

Comments (0)
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…
Download full paper
GRAB THE BEST PAPER
Data Warehouse assignment
Read TextPreview

Extract of sample
Data Warehouse assignment

Download file to see previous pages... 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...
The analysis provides ample opportunity for the company to analyze its customers' purchases too. In a formal OLAP tool, the customers can be drilled down according to the concept hierarchy and various other aspects of weekly sales can be unearthed. For example, the customer group can be used as an important field to analyze the customers' purchases week-wise. The customer dimension does not have enough fields for a triple concept hierarchy, otherwise, it could lead to a detailed group-wise analysis for sales. The trend could also be analyzed product-wise. It is important to understand again, that a time-based analysis of sales is the most beneficial one as it leads to comparison of all trends of sales with other actions that have been taken in the past.



The following graph shows the trend of product sales, detailed against customers, week-wise:


This shows again the importance of analysis of data through pictorial representations: the outlier lines in the data depict extreme values. Using a more user-friendly OLAP tool, an analyzer can drill down to the extreme value and find out a possible reason for that value. It is necessary to understand the dimensions of a graph when analyzing the results. A manager needs to be able to pull down and across the dimensions of a data warehouse in order to analyze the data from different perspectives and get the best results.





Answer 1 - b
The use of a data warehouse or a mart is to facilitate the analytical requirements of a manager interested in finding trends in data or correlating the actions of a company in the past with changes in business profits or sales. Thus, there are several forms of presentation that can be considered suitable to present ...Download file to see next pagesRead More
Comments (0)
Click to create a comment
CHECK THESE SAMPLES - THEY ALSO FIT YOUR TOPIC
Data warehouse
The content of the paper comes from four books reviewed by the author and primarily serves the purpose of delivering fundamental knowledge of the topics which are gaining immense importance today (Gray 2001). The target audience of this paper are mostly scholars and researchers who could get basic information and clear definitions of topics mentioned above.
2 Pages(500 words)Essay
Data Warehouse, Data Mart and Business Intelligence
Many organizations are increasingly adopting data warehousing to enhance reporting and decision making. A data warehouse facilitates the integration of data from various sources, data sharing, and provides consistent, organized, relevant and timely information for decision-making.
4 Pages(1000 words)Essay
Data Warehouse
Data warehousing is a process of centralized data management and retrieval. Data warehouses can have both currents as well as historical data.  The data received from various operational resources in an organization is analyzed using different data analysis tools like ETL, OLAP etc. to create various reports.
5 Pages(1250 words)Essay
Data warehouse presentation evaluation
There are four design approaches to this process that differ by scale of data, action sequences and complexity. Top-Down Approach assumes that data is transferred from diverse OLTP systems into a centralized place where it could be used for analysis. As Eckerson writes, the major benefit of a Top-Down Approach is that it provides an integrated, flexible architecture to support downstream analytic data structures.
2 Pages(500 words)Essay
Case Studies of Data Warehousing Failures
There is several scope of what can be considered as data warehousing failures. Some of them are over budget, extended deadline (unreasonable deadline for project) or pushing back the milestone dates, management support (lack of formal commitment from
5 Pages(1250 words)Essay
Data Warehouse Project Management
These sophisticated data storage technologies are known as data warehouses. A data warehouse is a copy of the transactional data that is specifically structured for
20 Pages(5000 words)Essay
Data warehouse
Effective and efficient management of information depends on how good and efficient the data warehouse in an organization is made. Data warehousing is the base for introducing any business intelligence tool in the organization. The data
8 Pages(2000 words)Essay
Data warehouse, data mart and business intelligence
warehouse that combines data from a variety of sources such as corporate databases or information systems and serves a range of front-end reporting, querying and analytic tools (Dayal, Castellanos, Simitsis, & Wilkinson, 2009). In addition, the data warehouse is a database of
2 Pages(500 words)Essay
Hulu
The CEO then was Jason Kilar. Since the commencement, of Hulu, in 2007, the company has had numerous achievements, which has contributed to the website’s renowned past. Recently, the company announced that it would be
3 Pages(750 words)Research Paper
Data warehouse
In the contemporary competitive business environment, this has become one of the most popular technologies as decisions become an important determiner of the organizational development. Some of the advantages of data
4 Pages(1000 words)Essay
Let us find you another Essay on topic Data Warehouse assignment for FREE!
Contact us:
+16312120006
Contact Us Now
FREE Mobile Apps:
  • About StudentShare
  • Testimonials
  • FAQ
  • Blog
  • Free Essays
  • New Essays
  • Essays
  • The Newest Essay Topics
  • Index samples by all dates
Join us:
Contact Us