Data warehouse and OLAP technology applied in the financial analysis of listed company

Using Microsoft SQL Server 2005 as the technology platform of building data warehouse, this paper establishes data warehouse examples according to the financial ratios of listed companies, providing multi-level and multi-dimension data analysis for the managers, satisfying different levels of data queries, further improving the scientific decision-making level of listed companies operating.