What you need to consider when drilling down the data.(vol.1)

People drill down data by some axis.

For example, sales amount data can be broken down (drilled down) by area, by branch or by product etc.

It is technically possible to drill down by any axis but you may find it not practical at all when you try to apply the results into your business. Why.

From my experience and survey, I found three major points you should consider when you select the axis for drilling down the data.

One of the three is “Impact to the goal”.

You need to make sure the consequence of using the axis will effectively contribute to or affect the goal finally.

You can break the data by customer location (area), for instance. But if the business is internet shop, then location does not matter at all. I know this is a too simple example, but people tend to skip this exercise when they simply use some axis to break the data.

The question you should ask would be “Is the axis really a key driver to the goal?”.

Advertisements

One response to “What you need to consider when drilling down the data.(vol.1)

  1. Reblogged this on conlatio.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s