Nobody downloaded yet

Data Warehouse assignment - Essay Example

Comments (0) Cite this document
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 paperFile format: .doc, available for editing
GRAB THE BEST PAPER96.3% of users find it useful
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
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Data Warehouse assignment Essay Example | Topics and Well Written Essays - 2750 words”, n.d.)
Data Warehouse assignment Essay Example | Topics and Well Written Essays - 2750 words. Retrieved from https://studentshare.org/technology/1504259-data-warehouse-assignment
(Data Warehouse Assignment Essay Example | Topics and Well Written Essays - 2750 Words)
Data Warehouse Assignment Essay Example | Topics and Well Written Essays - 2750 Words. https://studentshare.org/technology/1504259-data-warehouse-assignment.
“Data Warehouse Assignment Essay Example | Topics and Well Written Essays - 2750 Words”, n.d. https://studentshare.org/technology/1504259-data-warehouse-assignment.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document
CHECK THESE SAMPLES - THEY ALSO FIT YOUR TOPIC
Data warehouse
...? How information systems have revolutionized the way businesses have been operating lately stands at the focus of this paper. The author of the paper has actually summarized the benefits of information systems in the field of business automation and reengineering, customer relationship management, building IT enabled city infrastructures and use of data mining in business analytics. 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...
2 Pages(500 words)Essay
Data Warehouse, Data Mart and Business Intelligence
...?Running head: Computer Sciences and Information Technology Data Warehouse, Data Mart and Business Intelligence Insert Insert Grade Insert Tutor’s Name 13 March 2012 Data Warehouse, Data Mart and Business Intelligence Introduction 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. This discussion explores the differences between...
4 Pages(1000 words)Essay
Data Warehouse
... Data Warehouse In computing the term data warehouse (DW) refers to a centrally managed and integrated database containing both raw and formatted data received from various operational sources (in an organization), generally stored in an archival manner for easy access and used for reporting and analysis purposes as shown in fig. 1. Data warehousing is a process of centralized data management and retrieval (Greenfield, par.1). Data warehouses can have both current as well as historical data. The data received from various operational resources in...
5 Pages(1250 words)Essay
Data Warehouse Business Pla
...? Data Business Plan Bridgette Scott American Public System Data Warehouse Business Plan Data Warehouse Business Plan is essential in creating a clear understanding of the operations of a business, helping management establish potential risks and pitfalls of the business. This business plan will highlight the overview and structure of the business forming the basis of issue identification and strategic assessment. The business plan points out the infrastructure and information systems of the company and role in management and operation of data warehouses. The company’s data management and knowledge by its...
5 Pages(1250 words)Assignment
Data warehouse presentation evaluation
...Generally a data warehouse is a trace of an enterprise's past transactional and operational information that is stored in a specially designed database with appropriate facilities for data analysis and reporting. There is one common idea in the basis of data warehousing design: first data should be integrated from distributed and differently structured databases and then it should be picked out for purposes of reporting, decision support, analysis or control. 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...
2 Pages(500 words)Essay
Data Warehouse Project Management
...Data Warehouse Project Management Contents of the Report Introduction DePaul An Introduction The Data Warehouse Project Project Charter Requirements Document Statement of Work Risk Analysis Conclusion Introduction Databases and Database theory have been around for a long time now. The earlier databases centered around a single database serving both purposes: transaction processing and decision support. However with the advancement of technology such as 4GL and PC and with the empowerment of the end user to perform his/her own tasks, a more sophisticated version of the databases started to occur. These sophisticated data storage technologies are known as data warehouses. A data warehouse is a copy of the transactional data... that is...
20 Pages(5000 words)Essay
Data warehouse
...Data Warehousing Introduction Data warehousing is a very powerful tool in today’s’ competitive business environment. “Virtually everything in business today is an undifferentiated commodity, except how a company manages its information. How you manages information determines whether you lose or win” - Bill Gates (quote taken from the Book ‘Data warehouse project management’, 2000 – Sid Adelman and Lerissa Terpeluk Moss). 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...
8 Pages(2000 words)Essay
Data warehouse and data mining in business
...Data Warehouse and Data Mining TABLE OF CONTENT 1 INTRODUCTION AND HISTORY 2 MARKET ANALYSIS 2 1Market-Basket analysis 2.1.2 Concept Description 2.1.3 Deviation 2.1.4 Visualization 3.1SYSTEM COMPARISON AND EVALUATION 3.1.1 Oracle Data Mining 3.1.2 Intelligence Miner and SYBASE 4.1 COMPARISON OF UAE AND THE INTERNATIONAL LEVELS 4.1.1 Reliability 4.1.2 Adoptability 4.1.3 Capacity 5.1 RECOMMENDATION 6.1 CONCLUSION Work Cited LIST OF ACRONYMS OLAP- On-Line Analytical Processing ODM –Oracle Data Mining UAE- United Arab Emirate RDBMS – Relational Data Management System 1.1...
5 Pages(1250 words)Essay
Data warehouse
...Data Warehouse College: Data Warehouse In the era of development of business technology data warehouse - data mining are crucial tools in the business environment. Data warehouse is a system used for reporting and data analysis of information within organizations. This is a critical tool that many managers use for synthesis of decisions that affect the organizational path. 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...
4 Pages(1000 words)Essay
Description of a data data warehouse
...Data Warehouse A data warehouse is a oriented, integrated, time-variant and non-volatile collection of data in support of management’s decision making process (Bill Inmon). Subject-oriented: It can be used to analyse a particular subject area. Integrated: It integrates data from different data sources. Time-Variant: A data warehouse is used to store historical data. Non-volatile: The data does not change once it is in the data warehouse. Importance of Data Warehouse With the use of a...
5 Pages(1250 words)Assignment
sponsored ads
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.
Let us find you another Essay on topic Data Warehouse assignment for FREE!
logo footer
Contact us:
+16312120006
Contact Us Now
FREE Mobile Apps:
  • StudentShare App Store
  • StudentShare Google play
  • About StudentShare
  • Testimonials
  • FAQ
  • Blog
  • Free Essays
  • New Essays
  • Essays
  • Miscellaneous
  • The Newest Essay Topics
  • Index samples by all dates
Join us:
Contact Us