myApp Dashboard
Life SciencesBusiness Impacts
70% Reduction in Processing Time
Reduced Manual Error
Data Integrity & Availability
Data Visualization for Insights
Customer Key Facts
- Location : North America
- Industry : Pharmaceutical
Problem Context
The customer is a Fortune 500 Pharmaceutical company. Their Infrastructure Lifecycle Team had undertaken an application migration initiative in which Applications, associated Servers and Databases are upgraded to the latest version or migrated from one location to another.
Challenges
- Large variety of data formats in the excel sheet
- Large scale data imbalance
Technologies
Amazon RDS
Microsoft SQL Server
Tableau
Solution:
The team was tracking this activity by maintaining separate Excel files for the aforementioned programs on a SharePoint location. Due to the vast amount of data stored in the form of Excel files, it was difficult to comprehend the progress or generate any status reports for the migration activities. Generating insights from this data using Excel was becoming increasingly difficult for the team.
Quantiphi built state-of-the-art BI dashboards on Tableau to visualize various metrics and help the team effectively answer queries. Custom views in RDS MySql were also built by consolidating data formats across programs and data sources.
Finally, we automated the process of reading source Excel files and loading them into RDS table to be consumed by Tableau.
Results
- Enhanced visualizations otherwise not available in native reporting Application
- Increase time savings due to reduction in manual efforts
- Operationalized the reporting across the organization
