Category: Insights Team

Explorazor Product Updates – Seamless Root Cause Analysis, Conditional Formatting, and More

by adminin conditional formatting, dual axis charts, Explorazor product updates, Insights Team, root cause analysis

Hello there, welcome. We’re excited to share the latest updates made on our data exploration and analysis tool, Explorazor, covering root cause analysis, conditional formatting, and dual axis charts. We’ll also highlight the benefits that Brand & Sales can derive from these updates. 

If you have headed directly to this blog without browsing the website, here’s a quick introduction to Explorazor: curated especially for Brand and Sales Teams at Pharma and Consumer Goods companies, Explorazor allows users to explore their data faster, better, and easier than on Excel by combining all datasets into a single consolidated dataset that can be queried via a simple search interface.

Let’s dive into the updates:

  1. Root Cause Analysis 

As the name suggests, root cause analysis is the process of arriving at the heart, or the root cause, of any event, usually an event of concern. 

Root cause analysis (RCA) helps managers determine why the problem occurred in the first place. For example, in Explorazor, users can identify the reasons behind market share degrowth and find out which state or city was responsible for it.

How it works is that the user identifies a table value, clicks on it, and is able to drill down into any hierarchy or drill across KPIs from multiple datasets in the same view. Here’s what it looks like:

Explaining ‘drill across’ further, users can navigate through multiple datasets at the same time. 

This is a highly interactive method for users to rapidly diagnose issues or pain points, allowing them visibility into multiple data cuts simultaneously. We recommend skimming through the blog ‘Conduct Drill-Down on an Integrated Dataset via Point-and-Click’ to see an example of how RCA is conducted on Explorazor via double-clicking. The example is complete with screenshots from Explorazor. 

We’re also working on further updates within root cause analysis – the freedom to sort values automatically will soon be available.

  1. Conditional Formatting

Users can provide business rules on their data, above or below which they want the data to be highlighted differently. This allows them to quickly identify outliers or get a clear view of when they hit a target.

Actual product screenshot - Explorazor - Conditional Formatting

Another significant benefit of conditional formatting on Explorazor is the option to pin a conditionally formatted query directly to the dashboard. The conducted query is saved to the dashboard for future use and keeps auto-updating, so there’s a lot of smoothness added to the querying processes of users, who would have previously had to re-run the same formatting procedure multiple times. 

There are a lot of design-based options for conditional formatting, like color-coding areas of improvement in red and success zones as green. 

  1. Dual, and Triple Axis Charts

One may have to look at the trends of multiple different KPIs at the same time. However, not all KPIs will have similar values – one could be in the millions while another could be in the 100s. Correlating such figures is a challenge.

What Dual Axis Charts do is allow users to see the trends in all these different KPIs together, so that they can correlate how changes in different KPIs affect others. 

Actual product screenshot - Explorazor - Triple Axis Charts

Users also have total control over each axis w.r.t the metric shown. For example, Axis 1 can display the trend of Market Share while Axis 2 displays Internal Sales. 

With the ability to look at the trends of multiple KPIs of different scales at the same time, the relationship between two or more measures can be demonstrated and correlations, wherever the nature of the values allow, can be viewed.

Triple Axis Charts? Works the same way as Dual. 

Get More Out of Your Datasets, and Your Skill Set!

Explorazor is not here to radically change the way Brand & Sales teams interact with data. We simply propose streamlining scattered datasets under a single roof, accessible to all. 

Explorazor focuses on letting each department and individual use their skill sets in solving real market problems and finding ways to promote their brand and grow their revenue, instead of getting embroiled in the daily tangles of multiple tabs, inaccessibility to needed datasets, and undue dependence on others for ad-hoc analysis. Insights Teams benefit greatly too – check out the reasons why an Insights Team should consider Explorazor for their managers. 

If you are a Brand Manager, learn about the 3 Types of data analysis Brand Managers can perform super-easily on Explorazor. 

We hope you find these product updates useful. If you have any suggestions or queries, do not hesitate to contact us; we are more than happy to connect and help.

Take an Interactive Product Tour of Explorazor!

pRODUCT TOUR

Why Should an Insights Team Consider Explorazor for Brand Managers?

by adminin ad-hoc query, Brand Managers, dashboarding tool, data pivots, Excel, Explorazor, Insights Team

In this blog, we’ll be making a case for why an Insights team should consider Explorazor for Brand Managers, discussing the problem with current dashboarding tools, and how Explorazor will benefit Insights Teams massively. 

Before we begin, just a quick introduction to Explorazor – it is a data exploration tool designed specifically for Brand Managers to obtain instant data pivots on an all-inclusive, integrated dataset, using a simple search functionality, with the ability to pin insights to dashboard and download any data point as a CSV file.

Let’s begin:

Introduction

Now, a part of the job for an Insights team is to introduce new products/tools in the company to help Brand Managers –

  1. Extract the maximum out of the data – as in, extracting the best insights which lead to the best decisions
  2. Doing so in a manner that eases, not complicates, a Brand Manager’s interactions with the data 

We interviewed 100+ Brand Managers from Unilever, Nestle, Reckitt, Glenmark, Godrej, and more, asking them about the lives of Brand Managers and the various data-related challenges they face. We then developed Explorazor, the data exploration tool in question, in such a way as to 

  1. Help Brand Managers get any data pivots instantly
  2. Ensure that it is so simple, that Brand Managers have no difficulty in adopting it

Regarding the instant data pivots, it is possible on Explorazor because Explorazor hosts all data in an integrated manner. Think of Kantar, Nielsen, IQVIA, primary sales, secondary sales, media, and every other dataset, all combined into one. Regarding the instant adoption, there is no end-user difficulty in usage, nor is there any novel proposal – Explorazor simply seeks to improve their Excel experience, without leaving Excel entirely.

Brand Managers are strikingly similar in their possession of skill sets, job roles, and the right personality traits, so the background they came from didn’t prove to be an adoption hindrance as well. 

The Problem with Dashboarding Tools

The major part of a Brand Manager’s job is to ensure that the brand is operating smoothly, across geographies. To do this on a typical BI dashboard, they would have to make, manage, and maintain tens of dashboards at a time. Workload is increased. 

Additionally, the data is stored individually, with no communication between them whatsoever. Creating a connection between them to answer ad-hoc queries is a painstaking task, and Brand Managers simply ask the Insights Team to revert with an answer to their ad-hoc queries. 

Finally, even if the dashboarding tool is able to do all of this, Brand Managers educating themselves on the ins and outs of the tool and how to use it, is, simply put, not going to happen. As a Growth Analytics Lead of a 35,000+ employee company told us “There are so many tools in a company, but nobody uses them. They just pose questions to us!”

Such is the case of the average company – BI tools that help create dashboards are lying unused because they don’t help people (in our case, Brand Managers) ease their daily lives. 

Benefiting Both Parties

The primary reason for Insights Teams to consider Explorazor for their Brand Managers is that Explorazor empowers the Brand Manager to ‘Do It Himself’. No longer is the Brand Manager dependent on anyone to run ad-hoc analysis. The win-win here is that the Insights Team’s time is freed up to concentrate on what they should actually be doing – strategizing for the long-term, running different types of modeling on different datasets to create better forecasts and targets for the business, and so on.

Consider an example: Suppose your company owns an apparel brand present in retail stores across the nation. Now as an Insights Team, you can focus on things like mapping out the loyalty base in each region, and studying why it is shifting, if that’s the case. You can then start benchmarking competition and finding out if a particular campaign they ran during that time period led to a shift in the loyalty base. If sales showed de-growth in stores in a particular city during the year-end, you can dig deep to find the exact answer for it – it may be something as minute as the discount scheme offered by competition being better than yours. You can design loyalty programs to win back your customer base, in addition to ensuring you have a better discount scheme the next time around. In a utopian and very possible scenario, Brand Managers would be thanking you over emails and town halls. 

All of this is possible, if only you have the freedom to execute what you are capable of.

Insights team should consider Explorazor for Brand Managers. If you are interested in knowing more about Explorazor, kindly schedule a 30-min demo call with us here.

If you want to understand how Explorazor helps Brand Managers explore data on an integrated dataset, we suggest you skim through the ‘3 Types of Analysis Brand Managers can Perform Super-Easily on Explorazor’ blog. 

Take an Interactive Product tour of Explorazor.

pRODUCT TOUR