...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
...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 Understand...
Words: 2370 - Pages: 10
...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 delivery location...
Words: 1822 - Pages: 8
...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
...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 you(as an...
Words: 6865 - Pages: 28
...representative who manually takes down mandatory information required for the order on an order pad, such as: customer name, customer identification number shipping/billing address, product number, product description, quantity, and shipping instructions. All customer information that is taken down is required to process the order. The representative accesses the firm’s order entry system and checks the inventory and location for each product that is ordered. The representative will access the company’s 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,...
Words: 2332 - Pages: 10
...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
...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 cleansing...
Words: 20485 - Pages: 82
...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 technologies...
Words: 1523 - Pages: 7
...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...
Words: 6467 - Pages: 26
...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 strategy...
Words: 4202 - Pages: 17
........................................................................................ 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
...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 scorecard...
Words: 4398 - Pages: 18
...Middleware and Enterprise Integration Technologies Software Engineering Data Base Technologies Programming for Mobile and Remote Computers Information Technology for Management of Enterprise TOTAL Week 4 Scheme of Examinations Theory T/W Practical Oral Total Hours Marks Marks Marks Marks Marks 3 100 25 -25 150 Pract/ Week 2 Tut/ Week -- 2 4 2 -- 3 100 25 -- 25 150 3 4 5 4 4 4 2 2 2 ---- 3 3 3 100 100 100 25 25 25 --25 25 25 -- 150 150 150 6 4 24 10 1 1 3 -- 100 600 25 150 -25 25 125 150 900 INFORMATION AND NETWORK SECURITY CLASS T.E. ( INFORMATION TECHNOLOGY) HOURS PER LECTURES : WEEK TUTORIALS : PRACTICALS EVALUATION SYSTEM: THEORY PRACTICAL ORAL TERM WORK : SEMESTER VI 04 -02 HOURS 3 ---- MARKS 100 25 25 1. Introduction What is Information Security? Security Goals. 2. Cryptography Crypto Basic, Classic Cryptography, Symmetric Key Cryptography: Stream Ciphers, A5/1, RC4, Block Ciphers, Feistel Cipher, DES, Triple DES, AES, Public Key Cryptography: Kanpsack, RSA, Defiie-Hellman, use of public key crypto- Signature and Non-repudiation, Confidentiality and Non-repudiation, Public Key Infrastructure, Hash Function: The Birthday Problem, MD5, SHA-1, Tiger Hash, Use of Hash Function. 3. Access control - Authentication and Authorization Authentication Methods, Passwords, Biometric, Single – sign on, Authentication Protocol, Kerberos, Access control Matrix, ACLs, Multiple level security...
Words: 3868 - Pages: 16
...guide) M.V.Kameshwara Rao Professor,GSIB,GITAM university (Faculty guide) Submitted By Anand Vuppalapati (1226112104) Acknowledgements I ‘am pleased to have associated with TVS Logistics Services Ltd. In the Internship project on Warehousing & functioning of ERP, a project of significance to both, TVS Logistics Services Ltd. and me. I take this opportunity to thank Mr. Pavan Nair, Regional head, TVS Logistics Services Ltd, Pune for giving me the opportunity to work on this project and also for his guidance as project guide. We are deeply grateful to Professor M. Kameshwara Rao, GITAM School of International Business for providing insightful and rich mentoring support for this project. The results of this study reflect the thoughtful input of all participants including the views of the eminent professionals in the company, solicited during the course of the interviews we had with them. Thank you to all who gave time to make this study useful. It was a most rewarding experience to work on such a challenging project. We believe that the results of this study would be helpful to TVS Logistics Services Ltd. in making thoughtful changes in the Third party logistics sector. Sincerely, Anand Vuppalapti Class of 2012-2014 Contents Page No. Preface i Acknowledgements ii CHAPTER-I: EXECUTIVE SUMMARY 4 CHAPTER-II: INTRODUCTION Overview of ERP 5 ERP Benefits and Limitations 5 CHAPTER-III: SECTOR REVIEW ...
Words: 10775 - Pages: 44
