The benefits of drilling down your data.

When you gather data and begin utilizing tools to analyze your data, it is important to have a tool that can help you to drill down to the smallest aspect of your data. Software such a Tableau allows you to load flat-file and relational databases from excel, and data from connected sources and databases. Once the data is loaded into Tableau and you get ready to analyze said data, this tool allows you to drill down into the data based on what you are analyzing.

For example, if you wanted to analyze your total revenue, you could look at that as the total sum of revenue and leave it there. But how beneficial would that be to your business or how would that help you to make decisions? It really would not. So what if you decided that you wanted to know what category of products and in what region you are experiencing the highest revenue since this information would be more useful to you? Well, the program would help you to get that information because it allows you to drill down from the category to sub-category, and down to the exact product name or product ID that is pulling in the highest revenue. You can then drill down based on region, state, and even down to the exact city/town that is pulling in the highest revenue.

Now, remember, these programs are not magic, you must include the data for the program to be able to show you what you are looking for. So, to be on the safe side, when deciding what data fields to include in your flat files and databases, include them all. Sometimes we do not know exactly what we are looking for but when we have big data it gives us plenty of information to choose from and put together to gain insights.

The ability to drill down into your data enables you to see your business from the bottom up so that when there are products/services or regions that are overperforming or underperforming, you can gain insight and make informed decisions that will be beneficial for you company to realize continued growth.


Check out last week’s post

The importance of visualizing your data.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.