Evaluate Competitor Brand Penetration by Channel

Introduction: To analyze how competitor vs. non-competitor biosimilar brands perform across different sales channels (online, retail, mobile), focusing on oncology markets like _trastuzumab-anns_, _bevacizumab-awwb_, and _rituximab market_, within a 36-month window from the cdl_effective_date

 

Requirements: Create a Databricks pyspark logic by Read the table “purgo_playground.bai_sales_agg_obu_customer_datapack“. Filters transaction data to include only key oncology biosimilar markets fortrastuzumab-anns, bevacizumab-awwb, rituximab market, Includes the data only from the last 36 months based on cdl_effective_date column and fetch the date from the table “bai_sales_agg_obu_customer_datapack“. Groups the data by channel_name (like online, retail, mobile), competitor_flag (true/false). Sums up 3 key sales metrics for integrated_units, integrated_normalized_units, integrated_dollars.

 

Final Output: Show the results for competitor vs. non-competitor brands are performing in each sales channel, based on total sales units, normalized units, and dollars.

 

Unity Catalog: “purgo_playground.bai_sales_agg_obu_customer_datapack“