Decomposition Analysis tree, KPIs

 

(1) decomposition analysis tree:

Function Description: The decomposition analysis tree provides a step-by-step and intuitive analysis process for a specific metric. The data is analyzed layer by layer from the overall to the details, this gives users an exceptional and clear analysis idea and decomposition process.

Case study: Take the supermarket data cube (Sales of FoodMart 2000) as an example.

1. The decomposition analysis tree analyzes the Specific metrics of a cube. When the program runs for the first time, you need to select the analysis metrics. First, you need to analyze the corresponding layers of dimensions. We start from the customer (MERS mers) dimension to analyze the Store Sales ).

2. You can see that only one node is displayed for the first time, and All values (All) are displayed. Click to show Country-level customers. Store Sales in the United States, Canada, and Mexico are displayed in detail. Their sum will be the value of the common parent node, which is 100% in total. Click the United States to expand the province-level customers in the United States.

3. The Tree nodes in each step are displayed in an intuitive bar chart, showing the data of the bottom-layer leaf nodes.

4. in the process of analysis, you sometimes need to change the analysis angle and analyze the current data from another dimension, especially when the dimension of the analysis has reached the lowest level, no more details can be found, you can right-click another dimension to continue the analysis (Note: The dimension that has been analyzed will not be analyzed ).

For example, when analyzing to the United States, you do not want to continue to analyze the provinces. Instead, you need to analyze the Store Sales of customers of different genders in the United States.

Corresponding intuitive bar chart:

Then, you can perform further analysis in the Gender dimension (in this example, Gender has only one level and cannot perform further analysis ).

5. when there are many open nodes that cannot be displayed in a window, the program will only display the previous node and integrate multiple nodes following it from one, when you need to view the composition of these specific nodes, move the cursor to the last visible node and click expand nodes.

At this time, there are many graphical presentations, but the labels are not fully displayed. You can use the mouse to partially zoom in the image.

(2) KPIs:

Function Description: KPI is an abbreviation of Key Performance Indicator. It is an important Indicator data that users are concerned about. These indicators generally have a target value, an actual value. KPIs displays the status and trend of the data with representative icons.

Case study: KPIs are built based on cubes. A cube can have multiple KPIs without KPIs. Take Adventure Works under Adventure Works DW as an example.