Abstract: In view of problem of inadequate function of data integration and analysis of special fund of coal enterprise, a data analysis system for coal special fund based on OLAP technology was designed. The system uses HOLAP hybrid structure to realize physical storage of data, uses snowflake schema to organize data of fact table and dimension table, and loads the data into multidimensional data set after ETL processing for the data. Eventually, the system uses OLAP multidimensional analysis technology to realize data analysis function and good user interaction, so as to meet needs of dada analysis of special fund and provide necessary support for enterprise decision.