Bold BI

5 Interactive Data Visualization Features You Should Know

5 Interactive Data Visualization Features You Should Know

Gone are the days when data visualizations were static, when you could view plotted data but not interact with it. Raw data, when captured, isn’t useful unless you allow the user to break it down and evaluate it. Interactive data visualization can act as a standalone solution to help you achieve faster decision making, see your data clearly, and allow stronger user engagement.

Interactive visualization can be anything from drill-down in a chart to hovering over a chart to select specific data points and visualize the story in your own way. In this article, we’ll look at the five most useful interactive data visualization techniques and how to apply them using Bold BI.

Filters

If you have a huge data set and want to concentrate only on a specific area, you can add filters to limit the data displayed in the chart or dashboard. Filters can also be used to provide different combinations of data. So, instead of having a separate visual or dashboard for each category, you can add filters and let users change their criteria to explore the data.

Bold BI allows you to add filters to your dashboard through customizable filter widgets as well as built-in grid filters.

Filter Widgets available in Bold BI
Filter Widgets

To add a filter, drag and drop the filter widget from the toolbox to the designer canvas and configure the field you want to filter.

Configuring a Filter Widget in Bold BI
Configuring a Filter Widget

Filters can be added to any field based on the field type. Bold BI provides filter widgets such as range slider, combo box, and date picker for numeric, string, and date-time fields, respectively. The following image shows visualizations bound to the different field types.

Filtering a Dimension in Bold BI Using a Combo Box
Filtering a Dimension Using a Combo Box

 

Filtering a Numeric Range Using Range Slider
Filtering Using a Numeric Range Slider

 

Date-Based Filtering Interaction Using a Date Picker
Date-Based Filtering Using a Date Picker

You can customize filters for a single widget or a group of widgets using the filter configuration window. In the filter configuration window, for a selected master widget, you can add one or more listener widgets from the widgets list.

Filter Configuration Button in the Bold BI Dashboard Designer Tool Bar
Filter Configuration Button in the Tool Bar

The filter configuration window also has various other features. Filter profiles allow you to add custom relationships for a group of widgets if you need to target a different column for that group. Cross-data-source filtering is also possible by adding a custom relationship that includes the target data source and the target column. Learn more about filter configurations from our user guide.

Drill Down

Drill down allows users to explore in-depth details associated with displayed chart elements at the click of a mouse. For example, a chart showing sales across various countries can be drilled down by clicking a chart element to show sales across the states in that country. This allows users to analyze different layers of multidimensional data.

Bold BI allows you to add drill downs for charts and tree maps. To configure a drill down, add multiple dimensions based on the required number of hierarchy levels to the columns section.

Adding Drill-Down Interaction to a Pie Chart
Adding Drill-Down to a Pie Chart

In the dashboard viewer, you can click on the pie slice or tree map region you want to explore and drill down to gain a deeper understanding of the data. You can also navigate back to the top hierarchy using the bread crumb available at the top of the chart or tree map.

Pie Chart in a Drilled-Down State
Pie Chart in a Drilled-Down State

Linking

Widget linking can help you connect dashboards that are related to one another. For example, you may have high-level key performance indicators (KPIs) in one dashboard, and another dashboard holding details at a department level. You can add detailed dashboard links to your master dashboard’s widget and navigate to them see the complete story of the data. You can also add parameters and filter details in a secondary dashboard, based on the item selected in your master dashboard.

Bold BI supports linking in all the widgets except card, gauge, and filters. Linking can also be done with external web content.

To configure links in a widget, select the widget and choose Enable Link in the properties panel. Enter the URL of the other dashboard or the URL of the external web content in the URL text box. You can also send the selected value as a query parameter using the Append Column list box below the URL text box. Double-click the required field to append the parameter to the URL. You can learn more about linking from our documentation.

Configuring Widget Linking in Bold BI Dashboard Designer
Configuring Widget Linking

Show or hide values

Showing or hiding values can be a very useful feature when you have a large data set, and when legends are dynamically generated, as shown in the following example.

Pie Chart with Dynamically Generated Legends
Pie Chart with Dynamically Generated Legends

In the previous figure, the pie chart shows sales by country. If you want to exclude one or more data points and dig into only two or three countries where you want to create a sales strategy, all you need to do is click the legend items for the series you want to hide. The legend items will go into a disabled state and the corresponding data points will be removed from the chart and all aggregation calculations. The following figure shows the example pie chart with several legends and their data points removed from the chart.

Pie Chart with Hidden or Excluded Data Points
Pie Chart with Hidden or Excluded Data Points

In Bold BI, you can also click on a series legend to exclude it from the chart as shown in the following image.

Hiding a Chart Series in Visual Interaction
Hiding a Chart Series

Sorting

Sorting allows users to visualize data in ascending or descending order.

In Bold BI, the comparison charts display values in descending order by default for better readability and easy comparison. You can also reverse the order or sort based on a condition when configuring the chart widgets. Grid widgets, on the other hand, provide support for interactive sorting by simply clicking on a column header. The following images show the sorting functionality in the grid and pivot grid widgets.

Sorting in a Pivot Grid Widget
Sorting in a Pivot Grid

 

Sorting in a Grid Widget
Sorting in a Grid

Conclusion

We hope this article helped you improve your dashboards by adding interactive data visualization features to them. If you have any questions, please submit them in the comments section below. You can also contact us by submitting your queries on the Bold BI website, or if you already have a Bold BI account, you can log in to submit your support query. Bold BI now comes with a 15-day free trial with no credit card information required. We welcome you to start a free trial and experience Bold BI for yourself.

Start your free 15-day trial today

1 comment

  1. joker stash write and swipe
    July 18, 2019 at 11:36 pm

    Тhanks very nice blog!

Leave a Reply