The Balanced Scorecard consolidated data model
Similarly to the fact sheet data model, the BSC data model combines facts from various perspectives. In accordance with the strategic measures that we defined in the previous section, the BSC data model combines information from our sales, marketing, and human resources perspectives. To be specific, we store the following events in our data model's fact table:
Sales invoices
Sales credit memos
Sales quotes
Employee training
Employee QlikView usage
The last event is related to the personal behavior analysis that we performed in the human resources perspective in Chapter 7, Human Resources. However, instead of using a data log from RescueTime, we will use QlikView's own session and audit logs to evaluate how employees' use QlikView's applications.
It is also common to add events from the financial, working capital, and operations perspectives. In this example, as we are only measuring revenue in the financial perspective of the BSC, we use the more detailed...
