MCB Data Cloud Certification Practice Exam

In the calculated insight for Cumulus Financial, which element serves as a dimension?

1. 'high net worth' (filter).

2. 'branch' (dimension).

3. 'banking value' (metric).

4. 'banking value' (metric) and 'branch' (dimension).

The correct answer is: 'branch' (dimension).

To understand why 'branch' serves as a dimension in the context of calculated insights for Cumulus Financial, it's important to grasp the fundamental concepts of dimensions and metrics in data analysis. A dimension is a categorical variable or attribute that allows you to organize and segment data. It serves as a way to break down the data into specific categories for analysis. In this case, 'branch' represents a specific location or division within Cumulus Financial's operations, making it a key aspect for segmenting various insights related to performance or other metrics. By using 'branch' as a dimension, analysts can view and assess the financial data across different branches, enabling them to derive insights related to geographical performance or branch-specific trends. On the other hand, 'high net worth' acts as a filter, which restricts the data being analyzed rather than categorizing it. The 'banking value' is a metric representing a quantifiable measure, such as revenue or profit, rather than a categorical grouping. Therefore, while filters and metrics play important roles in analyzing data, it is the use of 'branch' as a dimension that provides meaningful segmentation for insight generation in this scenario.