Loading Dashboard with Partial Data Merged

Problem Statement

Most challenging situation we face while maintaining heavy dashboards is opening analysis via client. For the dashboards built around huge amount of data load all the data before we actually start development /enhancement/ maintenance. Even for simple stuffs, like changing column names, formatting, updating an expression etc., which activities take less than a minute; we have to wait for hours to load all data- which doesn't make much sense and bring down the productivity.

We understand, we got an options like -

• Developing dashboards around on-demand data tables

• Limiting ILs before opening analysis etc.

However, they are tedious and impractical in most of the scenarios (High number of sources, specific customer requirements)

Solution Proposed

There should be an option while opening dashboard to select between -

• No Data (Just analysis and structure)

• Low data (First few records only from each sources only)

  • Suggestion : by forcefully adding where clause to ILs, e.g. LIMIT 100

• All data

This will allows to load dashboards faster from client when needed and saves a lot of time.

Optionally, Similar to the options we got Data >> Reload Linked Data OR Data >> Reload All Data ; we can have another option to load All data to load remaining of the data as needed.

Key Benefits

1. Reducing load time of analyses gives more time to work on actual development.

2. Limiting Data in analysis also boosts runtime performance as Spotfire needs to process less amount of data while applying changes to calculations / columns etc.

3. It brings down the duration of Impact i.e. if a dashboard is having an issue observed, we can reduce the time to fix it; improving overall time to resolve.