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 ...

Get Mastering QlikView Data Visualization now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.