Premium Essay

Data Warehousing Case Study

Submitted By
Words 1077
Pages 5
Description – This video course is about to provide knowledge, skills and understanding about Data Warehousing and how to apply this in emerging fields of big data and online data storage management.
Data Warehousing
Data Warehousing is more concerned with database administration in a computer based environment. Data Warehousing which is also known as enterprise data warehousing (EDW) is an efficient system to keep the inventory of data pertaining to different aspects of the organization which is ultimately use for reporting and data analysis. Data Warehousing is treated as the core component of business intelligence. It is the main repositories of integrated data from different departments of an organization or different sources (i.e. suppliers,
…show more content…
Moreover, later on these repositories of the data provide an ease to businesses for making effective decisions. Data Warehousing video course is designed and developed by database experts and qualified professionals in a way that all learning takes place in self-explanatory manner.
Data Warehousing is a continual process of keeping the data by getting it from different departments such as marketing, sales, production, accounts or auditing etc. This data sometimes pass through further processes which are used to refine the data to make it more useable in Data Warehousing for reporting purpose. All the storage of data consists of electronic storage media which is backed by secure and reliable data management devices. The concept of data storage is not the new one but when we talk about Data Warehousing and storage in electronic format then it comes to know that it is originated in 1988 by the IBM researchers Barry Devlin and Paul Murphy. The need for Data Warehousing is increased with the increase use of computer systems and their evolution to become more complex for handling large scale data. The need for today’s business world is not just limited to storage of data. In fact, Data Warehousing is increasingly using in exploration and data mining for looking specific patterns and trends in the data that makes the businesses to forecast their future course of actions. Effective data storage and management has made the things possible what make the services like online traveling reservation systems and use of automated teller machines (ATM)

Similar Documents

Premium Essay

Sap Warehouse Management

...Warehousing in theory and practice A case study at ÖoB, Clas Ohlson, Stadium, Åhlens Mahesh Kumar Rajuldevi Ranjit Veeramachaneni Sridhar Kare _______________________________________________________________________ This thesis comprises 30 ECTS credits and is a compulsory part in the Master of Science with a Major in Industrial Engineering – Logistics, 120 ECTS credits Nr. 5/2009 _______________________________________________________________________ Warehousing in theory and practice A case study at ÖoB, Clas Ohlson, Stadium, Åhlens Mahesh Kumar Rajuldevi Ranjit Veeramachaneni Sridhar Kare Master Thesis Subject Category: Series and Number: Technology Industrial Engineering: Logistics, 17/2008 University College of Borås School of Engineering SE 501 90 BORÅS Telephone: +46 033 435 4640 Examiner: Supervisor: Date: Keywords: Göran Stjernman Göran Stjernman November, 2008 Warehousing, Warehouse management systems, Retail stores, Inventory, Labour management. ii Acknowledgements The present master’s thesis work represents the essence of our achievements during the two years of study in Industrial Engineering and Logistics programme at University College of Borås, Borås. During this period there have been many people who have inspired us throughout the study period. The thesis work is concluding part of our university degree in MSc. in Industrial Engineering and Logistics. This master’s thesis was written during autumn 2008. This period was......

Words: 29709 - Pages: 119

Premium Essay

Case Study Questions

...CISM 4136 A- Global Information Resource Management Case Questions Carol V. Brown, D.W. DeHayes, J.A. Hoffer, W.E. Martin,&. W.C. Perkins, Managing Information Technology, Seventh Edition, 2012, Prentice Hall. Case Study 1 - Midsouth Chamber of Commerce (A): The Role of the Operating Manager in Information Systems 1. Identify the key players in the case and describe their respective roles. Are these the right roles? What roles in particular should be modified? How might such role modifications be accomplished? 2. Focus on the role of the software vendor- Unitrak Software Corporation. Was it an appropriate role? Did Unitrak act responsibly? 3. How much is Kovecki to blame for this situation? 4. One of the recurring themes of this book is the importance of information systems politics. To what extent does IS politics explain the situation that has developed at the Midsouth Chamber of Commerce? 5. The case involves what appears to be a fairly routine use of information technology to support a service organization. Yet the Midsouth Chamber of Commerce encountered major problems in bringing up its new system. Is there a lesson here for organizations seeking to adopt new information technology? What is it? 6. What should Lassiter do now? Case Study 11-1- Vendor-Managed Inventory at NIBCO 1. What was the catalyst for NIBCO to develop a VMI program, and why was it able to respond? 2. Describe what types of transactions are involved in NIBCO's VMI......

Words: 1468 - Pages: 6

Premium Essay

Data Mining Case Study

...Health – A Cerner data warehouse in 90 days - Case Study http://www.healthcatalyst.com/success_stories/how-to-deliver-healthcare-EDW-in-90-days/?utm_medium=cpc&utm_campaign=Data+Warehouse&utm_source=bing&utm_term=+data%20+warehousing%20+case%20+study&utm_content=3542719787 Name: Goutham Para Provide brief but complete answers. One page maximum (print preview to make sure it does not exceed one-two pages). Q1: Describe the original data warehouse designed for Indiana University Health and its limitations. Please describe the new data warehouse and the differences between each? The original data warehouse structured and designed for Indiana University Health is traditional enterprise data warehouse. They designed data warehouse by using early binding architecture. There would be errors it takes months to update (health catalyst). Indiana University developed a new data warehouse health catalyst with help of late binding architecture. They promised to complete the work within 90 days as soon as possible with no risk. Health catalyst gave deadline data of 14 billion rows in to Enterprise Data warehouse (EDW), it is totally clinical data for ten years of Indiana university’s health network (health catalyst). The observed difference between both data warehouses is old and slow process. Considering health catalyst is faster for storing enormous data very fast without any faults. Q2: Identify the major differences between a traditional data warehouse and a data mart?......

Words: 666 - Pages: 3

Premium Essay

Real-Time Business Intelligence at Continental Airlines

...Case Study One- Real-Time Business Intelligence at Continental Airlines Real- time data warehousing works with Continental's strategies and plans through providing the best service possible to its customers. Continental had the goal of getting people to their destinations on time and with everything that they were traveling with. Real-time data warehousing helps to track the flight information, connection information, and passenger information in order for the company to be effective and for the passenger to have an enjoyable flight. With the fast paced environment of society and businesses today, the real-time data warehouse is the most efficient method of information travel for the company to use. At the click of a few keys, anyone with access is able to find information about connecting flights, passenger information and also problems that the passenger might run into with their flights. The real-time data warehousing was able to address the problems with airline reservations and connection people to other airlines for flight transfers, this makes things easier so the airline is able to see where each customer is going and the service that they need to provide to that customer to get them to their location on time with the least amount of glitches as possible. This feature also tracks passenger information such as all of their demographics and also tracks any disturbances that they might have had on a flight before so that the airline can work to avoid......

Words: 625 - Pages: 3

Premium Essay

Anup

...Integrations of systems, Outsourcing management, testing, storing. It also further performing business such as Business Intelligence, Security applications, Modernization of Legacy and Data Migrations. At present company’s employee strength is over 3500 peoples from different nationalities and it operating across the US, Canada, UK, Europe, Asia Pacifica and Middle East. Thus, Mastek operating eight of world class global delivery center in India and Malaysia. A person who took the cultural experience in this organization is working as a software engineer, who transferred from India Mastek to its UK branch. Nature of the Business Mastek (UK) Using an established framework, Mastek has over two decades of proven experience in the development and maintenance of large enterprise data warehousing and business intelligence decision support systems. Mastek's data warehousing and business intelligence solutions can help drive a lower total cost of ownership for your enterprise and are backed up by delivery models with stringent quality processes to reduce the risk and improve ROI. Mastek has unique solutions that not only monitor and display information but also supply the right information at the right time to support decision-making during real-time operations.  Our understanding of data warehousing and business...

Words: 1802 - Pages: 8

Premium Essay

Modeling Data Warehouse

...Discussion Question: 1. When developing a successful data warehouse, what are the most important risks and issues to consider and potentially avoid? Data warehouse projects have many risks. Most of them are also found in other IT projects, but data warehousing risks are more serious because data warehouses are expensive, time-and-resource demanding, large-scale projects. Each risk should be assessed at the inception of the project. When developing a successful data warehouse, it is important to carefully consider various risks and avoid the following issues: • Starting with the wrong sponsorship chain. You need an executive sponsor who has influence over the necessary resources to support and invest in the data warehouse. You also need an executive project driver, someone who has earned the respect of other executives, has a healthy skepticism about technology, and is decisive but flexible. You also need an IS/IT manager to head up the project. • Setting expectations that you cannot meet. You do not want to frustrate executives at the moment of truth. Every data warehousing project has two phases: Phase 1 is the selling phase, in which you internally market the project by selling the benefits to those who have access to needed resources. Phase 2 is the struggle to meet the expectations described in Phase 1. For a mere $1 to $7 million, hopefully, you can deliver. • Engaging in politically naive behavior. Do not simply state that a data warehouse will help managers make......

Words: 2805 - Pages: 12

Premium Essay

Data Warehousing in Universities

...Implementation of a Data Warehouse Prototype for the University of Nairobi within the Context of Relational Online Analytical Processing (Data Analysis) PRESENTED BY: 1.  JORAM KIPLIMO D61/68960/2013 0724431978 . PRESENTED TO: Dr. Muranga Njihia Word count: 2752 ABSTRACT Data ware housing is a booming industry with many interesting research problem. The data warehouse is concentrated on only few aspects. The discussion here is about the data warehouse design and usage in the case of the University of Nairobi Environment. Data warehouse can be built using a top-down approach, bottom – down approach or a combination of both. In this research paper we are discussing about the data warehouse design process. Data Warehouse (DWH) systems are used by decision makers for performance measurement and decision support. Currently the main focus of the DWH research field is not as much on the interaction of the DWH with the organization, its context and the way it supports the organization’s strategic goals, as on database issues. The aim of the study is to emphasize and describe the relationship between the DWH and the organization with conceptual models, and to use this knowledge to support data interpretation with business metadata. KEYWORDS Data Warehouse (DWH) Data Mart Extraction, Transformation and Loading (ETL); Software that is used to extract data from a data source like a operational system or data warehouse, modify the......

Words: 2816 - Pages: 12

Premium Essay

Data Warehousing

...Data Warehousing Essay, Research Paper Contents 1. Introduction 2. What is a data warehouse 3. Past, Present and Future 4. Data Warehouses and Business Organisations 5. Conclusion 6. Bibliography 1.0 Introduction In recent years, data warehousing has emerged as the primary method of analysing sales and marketing data for a competitive advantage. As the number of knowledge workers using the data warehouse/data mart grows and the amount of data increases daily, performance problems have become a major concern of both the Information Systems staff and the users. Many options have been tried in an attempt to solve the performance problems – from bigger hardware to different software or database tuning and redesign using star schemas or snowflake data structures. However, all have limitations – either in functionality or in terms of cost – and their strengths are almost inevitably outstripped by users’ demands. During the past three years, data warehousing has emerged as one of the hottest trends in information technology for corporations seeking to utilise the massive amounts of data they are accumulating. Managers from all business disciplines want enterprise wide information access, as well as the ability to manipulate and analyse information that the company has gathered for a single purpose, to make more intelligent business decisions. Whether to increase customer value, identify new markets or improve the management of the firm’s assets, the data......

Words: 3367 - Pages: 14

Premium Essay

Business Leadership

...618-92667390; Fax: þ 618-92663076; E-mail: pervang@cbs.curtin.edu.au Abstract This paper critically analyses the nature and state of decision support systems (DSS) research. To provide context for the analysis, a history of DSS is presented which focuses on the evolution of a number of sub-groupings of research and practice: personal DSS, group support systems, negotiation support systems, intelligent DSS, knowledge management-based DSS, executive information systems/business intelligence, and data warehousing. To understand the state of DSS research an empirical investigation of published DSS research is presented. This investigation is based on the detailed analysis of 1,020 DSS articles published in 14 major journals from 1990 to 2003. The analysis found that DSS publication has been falling steadily since its peak in 1994 and the current publication rate is at early 1990s levels. Other findings include that personal DSS and group support systems dominate research activity and data warehousing is the least published type of DSS. The journal DSS is the major publishing outlet; US ‘Other’ journals dominate DSS publishing and there is very low exposure of DSS in European journals. Around two-thirds of DSS research is empirical, a much higher proportion than general IS research. DSS empirical research is overwhelming positivist, and is more dominated by positivism than IS research in general. Design science is a major...

Words: 15413 - Pages: 62

Premium Essay

Concept Selling

...then we understand it through an example of a concept called FTWZ (Free trade warehousing Zone) Concept Selling- A type of marketing that uses the idea that consumers left to their own devices are unlikely to purchase a particular product. The concept selling approach is often advanced by a business as a justification for being especially aggressive in their marketing campaigns to promote sales. Concept selling is simply taking a product and selling it on the basis of an idea, making it more palatable to the customer. It is painting a word picture to the prospect, letting them visualize a certain situation. Concept selling vs Product selling. So what is the big difference ! “The number one thing when using Concept selling vs Product selling is that it creates a form of communication that gets the prospects attention. You are communicating an idea that makes more sense for your prospect to understand and relate to. In other words, it becomes more palatable to the prospect.” FTWZ- Fee trade warehousing Zone A Free Trade & Warehousing Zones (FTWZ) is a special category of Special Economic Zones with a focus on trading and warehousing. Selling of this unique concept is an interesting case study to analyse which includes a lot of challenging situations and roadblocks along the course. Firstly we analyse what is the concept of free trade warehousing Zone FTWZ (Free Trade and Warehousing Zones) is a policy of the Government of...

Words: 5858 - Pages: 24

Premium Essay

It560 Week 2

...Week 2 Assignment Kaplan University 12/12/11 Part A What are the primary reasons for changing the current systems? Butler University’s IT department provides and is responsible for technologies in the areas of network and systems, administrative, computing, web applications, instructional technologies among others. Staying on top of new innovative technological offerings is key to the success of how the university operates and conducts their day to day business. As stated in the case study readings, “many of the administrative users are displeased with outdated Centex and Centigram capabilities, although they lauded the communication systems high reliability. (Brown, 179) There was also one major problem with Butler’s current communication system. They were unable to communicate to the entire campus via the current system; in the event of an emergency it would be almost impossible to disseminate emergency information. The overall reason for this change is to improve communication by leveraging newer technologies. What role did Butler’s IS department play? Butler’s IS department will be very instrumental during this process. The IS team will first have to assist with the initial assessment of the current systems to identify the requirements for the new systems. Once the requirements are identified the IS department will also help to identify the right systems that will be acquired to replace Butlers current system. During......

Words: 1795 - Pages: 8

Premium Essay

Session Plan

...(Section-B,C & IMG), Phone: 9810075186, E.Mail:deepali.tnd@gmail.com Introduction: This course is to explain to the student the role of IT in organizations. Make students familiar with Transaction processing, Functional systems. Introduce the students to Computer Networking and to the role of IT in Supply Chain Management and Enterprise Resource Planning. Teach students Basics and Advanced MS-Excel including applications. Expose students to Data, Databases and Data-warehousing. Introduce the concept of Decision Support Systems and Management Information Systems including some of its common applications. Contents: Introduction of I.T. and fundamentals Strategic Information Systems for competitive advantage. Porters five forces model, Value chain model Introduction to Computer Networks Transaction Processing, Functional applications, CRM and integration Concepts of Supply Chain Management and Enterprise Resource Planning Microsoft Excel RDBMS and Data warehousing, Decisions Support Systems Management Information Systems Term Project Objective: Objective of this course is to help student understand: * Role of IT in organizations and the value derived from IT * Leveraging IT for competitive advantage * Common IT applications in collaborative, global Business * Usage of MS Access and MS-Excel and its application * Importance of Decision Support Systems( DSS) in business *......

Words: 498 - Pages: 2

Premium Essay

Siam Cements

...Proceedings of the Eastern Asia Society for Transportation Studies, Vol. 5, pp. 1673 - 1686, 2005 EVALUATION OF THE DECENTRALIZED PLANT DISTRIBUTION SYSTEM IN THE LOGISTICS OF THAI CEMENT Pairoj RAOTHANACHONKUN Graduate Student Department of Civil and Environmental Engineering Nagaoka University of Technology 1603-1 Kamitomioka-machi, Nagaoka, Niigata, 940-2188, Japan Fax: +81-258-47-9650 E-mail: pairoj@stn.nagaokaut.ac.jp Shinya HANAOKA Assistant Professor Transportation Engineering School of Civil Engineering Asian Institute of Technology P.O. Box 4, Klong Luang, Pathumthani, 12120, Thailand Fax: +66-2-524-5509 E-mail: hanaoka@ait.ac.th Abstract: Siam Cement Public Company Limited (SCC) faced stiff competition after the economic crisis in 1997, decided to close most of their warehouses for the change of logistics system. SCC presently operates five cement plants located whole regions in Thailand with except of the northeast region where three warehouses are still operated. This plant distribution system can be called the decentralized plant distribution system. Which plant distribution system is more efficient for SCC as the logistics strategy between centralized and decentralized? Based on this background, total logistics costs of both systems are formulated and calculated. In addition, the locations of a single warehouse without plant operation are evaluated using linear programming to minimize total logistics costs, which calculated with and without environmental......

Words: 5140 - Pages: 21

Premium Essay

Network Solution

...Introduction This is an individual project. Each student must complete a Case Study that provides the requirements analysis and a proposed solution for converged network solution. The target audience will be the organization’s Chief Information Officer (CIO). The Case Study deliverable is an MS Word document. The completed Case Study deliverable is due by 11:59 PM Eastern Time on the due date shown in the Course Schedule. See the Additional Information section of the syllabus for the penalty for late or missed assignments and projects. The Case Study is valued at 12% of the course grade. Case Study Company Overview Catacomb, Inc. is a global logistics provider that offers fully integrated freight and supply chain services through managed warehousing and domestic and international freight forwarding. Services range from door-to-door domestic and international delivery services to total supply chain management. With branches across the United States and Europe and partners worldwide, Catacomb continues to expand, and it has experienced rapid growth through acquisitions. Note: The term supply chain refers to all the elements involved in bringing an organization's products from the raw-goods stage to the customer. The Association for Operations Management (APICS) dictionary ((http://www.apics.org/Resources/APICSDictionary.htm) defines “supply chain management (SCM)” as the design, planning, execution, control, and monitoring of supply chain activities with......

Words: 878 - Pages: 4

Premium Essay

American Conector

...SUPPLY CHAIN MANAGEMENT DESIGNATION PROGRAM MODULE THREE Logistics and Transportation ©Supply Chain Management Association Supply Chain Management Professional Designation Program Copyright © 2013 by the Supply Chain Management Association No part of this material in this manual may be reproduced without the prior written consent of the Supply Chain Management Association. 777 Bay Street, Suite 2701, P.O. Box 112, Toronto, Ontario M5G 2C8 Tel: (416) 977-7111 Fax: (416) 977-8886 Web Site: www.scmanational.ca. Use of this material is restricted to SCMA and its Provincial/Territorial Institutes for the express purpose of delivering the Supply Chain Management Designation Program. No other use is authorized, expressed, or implied. This material must be used in its entirety. © Supply Chain Management Association Supply Chain Management Professional Designation Program Module Three Logistics and Transportation Information and Overview .................................................................................................... IO – 1 General Information ........................................................................................................ IO – 2 Module Overview ........................................................................................................... IO – 4 Module Readings ............................................................................................................ IO – 7 Session and......

Words: 6233 - Pages: 25