Dynamic KPIs, Saving Filters as Groups, Updates to Root Cause Analysis and More – Explorazor Product Updates January 2023

We’re rapidly developing Explorazor to help Brand Managers conduct fast and efficient data exploration. Having already launched seamless root cause analysis, conditional formatting, dual and triple-axis charts in November’s release, we have made some other improvements this time around.

If you are yet to be acquainted with Explorazor, it is a CPG and pharma-specific data exploration tool laying the groundwork for skilled professionals to focus on solving real market problems instead of grappling with unstandardized data and slow laptops all the time. 

The Explorazor proposal for Brand Managers is to work on a harmonized dataset, accessible to all, facilitating instant data pivot extraction (via simple querying) and root cause analysis (via simple clicks) – saving time and effort while accelerating hypothesis testing rates. We do model and engineer your data for you as well.

Let’s look at January’s updates:

  1. Dynamic KPI creation

Users can get custom KPIs created as per their requirement, which are dynamically calculated for every query 

Let’s take an example of ‘Rate of Sales’ as a dynamically created KPI:

Simply insert ‘Rate of Sales’ as a keyword in your query as shown below:

The above image is an example of a dynamically created keyword. Users can get custom KPIs such as Rate of Sales, Market Share, etc. created as per their requirements.

It’s dynamic, so the query will be relevant all the time. As per your query, your numbers of the KPI will be calculated and updated in real-time. For example, you can get KPIs like ‘market share’ which can be calculated dynamically for brands, geography, or distribution, using the keyword, you can use the resulting table to create all kinds of visuals for presentation purposes, and/or perform root cause analysis on it.

  1. Filter Grouping

The rationale is simple – managers use a particular set of filters frequently. Typing in these set of filters repeatedly for every query is undesirable. 

Filter Grouping, as you’re smart enough to figure out by now, allows you to save a group of filters under a common header, and use it to apply the group of filters with ease in the future. Simply recall the header the next time you want to use that set of filters.

  1. Updates to Root Cause Analysis

Explore the root cause analysis/drill-down in detail in the linked blog. 

We have introduced more interactive elements to root cause analysis this time. To show important metrics for a data field, directly click on that field to display all its corresponding values in the left panel. 

This will be better understood with an example:

For any field you click, the numbers on the left panel change dynamically to reflect metrics for our area of interest.

An additional convenience here is the ability to sort the information on an ascending or descending basis. 

Some Other Updates

  1. Recently used keywords will now be prompted as suggestions as you type for quick access. A Google-like feature, and when it comes to a search interface, there’s no reason not to have it Google-like
  2. Min & Max query support is live
  3. There’s an option to edit live data connection options
  4. Updates to conditional formatting

That’s it for this time, and we’ll be back with more updates next month. Our goal remains the same: to help Brand Managers in CPG and Pharma focus only and only on data exploration, and create real impacts through it, with the ultimate objective of improving brand and company revenue. 


Explorazor is a product of vPhrase Analytics.

Take an Interactive Product Tour of Explorazor Today!