Multi-Dimensional Analysis

During the process of data analysis, you need to explore data from different dimensions to understand data. If you analyze data from a single dimension, you may overlook important data information.

The key advantage of FineBI lies in its flexibility. To be more specific, FineBI allows you to quickly drag and drop dimensions and indicators to obtain analytical results. In contrast, using traditional tools takes significantly more time to create or switch between charts across multiple dimensions. Subsequently, you can analyze Sales from multiple dimensions.

To begin with, prepare a multi-dimensional data table. Upload Sales Data.xlsx to FineBI and use the data table to create a component.

Analysis by Year

Sales analysis by year reveals a steady growth trend of sales year by year, indicating improving operational performance in recent years, as shown in the following figure.

Analysis by Month

Since sales analysis by year is too general, you can further analyze data by month to view the sales trend.

The sales demonstrate a sharp decline in July each year. Besides, the sales from January to April each year are also low. Based on the information displayed in the data, you can investigate underlying causal factors.

Analysis by Region/Category

To find more data information, you can try to analyze Sales from more dimensions. You can drag the Region and Category fields into the analysis area, as shown in the following figure.

The above figure shows that the sales of products of the Furniture category are the highest in all regions excluding Central South. Upon identifying this anomaly, you can further investigate the cause. Based on the investigation, you can determine whether the anomaly is caused by intensive competition or low productivity in the furniture division in Central South, thereby looking for opportunities for furniture sales growth.

Conclusion

Through sales analysis from multiple dimensions, including the year, month, and region/category, you can obtain multiple pieces of data information. In conclusion, if you analyze data from a single dimension, you may overlook important data information. Therefore, you are advised to flexibly analyze data from different perspectives or dimensions in FineBI.