Client
Multinational pharmaceutical company with a diverse drug portfolio.
OPPORTUNITY
The client wanted to apply big data analytics on their fever drug portfolio subjects to understand the clinical treatment pathways using real-world evidences and electronic health records. The client did not have enough information to enable analysis across multiple systems to generate a systematic analytical output.
SOLUTION
SG Analytics' data scientists provided a comprehensive big data solution, where data from multiple systems in different formats was cleansed, transformed and aggregated to enable batch processing and advanced analytics.
-
Our team mapped, aggregated and standardized data from various sources for fever drug portfolio.
-
The team set up an Extract-Transform-Load (ETL) mechanism for data acquisition and analyzing the data quality.
-
We loaded the data into a staging area in Hadoop technology. After the staging layer, the team ensured that data was converted into HDFS module in parquet format.
-
We applied advanced analytical models and visualization on the data marts for faster prediction and efficient insight generation.
-
The team monitored the model continuously and re-calibrated the same for better results.
VALUE DELIVERED
1
Provided and maintained an enterprise-wide big data warehouse for clinical analytics.
2
Designed analytical models and data visualization tools to establish effective pathways prediction for faster and improved insight generation.
