Data drilling
Data drilling
Main page

Data drilling

logo
Community Hub0 subscribers
What are your thoughts?
Be the first to start a discussion here.
Be the first to start a discussion here.
Data drilling

Data drilling (also drilldown) refers to any of various operations and transformations on tabular, relational, and multidimensional data. The term has widespread use in various contexts, but is primarily associated with specialized software designed specifically for data analysis.

There are certain operations that are common to applications that allow data drilling. Among them are:

Query operations:

Tabular query operations consist of standard operations on data tables.

Among these operations are:

Consider the following example:

Fred and Wilma table (Fig 001):

The preceding is an example of a simple flat file table formatted as comma-separated values. The table includes first name, last name, gender and home country for various people named fred or wilma. Although the example is formatted this way, it is important to emphasize that tabular query operations (as well as all data drilling operations) can be applied to any conceivable data type, regardless of the underlying formatting. The only requirement is that the data be readable by the software application in use.

See all
User Avatar
No comments yet.