To maximize system benefits, before working with Dashboard Studio, determine the information to be displayed and the view relationships:
Examine the data sources and determine the queries required to return the data
Decide what information is to be presented, and whether sections need to be built or existing sections can be used
Build queries with aggregations that enable the return of the least number of rows
Determine the views to be presented (pivots, charts, tables, and reports)
Decide whether filters are to be shared over multiple data sources (that is, results and table sections)
Identify the table structures on which the views are based and the filters applied