| Dimensional Warehouse Model Data Model |
| Description | To analyze and compare the effectiveness of customer promotions, product promotions, marketing drives and advertising strategy. By keeping track of campaign cost, results and effect on product sales and services revenue, the Health Plan can determine the overall campaign effectiveness. |
| Diagrams | |
BST - Campaign Cost Analysis |
|
BST - Campaign Profitability Analysis |
|
BST - Campaign Sales Analysis |
|
| Entities | |
Campaign Cost Analysis |
|
Campaign Profitability Analysis |
|
Campaign Sales Analysis |
|
| Dimensional Warehouse Model Data Model |