Premium Essay

"Enterprise Level Data Work Flows and Data Warehouse

In: Computers and Technology

Submitted By iahammod3175
Words 6349
Pages 26
CSCI 1507 (1903)

"Enterprise level data work flows and Data Warehousing"

Professor Rajni Palikhey
University of Northern Virginia

Acknowledgement

This Research Paper would not have been possible without the guidance and the help of my co-students and respected Professor who in one way or the other contributed and extended their valuable assistance in the preparation and completion of this research paper. I would to like to convey my sense of gratitude to Professor.Rajni Palikhey who helped and supported us right throughout the semester. This paper would not have been possible 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…...

Similar Documents

Premium Essay

Research of Improve the Data Quality

...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......

Words: 3026 - Pages: 13

Premium Essay

Data Information and Information System

...Data: Raw material Data collection costs money Collect only necessary and sufficient data Data is generally used by machines Data is useless unless it is process to create information Information: Processed data Data process by machines giving information Information is used to run an organization efficiently Information used by managers to initiate actions TYPES OF INFORMATION Operational Information - used to day to day operations Example information needed by a shopkeeper: Daily sales account List of low stock items to be re-ordered List of overstock items Long overdue payments Profit loss account Tactical information - used to improve profitability Example information needed by a shopkeeper: Slow or fast moving items Reliable supplier of items Sales trends Strategic Information - information to expand business and explore new opportunities Example information needed by a shopkeeper: Whether to stock different varieties of items Whether to diversify Whether to start a new branch in a different locality Whether to start an e-shop Statutory Information - used to provide information to the government Example information needed by a shopkeeper: Income tax account Sales tax account MANAGEMENT HIERARCHY AND INFORMATION NEEDS QUALITIES OF INFORMATION Accurate Complete Timely Trustworthy Relevant Brief Up-to-date SignificanceEnsure correct input and processing rules Include all data Give at the right time Do not hide unpleasant information ......

Words: 2370 - Pages: 10

Premium Essay

.Lkmk

...procurement process and the data, document, and information flows associated with the process. * Explain the financial impact of the steps in the procurement process * Explain the role of enterprise systems in supporting the procurement process Chapter Outline and Teaching Suggestions 1. Key Concepts and Assumptions a. Procurement - Requisition to pay b. Business to consumer c. Business to business Explain what procurement means and differentiate between B2B and B2C procurement. 2. A Basic Procurement Process d. The framework i. Physical flow ii. Data and document flow iii. Information flow Review the framework introduced in chapter 1 e. Physical Flow iv. Create requisition v. Create and send purchase order vi. Receive shipment vii. Receive invoice viii. Send payment Explain each step in terms of purpose. Discuss how communication between process steps is accomplished. 3. Document and Data Flow f. Purchase Requisition g. Purchase Order h. Packing List i. Goods Receipt Document j. Goods Receipt Document For each document, explain its role in the process and the key data in the document. For the data in the documents, explain the purpose of the data and how it is used in the various process steps and how the data may change during the process. Discuss alternative values for the data such as......

Words: 1822 - Pages: 8

Premium Essay

Data Warehousing

...Data warehousing: what is it, why do we want to do it, how is it done? How do data warehouses compare with operational databases? What do we want to consider when doing so, and what are our options in terms of implementation? In this article, I discuss data warehouses: what they are, how they compare to operational databases, and how they are designed, implemented and maintained. An operational database is one which is used by the enterprise to run its day to day operations. They are created to support fast transaction processing, with frequent updates. Speed is key to operational databases. They typically are used by clerical staff, and are on the order of megabytes of data to gigabytes. Database consistency is very important to operational databases, and consistency checks and constraints are rigidly enforced. They contain the most current set of data applicable to running enterprise operations. These are our sales and inventory databases. A data warehouse differs from this in many ways. They are used by management for making decisions, watching trends, and running reports. They are typically used offline, have few users and are very large: gigabytes to terabytes. They contain historical data, are read only, and are added to but rarely or never updated (the rows in the database are not changed, I mean). The data in the data warehouse is time sensitive – each row is the warehouse is timestamped so that trending of data versus time can be done. The kinds...

Words: 1530 - Pages: 7

Premium Essay

Crm and Dss System

...study of the integration between CRM systems and Decision Support System (Efficient support for multi levels of management in the organization) Nehad Omar Mohamed Arab Academy for Science &Technology & Maritime Transport Faculty of computer science and information systems Department of Information system (Decision Support Systems) Cairo, Egypt NehadOmarM@gmail.com Abstract This paper reports the results of a study into the Integration between customer relationship management systems (CRM) including different level of functionality with decision support systems(DSS),and analyzes the role played by the information system and its component, briefing simple steps of building a CRM system with quality to avoid the popular known problems of integration between systems trying to produce a clear data with enough degree of quality to be used the DSS system to support different levels of management in the organization to put their strategies based on expected number of customer. A combination of survey and case studies research approach was used. is a way of knowledge and can establish a correspondence between an object identified and a general system. In a systemic approach CRM helps organization to manage their customers, their prospects and their sales. CRMs can be either web-based or stand-alone systems and can keep track of people, their relationships to the organization , whom they work for, what they're doing, what they're thinking about buying and how often they contact......

Words: 6865 - Pages: 28

Premium Essay

Collaborative Writingbusiness Processes

...entry system and check the inventory for each product ordered. While taking down the information, the representative checks the availability of the product to the warehouse nearest to the customers shipping address. If the product is not available at the closest warehouse, a check is done for the next closest warehouse to find the product. While searching for availability, a credit check is performed before each order by the Accounting department. If the credit is approved, an invoice will be generated by Accounting and the Sales department will get the okay to process the order, pending the delivery date. If denied, the customer will have a credit hold status and will be contacted regarding it. The credit hold will be forwarded to the credit department and the customer service representative will receive a daily report on orders placed on credit hold. The product will not be shipped, until payment is received. When payment is received by Accounting, the order is processed and the delivery date is then communicated, pending warehouse availability. Once this process is done, a delivery date is determined by the representative. If the order is processed via phone only, the representative communicates with the customer when the product will be delivered and shipped. Once the product availability is confirmed the warehouse will check the availability, find the product, get the product off the shelf, and type it into the system to show the product has been shipped and needs to......

Words: 2332 - Pages: 10

Premium Essay

Enterprise Systems

...ENTERPRISE SYSTEMS MIS, 2015 Learning Objectives  How do enterprise systems help businesses achieve operational excellence?  How do supply chain management systems coordinate planning, production, and logistics with suppliers?  How do customer relationship management systems help firms achieve customer intimacy? Traditional View 3 MIS, 2015 Enterprise Systems 4 MIS, 2015 Cross-functional process 5    Many business processes are cross-functional, transcending the boundaries between sales, marketing, manufacturing, and research and development. These cross-functional processes cut across the traditional organizational structure, grouping employees from different functional specialties to complete a piece of work. E.g.:   Order Fulfillment Process Procure to Pay. MIS, 2015 Order Fulfillment Process 6 For example, the order fulfillment process at many companies requires cooperation among •the sales function (receiving the order, entering the order), •the accounting function (credit checking and billing for the order), and •the manufacturing function (assembling and shipping the order). MIS, 2015 Enterprise Application 7  Enterprise Application automate processes that span multiple business functions and organizational levels and may extend outside the organization. MIS, 2015 How Enterprise Systems work 8     based on a suite of integrated software...

Words: 1318 - Pages: 6

Premium Essay

Information System - Enterprise Application

........................................................................................ 2 I. DATA BASES............................................................................................................................................... 2 I.1. Definitions ............................................................................................................................................................... 2 I.2. Major Methods and DBMS...................................................................................................................................... 3 I.3. Information-related issues........................................................................................................................................ 4 II. COLLABORATION TOOLS (GROUPWARE) ..................................................................................... 4 II.1. Introduction & Definition ....................................................................................................................................... 4 II.2. Electronic Document Management (EDM) ............................................................................................................ 5 II.3. Process Management (Workflow) .......................................................................................................................... 6 II.4. Electronic Data Interchange (E.D.I.) ...........................................................................

Words: 9771 - Pages: 40

Premium Essay

Enterprise

...of an Enterprise Data Warehouse Edward M. Leonard Marquette University Recommended Citation Leonard, Edward M., "Design and Implementation of an Enterprise Data Warehouse" (2011). Master's Theses (2009 -). Paper 119. http://epublications.marquette.edu/theses_open/119 DESIGN AND IMPLEMENTATION OF AN ENTERPRISE DATA WAREHOUSE By Edward M. Leonard, B.S. A Thesis submitted to the Faculty of the Graduate School, Marquette University, in Partial Fulfillment of the Requirements for the Degree of Master of Science Milwaukee, Wisconsin December 2011 ABSTRACT DESIGN AND IMPLEMTATION OF AN ENTERPRISE DATA WAREHOUSE Edward M. Leonard, B.S. Marquette University, 2011 The reporting and sharing of information has been synonymous with databases as long as there have been systems to host them. Now more than ever, users expect the sharing of information in an immediate, efficient, and secure manner. However, due to the sheer number of databases within the enterprise, getting the data in an effective fashion requires a coordinated effort between the existing systems. There is a very real need today to have a single location for the storage and sharing of data that users can easily utilize to make improved business decisions, rather than trying to traverse the multiple databases that exist today and can do so by using an enterprise data warehouse. The Thesis involves a description of data warehousing techniques, design, expectations, and challenges regarding data......

Words: 20485 - Pages: 82

Premium Essay

Role of It

...entire distribution set up to achieve higher service levels and lower inventory and lower supply chain costs. The broad strategic directions which need to be supported by the IT strategy are increasing of frequency of receipts/dispatch, holding materials further up the supply chain and crashing the various lead times. Critical IT contributions and implementations are discussed. Fundamental changes have occurred in today's economy. These changes alter the relationship we have with our customers, our suppliers, our business partners and our colleagues. It also describes how IT developments have presented companies with unprecedented opportunities to gain competitive advantage. So IT investment is the pre-requisite thing for each firm in order to sustain in the market. INTRODUCTION: Supply chain management (SCM) is concerned with the flow of products and information between supply chain members' organizations. Recent development in technologies enables the organization to avail information easily in their premises. These technologies are helpful to coordinates the activities to manage the supply chain. The cost of information is decreased due to the increasing rate of technologies. In the integrated supply chain model (Fig.1) bi-directional arrow reflect the accommodation of reverse materials and information feedback flows. Manager needs to understand that information technology is more than just computers. Except computer data recognition equipment, communication......

Words: 1523 - Pages: 7

Premium Essay

Erp System in Xinghe Electronic Commerce Company

...time has been completely changed for companies. For example, traditional business model has been replaced by E-commerce model. With an abundant of consumer’s demand, revolution of tech, short period of product life cycle and sharp competition in marketing, companies should follow this 3C guideline which is consumer, challenge and change. Also, company should match consumer’s customize demand so that the company can accelerate adapt the development of marketing’s changing. Under the new external environment, e-commerce companies need to adjust their development strategies, restructuring their business processes and organizations, also need to use modern information technology, enterprise information management. In this context, electricity providers need to use integrated enterprise management information system to provide real-time, accurate and complete information in order to enhance the effectiveness of decision-making, improve management efficiency and economic benefits. Xinghe E-commerce Company is directly under the China Government-owned Corporation. The original capital for the company was 13,500,000 RMB, and the first investment was 50,000,000 investments. And the company has been built the business as several models such as B2B, B2C and C2C. Construction has a B2B platform for farmers and markets (refers to the farmers and merchants intention agreement, from farmers to supermarkets, markets and store on the street straight for the agricultural......

Words: 6467 - Pages: 26

Free Essay

Business Management

...the importance of data, the management issues that relate to it, and its life cycle. Other objectives include relating data management to multimedia and document management, explaining the concept of data warehousing, data mining, analytical processing, and knowledge discovery management. An Overview Section 12.1 – The Need for Business Intelligence – The section serves as an overview of Business Intelligence and its use in business. It discusses the problems associated with disparate data stores where data are not integrated into a single reporting system. The section discusses the technologies involved in Business Intelligence and the vendors involved. It also talks about predictive analytics, alerts and decision support. Section 12.2 – BI Architecture, Reporting and Performance Management – This section discusses the modes of data extraction and integration into a standardized, usable and trustworthy one. It also discusses the different types of reporting systems available to organizations, data mining, query and analysis. The section provides an insight into Business Performance Management (BPM) as a way for business managers to know if their organizations are achieving their strategic goals Section 12.3 – Data, Text and Web Mining and BI Search – This section discusses data mining technology, tools, and techniques. Information types, data mining applications, text mining, and web mining are explored. There is also a discussion of the failures of data......

Words: 5712 - Pages: 23

Premium Essay

Supply Chain Management

...deciding factor in the success or failure of any given product is in the efficiency with which it can be brought to the market place. If the revenue derived from the sale of a product does not create a required profit margin over the cost of its production then that product is doomed to failure, and the health of the enterprise that manufactures the product will suffer.  supply chain management softwareWith that in mind it is clear that the most important factor in the life cycle of a product is the budget and time frame within which it is manufactured. The discipline of supply chain management and the ranges of software used to control it have been developed in order to make this cycle more efficient and cost effective. The field is led by the Council of Supply Chain Management Professionals (CSCMP)  Aspects of Supply Chain Management  Supply chain management is a complex field encompassing every process involved in manufacturing a product. Supply chain management software assists enterprises in controlling streamlining the process through several logistical areas.  Customer Service Management: Customer relations provide information to the manufacturer on the level of demand for the product, and also provide feedbackto the customer on promised delivery schedules.  Supply chain management software provides reporting modules to track both current demand and answer a range of ‘what if’ questions to assist in the prediction of future demand depending on changes in......

Words: 4202 - Pages: 17

Premium Essay

University of Macao

...Excellence and Customer Intimacy: Enterprise Applications Video Cases Video Case 1a: What Is Workday: Enterprise Software as a Service (Saas) Video Case 1b: Workday: Mobile Solutions for iPad Video Case 2: Evolution Homecare Manages Patients with Microsoft CRM (2011) Video Case 3: Sinosteel Strengthens Business Management with ERP Applications (2008) Instructional Video 1: Zara’s: Wearing Today’s Fashions with Supply Chain Management 6.1 Copyright © 2014 Pearson Education publishing as Prentice Hall Management Information Systems, Global Edition Chapter 9: Achieving Operational Excellence and Customer  Intimacy: Enterprise Applications LEARNING OBJECTIVES • Describe how businesses use enterprise systems to achieve  operational excellence. • Explain how supply chain management systems coordinate  planning, production, and logistics with suppliers. • Describe how customers relationship management systems  help firms achieve customer intimacy. • Explain the challenges posed by enterprise applications. • Describe the new technologies used by enterprise  applications. 9.2 Copyright © 2014 Pearson Education Management Information Systems, Global Edition Chapter 9: Achieving Operational Excellence and Customer  Intimacy: Enterprise Applications Enterprise Systems • Enterprise Systems – Enterprise resource planning (ERP) systems – Suite of integrated software modules and a common central  database –......

Words: 2000 - Pages: 8

Premium Essay

Business Intelligence

...Solution Ltd 4 4. LITERATURE REVIEW 7 4.1 BI Architecture and components 8 4.2 Enterprise Resource Planning (ERP) 9 4.3 Levels Of Strategy Within An Organisation And Linkage To Bi 11 4.3.1 The Corporate Level Strategy 11 4.3.2 Business-Level Strategy 12 4.3.4 Operational Strategy 13 4.3.5 Bi implementation strategies 14 4.3.5 Balance Scorecard (BSC) 15 5. The Macro Environment of Sensible Solution Ltd 17 5.1 Swot Analysis 17 5.2 Pestle Analysis 18 6. CONCLUSION/RECOMMENDATIONS 19 7. REFERENCES 21 LIST OF FIGURES Figure 1:Linking Sensible Solution Ltd strategy and goals with Business Intelligence 5 Figure 2:Linkage in Organisation & Functional Benefits of Business Intelligence 6 Figure 3:What business intelligence means in practice 7 Figure 4:The Road Map of BPM define the steps that the company needs to follow as a guide to ensure that the I.T Strategic has the same goals as business strategy 9 Figure 5:ERP integration of all departments within organisation 10 Figure 6:The Enterprise Data Model is the Foundation for Linking Strategy and Analytic Capabilities - it Links the Data to the Business Strategy 11 Figure 7:Business Strategy and BI capabilities 12 Figure 8:The layout of Corporate Strategy, Business Strategy and Operational strategy Links to BI 13 Figure 9:The BI Pathway Methods 14 Figure 10:Business intelligence development process flow from requirements through implementation. 15 Figure 11: The logic of the balanced......

Words: 4398 - Pages: 18