Helped a large pharmaceutical company to extract insight from data and improve performance using Augmented Analytics
Augmented Analytics for Sales & Operational Planning (S&OP) for a Pharma Company
About the Client
The Business Challenge
The client wanted the capability to develop dashboards on-the-fly, generate insights, and make business decisions quickly and efficiently. Moreover, 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
Therefore, 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. Furthermore, 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
Architecture
Tools Used
Backend
Golang
Frontend
ReactJS (ChartJS & D3.js for visualizations)
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
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.
