The ad hoc query feature allows business personnel to perform drag-and-drop operations to generate tables for data analysis. This feature is supported only in group workspaces of Quick BI Enterprise Standard.
Service scope
A low-threshold data exploration and analysis tool for tens of millions of data volumes.
Core capabilities
Flexible data analysis: The ad hoc query feature provides flexible data analysis capabilities. You can use ad hoc queries to analyze data in real time.
Multi-dimensional data combination: The ad hoc query feature allows you to use multiple dimension fields and measure fields to meet the requirements of forming a facet to implement multi-dimensional analysis scenarios.
Easy of use: The ad hoc query feature requires a low configuration cost. You need to perform only drag-and-drop operations to generate table data. Even business personnel that do not have technical background can quickly create an ad hoc query.
Scenarios
Data exploration at anytime and anywhere
Explore data in various scenarios and merge or split dimensions
For example, you want to query the sales amount of office supplies in the East China region last month on June 1. On June 2, you are requested to transfer goods based on the inventory of stores in the Chinese mainland to ensure that the stores in important regions will not be short of inventory in 618 Shopping Festival. If you use a cross table, you cannot quickly switch from querying the sales data in the East China region to viewing the inventory of stores in the Chinese mainland. In this case, you can use an ad hoc query to view data and download data in a flexible manner.
Dynamic data analysis during a conference
If you want to perform data analysis during a conference, you can perform drag-and-drop operations to obtain the analysis result. This can help you make business decisions.
Quick response to business changes
Change the analysis direction based on business changes and update the content to respond to business changes
When the business scope or personnel organization changes, the data ownership or viewing perspective often changes accordingly. For example, the original category of product A belongs to the category of women's clothing and becomes the category of fashion brand. At this time, data can still be displayed when the bottom table is not updated, and the relevant data of product A can still be quickly dragged out by using ad hoc analysis.
UI
No. | Region | Description |
① | Data tab |
|
② | Feature navigation bar | Similar to the Excel ribbon, it supports common functions such as suppression, custom subtotals, analysis and calculation, and clearing. |
③ | Row and column containers | This section allows you to drag specific fields to the row and column containers to generate the row and column data for the table. |
④ | Query control | This section allows you to drag dimension values to generate filter conditions. You do not need to configure complex conditions. |
⑤ | Table display section |
|
Step
On the Create Ad Hoc Analysis page, you can perform the following operations:
Create an ad hoc query: If your data is complex and frequently modified, and you require data in different scenarios, you can use ad hoc queries to view and download data in a flexible manner.
Select a dataset or field: You can select a dataset or field on the Create Ad Hoc Analysis page for data analysis.
Use the feature navigation bar: You can perform basic operations on the Create Ad Hoc Analysis page. You can undo, redo, suppress, analyze, and calculate the extracted data and customize subtotals for data.
Perform drag-and-drop operations in an ad hoc query: You can perform drag-and-drop operations on the Create Ad Hoc Analysis page to generate tables and filters
Perform operations on tables in an ad hoc query: You can configure the measure fields and dimension fields in the existing table on the Create Ad Hoc Analysis page.
Page Settings in Ad-hoc Analysis: In ad hoc analysis, you can configure operations such as exporting, merging cells, and displaying totals.
Perform interactive analysis in an ad hoc query: You can drill down, roll up, and expand data for analysis.