Subject Model Application Example

Version

Application Scenario

Subject models allow you to explore multidimensional analysis.

With models, you can perform multi-table analysis within a single analysis subject.

Scenario one: simpler data preparation

With models, multiple tables can be quickly associated into a large and wide table for analysis. You can directly add fields to components for analysis without waiting for any update.

Scenario two: simpler reuse of component analysis

Analysis operations such as calculation field adding, drilling, and detail filtering performed on data tables in the to-be-analyzed area will be synchronized to the table' model. If you need the table for another analysis in the subject, you can use the processed fields directly with no component copying.

Scenario three: cross-table fields directly involved in calculation after table association

You can directly add cross-table fields to calculation fields for analysis.

Scenario four: N:N association

Components created from associated tables are linkable for you to view filtered results.

Implementation Method

You can perform multi-table analysis if these tables from an analysis subject are associated in Model View.

The prerequisite for cross-table analysis is table association in Model View.

Creating an Analysis Subject and Adding Data

Download the sample data XX China Store Data.zip and upload it to an analysis subject.

For details, see Quick Tutorial.

Establishing a Model

Drag the fields in tables to associate tables and adjust the association according to Configuration Suggestion. The following figure shows the procedure.

For details, see Model View.

The following figure shows the effect.

Sales Volume Analysis for Products of Different Types

After the three tables are associated, you can use fields in the tables for cross-table analysis in a component.

Drag Product Type from Product Information and Sales from Product Sales into the analysis area to view the sales of products of different types.

Hover your cursor over the field in the analysis area to view its source.

Sales Analysis of Jiangsu Province

Sales Analysis of Different Products in Jiangsu Province

You can also perform cross-table analysis when processing the fields in the to-be-analyzed area.

Click the drop-down icon next to the field Sales in Product Sales and select Filter Detail from the drop-down list. Click Add Condition, select the field Province in Store Information, and filter out the data of Jiangsu Province.

Drag the filtered field into the analysis area to view the product sales in Jiangsu province.

Sales Trend of Jiangsu Province

Field operations performed in the to-be-analyzed area will be retained in the model, and the processed fields can be used directly in an added component.

Click the  button to add a component, drag Date and Sales from Product Sales into the analysis area, and set Chart Type to Partitioned Line Chart to view the sales trend of Jiangsu province.

Sales data of Jiangsu province is already filtered out through Filter Detail performed on the field Sales in the previously-created component. The filtered field will be retained in the model and can be used directly in the next analysis.

Comparative Analysis of Sales Volume of Jiangsu Province

You can add calculation fields based on cross-table fields. The added calculation fields will be retained in the model and can be used directly in analysis subjects.

For example, you can obtain the sales volume of different products in Jiangsu province by adding a calculation field.

The added calculation field is available in Cross-Table Field. Drag the cross-table field into the analysis area to compare the sales volume of Jiangsu province with that of the whole country.

The added calculation field will be synchronized to the model. You can use this calculation field directly in another new component.

Indicator Name

Indicator Name, generally used for legend generation, is available in Cross-Table Field when you create a graphical chart in a component.

Viewing Component Information in Dashboards

You can select a component in a dashboard and click the Component Information button to view the update information of tables related to the component.

Association Between the To-Be-Analyzed Area and Model

The settings performed in the to-be-analyzed areas (even those in different components) will be synchronized to the model. For details, see Overview of the Settings of the Area to be Analyzed.