Abstract Multidimensional data analysis can observe and process data from several angles, obtaining useful information for management decision-making departments and providing effective support by turning business data into management data. Based on SQL Server 2008 and adopting Multidimensional data analysis technology to statistic and analyze the Environmental Impact Assessment (EIA) basic data of electric industry, we can get the analysis results of the distribution situation, investment, resource consumption, pollutants, and the environmental impact of power construction projects in different periods and different regions so as to make users analyze the construction and development of electric industry from multiple angles and provide effective scientific decisive data support for environmental management and decision-making.