Sales Performance & Market Insights Dashboard
Roche
Jun 2024 - Jul 2024 (2 months)
Sales Analytics, KPI Tracking, Healthcare Analytics, Competitive Benchmarking, Data Modeling, CRM Built an automated sales analytics platform in Tableau using SQL, AWS Athena, and Dataiku, consolidating IQVIA claims data, internal CRM, and 340B program datasets to track brand performance, market share, and channel mix (Hospital/Clinic/Retail) across 50+ geographies. Reduced manual reporting by 30% via dynamic dashboards tracking KPIs (sales trends, target vs. actual, regional growth, competitor benchmarking), enabling data-driven territory planning that contributed to 5% revenue uplift in underperforming regions.