The FDC + Snowflake – Empowering decision makers in the Pharma value chain

Reading Time: 4 minutes

Brand analytics is crucial for any Pharma manufacturer’s success. During the drug research and development phase, Pharma manufacturers spend millions of dollars, and consume 10-15 years to bring much needed drugs to the market, with only 7-12 years of patented time available. This makes it critical to have an effective go-to-market strategy, and a continuous monitoring of the brand to maximize revenue.

Brand analytics in action

  • Unable to create a single source of truth.
  • Delayed data-to-insight journey.
  • High churn time on ad-hoc analyses.

Lumin and Snowflake, present a comprehensive solution to all these challenges. With Lumin’s Pharma brand book, powered by Snowflake, decision makers in the Pharma value chain can obtain critical insights at speed and scale. With Lumin’s advanced analytical capabilities and Snowflake’s computing prowess, users can proactively address brand trend breaks, accurately pinpoint root causes, and simulate potential spending corrections, ultimately maximizing business impact. The following use case illustrates how a Pharma major can optimize their brand potential.

The datasets and KPIs

The data’s schema consists of the following parameters:

Key dimensions

  • HCP (Health Care Professionals) demographics
  • Payer channel
  • Payer information via which the prescription is dispensed through
  • Call planning & targeting

Key measures

  • Monthly prescriptions at the HCP level, over 24 months
    • TRx = Total Prescriptions
    • NRx = New Prescriptions
    • NBRx = New-to-Brand Prescriptions
    • NTS = New-Therapy-Starts
  • Sales Activity:
    • Personal call detailing
    • Remote calls
    • Veeva approved emails

The data used for this use case is an amalgamation of multiple in-house data sources (Sales Force Zip-to-Territory, sales activity, and sales targeting), and multiple third-party sales datasets from IQVIA’s Xponent PlanTRAK and Prescribing Dynamics products. These third party datasets are obtained directly from Snowflake’s marketplace, and the final aggregated data with in-house data sources is hosted on Snowflake’s warehouse, connected via Lumin’s in-built Snowflake connector. (See image 1 below)

Image 1 : Connecting to aggregated IQVIA data with internal datasets hosted on Snowflake’s Data Warehouse

In this blog, we walk you through the data-to-decisions journey of a marketing manager of the brand ‘Zeldatab’, running a descriptive analysis exercise to analyze the brand and its competitors.

Descriptive Analysis with Lumin

Starting simply, a brand manager would want to know what their brand’s share is against its competitors. With Lumin, we can type in the question in simplelanguage as shown below, and a comprehensive analytical answer is presented as seen in image 2.

What is the share of sales by brands?

Image 2: Brand share in July 2023

To break things down – Lumin understood our question in plain English text and converted it into an analytical query, where in this case it has also included a relevant time filter for the latest month.

Now that we know that the brand share is 33.94%, it would be interesting to see how the business has been growing over time.

What is the monthly growth rate of Zeldatab?

Image 3: Month-on-Month growth of Zeldatab. Also highlights few features of Lumin viz. data export, chart switcher, and connected insights.

As you can see in image 3, Lumin dynamically selected the best-fit visualization to analytical result, while also generating a contextualized narrative to explain the same. As a brand manager, I would now be concerned about the recent drop in sales I notice in May 2023, and would like to deep-dive into this.

Before we explore that,it is important to note that Lumin also allows us to:

  • Export the underlying data to share with colleagues.
  • Switch chart visualization to see growth trends.
  • Access easy exploration of next analyses through connected insights.

On clicking the connected insights button (3), Lumin provides us a set of simple and advanced analytical questions closely related to the metric or KPI that we are exploring. As you can see in image 4 below, Lumin has proactively nudged us to ask the next question indicating the predicted future sales of Zeldatab.

Image 4: Connected insights feature of umin

As the next logical step, it would be prudent for the brand manager to identify which payer channel is contributing to this decline of growth seen in May 2023.

What is the growth contribution by payer channel for Zeldatab in May 2023?

As a brand manager one of the major levers of change to consider, would be the payer channels. The formulary status plays a crucial role in how a drug is dispensed at the pharmacy and what drives an HCP (Health Care Professional) to prescribe the drug. As seen below in image 5, Lumin has identified that there is one major payer channel contributing to the drop – the commercial channel.

Image 5: Waterfall chart showcasing growth contribution of payer channels for Zeldatab in the month of May 2023.

Lumin also provides us with some powerful collaboration features that allow us to (refer image 5):

  • Share insights with your colleagues.
  • Add comments (understanding, observations, POV, etc.) on the insights while you collaborate with your colleagues.
  • Create personalized alerts and signals to better track the metrics or KPIs.
  • Get notified when there is a breach in a defined threshold.
  • Capture the insights as you go about your exploratory journey, in a storyboard format called workspace. (Note: The workspace can further be shared with your colleagues just like how PowerPoint presentations illustrate a story)

Deep dive and diagnose brand trends with Diagnostic Analytics

Now, since we have zeroed-in on the major cause of the growth drop– the commercial payer channel, the next question a brand manager would logically present is why the sales rate through the commercial channel is declining?

Why has commercial sales for Zeldatab changed in May 2023?

Image 6: Deep-dive analysis on decrease in commercial sales for Zeldatab

As seen in image 6, Lumin performs an analysis across hierarchies such as Geography Hierarchy (region, district, territory), Physician Hierarchy (physician specialty group, physician specialty), and Payer Hierarchy (payer channel, payer) all in a matter of seconds. Lumin presents before us a detailed narrative along with an interactive bubble chart that presents the deep-dive analysis within each hierarchy.

From the chart, we can see that there are 3 key contributors to the decline of sales: Primary Care Physicians, Humana (Payer), and the Southeast Region. Now, although the analysis is precise and insightful, a business user is fair to question the reliability of this information presented. Lumin has just the answer for it – XAI(Lumin’s Explainable AI feature). Just like how an analyst would provide context on their analyses, Lumin has the capability to meticulously explain (in detail) the various steps involved in arriving at this insight.

Lumin provides a comprehensive step by step explanation all the way from the input data to the model reliability of the analyses as seen in Image 7.

Image 7: XAI (Explainable AI)

The logical next question for any brand manager would be, “how do I influence change to improve the declining sales?” Lumin’s versatile ability to run simulations to alter various promotional activity deployed provides the perfect answer.

Lumin through the run simulation option can perform this cumbersome task in a matter of seconds. First the brand manager can choose and focus on the key contributor (primary care physicians), by applying necessary filters as shown in image 8.

Image 8: Applying relevant focus filters to simulate.

Now let’s adjust promotional drivers such as Calls per HCP by 20%, Email per HCP by 10%, and Remote calls per HCP also by 20%, as shown in Image 9, to see how best it impacts the sales of Zeldatab.

Image 9: Adjusting promotional drivers

Image 10: Simulation

As you can see in image 10, Lumin provides quick results of the simulation and explicitly specifies the best-in-class simulation results along with the optimal change in promotional drivers.

It is worth noting that Lumin uses Snowpark to run these intense analytical workloads, such as diagnostics, simulations, and forecasts, there by providing business users with the ability to dynamically query and process their data within the Snowflake environment. Snowpark further accelerates the querying process and keeps the data secure as it moves between storage and processing.

Expect the unexpected with Lumin’s smart nudges feature

Now that we know how to analyze the known easily through cursory analysis, what about the hidden changes and unexpected trend breaks?How does Lumin assist in expecting the unexpected?

Here’s how: Lumin has powerful foresight capabilities- with its autonomous nudges feature, it identifies anomalies in the data of critical KPIs and hierarchies, and “nudges” the user to pay necessary attention to critical change. Lumin’s anomaly engine synthesizes millions of data points in seconds to give business users the insights necessary to be a step ahead of potential change. By analyzing the trend breaks in detail, Lumin answers the critical questions of when, why, and to what degree of any foreseen change.

For this example, we have set up autonomous nudges for TRx by payer hierarchy to identify any potential changes, and as you can see in image 11, the autonomous nudges feature has proactively worked out the trend break, and presents nudges as well for the brand manager to act on.

Image 11: Autonomous nudge detected the unexpected decrease in commercial sales in May 2023

Get a sneak peek into the future:Identify the sales trend of your brand using predictive analytics

We have seen so far that the brand manager has the capability to analyse and foresee future changes and trends through the automated nudges feature. The next logical question could be, “can I truly look into the future and see where my brand is headed?”

Lumin with its predictive analytics feature, can easily help answer that line of thought. We can ask Lumin to predict the sales trend with the question below.

What are the expected commercial Zeldatab sales in the next 3 months?

Image 12: Forecast of commercial payer sales of Zeldatab

Image 13: XAI (Explainable AI) for forecast

Lumin, through its natural language processing capabilities, understands we are trying to predict sales for Zeldatab and invokes the forecasting module to run multiple multi-variate forecasting models in its analytical engine, and presents the most accurate model as an output. For our question, Lumin selected the multi-variate time series ARIMAX model for predicting TRx sales. (See Image 12)

As mentioned earlier, to usher in trust and transparency, Lumin provides a detailed explanation of the analyses from input data, its sanity, the prediction models applied (including accuracy), and how we interpret them, along with the reliability of the models. (See Image 13)

Summary

With the power of Snowflake +Lumin, comprehensive brand analytics can be performed in a matter of minutes, which typically takes weeks. Lumin can serve as the single source of truth that all key decision makers in the commercial value chain can utilize. The simple ability to ask questions and obtain immediate answers accelerates any brand manager’s data-to-decision journey, and is a must have for every growth seeking Pharma company.

Curious to know more?Book a demo and take a sneak peek at Lumin by Fosfor.

Author

Vishnu Vardhanan Mohanraj

Solutions Architect, Fosfor

With more than a decade of experience in commercial pharmaceutical analytics, Vishnu is known for assisting pharma giants in getting more out of their data. He is the Solutions Architect of Fosfor's Decision Intelligence platform. Vishnu is a data enthusiast and product evangelist, empowering customers with actionable data stories. When not at work, Vishnu explores new travel destinations, reads fiction, watches anime, plays MOBA games, and visits exciting new food spots.

More on the topic

Read more thought leadership from our team of experts

Harnessing the power of Lumin and Streamlit in Snowflake: From data exploration and visualization to Decision Intelligence

As a data enthusiast myself, I understand the importance of data exploration, visualization, and decision intelligence in today's data driven world. That is why I am thrilled to share with you how Lumin and Streamlit can revolutionize your data analysis experience in Snowflake, the leading cloud-based data warehouse platform. So, fasten your seatbelts as we embark on a journey to harness the true power of Lumin and Streamlit to unlock the potential of your data.

Read more

Augmented decision intelligence + limitless cloud scale = pharma’s success playbook

Cloud technologies have now become a must in the pharmaceutical industry. Leading life-sciences companies are discovering the potency of cloud data in enabling analytics, shrinking innovation cycles, and standardizing processes across global operations, among other benefits. For example, Moderna delivered its first clinical batch of its COVID-19 vaccine candidate to the US National Institutes of Health for Phase I trial only 42 days after the initial sequencing of the virus by using cloud technology.

Read more

How Spectra and Snowflake can illuminate your data journey

Considering that more people are becoming tech-savvy, enterprises need to focus on data and derive actionable insights as quickly as possible.

Read more
We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. View more
Cookies settings
Accept
Privacy & Cookie policy
Privacy & Cookies policy
Cookie name Active

What is a cookie?

A cookie is a small piece of data that a website asks your browser to store on your computer or mobile device. The cookie allows the website to “remember” your actions or preferences over time. On future visits, this data is then returned to that website to help identify you and your site preferences. Our websites and mobile sites use cookies to give you the best online experience. Most Internet browsers support cookies; however, users can set their browsers to decline certain types of cookies or specific cookies. Further, users can delete cookies at any time.

Why do we use cookies?

We use cookies to learn how you interact with our content and to improve your experience when visiting our website(s). For example, some cookies remember your language or preferences so that you do not have to repeatedly make these choices when you visit one of our websites.

What kind of cookies do we use?

We use the following categories of cookie:

Category 1: Strictly Necessary Cookies

Strictly necessary cookies are those that are essential for our sites to work in the way you have requested. Although many of our sites are open, that is, they do not require registration; we may use strictly necessary cookies to control access to some of our community sites, whitepapers or online events such as webinars; as well as to maintain your session during a single visit. These cookies will need to reset on your browser each time you register or log in to a gated area. If you block these cookies entirely, you may not be able to access gated areas. We may also offer you the choice of a persistent cookie to recognize you as you return to one of our gated sites. If you choose not to use this “remember me” function, you will simply need to log in each time you return.
Cookie Name Domain / Associated Domain / Third-Party Service Description Retention period
__cfduid Cloudflare Cookie associated with sites using CloudFlare, used to speed up page load times 1 Year
lidc linkedin.com his is a Microsoft MSN 1st party cookie that ensures the proper functioning of this website. 1 Day
PHPSESSID ltimindtree.com Cookies named PHPSESSID only contain a reference to a session stored on the web server When the browsing session ends
catAccCookies ltimindtree.com Cookie set by the UK cookie consent plugin to record that you accept the fact that the site uses cookies. 29 Days
AWSELB Used to distribute traffic to the website on several servers in order to optimise response times. 2437 Days
JSESSIONID linkedin.com Preserves users states across page requests. 334,416 Days
checkForPermission bidr.io Determines whether the visitor has accepted the cookie consent box. 1 Day
VISITOR_INFO1_LIVE Tries to estimate users bandwidth on the pages with integrated YouTube videos. 179 Days
.avia-table-1 td:nth-of-type(1):before { content: 'Cookie Name'; } .avia-table-1 td:nth-of-type(2):before { content: 'Domain / Associated Domain / Third-Party Service'; } .avia-table-1 td:nth-of-type(3):before { content: 'Description'; } .avia-table-1 td:nth-of-type(4):before { content: 'Retention period'; }

Category 2: Performance Cookies

Performance cookies, often called analytics cookies, collect data from visitors to our sites on a unique, but anonymous basis. The results are reported to us as aggregate numbers and trends. LTI allows third-parties to set performance cookies. We rely on reports to understand our audiences, and improve how our websites work. We use Google Analytics, a web analytics service provided by Google, Inc. (“Google”), which in turn uses performance cookies. Information generated by the cookies about your use of our website will be transmitted to and stored by Google on servers Worldwide. The IP-address, which your browser conveys within the scope of Google Analytics, will not be associated with any other data held by Google. You may refuse the use of cookies by selecting the appropriate settings on your browser. However, you have to note that if you do this, you may not be able to use the full functionality of our website. You can also opt-out from being tracked by Google Analytics from any future instances, by downloading and installing Google Analytics Opt-out Browser Add-on for your current web browser: https://tools.google.com/dlpage/gaoptout & cookiechoices.org and privacy.google.com/businesses
Cookie Name Domain / Associated Domain / Third-Party Service Description Retention period
_ga ltimindtree.com Used to identify unique users. Registers a unique ID that is used to generate statistical data on how the visitor uses the web site. 2 years
_gid ltimindtree.com This cookie name is asssociated with Google Universal Analytics. This appears to be a new cookie and as of Spring 2017 no information is available from Google. It appears to store and update a unique value for each page visited. 1 day
_gat ltimindtree.com Used by Google Analytics to throttle request rate 1 Day
.avia-table-2 td:nth-of-type(1):before { content: 'Cookie Name'; } .avia-table-2 td:nth-of-type(2):before { content: 'Domain / Associated Domain / Third-Party Service'; } .avia-table-2 td:nth-of-type(3):before { content: 'Description'; } .avia-table-2 td:nth-of-type(4):before { content: 'Retention period'; }

Category 3: Functionality Cookies

We may use site performance cookies to remember your preferences for operational settings on our websites, so as to save you the trouble to reset the preferences every time you visit. For example, the cookie may recognize optimum video streaming speeds, or volume settings, or the order in which you look at comments to a posting on one of our forums. These cookies do not identify you as an individual and we don’t associate the resulting information with a cookie that does.
Cookie Name Domain / Associated Domain / Third-Party Service Description Retention period
lang ads.linkedin.com Set by LinkedIn when a webpage contains an embedded “Follow us” panel. Preference cookies enable a website to remember information that changes the way the website behaves or looks, like your preferred language or the region that you are in. When the browsing session ends
lang linkedin.com In most cases it will likely be used to store language preferences, potentially to serve up content in the stored language. When the browsing session ends
YSC Registers a unique ID to keep statistics of what videos from Youtube the user has seen. 2,488,902 Days
.avia-table-3 td:nth-of-type(1):before { content: 'Cookie Name'; } .avia-table-3 td:nth-of-type(2):before { content: 'Domain / Associated Domain / Third-Party Service'; } .avia-table-3 td:nth-of-type(3):before { content: 'Description'; } .avia-table-3 td:nth-of-type(4):before { content: 'Retention period'; }

Category 4: Social Media Cookies

If you use social media or other third-party credentials to log in to our sites, then that other organization may set a cookie that allows that company to recognize you. The social media organization may use that cookie for its own purposes. The Social Media Organization may also show you ads and content from us when you visit its websites.

Ref links:

LinkedInhttps://www.linkedin.com/legal/privacy-policy Twitterhttps://gdpr.twitter.com/en.html & https://twitter.com/en/privacy & https://help.twitter.com/en/rules-and-policies/twitter-cookies Facebookhttps://www.facebook.com/business/gdpr Also, if you use a social media-sharing button or widget on one of our sites, the social network that created the button will record your action for its own purposes. Please read through each social media organization’s privacy and data protection policy to understand its use of its cookies and the tracking from our sites, and also how to control such cookies and buttons.

Category 5: Targeting/Advertising Cookies

We use tracking and targeting cookies, or ask other companies to do so on our behalf, to send you emails and show you online advertising, which meet your business and professional interests. If you have registered on our websites, we may send you emails, tailored to reflect the interests you have shown during your visits. We ask third-party advertising platforms and technology companies to show you our ads after you leave our sites (retargeting technology). This technology allows us to make our website services more interesting for you. Retargeting cookies are used to record anonymized movement patterns on a website. These patterns are used to tailor banner advertisements to your interests. The data used for retargeting is completely anonymous, and is only used for statistical analysis. No personal data is stored, and the use of the retargeting technology is subject to the applicable statutory data protection regulations. We also work with companies to reach people who have not visited our sites. These companies do not identify you as an individual, instead rely on a variety of other data to show you advertisements, for example, behavior across websites, information about individual devices, and, in some cases, IP addresses. Please refer below table to understand how these third-party websites collect and use information on our behalf and read more about their opt out options.
Cookie Name Domain / Associated Domain / Third-Party Service Description Retention period
BizoID ads.linkedin.com These cookies are used to deliver adverts more relevant to you and your interests 183 days
iuuid demandbase.com Used to measure the performance and optimization of Demandbase data and reporting 2 years
IDE doubleclick.net This cookie carries out information about how the end user uses the website and any advertising that the end user may have seen before visiting the said website. 2,903,481 Days
UserMatchHistory linkedin.com This cookie is used to track visitors so that more relevant ads can be presented based on the visitor’s preferences. 60,345 Days
bcookie linkedin.com This is a Microsoft MSN 1st party cookie for sharing the content of the website via social media. 2 years
__asc ltimindtree.com This cookie is used to collect information on consumer behavior, which is sent to Alexa Analytics. 1 Day
__auc ltimindtree.com This cookie is used to collect information on consumer behavior, which is sent to Alexa Analytics. 1 Year
_gcl_au ltimindtree.com Used by Google AdSense for experimenting with advertisement efficiency across websites using their services. 3 Months
bscookie linkedin.com Used by the social networking service, LinkedIn, for tracking the use of embedded services. 2 years
tempToken app.mirabelsmarketingmanager.com When the browsing session ends
ELOQUA eloqua.com Registers a unique ID that identifies the user’s device upon return visits. Used for auto -populating forms and to validate if a certain contact is registered to an email group . 2 Years
ELQSTATUS eloqua.com Used to auto -populate forms and validate if a given contact has subscribed to an email group. The cookies only set if the user allows tracking . 2 Years
IDE doubleclick.net Used by Google Double Click to register and report the website user’s actions after viewing clicking one of the advertiser’s ads with the purpose of measuring the efficiency of an ad and to present targeted ads to the user. 1 Year
NID google.com Registers a unique ID that identifies a returning user’s device. The ID is used for targeted ads. 6 Months
PREF youtube.com Registers a unique ID that is used by Google to keep statistics of how the visitor uses YouTube videos across different web sites. 8 months
test_cookie doubleclick.net This cookie is set by DoubleClick (which is owned by Google) to determine if the website visitor’s browser supports cookies. 1,073,201 Days
UserMatchHistory linkedin.com Used to track visitors on multiple websites, in order to present relevant advertisement based on the visitor’s preferences. 29 days
VISITOR_INFO1_LIVE youtube.com 179 days
.avia-table-4 td:nth-of-type(1):before { content: 'Cookie Name'; } .avia-table-4 td:nth-of-type(2):before { content: 'Domain / Associated Domain / Third-Party Service'; } .avia-table-4 td:nth-of-type(3):before { content: 'Description'; } .avia-table-4 td:nth-of-type(4):before { content: 'Retention period'; }
Third party companies Purpose Applicable Privacy/Cookie Policy Link
Alexa Show targeted, relevant advertisements https://www.oracle.com/legal/privacy/marketing-cloud-data-cloud-privacy-policy.html To opt out: http://www.bluekai.com/consumers.php#optout
Eloqua Personalized email based interactions https://www.oracle.com/legal/privacy/marketing-cloud-data-cloud-privacy-policy.html To opt out: https://www.oracle.com/marketingcloud/opt-status.html
CrazyEgg CrazyEgg provides visualization of visits to website. https://help.crazyegg.com/article/165-crazy-eggs-gdpr-readiness Opt Out: DAA: https://www.crazyegg.com/opt-out
DemandBase Show targeted, relevant advertisements https://www.demandbase.com/privacy-policy/ Opt out: DAA: http://www.aboutads.info/choices/
LinkedIn Show targeted, relevant advertisements and re-targeted advertisements to visitors of LTI websites https://www.linkedin.com/legal/privacy-policy Opt-out: https://www.linkedin.com/help/linkedin/answer/62931/manage-advertising-preferences
Google Show targeted, relevant advertisements and re-targeted advertisements to visitors of LTI websites https://policies.google.com/privacy Opt Out: https://adssettings.google.com/ NAI: http://optout.networkadvertising.org/ DAA: http://optout.aboutads.info/
Facebook Show targeted, relevant advertisements https://www.facebook.com/privacy/explanation Opt Out: https://www.facebook.com/help/568137493302217
Youtube Show targeted, relevant advertisements. Show embedded videos on LTI websites https://policies.google.com/privacy Opt Out: https://adssettings.google.com/ NAI: http://optout.networkadvertising.org/ DAA: http://optout.aboutads.info/
Twitter Show targeted, relevant advertisements and re-targeted advertisements to visitors of LTI websites https://twitter.com/en/privacy Opt out: https://twitter.com/personalization DAA: http://optout.aboutads.info/
. .avia-table tr {} .avia-table th, .flex_column .avia-table td { color: #343434; padding: 5px !important; border: 1px solid #ddd !important; } .avia-table th {background-color: #addeec;} .avia-table tr:nth-child(odd) td {background-color: #f1f1f1;}
Save settings
Cookies settings