2148086
page-template,page-template-right_sidebar,page-template-right_sidebar-php,page,page-id-2148086,page-child,parent-pageid-12536,strata-core-1.0.5,ajax_fade,page_not_loaded,wpb-js-composer js-comp-ver-6.2.0,vc_responsive

About Client

The client is a global event management company based in Chicago with a strong presence in the Americas, Europe, and the Middle East.

Challenge

  • Client was facing issues due to less usable (un-optimized) reports generated using Tableau
  • The Tableau reports had to be accessed simultaneously by most of the organization, which accounts to nearly 1500 individuals. This impacted the report generation as it slowed down the entire process significantly.
  • The report generation time-frame had to be brought down to increase usability of reports throughout the organization.
  • Other factors that contributed to the problem were the un-optimized hardware that was running on legacy servers. There were also issues pertaining to Virtual environment/ Shared Infrastructure.

Our Solution

Various Data points were gathered and considered to identify the slow nature of report generation including-

    • Tableau Processes and Execution Times for 25, 50, 75 and 100 concurrent users
    • Server RAM, CPU, I/O utilization during Reports’ execution

Tableau performance monitor and other tools were used as a part of the evaluation

After analyzing the data sets, dashboard-specific and generic tableau environment problems were identified which caused the slowdown.

Various settings of items were iterated and a feasible solution was selected as per client’s need-

  • Dashboard Design: Dashboard Specific
  • Tableau Extract Query: Dashboard Specific
  • DB Table Structure: Dashboard Specific
  • Tableau Server Configuration: Impacts all dashboards
  • Hardware and Infrastructure: Impacts all dashboards

Outcome

Dashboard response times for all required dashboards reduced to

8 seconds

from the previous response time of 1-1.5 minutes

91.11%

optimization achieved.

  • The refresh time for Tableau Extract noticeably reduced in the process.
  • In turn, Dashboard designs were optimized to cater to client needs
  • Tableau utilization increased in general across the organization due to better user experience and engagement.

Related Case Studies

Would You Like Us To Contact You?

  • This field is for validation purposes and should be left unchanged.