Decision support systems provide the field of query optimization with increasing challenges in the traditional questions of selectivity estimation that can exploit transformations without exploding search space. The aims of this paper are to understand what the data warehouse and protect the sensitive information stored elsewhere in data warehouse. In the system, management level of system can review all records of historical data for monthly or yearly as user desired item for each dimension. This system is developed to easy access for frequently needed data, to improve end-user respond time. The paper results in accumulation of growing amounts of data in operational databases. The system can help to retrieve complex query analysis report. In this paper, we analyze personnel information by using Data Warehouse and OLAP tools.