top of page

Use Cases

Drill down to see what use cases Purgo AI's Agent can handle.

Search by Business Function

Accelerate Drug Discovery

  • Genetic Target Identification

  • QSAR Modeling (Quantitative Structure Activity Relationship)

  • Geneformer Modeling (Gene Expressions & Network Biology)

  • Image Classification (eg. Digital Path.)

  • Chromatography Insights

Streamline Clinical Development

  • Clinical Trial Protocol Design

  • Clinical Trial Site Selection

  • Drug Repurposing

  • Automate QA of Clinical Data

  • Modernize Clinical Data Repository

Build a FAIR Data Platform

  • Knowledge Graphs for R&D

  • Medical Image Processing & Management (Pixels for DICOM)

  • Omics Data Management

  • Research Assistant

  • BioMedical Information Retrieval

View by Business Solution

Automate QA of Clinical Data

Data value validation quality check with indication_config to target
Requirement:
Create a PySpark code to perform Data value check comparison between sql queries in ‘indication_config' table and the target table 'indication_level_metric’. Display the DQ validation results by comparing each value of every column in target and sql query output and it should display the validation column: query_<column_name>, target_<column_name>, <column_name>_validation_result (PASS/FAIL)….
Data value validation quality check with indication_config to target

Requirement:
Create a PySpark code to perform Data value check comparison between sql queries in ‘indication_config' table and the target table 'indication_level_metric’. Display the DQ validation results by comparing each value of every column in target and sql query output and it should display the validation column: query_<column_name>, target_<column_name>, <column_name>_validation_result (PASS/FAIL)….

Automate Reporting (e.g., OTIF)

AD-344: Aggregate REP_SHARE_OF_VOICE Metrics by Reporting Date for Repatha
*Requirements*: Develop SQL Logic, Read the table 'stitched_pmr_consolidation_data' and extracts Share of Voice (SoV) metrics specifically for the product *Repatha*. The logic must filter the dataset to include only records where *metric = 'REP_SHARE_OF_VOICE'*, *frequency = 'QUARTERLY'*, *speciality = 'ALL'*, and *product_name = 'REPATHA'*. Additionally, the results must be restricted to reporting dates on or after *September 1, 2023*. After applying these filters, the SQL logic should group the dataset by *product_name* and *time_stamp*, and compute the *SUM(value)* for each group to derive the total Share of Voice for Repatha per reporting period. The final transformed output should expose three fields — *product_name*, *time_stamp*, and *total_share_of_voice* — and must be published through a finalized view named *stitched_pmr_consolidation_data_vw*.

*Final Output*: Show the results.

Unity Catalog: stitched_pmr_consolidation_data_vw
AD-342: Customer_360 - Fix CPD Value Inflation Issue Across Brands for BLUE BALL Sales Team

*Introduction*: Users observed that *CPD (Calls Per Day)* values are appearing doubled or inflated across multiple brands and quarters in the dashboards. When the backend table s_field_reporting_activity_sales_team_brand_interactions_intmd_union_all was checked, the CPD values were already inflated at the source. It is focuses on validating the source calculations and identifying the correct CPD computation using the formula CPD = rep_calls_total_calls / rep_calls_total_days_in_territory. The team needs a query to reproduce the issue and verify if the inflated values match the dashboard output and source table.

*Requirements*: Develop SQL Logic, Read the file c360_s_field_report_activity_sales_team_brand_interactions_intmd_union_all.  Filter the dataset for the following values, business_unit_code = *BCBU,* sales_team_grouping = *BLUE BALL,* classification_type = *BLUE BALL ALL PORTFOLIO TARGET,* interaction_channel = *ALL,* time_bucket_id = *CQTDW,* classification_value IN (‘EB’, ‘ED’, ‘ALL_TARGETS_PROFS’) Use the CPD formula as  Total_CPD = SUM(rep_calls_total_calls / rep_calls_total_days_in_territory). Round off CPD value to *one decimal*. Group data by all non-aggregated columns. Return the dataset so the inflated CPD values can be compared with dashboard values.

Unity catalog: c360_s_field_report_activity_sales_team_brand_interactions_intmd_union_all

bottom of page