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:
- 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.
- 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.
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.
- 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.
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!