Cross Tables

Cross table (crosstab for short) is a two-way table consisting of rows and columns. It is typically used to determine whether there is a relation between row variables and column variables. Cross tables are often used in various names. For example, pivot tables and multi-dimensional tables are often used in Business Intelligence (BI) and OLAP contexts. In essence, they are the same tables operating on the same principles. Normally they have a grand total, row totals, column totals, cell values, and sub-totals.

cross table in Rosella BI Server.

Groupby Tables

Groupby tables are similar to cross tables. It differs that columns do not represent categories.

groupby table in CMSR.

Analytic tools for Cross and Groupby Tables

CMSR and Rosella BI Server support powerful analytics for cross and groupby tables. Analytic features include the followings;

  • Hotspot analysis
  • Deviation analysis and detection with expected values.
  • Percentage analysis
  • and so on.

These features are fully implemented in CMSR and BI Server. For more, please read CMSR and Rosella BI Server.


StarProbe data miner suite
Data Mining Methods

 Audit and Monitoring
 Basket Analysis
 Credit Risk Analysis
 Credit Risk Modeling
 Credit Scoring
 Customer Profiling
 Customer Retention
 Customer Segmentation
 Database Marketing
 Direct Mail Marketing
 Direct Marketing
 Geographic Segmentation
 Healthcare Fraud Detection
 Insurance Risk Analysis
 Insurance Risk Modeling
 Insurance Scoring
 Market Segmentation
 Market Survey Analysis
 Marketing Research
 RFM Marketing & Modeling
 Risk Management
 Risk Modeling
 Sales Forecasting
 Sales Trend Analysis
 Trend Analysis
Data Mining Tools

 BI / OLAP
 Clustering
 Correlation Analysis
 Decision Tree
 Hotspot Analysis
 Link Analysis
 Neural Network
 Predictive Modeling
 Profiling
 Self Organizing Maps (SOM)
 Web Mining