...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? Explain the...
Words: 666 - Pages: 3
...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 data and then...
Words: 2816 - Pages: 12
...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 very...
Words: 29709 - Pages: 119
...This case study investigates the healthcare informatics processes and technology in improving the accurate entry of patient data and summarizes nursing research regarding data integrity. The case study examines the impact of consequences of the use of Electronic Health Record (EHR) systems on the quality of care and proposed solutions to address accidental EHR-related mistakes. In this case study every diagnostic procedure was done correctly and promptly for patient`s well-being, while poor and improper entry of the patient’s data led to jeopardizing the integrity of information, and further endangering patient safety or decreasing quality of patient care. One of the methods to ensure data accuracy is to ask the patient to verify data that is collected during admission and assessment processes. This verification may be accomplished through: verbal confirmation, reviewing data by patient on selected computer screen or tablet, and reviewing printouts by client of entered data. Each of these methods has possible problems. Patient may not be English proficient, the atmosphere in the emergency room may be too fast paced for the patient to be able to accurately review the data or patient may have verbal or vision weakness. Usually, electronic health records data entry result in faults due to software design flaws, poor decision support rules, inadequate user training, system performance issues, human error, interruptions by colleagues while submitting patient data, or use of the...
Words: 667 - Pages: 3
...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 warehouse...
Words: 3367 - Pages: 14
...Introduction Warehouse management is part of logistic and supply chain management system which is a vast and critical process. With the change of business nature due to globalization the complexity of warehouse management has increased more. As much of the business success of today’s competitive world depends on effective logistic and supply chain management system companies are relying more on integrated computerised system to manage their warehouse function more effective and efficiently. SAP Warehouse Management System is one of those kinds of solution which fulfil all the requirement of today’s business need. The system is flexible and provides automated support to process warehouse activities. It includes planning, monitoring and controlling. As a result there has been remarkable improvement in the warehouse management process with speed and accuracy. Warehouse Management Warehouse management (WM) is an integrated process of managing all activities of a warehouse. Prime consideration of warehouse management is to manage the movement and storage of materials within a warehouse and process related transactions including shipping, receiving, put away and picking of materials or goods (Wikipedia 2011). Warehouse management is no longer limited to the boundaries of a particular warehouse. A wide range of activities have been incorporated to this process. These are inventory management and planning, cost management, container storage, loading and unloading of goods, warehouse design...
Words: 1573 - Pages: 7
...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 cost...
Words: 5140 - Pages: 21
...Case Study: #1 - The Big Data Challenges Arnechia Washington Professor Durgin CIS500 Info Syst Decision-Making January 26, 2014 Volvo Car Corporation has incorporated the cloud infrastructure into its networks to globalize the company. “With hundreds of sensors and CPUs embedded throughout the car — from the brakes to the central locking system — data is now being captured for use within the vehicle itself, and also, increasingly, for transmission via the cloud back to the manufacturer” (Strader, 2011). Volvo’s data Warehouse has multi-terabytes of data from the hundreds of sensors and CPU’s that are embedded throughout the car as well as data from customer relationship systems. The Cloud platform allows implementing and evaluating real-time information systems to transform data into knowledge. This will give Volvo a competitive advantage over other car companies and allow their offices no matter the location to immediately take advantage of the data that is stored. There are two different cloud infrastructures within their infrastructure: service cloud and vendor hosting. Service cloud is used to support the customers and while their customers are operating the vehicles. This will enhance the car from the information that is gained based on the design and performance level of the car. Vendor hosting is used for the data that is located in separate warehouses. This platform allows the data to be consolidated into one place and reduces the cost to maintain, operate...
Words: 989 - Pages: 4
...A CASE STUDY ON MANAGING GROWTH AT SPORTSTUFF.COM A group case report during the class IOM 581 – Supply Chain Management Prof. Sosic Greys UNIVERSITY OF SOUTHERN CALIFORNIA SPRING 2013 SportStuff.com SportStuff.com was founded by Sanjay Gupta in 1996. This business supplied sports equipment for children. Children tend to outgrow their size in no time. Hence, parents had to discard the sports equipment every now and then. SportStuff.com sold used equipment from other customers and surplus equipment from manufacturers over the Internet. Sanjay received enough capital from venture capitalists and could offer a wide variety of products. As the demand began to grow rapidly, Sanjay had to come up with new strategies for warehousing. Initially starting with one warehouse in St. Louis, he had to lease more space within the same warehouse to meet the demand. Demand has been growing rapidly since 1999 and Sanjay needed a new plan. He has a few options including leasing more warehouse space in St. Louis or finding other potential locations across the United States. The next 3 years were predicted to have a growth rate of about 80% per year. A serious supply chain redesign was needed soon; otherwise costs would far exceed the growing demand and revenues. Leasing a warehouse involves fixed and variable costs. Fixed costs are based on the size of the warehouse itself. Variable costs depend on the actual quantity that was shipped through the warehouse. Additionally, he can rent...
Words: 1249 - Pages: 5
...service provided by a company, it is critical that managers be knowledgeable about how to optimize the flow of products and goods within their supply chain. This book takes a very technical subject and makes it possible for managers and students alike to understand all aspects of network design. The practical approach used in discussing topics throughout the book provides a clear and excellent framework for those seeking to learn more about the topic. The book is a needed and welcome contribution to the profession.” —Dr. Mary C. Holcomb, Associate Professor of Logistics, Department of Marketing and Supply Chain Management, College of Business Administration, University of Tennessee “Supply chain management (SCM) is a rapidly growing area of study—and network design is one of the fastest growing areas within SCM. This book would make a great classroom textbook. It is easy to follow with clear examples and useful exercises. It is laid out in progressive layers, with one’s understanding of the subject matter building as you go. You can stop midway and be comfortable with the fundamentals, or you can go as deep as desired into Supply Chain Network Design. “I have been a long-time practitioner of network modeling, as a manager in business and as a consultant, and I have covered the topic in university lectures; I still learned a great deal about a subject I thought I knew thoroughly!” —Bill Nickle, Principal, Nickle Consulting “This is a wonderful book that offers students and practitioners...
Words: 15552 - Pages: 63
...Abstract Information Technology has become a significant component of new capital investment (some estimate put it at 30%) and several economists look to computers as the best hope for a sustainable increase in economic growth rates. Thus the question arises, can computers and the usage of information technology help attain the break-even earlier resulting in more and more profits? Thomas K. Landauer, in his book, The Trouble with Computers (MIT Press, 1995), argues that computers have been unproductive due to poor design and deployment. To support this thesis, Landauer Drwasn on economic data and analysis as reported by other researchers, and offers voluminous anecdotal evidence of computer shortcomings. He then proceeds to offer his own solution to this problem and provides an argument that computers can be improved in ways that would make them more useful, usable and productive. Introduction In India, Information Technology has built up a valuable brand equity over a decade. It is estimated that IT sector in the country has been growing at a rapid rate of over 35% per year. The contribution of IT has not been only limited to Banking, ITES and BPO sector, but also to the ever-growing Manufacturing sector. IT today provides the communication and analytical power to the organization to conduct business and compete at the global level. In the broadest sense, information technology refers to both the hardware and software that are used to store, retrieve, and manipulate information...
Words: 2276 - Pages: 10
...Case Study: Grill Rite Introduction: Grill Rite is an old-line, seasonal company that started out making wooden matches and then evolved into making electric barbecue grills. They sell five models of grills nationally. It is evident from the case study that the workers of Grill Rite are very loyal. Inventory is handled by a system of four warehouses, one central warehouse and three regional warehouses. The company stockpiles on purpose to ensure that the workforce has a stable income. On an annual basis, however, the output matches demand. There has been an increased amount of complaints from regional sales managers about poor customer service. Customers’ orders go unfilled or are late, due to shortages at the regional warehouse which is causing the company to lose sales. The regional warehouse managers began to increase their order sized from the main warehouse in order to maintain larger amounts of safety stock. This has increased inventory holding costs, and not solved the problem of stock-outs. On the other hand the main warehouse feels that their policy is to give preference to filing orders from “actual” customers and not to the regional warehouses. It is evident that the regional warehouses also supply to customers on a regional basis. This inventory issue is costing the company in lost orders and being stuck with stock holding costs. Problems: 1. The president’s stance on steady output conflicts with seasonal demand. 2. Having a single, centralized warehouse...
Words: 543 - Pages: 3
...key factors concerning fire incidents. To identify and recommend the responsibility of different actors to create social awareness against fire hazards. To find possible ways to tackle fire hazard and design rescue process in present context. To find variables which are flexible to change, even in the conjusted urban context and can facilitate fire hazard rescue. To attempt to find new type of stratetegy to tackle fire incidents and if required, incorporate new design elements or illustrate conceptual basis of the process. Possible Outcomes: An in-depth study will bring light to a number of aspects regarding fire hazard incidents. The research will identify the reasons behind fire hazards, its victims, misery and the damages. Also it will bring light upon the possibilities and challenges of fire fighting strategies prevailing in Dhaka city. By analyzing the problem thoroughly, the study will draw attention to the different actors it involves, their roles and performance. The result of the research is expected to create awareness among all the levels of populace and encourage forming efficient strategies to combat fire hazards effectively. Outline of Methodology: Literature Review To establish the concept and to have a better knowledge and...
Words: 1046 - Pages: 5
...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 anything...
Words: 625 - Pages: 3
...5 Supply Chain Management Based on Modeling & Simulation: State of the Art and Application Examples in Inventory and Warehouse Management Francesco Longo Modeling & Simulation Center – Laboratory of Enterprise Solutions (MSC-LES) Mechanical Department, University of Calabria Via P. Bucci, Cubo 44C, third floor, 87036 Rende (CS) Italy 1. Introduction The business globalization has transformed the modern companies from independent entities to extended enterprises that strongly cooperate with all supply chain actors. Nowadays supply chains involve multiple actors, multiple flows of items, information and finances. Each supply chain node has its own customers, suppliers and inventory management strategies, demand arrival process and demand forecast methods, items mixture and dedicated internal resources. In this context, each supply chain manager aims to reach the key objective of an efficient supply chain: ‘the right quantity at the right time and in the right place’. To this end, each supply chain node (suppliers, manufacturers, distribution centers, warehouses, stores, etc.) carries out various processes and activities for guarantying goods and services to final customers. The competitiveness of each supply chain actor depends by its capability to activate and manage change processes, in correspondence of optimistic and pessimistic scenarios, to quickly capitalize the chances given by market. Such capability is a critical issue for improving the performance of the ‘extended...
Words: 17564 - Pages: 71
