Pharma Sales Analyzer

Pharm Sales Analyzer turns pharma data into actionable insights, boosting sales efficiency and uncovering growth opportunities.

Comment

Inspiration:

Pharma companies deal with complex data — from prescriptions to rep performance — but often lack real-time, actionable insights. We wanted to bridge that gap. Our inspiration was to empower decision-makers with a unified dashboard that not only shows what happened but also why it happened and where opportunities exist. With Salesforce Data Cloud and Tableau Next, we saw an opportunity to create a semantic analytics layer that transforms raw data into strategy.

What it does:

  1. Our solution delivers:
  2. Real-time KPIs (today vs. yesterday’s sales, weekly sales growth).
  3. Market Share & TRx gap analysis by state, city, and product.
  4. Drilldowns into sales rep–level performance to track contribution and highlight underperformance.
  5. A semantic layer for consistent business metrics across Salesforce Data Cloud and Tableau Next.
  6. Actionable dashboards that support rep allocation, territory planning, and growth strategies.

How we built it:

  1. Data Integration: Ingested pharma sales data into Salesforce Data Cloud with incremental refresh pipelines.
  2. Semantic Layer: Defined KPIs and calculations (e.g., TRx Gap, Market Share %) in Tableau Next’s semantic model.
  3. Visualization: Built interactive dashboards in Tableau Next: Market Share Heatmaps Sales Rep Leaderboards Product Growth Trends
  4. Interactivity: Enabled proportional brushing, filter + URL actions, and drilldowns to drive user engagement.
  5. Integration: Connected insights back to Salesforce CRM for actionability.

Challenges we ran into

  1. Learning curve with Tableau Next semantic layer and its integration with Salesforce Data Cloud.
  2. Managing large pharma datasets while ensuring real-time performance with incremental refresh.
  3. Designing dashboards that balance granularity (rep-level data) with clarity for executives.
  4. Implementing proportional brushing and URL actions in a hackathon timeframe.

Accomplishments that we're proud of

  1. Built a working end-to-end pipeline from Salesforce Data Cloud → Tableau Next → CRM insights.
  2. Delivered dashboards that judges and end-users can interact with live during the hackathon.
  3. Created a semantic layer that ensures consistent, reusable KPIs across visualizations.
  4. Showcased real-world value for pharma companies by turning raw data into strategy.

What we learned

  1. How to design for both executives and reps by layering high-level KPIs with drilldown capabilities.
  2. Best practices for semantic modeling in Tableau Next to make dashboards scalable.
  3. The importance of storytelling with data — beyond charts, explaining the “so what” factor.
  4. Hands-on skills in Salesforce Data Cloud integration, Tableau Next actions, and incremental refresh pipelines.

What's next for Pharma Sales Analyzer

  1. Add AI-driven insights with Einstein GPT to automatically highlight anomalies or opportunities.
  2. Expand to predictive analytics (e.g., forecast sales growth using time-series models).
  3. Integrate call center datasets for a 360° customer view (sales + service).
  4. Deploy as a ready-to-use solution package on Salesforce AppExchange for pharma businesses.

Built With

Share this project:

Updates