...Project on Data Management Submitted By: Name……………………. Section………………….. Question1. What are the components of quality data? Answer1. The latest information technology dimensions has enabled to make diverse use of data and turning the raw data into meaningful information to extract the quality. Data can be referred to raw numbers, figures which are useless unless they are put into a form and converted into a useful information. A data is said to be effective when it is converted into useful form or rather can be used to provide some information. When the raw data which is numeric, figures is converted into meaningful information, it is said to be known as information which can be used to give the data a meaning. Data quality is defined by its usefulness. When the data offers accurate information regarding a person or an organization then it is said to be known as data quality. The components of data quality can be analyzed with the help of the following data elements: 1. Accuracy which defines how correct and precise is the data 2. Completeness, the comprehensiveness of data also defines the data quality 3. Timeliness, the timely updates on the data also ensures that the data is correct and free from any discrepancy 4. Relevancy, the data that is gathered should be relevant which defines the purpose and fulfills the use. It defines that the data gathered accomplish the purpose 5. The last element of data quality is its availability. It defines the availability...
Words: 955 - Pages: 4
...Research of improve the data quality Abstract Data Warehouse is a data collection which is subject-oriented, integrated, relativelyand relatively stable. and It can reflect the changes of history and support the management decision. It is an important segment to maintain the accuracy of the data warehouse. However, ETL is an important part to build data warehouse and occupy about 60 percent of the load. The improvement of the quality in the data warehouse helps to guarantee the reliability and also help the enterprise to summarize and use the data for a long period of time. There are many methods to improve the quality of data. However, in the view of the experience summary and practice accumulation in the practical application, the paper mainly focuses on the ETL dispatcher and way of check to improve data quality of data warehouse. First of all, the automation of data management which is realized by ETL principle make the data into a data stream., the database where the data exists become as starting point of ETL, saving the data warehouse with ultimate high-quality data as the end of ETL. Second, for the data which the ETL data flow has been formed to generate example, for the data which complete ETL processes structure to handling historical information, thus ensuring that the ETL flow can monitoring. Third, building the processing logic of ETL tectonic processes, is the core of constructing high-quality data, constructing the automated calibration procedures...
Words: 3026 - Pages: 13
...Content | Page | 1 | Abstract | 3 | 2 | What is Data Warehouse? | 3 | 3 | Who uses Data Warehouse? | 4 | 4 | Characteristics of Data Warehouse | 4 | 5 | Basic Elements of Data Warehouse | 5 | 6 | Basic Processes of Data Warehouse | 7 | 7 | Basic Components of Data Warehouse | 8 | 8 | Data Warehouse Architecture | 9 | 9 | Steps to build successful Data Warehouse | 12 | 10 | Selection of Data Warehouse | 13 | 11 | Cost and Size of Data Warehouse | 15 | * Abstract: This document is for explaining what data warehouse is and how does it work. It also explains how data warehousing is useful for companies and organizations for the purpose of decision making and offers a broad array of decision support services to all companies. Data warehousing technique is adopted by many of the companies who use Information Technology to gain a competitive advantage. Companies who have started using this technology are building various techniques to develop hardware, software and other tools that help data warehouse to function more effectively. In this term paper I have given a brief idea about the development and basic terms that are necessary to understand data warehousing. The paper also states advantages and disadvantages encountered while developing data warehouse. * What is Data Warehouse: Data Warehouse is a database in which information of an organization is stored...
Words: 2065 - Pages: 9
...F4: DW Architecture and Lifecycle Erik Perjons, DSV, SU/KTH perjons@dsv.su.se The data warehouse architecture The back room The front room Analysis/OLAP Productt Product2 Product3 Product4 Time1 Time2 Time3 Time4 Value1 Value2 Value3 Value4 Value11 Value21 Value31 Value41 Data warehouse External sources Extract Transform Load Serve Query/Reporting Operational source systems Data marts Data mining Falö aöldf flaöd aklöd falö alksdf Operational source Data staging systems (RK) area (RK) Legacy systems Back end tools OLTP/TP systems Data presentation area (RK) ”The data warehouse” Presentation (OLAP) servers Data access tools (RK) End user applications Business Intelligence tools Operational Source Systems Operational source systems characteristics: Operational source systems • the source data often in OLTP (Online Transaction Processing) systems, also called TPS (Transaction Processing Systems) • high level of performance and availability • often one-record-at-a time queries • already occupied by the normal operations of the organisation OLTP vs. DSS (Decision Support Systems) OLTP vs. OLAP (Online analytical processing) Operational Source Systems More operational source systems characteristics: Operational source systems • a OLTP system may be reliable and consistent, but there are often inconsistencies between different OLTP systems • different types of data format and data structures in different OLTP systems AND DIFFERENT...
Words: 2902 - Pages: 12
...Business Analysis Part I – Wal-Mart Melissa Wojciehowski MGT/521 June 21, 2012 Dr. Felicia Bridgewater Business Analysis Part I – Wal-Mart Wal-Mart is a common staple in American society today, as it was in the past. From the time Wal-Mart opened its doors in Rogers, Ark back in 1962, Wal-Mart has served the public in ways that are unimaginable to other convenience store and retail chains throughout the nation. When first opened, Sam Walton imagined that his store would be a convenience to working families. The company became incorporated as Wal-Mart Stores, Inc., on Oct. 31, 1969. (Walmart.com, 2012) This allowed for growth into various outlets such as automobile care, pharmaceuticals and warehouse sales (Sam’s Clubs). With this growth also came notoriety. The year after becoming incorporated, Wal-Mart, Inc. began trading shares on OTC markets and two years later were listed on the New York Stock Exchange. Little did Mr. Walton know of the iconic changes Wal-Mart would put into place for businesses. In this paper I will examine, from the viewpoint of a mutual fund manager, whether or not Wal-Mart, Inc. is a company worth investing in. In order to do this, I will take a look at a brief SWOT analysis of the company as a whole. I will then examine Wal-Mart’s stakeholders, both internal and external, and whether or not Wal-Mart is living up to their expectations and what if anything needs to be done to make that happen. Strengths: Based on the corporate page of...
Words: 1514 - Pages: 7
...insertion of a central venous cannula. Conduction through the AV node and His–Purkinje system was intact, showing that the transient RBBB was caused by traumatic injury rather than by other disease of the conduction system. Designing central venous catheter product, which will appeal customer who are looking for a quality, healthy, sterility, and pyrogen free. The new product should be on shelf in test markets within nine months of start of the project and meet following goals. Page 5 Team members: Mahmud Abu el-Atta Mohamed Elmorsy Hamada Sharaf Amr Abdel Aziz Ismail El Hamalawy Maged Hamdy Emad Ali Production Planning specialist Quality assurance specialist Production manager Quality control lab Purchasing manager Operations Warehouse manager The mission goals meet the five...
Words: 2122 - Pages: 9
...DATA MINING AND DATA WAEHOUSING POSSIBLE OBJECTIVE TYPE QUESTIONS & ANSWERS 1. Data scrubbing is the A. process of rejecting the data in the data warehouse and to create the necessary indexes B. process of accepting the data from the data warehouse and to create the necessary indexes C. A process to upgrade the quality of data before it is moved into a data warehouse D. A process of upgrading the quality of data after it is moved into a data warehouse ANSWER : C 2. The architecture of Active data warehouse includes which of the following? A. Closer to real-time updates B. As a minimum of one data mart C. Data that can extracted from numerous internal and external sources D. All of the above. ANSWER : D 3. An operational system which means...
Words: 1677 - Pages: 7
...without her cooperation and technical assistance. We would also thank our Institution and our faculty members without whom this project would have been a distant reality. We also extend our heartfelt thanks to our family and well wishers. I would like to take this occasion to specially thank University of Northern Virginia to provide us with excellent faculty and also in supporting us getting quality education remotely. Contents SL No Title Page no 1 Abstract 5 2 Introduction to Databases 6 3 OLTP and OLAP Systems 7 4 Difference between OLTP and OLAP 9 5 Data Modeling 13 6 Workflows in Enterprise level Data warehousing 18 7 Business Intelligence tools used in Data flow and Data Warehousing 21 8 Analysis in Data warehousing 24 9 Conclusion 28 10 Foot Note 30 11 References 31 ABSTRACT These days majority of the applications, may it be web applications or windows applications or mobile applications, are completely database dependent. Most of the application developments are becoming database driven environments, hence rendering databases as one of the most key elements in a software environment. This dependency on databases can attributed to the increasing number of data requirements from the...
Words: 6349 - Pages: 26
...new CIO has joined the organization and wants you to report on the data warehouse. In your overview to the CIO, define the following components of a data warehouse: (Be sure to include the interrelationships between the components) 1. Data warehouse (Data Base management system) 2. Data warehouse – metadata 3. Data Warehouse – Database 4. Other internal data 5. Other external data 6. Operational databases 7. Data extraction/cleaning/preparation/programs I will start to define data warehouse and each of his components to the CIO. The data warehouse store data from different source, and organize the data for quick and effective queries (Kendall &Kendall, 2010). Data warehouse has various components, and they are: The first component is Database Management System (DBMS) it’s the software that manages the data warehouse database. Also, is the heart of the database allows the creation, modification, and updating of the database, the retrieval of data, and the generation of reports and displays (Kendall &Kendall, 2010). The metadata is a component about the data in the files or database; it also describes the data, name given and length assigned to each data item, and the length and composition of each record in the data warehouse (Kendall &Kendall, 2010). Metadata contains rows, tables, and cells about the data stored in the database. Another component of data warehouse is the database, this component formally define and centrally controlled...
Words: 1172 - Pages: 5
...like to save and have a better life.” (Walmart.com) Background on Walmart Walmart serves customers and members more than 200 million times per week at more than 10,130 retail units under 69 different banners in 27 countries. With fiscal year 2012 sales of $443 billion, Walmart employs 2.2 million associates worldwide. Walmart was founded in 1962, with the opening of the first Walmart discount store in Rogers, Ark. The company incorporated as Wal-Mart Stores, Inc., on Oct. 31, 1969. The company's shares began trading on OTC markets in 1970 and were listed on the New York Stock Exchange two years later. The company grew to 276 stores in 11 states by the end of the decade. In 1983, the company opened its first Sam’s Club membership warehouse and in 1988 opened the first supercenter -- now the company’s dominant format -- featuring a complete grocery in addition to general merchandise. Walmart became an international company in 1991 when it opened its first Sam's Club near Mexico City. (Walmart.com) Background on Walmart Strategy Traditionally, Walmart has had a low-cost, high volume strategy. The strategy aims at customer satisfaction through low prices and good customer service. Following are the key points of Walmart’s strategy: • Low cost: Walmart has low operating expenses. One of the primary reasons for their low operating expenses is their superior distribution capability because of the location of stores, information...
Words: 4430 - Pages: 18
...[Type text] DATA WAREHOUSE Introduction In todays competitive and information packed age, management, executives and business users need well organized data for decision support and for the organizational planning. Decision Support Systems (DSS) were developed to aid executives and managers to better understand the information and facilitate at making better decisions. But DSS has its own limitations. Due to the information requirement and their complexity, it was difficult for Decision Support System to extract all necessary information from the data. Therefore to overcome this drawback, a new data storage system, called the Data Warehouse was developed. What is a Data Warehouse? A data warehouse is a relational database. It is not used for daily routine transaction processing. It contains remarkable (having great significance) data derived from the transaction data. It also contains data from other sources like external systems, or applications. It is designed for query and analysis. Copyright 2011. Do not copy or publish any part of this document without author's permission. [Type text] Data Warehouse Vs Traditional Database A database is a collection of the relational data. Database system comprises of a database and database software. Similarly, a data warehouse is a collection of relational data as well as supporting system. If we look closer at it, we will find that both the traditional database and the data warehouse have indexes, fields, keys, views...
Words: 2229 - Pages: 9
...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...
Words: 2816 - Pages: 12
...industry is very intense and competitive. Producing many well-known brands has enabled Kraft Foods to sustain quality growth and profitability. Kraft Foods is wide spread across 72 countries and their products have reached more than 155 countries. This SWOT analysis will determine if the company is strong or has serious weaknesses. . SWOT Analysis for Kraft Foods Strengths: a. The extensive and wide geographical presence of the company throughout the world creates a diversified portfolio of the investment and reduces the overall risk of the company. b. The Company has a strong market position due to its strong market presence in the food industry. The presence at the global level makes it easier for the company to market an international brand. The history of quality service provider makes the company one of the most wanted brands among food lovers. c. The financial data shows the performance of the company sales for the last 5 years has shown positive outlook, which are positive financial indicators that the company is profitable. d. Kraft Foods does a Internal and RBV Analysis (Resource- based view) to Maintain and sustain a competitive advantage in the competitive world. Internal analysis provides the company with...
Words: 1666 - Pages: 7
...DATA WAREHOUSE A data warehouse is a logical collection of information gathered from different operational databases and used to create business intelligence that supports decision making tasks and business analysis activities. Walmart is known for having the biggest data warehouse used, which is larger then 4 Petabytes. Wal-Mart is very secretive about their data warehouse. After achieving a major milestone Teradata, Wal-Mart’s data warehouse supplier, was given permission to announce a few shallow facts about Wal-Mart’s data warehouse. • Wal-Mart has indeed the world’s largest, non military, database with a size of one-half a petabyte. • It is the world’s largest data warehouse Wal-Mart keeps track of 100 million customers buying billions of products every week. Using this data allows Wal-Mart to achieve Always Low Prices. It is the data warehouse that enabled Wal-Mart to become one of the 15 most profitable companies in the world. Let’s look at some sales questions Wal-Mart’s data warehouse has to answer: • How much orange juice did we sell last year, last month, last week in store X? • Comparing sales data of orange juice in various stores? • What internal factors (position in store, advertising campaigns...) in- fluence orange juice sales? • What external factors (weather...) influence orange juice sales? • Who bought orange juice last year, last month, last week? A data warehouse really is a Decision Support System (DSS). Providing the data to support business decisions...
Words: 898 - Pages: 4
...Bedard | | MT3500 | 10/24/2015 | A data warehouse is a relational database that is designed to help companies analyze data. It usually contains historical data derived from transaction data, but it can include data from other sources. Data warehouses are defined by subject matter and they enable an organization to consolidate data from several sources. They have the ability to hold multiple subject areas of very detailed information that works to integrate all data sources. A data warehouse environment also includes an extraction, transportation, transformation, and loading (ETL) solution, an online analytical processing (OLAP) engine, client analysis tools, and other applications that manage the process of gathering data and delivering it to business users. A data mart is a simple form of a data warehouse that is focused on a single subject or area of a company such as Sales, Finance, or Marketing. Data marts are often built and controlled by a single department within an organization. The sources could be internal operational systems, a central data warehouse, or external data. Compared to a data warehouse, a data mart often holds a single subject area of summarized information that concentrates on integrating information from one particular subject area. Data mining is the practice of automatically searching large stores of data to discover patterns and trends that go beyond simple analysis of data warehouses or data marts. Data mining is used to simplify and...
Words: 658 - Pages: 3
