Example - Adding Customer Service Data to Refine Your Model

Suppose your initial model includes the following dimensional hierarchy, as well as values for Inventory Status and Turnover Ranges.

You have data for an extensive list of measures: Sales, Order Qty, Material Cost per Unit, Discount, Percent Gross Margin, Carrying Cost per Unit, Percent Material Cost per Sale, Percent Carrying Cost per Sale, Sales per Customer, Percent Profit per Segment, and Inventory Turnover.

You decide you want to monitor customer service, so you expand your model to include indicators of service quality. The new dimensions and categories might be encoded Reasons for Dissatisfaction or Causes of Poor Quality Service.

You must ensure that your source data provides the required measures, such as the number of complaints, returns, and claims, or the dollar value of returns and claims.

You can complete your model by incorporating response times, labor costs, time lost to service claims, rework hours, scrap costs, or any other factor that significantly affects service quality.