Challenge
The client's internal data analytics application, initially developed by a single data scientist, became essential for visualizing clinical study data but was severely hindered by poor performance. Load times exceeded 7 minutes, causing significant delays and impeding effective decision-making.
The client needed to rapidly transform this application into a robust, production-quality tool without interrupting ongoing usage, ensuring that scientists and data teams could quickly access essential insights for critical business decisions.
Solution
Appsilon delivered strategic improvements through multiple iterations:
- First Iteration: Enhancing Stability and Transitioning to Posit Connect
- Improved infrastructure by migrating from a Linux VM with local data files to Posit Connect.
- Integrated directly with the client's data lake (Profiler), eliminating inefficient file-based processes.
- Implemented selective data loading and caching strategies, reducing initial load times from 7 minutes to around 2-3 minutes.
- Second Iteration: Optimizing Data Loading and Performance
- Leveraged Profiler's direct data-fetching capabilities, loading data on-demand rather than upfront.
- Improved user experience with real-time progress indicators.
- Further reduced load times dramatically to between 30-60 seconds.
Impact on Daily Operations
The optimization and implementation of robust R Shiny applications and Posit products significantly improved the client's day-to-day operations:
- Faster Decisions: Reduced app load time from 7 minutes to as little as 30 seconds, facilitating quicker and more informed business decisions.
- Enhanced Productivity: Scientists gained rapid access to critical data, freeing them to focus on core drug discovery processes.
- Strategic Focus:Enabled data scientists and business management teams to spend less time on app management and more time leveraging insights for strategic growth.
Strategic Partnership and Collaboration
Since 2020, the relationship has grown into a dedicated team extension comprising six experts from Appsilon. Collaborative efforts span two primary teams: drug discovery and translational gene research. Appsilon has developed seven essential Shiny applications, with four concurrently in active development.
Project Results
The final outcomes delivered substantial improvements:
- Performance Boost: Reduced critical application load time from 7 minutes down to just 30 seconds.
- Expanded Usage: Increased adoption and usage of R Shiny across multiple departments.
- Operational Efficiency: Improved decision-making speed and accuracy through streamlined data analytics.
Client Success Factors
- Successful deployment and optimization of seven customized R Shiny applications.
- Enhanced collaboration enabled by Posit Workbench and Posit Connect installations.
- Business-critical status established for R Shiny applications within the client's operations.
- Continuous support and training fostering sustained adoption and maximizing ROI from Posit technologies.
