Use MS Access + ms excel to achieve the simplest data analysis.

1. Create tables in access as required, not limited to access, but also other data sources;

2. Open Excel and select the pivot table;

3. Select an external data source;

4. select new data source and fill in the data source link information. In this example, select the Access Table fact created just now;

5. In the query design wizard, select all fact columns;

6. Go to the "finish" Page and select "create OLAP multi-dimensional dataset;

7. Enter the cube wizard;

8. Select the measurement value of a multi-dimensional dataset, which is the basis of the summary. The measurement method is count;

9. Select the dimension column of the multi-dimensional dataset, that is, the region and type in;

10. Save the multi-dimensional dataset and select the second item. This method is very inefficient in analyzing a large amount of data. It is suitable for selecting the third item for a large amount of data. However, we recommend using Analysis Service for analyzing a large amount of data;

11. Save the multi-dimensional dataset. Before saving the dataset, you will be prompted to save the query. Save it as needed. Then, follow the instructions to drag the field list to the graph position in sheet;

12. sort and area can be dragged and replaced, and can be dragged to the top of the table, as shown in figure 2 below;

13. click the button in the small red box to set the table format. The final result is shown in;

Now, a simple analysis process is complete. You can use this table to claim the Statistical Chart, which is supported by Excel.