Our team was developing a set of interactive, real-time dashboards for a well known facilities services client. One of the dashboards was taking 40+ minutes to process and retrieve the results using a live Tableau data model connection. This dashboard was intended for our client’s internal users, who have access to essentially all the data available in the system. This level of access also included our client’s customer users, who only access data related to their specific businesses.
This requirement called for the enforcement of multi-tenancy into the dashboard. This entailed that each time a user logged in, the dashboard had to filter out only the data he/she had been authorized to access. Each time a user logged in, a link of accessible locations and elaborate trail of selected drop-down options were making the underlying SQL query run for an exorbitant time. This was significantly affecting the dashboard’s performance, and rendered a very slow response time. We were faced with two primary challenges with respect to these dashboards:
Resolve the Tableau security requirement efficiently Improve the dashboard response time to less than 5 seconds