Empowered a large pharmaceutical company to improve the TCO, scalability and query performance by building a data lake on AWS and migrating Oracle DB applications to PostgreSQL Database
Migration of Dashboard/reporting from SAP BI to Yellowfin platform views and leveraged Yellowfin’s rich library to offer multiple insights.
About the Client
The Business Challenge
The client wanted to provide 30 of its top enterprise clients a capability to visualize the complete recruitment process, end-to-end right from requisition to offer. The client also wanted a simple template that would be user-friendly to the recruitment consultants and hiring managers and still provide total visibility down to a single candidate for a single job application.
What Aptus Data Labs Did
We migrated the client’s dashboard/report from SAP Bi to Yellowfin platform. We also created a new metadata layer with multiple views on Yellowfin and used Yellowfins’s library to offer multiple insights on each step of the process.
The Impact Aptus Data Labs Made
The new migrated analytics platform helped the client to build and roll out the recruitment dashboard to two of its clients quickly. It provided the client with a template that was easy to use and yet gave a visual representation of the entire recruitment process.
The Business and Technology Approach
Aptus Data Labs used the following process to resolve the existing challenge. Aptus Data Labs:
- Created visuals with a common view using multiple charts and graphs from Yellowfin’s library
- Created multiple widgets to provide detailed visibility on requisition status
- Provided one-button click visibility into the hiring process by multiple level filtration on aspects, such as business units, region, requisition type, and hiring personnel
- Customized widgets to alert the client about due dates, target actions, and backorders
- Provided the capability to share the processed visualization across the board with a single click
Tools Used
- Yellowfin
- SAP
- Oracle database
- API Services
The Outcome
The visualization capability helped the client to build and run the recruitment dashboard to two of its clients in 6 weeks. It provided the client with an easy-to-use template that gave a complete visual representation of the recruitment process end-to-end. It helped the client to derive valuable insights and plan actions to meet its timelines and SLAs (Service Level Agreement).
Related Case Studies
Achieving low-latency API-based queries with Mongo DB
Revolutionizing Pharma Analytics with AWS Data Lake
Boosting Performance with Apache Spark Migration
Unlock the Potential of Data Science with Aptus Data Labs
Don't wait to harness the power of data science - contact Aptus Data Labs today and start seeing results.
If you’re looking to take your business to the next level with data science, we invite you to contact us today to schedule a consultation. Our team will work with you to assess your current data landscape and develop a customized solution that will help you gain valuable insights and drive growth.
