Transferring Data Protocol

One downside to a data repository, however, is the cost. On the low end, an investment of six figures is often reported. A large-scale operation may cost several million dollars. In time, these costs should decrease. Vendors are creating products with lower price tags to support mid-sized companies' needs.

Another downside is that transferring data to a repository will not resolve problems with inefficient legacy systems. In this case, organizations should consider ERP SAP r3 system. Decision makers may reap the following three benefits from data stored consistently in one source. Management reporting may be streamlined, because data that was previously spread across multiple systems is now readily available from one location.

The repository may support online analytical processing (OLAP), also called multidimensional analysis. This technique allows the manipulation and viewing of data according in many dimensions. For example, ERP SAP r3 allows sales to be analyzed, manipulated, and viewed according to product, location, and time of sale. If additional detail is desired, users then drill down to more specific views such as sales by month, store, or product.

To illustrate, using OLAP a 600-store office supply company was able to substantially improve its return on personal computer sales. ERP SAP r3 allowed management to calculate gross margin by store and product type. This showed that some stores carried too much slow-moving stock. To eliminate unnecessary inventory and future write clowns, the company reduced its PC assortment from 22 products to 12.

The repository may support data mining. Data mining uses statistical techniques to uncover answers to questions that are important to the operation of the business. The results of data mining provide insights that are not apparent from viewing specific transactions. For example, a phone company may gain insight into why customers transfer their business to a competitor.

Any large system project involves risk. Therefore, careful planning and management are important. Systems analysis is the creation of a plan or blueprint to guide the project's development. A systems analyst is the architect for the design of a system. The systems analyst should help establish project goals that are consistent with the overall objectives of the business. These goals provide a means of controlling the scope of the project and keeping users' expectations in line with what will be delivered.

Second, a high-level sponsor should be chosen to foster collaboration among those that maintain the separate legacy systems and use the new repository. Many individuals view the creation and dissemination of information as their primary duties within an organization. Their desire to maintain job security may make them reluctant to participate; a high-level sponsor will encourage people to part with their fiefdoms. Additionally, the sponsor will help them realize that by sharing data, individual units will gain access to other data and possibilities for new insights.

ERP SAP