Decompose, Drill Through & Focus [BIME TIP]

In the new version of Bime, you can use the Decompose, the Drill-Through & the Focus features. Here's a quick tutorial on how each one works.

Decompose

If you choose to decompose then you can analyze data using a different axis (i.e. a different attribute).

The cartesian and pie charts allow you to 'decompose' your visualization, both on queries and on dashboards (if allowed in the dashboard preferences). Click on a data range and a pop-up appears, offering you this option. Click, and you can select which attribute you want to dig down into.

For example, this pie chart shows results based on one attribute (here, 'Year(Ship Date)') - but you can focus in on one element of that (here '2009') by using decompose.

Having opted to decompose using 'Sales Channel', the chart changes to show results only by the chosen Year, which has been moved to be a filter.

You can continue to 'pivot' your data by altering the filter. Alternatively, decompose another segment of the pie and each new view adds that segment's attribute to 'filters', enabling it to focus in on that segment, and uses the new chosen attribute in 'columns'.

Thus, decompose allows you either to drill down into the detail, or 'flip' the visualization from being defined by one attribute to another.

Drill through

If you choose to drill through then you can visualize the underlying data in each query.

In the pivot table, you can use the Drill Through feature on cartesian and pie charts to see underlying data for a selection of data points, displayed as detailed lines. For instance, the following figure illustrates the result of a query for which we visualize the Shipping Cost per Region. Let us imagine you want to see the underlying data for the Region Central. To do this, click on the Central horizontal bar and then click on the Drill Through item.

Once you click on Drill-Through for selected data points, Bime retrieves & computes all the underlying data and displays them in the Drill-Though pop-up illustrated by the image just below. In our current example, the Drill-Through operation has retrieved 2100 underlying lines (i.e. 21 pages of 100 lines). Consequently, keep in mind that the more numerous the underlying data are, the longer the Drill-Though computation time.

In the Drill-Through pop-up, you can navigate through the underlying data with the 'Next' & 'Previous' page buttons, visualize a specific page directly through setting the index of the wanted page in the numeric stepper, and exporting the underlying data as an CSV file through clicking on 'CSV'. In addition, you can modify the number of lines which are displayed per page. Then, click on 'OK' to close the drill-though pop-up.

To conclude, please note that the Drill-Through feature is available only on in-memory & RDBMS connections.

Focus

If you choose to use focus then you can restrict and execute an original query of the dashboard only for elements you have selected.

In the pivot table, the focus feature is a shortcut to filter elements visually. As illustrated in the following figure, let us imagine we are analyzing the profits we realize per customer segments.

Let us imagine now that we want to restrict our analysis to the Corporate & the Home Office customer segments. For this, we have only to multi-select Corporate & Home Office, and then click 'Focus on selection'.

As a result, the current result is restrict for Corporate and Home Office, as illustrated by the following figure.

To test out these awesome features, sign up for the free trial now!