Assisted a digital marketing company to optimize KPIs and increase...
Read More
Case Studies
Augmented Analytics for Sales & Operational Planning (S&OP) for a Pharma Company
Helped a large pharmaceutical company to extract insight from data and improve performance using Augmented Analytics
About the Client
The client is a multinational pharmaceutical company that manufactures and sells pharmaceutical formulations and active pharmaceutical ingredients primarily in India and the United States.
The Business Challenge
The client wanted the capability to develop dashboards on-the-fly, generate insights, and make business decisions quickly and efficiently. This capability would eliminate the necessity of a visualization developer to understand the requirements and generate the reports in a tool that
required complex training to use.
What Aptus Data Labs Did
Aptus Data Labs developed a natural language-driven AI/ML-powered web application that allows citizen Data Scientists & SMEs to generate incisive actionable insights using speech input in just a few clicks. As the users present the dashboards, they can also record minutes of the meeting and assign action items within the application.
The Impact Aptus Data Labs Made
With this solution, we enabled the client to get their business ahead of the curve by providing them the ability to generate quick & incisive business insights from the data. The solution
improved the productivity of business users and helped optimize the workflow of IT and Data Science teams.
The Business and Technology Approach
We have developed an Augmented Analytics web application that features:
Use of speech-to-text and Natural Language Processing technologies to:
- Generate SQL query from text input
- Auto-suggest visualizations from the generated SQL query & save them to dashboards
- Filter data in the dashboards using speech input
- Trigger and visualize machine learning models using voice-driven NLP
A data preparation layer that helps users to:
- Select tables & required fields for future visualizations
- Generate calculated fields from columns
- Map fields to compatible data types for ML model generation
- Map table & column names to speech-friendly synonyms
A data preparation layer that helps users to:
- Map table & column names to speech-friendly synonyms
- Assign action items to users
- Link meetings and action items with visualizations in the dashboard
Workflow/Architecture/Screenshot
Tools used
- Backend: Golang
- Frontend: ReactJS (ChartJS & D3.js for visualisations)
- Business Logic: Python
- Database: PostgreSQL
- Orchestration & Scheduling: Airflow
- Deployment: Docker, AWS
The Outcome
The Augmented Analytics solution eased the process of visualization and business insight generation time by cutting down development time by more than 70%, and empowered
business users and SMEs to generate key dashboards with simple voice input.
Related Case Studies
Augmented Analytics for Sales & Operational Planning (S&OP) for a Pharma Company
Helped a large pharmaceutical company to extract insight from data...
Read More
Database Migration from Oracle to PostgreSQL on AWS platform
Empowered a large pharmaceutical company to improve the TCO, scalability...
Read MoreExplore more of our client stories
- Major Indian Bank implements large Big Data Platform
- Indian’s top pharma company builds the distributed data lake with lower TCO
- Retail Analytics - Transaction, Customers, Stores, and Products for a Retail Consulting Company in the UK
- National Stock Exchange to migrate data to Hadoop platform for cold storage to process the data faster
- Major Retailer uses analytics to improve the cashbook to maintain GMV
- Helped a large pharmaceutical company to extract insight from data and improve performance using Augmented Analytics
- Enabled a leading IT company to predict operations accurately and predicting the service cost
- To minimize the logistics costs by optimizing vehicle route and schedule, while considering various business constraints and handling dynamic operational changes
- Enabled a document management firm to mine data accurately and improve operations efficiency through automation
- Identify suspicious claims of 12% of the claim data submitted for the last 24-months based on the behavioral pattern of expenses claim and supporting materials. This has saved the cost of INR 120 Cr for the business
- Optimize cashback by category, subcategory & brand or price brand to maximize the revenue by using multi-objective predictive model and multiple criteria optimization using well-known techniques like TOPSIS and Analytical Hierarchy Process for an e-commerce company in India using RapidMiner and customized operators
- Retail Analytics – Transactions, Customers, Stores, and Products for a retail consulting company in the UK Enabled a leading retail consulting company to analyze historical data […]
- Enabled a leading mortgage financing company to predict credit risk accurately and automate their process
