The preceding tables are all you need to store the usage, but to create effective dashboards of the actually usage, you will need additional data, for example, a date table, a table of time, a table of dashboards, pages, and of users.
W_USAGE_TRACKING table is nearly identical to the capture table, except that we add extra fields. One of these fields is
DATE_WID. This is so that the table can be linked to our standard
W_DATE_D table. We add indexes to the table, on the
date_wid field, and on the fields that will be filtered, such as
SAW_DASHBOARD. An additional task could be to create a day-level summary table that calculates performance measures for the day and will be joined to the
W_DATE_D table, therefore enabling ...