Problem:

• Poor performance of in-house Tableau dashboards using high volume data made reports unusable

Challenges:

• Improper setup of Tableau server resulting in poor site, user management and security risks
• Poor performance due to inefficient joins across multiple tables with millions of rows (>20 minutes to refresh view)

Our Solution:

• Implemented fixes for SQL tables and Tableau resulting in <20s load time for all reports
• Reviewed, proposed and implemented a proper project structure on the server instance along with group based security

Business Benefits:

• Speed up of analysis and increased adoption of insightful dashboards by Therapists, Sales and Finance teams

Technology