Hi, I have to make a dashboard to monitor some business processes. Processes are quite diverse, so the data needed is not standardized. If I just loaded all the data needed to separate tables, it would be > 30 tables, and their count will grow over time. So the question is – how to organize diverse data for a dashboard? Is there any kind of best-practice? Considering Qlik Sense, I thought about using just one "key-value" table on an Oracle server. In this case each dashboard report could be based on a special sql-code, which takes filtered data from the table and transforms it from "key-value" to a usual table on-the-fly (this could be quite fast if the data table on a server is partitioned by a process/report name). But we decided to build our reports in SAS VA, and it seems key-value solution is not appropriate for SAS VA because of in-memory calculation (key-value structure may increases data size) and poorer abilities to manage key-value data (not sure). So, is there any elegant solution to organize the data? I would appreciate any ideas.
... View more