Data Warehousing: Benefits and Implications

Data Warehousing: Benefits and Implications WHAT IS DATA WAREHOUSING? The term data warehouse or data warehousing was first coined by Bill Innon in the year 1990 which was defined as a â€Å"warehouse which is subject-oriented, integrated, time variant and non-volatile collection of data in support of managements decision making process†. When referring to data warehousing as subject oriented, it simply means that the process is giving information about a particular subject rather than the details regarding the on-going operations of the company. Moreover, when data warehousing was referred to as integrated it means that the data or information which are gathered from a number of sources are then all gathered to synthesize a coherent whole. On the other hand, data warehousing being time variant simply means that the data available were identified on a particular period. Lastly, data warehousing as being non-volatile means that the data is stable and when a new data is added to the system, the old data are never removed, instead they just remain there and this enables the organization to be able to give the management consistency in their business (Inmon, 1995). In the existence of modern times with the advent of technological advancements inevitably affecting the businesses in major ways, there has also been a development and emergence of new measures, practices, and techniques which used technology to be able to provide an unwavering solution to the problems in the organization with regards to the level and kind of information that the organization needs to be able to survive and prosper amidst the increasing competition in the market. Undeniably, one of this techniques and practices refers to the emergence of data warehousing as a tool helping todays businesses to be able to manage competition and the turbulent economic condition. The birth f the concept of data warehousing can be contributed to various researches and studies which were conducted in the past to provide various organizations with the means of getting information in a manner which is efficient, effective, and flexible. The data warehousing which is known today among the cor porate practice is not what it was when it started almost two decades ago. The practice of data warehousing nowadays is a result of the experiences and technologies in the last twenty years. Bill Inmon and Ralph Kimball are two of the heavyweights when it comes to data warehousing. However, although their names are known in this field, these two scholars have two varying views with regards to data warehousing. The paradigm which was illustrated by Inmon holds that the data warehouse forms only a part of the general business intelligence system. On the other hand, the paradigm of Kimball assumes that the data warehouse is a conglomerate of all the data in the organization. Other researchers assume that there is no right or wrong theories among the two assumptions from the two heavy weighs in data warehousing. However, most of them support the notion of Kimballs paradigm. They believe that most data warehouses started only as efforts from various departments starting on what they call as data marts until they develop and evolve to become a data warehouse. Furthermore, according to Manning (1999), data warehousing ahs been heralded as one of the sustainable solutions to management information and dilemma and such also provide the organization and environment which entails various benefits if they are practiced in the right way and if the perspectives are directed towards the right goal. The process of data warehousing is said to have the intention of providing an architectural model which can best provide an illustration for the flow data from the systems regarding the operation to the decision support environments. However, according to the same author, one problems stems down from the data warehousing technique that is such a system is said to be too expensive to be affordable by some organizations or businesses. It is undeniable that data warehousing continues to attract interest, it is also undeniable that many projects are failing to deliver the expectations from what they are supposed to deliver and they still prove to be too hi gh of accost to be handled by some businesses. However, to be able to justify this relatively high cost, it has been said that organizations should look at the long term benefit of the warehouse rather than simply looking at the short term benefits that such can offer. Moreover, data warehousing is also said to be designed â€Å"to be able to support ad hoc data analysis, inquiry and reporting by end-users, without programmers, interactively and online† (Heise, n.d.). The author also mentioned some key factors which can make the data warehousing practice a success among different organizations. According to him one of the key ingredients to the success of the practice is to make the management, especially the higher management, aware and conscious of all the benefits which this tool entails and what can data warehousing do to improve the performance of the business. The author as a key to the success of data warehousing is choosing the right people to make it happen. By choosing the right people, the author does not disregard the fact that the contribution of individual minds should be recognized to form a synthesis and a greater whole. Training strategy, the right structure or architecture, a sustainable mission statement, showing early ben efits, ensuring scalability, understanding how important is the quality of data, and using only proven and effective methodology are some of the other key ingredients to make data warehousing a successful practice. THE BENEFITS OF DATA WAREHOUSING David Heise was able to identify some of the benefits of data warehousing. According to him some of the benefits that it offers include the fact that it has a relative orientation on the subject area, it has the ability to provide an integration of data which were retrieved from diverse and multiple sources, it allows data analysis from time to time, it adds ad hoc inquiry and reporting, it provides decision makers with the capabilities to analyze, it relieves the IT from information development, it ahs the ability to provide better performance for complex analytical queries, it relieves the burden of processing databases which are based on transactions, it allows a planning process that is perpetual and continuous, and lastly, it converts corporate data to make them strategic information which can help them in planning for a better performance of the organization. Another benefit of data warehousing is that it enables and it helps different organizations in the strategic decision making resulting into formulation of strategic decisions which are geared towards enabling a better business performance and yielding better results. It can be assumed that most data warehousing practices are not intended for strategic decision making because they are normally used for post monitoring of decisions regarding to how effective they are. Nonetheless, it should not be also disregarded that data warehousing, according to LGI Systems Incorporated, can also be sued for strategic decision making and can be used profitably. Another benefit of data warehousing is that it enables the user to have unlimited access to a relatively very large amount of enterprise information which can be used to potentially solve a large amount of enterprise problems which can even be used to increase the profitability of the company. A very well-designed data warehouse can yield a greater return-on-investment with unlimited benefits nad the ability to better assess the risks associated with the organization. SAPs DATA WAREHOUSING SOLUTION For most of the companies which are implementing SAP, the next logical step for them would be the consideration of data warehousing as a useful tool and technique in the conduct of their business performance. In some situations, there are companies which use data warehousing as being parallel with the SAP transaction system. SAP has usually been regarded among organizations as their most important reference for transaction data. With that, it can be regarded that data warehousing, when coupled with SAP, can provide a greater solution and better transaction records (Khan, 2005). It has been said that the main objective of data warehousing is the ability to be able to analyze data from a variety of sources which can support businesses when they a making decisions. BW or the Business Information Warehouse is regarded as being the SAPs data warehousing solution. BW refers to an end-to-end data warehousing solution which uses Sap technologies which are already in existence. It is composed of various layers and types of information which are essential in building the BW architecture and in executing data warehousing solutions which will be helpful in the companys business performance. SAPs data warehousing solution can also be helpful in other aspects such as quotation processing, order processing, delivery, analysis and comparison and administrative and management functions (Fu Fu, 2003). The Business Information Warehouse, being SAPs data warehousing solution, has been developed specifically for business to be able to potentially analyze and gather various types and kinds of relevant information which will provide statistical information about related transaction in the best ways possible. The BW is helping the knowledge workers to quickly mine and gathers the data of the business; it is also equipped with pre-configured information on reports and models. COMPANIES USING DATA WAREHOUSING AND ITS IMPLICATIONS An example of a known company which uses data warehousing is WalMart. Being the worlds largest retailer, many say that the company should be also the organization with the largest data warehouse which is going to serve as the database of its inventory and all transactions related to their business performance. The data warehousing also has a big implication on the business of WalMart. According to the management of the worlds largest retailer, more than any other purpose, their data warehouse is helping them to be able to make decision support systems between the company and its various suppliers. Aside from that, another implication of data warehousing on WalMart is that it enables the suppliers to be able to access a large amount of online information and data which will be helpful with their suppliers in terms of improving their operations. One example of companies using and reaping the benefits of adapt warehousing will be various pharmaceutical companies, or in a larger scale, the general healthcare industry. For most of the pharmaceutical businesses which are under operation, they were able to acknowledge the fact that they lack a sustainable focus on their promotional practices, resulting to diffused sales efforts. With that, they regard that data warehousing technique has a big implication in their business because they regard such as the best medicine and remedy for the aforementioned problem. They are even using data warehousing to be able to attain a sustainable competitive edge against other businesses in the industry. In the case of pharmaceutical companies, it has an implication also in the marketing department. Data warehousing helps the marketing department, through various information contained, to come up with promotional and marketing activities which can yield them maximum results. Moreover, data wareho using also has an implication on the human resources department of the organizations because they can also help in the effective allocation of people and resources (Desai, 1999). REFERENCES: Desai, Amit; For Pharmaceutical Companies, A Data Warehouse Can be Just What the Doctor Ordered Fu, Henry, Fu, Biao; SAP BW: A Steb by Step Guide; 2003 Heise, David; What is Data Warehousing; n.d. Inmon, W. H.; What is a Data Warehouse?; Prism; 1995 Khan, Arshad; SAP and BW Data Warehousing: How to Plan and Implement; 2005 LGI Systems Incorporated; The Data Warehousing Information Center; Accessed on April 9, 2010 from http://www.dwinfocenter.org/strategy.html Manning, Ian; Data Warehousing; Adopting an Architectural View and Maximizing Cost Benefits; 1999

Simplicity in a Clean Well Lighted Place Essay -- essays research pa

Ernest Hemingway is known as one of the best writers of our time. He has a unique writing style in which he manipulates the English language to use the minimum amount of words and maximize the impression on the reader. A Clean, Well-Lighted Place is a prime example of this. Here, Ernest Hemingway uses his writing style to reinforce the theme of â€Å"Nada†. The setting is simple, the characters are plain, and the dialogues among them are short and to the point. It is with the absence of similes and metaphors that the reader is able to appreciate the work for what it is. Ernest Hemingway does not feel the need to give much detail on the setting. The reader knows that it is late and that these men are in a cafà ©. The main character is sitting in the shadow and he is drinking brandy. Hemingway leaves out details from the setting but does make it clear that this cafà © is, like the title suggest, clean and well-lighted. He only states important aspects of the setting demonstrating that details are nothing: nada. Through his writing Hemingway implies that this old man feels that little details in the world mean nothing. When the older waiter asks the younger waiter why this drunken man had tried to commit suicide a week before, the younger waiter simply answers â€Å"Nothing. He has plenty of money.† In the young waiters mind this old man has everything. Obviously, this old man feels that things like money are nothing and thus not worth living over. Ernest Hemingway, through the lack of deta...

Cardinality and Modality Essay

Cardinality Cardinality indicates the maximum number of times an instance of one entity can be associated with instances in the related entity. Cardinality can have the values of one or many, no more detail than that. It is either one or more than one. On the relationship line, the cardinality is the closest to the entity box. The cardinality symbol in the diagram on the slide is in the red circle. Cardinality is indicated at BOTH ends of the relationship line, so there is a left to right cardinality and a right to left cardinality. Modality Modality indicates the minimum number of times an instance in one entity can be associated with an instance in the related entity. Modality can have the values of zero or one, two or three are not allowed. The modality symbol is located next to the cardinality symbol, on the inside, i.e., NOT next to the entity box. A modality of one is denoted by a straight vertical line and a modality of zero is denoted by a circle. Like cardinality, modality is indicated at both ends of the relationship.

Workplace Diversity And The Workplace - 853 Words

Workplace Diversity Many outstanding articles, books, journals and papers have been written regarding the topic of workforce diversity. Some are relatively short papers such as Diversity in the Workplace published by the University of Florida, and seek to provide the reader with a basic understanding of what is meant by workplace diversity, as well as the potential benefits to both employers and employees alike. Other resources can be significantly more in-depth and explore subtopics of workplace diversity including the effects of marriage on work place attitudes, or how to effectively manage the cultural and demographic differences within a firm’s labor pool. Information regarding generalities in different cultures around the globe is also available as a resource for those seeking to understand customs in mannerisms and body language across varying cultures. In addition to the many websites and literature available to employers, there are also companies such as Big World Inc. , whose does business under the name of Diversity Resources, offers training tools and services geared towards providing customized solutions for firms wishing to outsource training programs for employees including harassment, conflict resolution, international team building, gender bias or any one of a number of other topics related to diversity. A brief list of some of these resources appears below: †¢ Diversity in the Workplace: Benefits, Challenges and Solutions. Greenberg, J. (2009) †¢ TheShow MoreRelatedDiversity In The Workplace. . Diversity In The Workplace990 Words   |  4 PagesDiversity in the Workplace Diversity in the workplace is imperative even though some commentators argue that too much diversity can be negative. Diversity can lead to staff feeling ‘threatened or even annoyed by persons with views and backgrounds different from their own’ (Barsoux, Strebel and Manzoni, 2010). Instead of inclusivity, diversity can end up causing conflicts, as some staff are reluctant in changing their viewpoints and are less adaptable to change. The discourse relating to diversityRead MoreWorkplace Diversity Of The Workplace965 Words   |  4 PagesJob’s face many struggles and challenges each and every day. Workplace diversity is something which is being talked about the most here lately. Out breaks of minimum wage, sexualities, gender, and even your skin color affects what diversity a business would want. Within the business, the professional level is set pretty high due to the superior designers making us able to dress well fashioned. When people step into a business they do not want someone that is going to walk in with a t-shirt and gymRead MoreDiversity At Workplace Diversity Within The Workplace3281 Words   |  14 Pages1.0 Diversity at workplace Diversity is a very extensive subject and can be in any genre or class; it is difficult to categorize because of its complex nature. According to Res (2012), diversity can be represented as a variety of human aspects pertaining to different societies and cultures in the workforce or can be explained tolerating the differences. On the contrary, diversity is a quest of differences among human beings in safe, positive and nurturing surroundings and moves beyond simple toleranceRead MoreThe Impact Of Workplace Diversity On The Workplace997 Words   |  4 Pages Workplace diversity is a term which describes the inclusion of people in the workplace regardless of their cultural differences such as gender, race and sexuality. Rather than disregarding them, diverse workplaces utilise these differences to widen the range of experiences and skills among their employees as stated by the Australian Breastfeeding Association (2012). Some professions, however, are more diverse than others. According to the Diversity Inclusion: Unlocking Global Potential - GlobalRead MoreDiversity in the Workplace964 Words   |  4 PagesRunning head: DIVERSITY IN THE WORKPLACE Abstract Select (highlight) this text and then begin typing your abstract, which should be limited to one paragraph of not more than 120 words A Survey of Organizational Culture and its Effectiveness on Managing Diversity in the Workplace Diversity in the workplace is a relatively new concept that has been attracting considerable attention from the executives of most businesses. â€Å"Ongoing demographic trends (increasing percentages of African-AmericansRead MoreWorkplace Diversity Within The Workplace865 Words   |  4 Pagesmarket today is workplace diversity. Workplace diversity is defined as all characteristics and experiences that defined each employee as individuals, but it can also be misunderstood as discrimination against employees. Diversity can include race, ethnicity, sex, religion, disability and sexual orientation discrimination. One reason why workplace diversity is important is because when you respect your employees productivity rate rises and many companies do not know that. A diverse workplace targets toRead MoreThe Diversity At The Workplace747 Words   |  3 PagesThomas (1992) entails the diversity at workplace in terms of all ancestry, ethnicity, age, gender, race, educational background, sexual orientation, marital status, religious belief, income, geographic location and work experience. The mobility in human resource trend is em erging within the competitive market that requires more strategic role on account of human resource management. Organizations may fall in dire consequences of outplaying by other competitors in strategic employment. Nowadays, workforceRead MoreWorkplace Diversity Within The Workplace1322 Words   |  6 Pagespast decade, diversity in the workplace has become one of the most frequently discussed topics in management groups or circles, while interested academically in the actual prospective of workplace diversity has remained limited. To be successful in managing diversity in the workplace first one must understand it from a personal perspective. To be able to derive knowledge and strength from one’s differences shows deep faces in character. A book I read in high school defined diversity as â€Å"the mosaicRead MoreDiversity in the Workplace5680 Words   |  23 PagesSURFACE LEVEL DIVERSITY, DEEP LEVEL DIVERSITY, AND ORGANIZATIONAL COMPETITIVENESS ABSTRACT Surface level diversity is the mixture of people who differentiate by sex, race or ethnicity, and the observably physically disabled. These differences typically cannot be changed and are easy to measure because they are visual. Deep level diversity are differences such as personality and attitudes that can be communicated through verbal and nonverbal behaviors. Diversity can be affiliated with socio-economicRead MoreDiversity in the Workplace1096 Words   |  5 PagesRunning head: DIVERSITY IN THE WORKPLACE Diversity in the Workplace Amber Barger ORG536 – Contemporary Business Writing and Communication Colorado State University –Global Campus Dr. Phillip Jackson November 26, 2013 DIVERSITY IN THE WORKPLACE As companies start to regain their footing after the recent economic downturn, 2 factors such as the rising number of immigrants, mergers of large corporations, the popular use of temporary workers and the increasing globalization of business,