Pain
The international developer has grown through acquisition. Because of this growth, the company has multiple ERP systems in-house. In North America, the company has a home grown system that is very inflexible in generating sales and inventory reports. In Europe, the company runs SAP which only offers proprietary reports as well. These constraints made it very difficult and time consuming for executives to get an overall view of corporate performance. It also made it difficult for product managers to see how their products were selling in different markets.

Vision
The Corporate CIO and MPS Partners had a vision of creating a single intranet site for tracking revenue based on the MPS Partners Revenue Management Dashboard Solution. The Corporate CIO  and MPS Partners believe that when SharePoint is combined with corporate business data, it becomes a powerful Business Intelligence (BI) tool that exposes corporate information not only to executives and analysts but to front-line workers that make key business decisions on a daily basis. Often, the data that these front line professionals rely on is information about revenue and projected revenue. The MPS Partners Revenue Management Dashboard is a pre-built set of scorecards, reports and data marts that delivers the most critical information through SharePoint.

Value
By using a set of scorecards and reports, the company was able to create consolidated reports and scorecards that highlighted performance across the company’s divisions and regions. This allowed managers and executive to track business performance vs. budget and forecast on a daily basis rather than after a month end close. Additionally, analysts were able to use the underlying
data warehouse to mine the company’s data that had previously been locked up in the ERP systems.

Solution
The international developer used many of the pre-built components within the MPS Partners Revenue Management Dashboard Solution. This allowed the company to deploy these global scorecards in less than 90 days. The following components were used:
 - Sales Data – Pre-built sales analysis comparing booked sales and open orders to forecast
 - Customer Analysis – Views of "My Top customers" as well as customers that have not purchased at previous levels
 - Sales Scorecard – Executive level view of current period, quarter and year to date performance with visual indicators
 -  Integration with Excel – Open in Excel functionality allows users to analyze further but against corporate data, NOT spreadsheets they build