Ad hoc analysis enables business users to drag and drop fields to build tables for self-service data exploration. This feature is available only in group workspaces of Quick BI Enterprise Standard.
Positioning
An accessible data exploration and analysis tool designed for datasets with tens of millions of rows. 
Key features
-
Flexible data analysis: Query and analyze data in real time, on demand.
-
Multi-dimensional data combination: Combine multiple dimension and measure fields to build multi-faceted analysis views.
-
Ease of use: Drag and drop fields to generate tables. No technical background required.
Scenarios
-
Data exploration anytime, anywhere
Explore data across scenarios and merge or split dimensions freely
Example: On June 1 you query office-supply sales in East China. On June 2 you need store inventory across the Chinese mainland to prepare for the 618 Shopping Festival. A cross table cannot switch between these views quickly, but ad hoc analysis lets you pivot, view, and download data on the fly.
-
Dynamic data analysis during meetings
Drag and drop fields during a meeting for instant analysis results that support real-time business decisions.
-
Quick response to business changes
Adapt analysis direction when business structures change
When organizational or product category structures change, data ownership and viewing perspectives shift. For example, if product A moves from the women's clothing category to the fashion brand category, you can still retrieve its data through ad hoc analysis before the underlying tables are updated.
UI
|
No. |
Area |
Description |
|
① |
Data tab |
|
|
② |
Feature navigation bar |
Functions like the Excel ribbon. Provides suppression, custom subtotals, analysis, calculation, and clearing operations. |
|
③ |
Row and column containers |
Drag fields here to define the row and column axes of the table. |
|
④ |
Query control |
Drag dimension values here to create filter conditions without complex configuration. |
|
⑤ |
Table display section |
|
Procedure
On the ad hoc analysis creation page, you can perform the following operations:
-
Create an ad hoc analysis: Build flexible queries to view and download data across different scenarios.
-
Select a dataset or field: Choose the dataset and fields to analyze.
-
Use the feature navigation bar: Undo, redo, suppress, analyze, calculate, and customize subtotals.
-
Perform drag-and-drop operations in an ad hoc analysis: Generate tables and filters by dragging fields.
-
Perform operations on tables in an ad hoc analysis: Configure measure and dimension fields in an existing table.
-
Page Settings in Ad-hoc Analysis: Configure export, cell merging, and total display options.
-
Perform interactive analysis in an ad hoc analysis: Drill down, roll up, and expand data for deeper analysis.