Analyze Channel-Level Sales Distribution for Biosimilar Oncology Brands

Introduction: This analysis helps in understanding how these biosimilar brands are performing across different channels (online, retail, mobile), showing the total sales performance of biosimilar products.

 

Requirements: Create a pyspark logic by Read the table “purgo_playground.bai_sales_agg_obu_customer_datapack“. Filter the dataset for kanjinti, mvasi, and riabni. Filter by time range by Include sales data within 36 months from cdl_effective_date. Group by key attributes brand_normalized_name, normalized_name, market_normalized_name, competitor_flag, channel_name. Aggregate the sales metrics by Sum of integrated_units, Sum of integrated_normalized_units, Sum of integrated_dollars.

 

Final Output: Show the result of channel-wise.

 

Unity Catalog: “purgo_playground.bai_sales_agg_obu_customer_datapack“