I have design 21 dash boards which shares the same columns (22 Columns) . Each dash board contains 5-10 Analyses( each analysis using 2-4 columns) , which are derived from the same columns.
Currently they have created single analysis and derived multiple views, each view we have used only 2-4 columns and excluding the remaining columns .
We are using Line charts, Bar charts, View selector and table views.
Is it a better in performance to use only single analysis and multiple views? or using the individual analysis?
Our DB has less amount of data, its medium in size for full loading it will take 2 hours.
One analysis with multiple views is a better approach as only one query hits the database.
Please mark if correct/helpful.