{"id":2094,"date":"2021-12-09T10:49:59","date_gmt":"2021-12-09T18:49:59","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/introducing-charts-for-query-analytics\/"},"modified":"2021-12-09T10:49:59","modified_gmt":"2021-12-09T18:49:59","slug":"introducing-charts-for-query-analytics","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/es\/introducing-charts-for-query-analytics\/","title":{"rendered":"Introducing Charts for Query & Analytics"},"content":{"rendered":"

Couchbase Web Console is a browser-based, interactive graphical user interface that supports the management of all services in Couchbase Server. It also includes the Query & Analytics Workbench that allows developers to interactively manipulate Couchbase data, explore the schema, and develop N1QL statements for their application needs. In addition, the Query Workbench is capable of giving insights into the query execution plan, allowing developers to get a detailed understanding of how these services process the statements.<\/span><\/p>\n\n\n\n

Performance tuning is also immediately available with the ADVISE feature, where the query engine lists the indexes currently used by the query, and automatically recommends additional indexes that could help improve query performance.<\/span><\/p>\n\n\n\n

\u00a0<\/p>\n\n\n\n

In Couchbase 7.0, we added further enhancements to make it easier for developers to work with Couchbase Scopes and Collections, and a capability to execute N1QL statements in a single transaction, providing an all-or-nothing approach to bulk database operations.<\/span><\/p>\n\n\n\n

Data visualization with Charts<\/span><\/h2>\n\n\n\n

In the latest Couchbase 7.0.2 update, Query Workbench has a new capability to allow users to visualize query results in a chart format.\u00a0<\/span><\/p>\n\n\n\n

<\/span><\/span><\/p>\n\n\n\n

The query result can be viewed in table, JSON, or Chart views.<\/span><\/p>\n\n\n\n

<\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n\n\n\n

Interactive charting capability<\/span><\/h3>\n\n\n\n

For many releases the workbench has supported copying data in tab-separated format to allow pasting into other visualization\/analysis tools like Excel or Tableau. This is still possible for more complex analysis, but bringing charts into the workbench allows a much tighter iterative loop between querying and visualization. Developers can now interactively work on the query statement, then execute it to immediately get the chart view.<\/span><\/p>\n\n\n\n

In the screenshot below, the query predicate has been changed to retrieve the number of scheduled flights by airlines that fly out of LAX airport.<\/span><\/p>\n\n\n\n

<\/span><\/span><\/p>\n\n\n\n

Charting with Analytics Service<\/span><\/h3>\n\n\n\n

The same charting capability is also available with the Analytics service. Here we use the Group Bar chart to display both the<\/span> “number of routes”<\/span> and the<\/span> “number of scheduled flights”<\/span> in the chart:<\/span><\/p>\n\n\n\n

<\/span><\/span><\/p>\n\n\n\n

Examples of different chart types<\/span><\/h3>\n\n\n\n

1- Use a Donut chart to show the total number of public likes from all the hotels by city<\/span><\/p>\n\n\n\n

2- Use the X-Y chart to show the potential relationship between the number of public likes and the overall rating of hotels by city<\/span><\/p>\n\n\n\n

<\/span><\/span><\/span><\/span><\/p>\n\n\n\n

Share the chart with others<\/span><\/p>\n\n\n\n

The chart can be downloaded as a scalable vector graphics (SVG) file. This is a portable file format that can be displayed in all browsers.<\/span><\/p>\n\n\n\n

<\/span><\/span><\/p>\n\n\n\n

\u00a0<\/b>Note that the SVG format allows scaling without pixelating the image. It can also be imported into Microsoft Powerpoint.<\/span><\/p>\n\n\n\n

More Resources<\/span><\/h2>\n\n\n\n

To learn more about Couchbase Query & Analytics Charting capabilities, check out the following resources:<\/span><\/p>\n\n\n\n