scenario 1:
Business Problem:
Customer is a mid-size company that manufactures sporting goods and related accessories and more recently, sports-related clothing. Their customers are large retail companies around the world
Problem statement:
The information available is restricted by the current enterprise resource planning(ERP) systems functionality, and it is a difficult for end users to access operational information Building new reports to answer business questions is a slow and costly process, and the promise of "end-user reporting" has never been realized because there are multiple systems, and in each system information is spread across multiple tables and requires expert knowledge to answer simple business questions
This has led to the following issues :
1) The manufacturer is falling behind competitively because business processes cannot keep up with change. Initiatives such as improvements in on-time deliveries and understanding the real impact of complex customer discounting structures are information intensive and are almost impossible to achieve across the business in a timely and cost-effective way
2) IT is finding it difficult to give people the
information that they need to keep up with a changing business environment, and with deliver solutions. It is also expensive to answer simple one-off, what-if type questions
3) Using the ERP systems for reporting is adversely affecting the transaction systems performance during peak reporting periods.
Solution Overview:
We will build a data warehouse that consolidates the data from the ERP systems and other sources to enable new types of analyses and reduce the cost and complexity of delivering information. With our business value-based approach, we will focus on building the necessary functionality to support the highest-priority business objectives while providing a platform for future enhancements
Business Requirements
The high-level requirements to support the key business objectives are as follows:
1)Sales reporting and performance tracking
The business needs timely and flexible access to sales information such as units shipped and revenue, including the ability to understand sales performance by territory, by product, and by customer. Ultimately, the goal is to track the actual sales achieved against the targets for each sales territory
2)Profitability
A key business driver is that the solution needs to include enough information to enable profitability analysis. This comprises information to enable profitability analysis. This comprises information such as manufacturing and shipping costs and any discounts offered to customers. This will enables the business to understand profitability of product lines as well as types of customers and to optimize the mix of products and customers
High-Level Architecture
The primary component of our solution is a data warehouse database the receives information from the source systems. We will focus in this phase of the project on building a database to support the requirements, and we will build the data integration process and more complex analytics
Business Benefits
The solution will deliver the following benefits to the client
1)IT will be better able to support business objectives by delivering new types of information and analyses quickly and cost effectively
2)The solution will provide better performance for the ERP systems by moving reporting to the data ware house