Data warehouse and Business intelligence (Sudanese electricity companies)

Abstract

The development of the business environment and technology in the world, The automation of systems which led to the accumulation of transaction data in the organizations and the need of information that enabling organizations to make tactical and strategy decisions that help them move forward to its goals, For that the need of business intelligence(BI) is came, BI help the organization in collection and integration the data from various sources and analysis it to help in extract information to help in decision-making. Sudanese power companies that follow to the Ministry of Electricity and Dams lack of integration between their systems and these companies have appreciable amount of data generated by their systems and it need system to help in the analysis of this data to produce information help in decision-making. The result of this study is provided BI system in accounting data that do integration between two companies from the electricity companies are Sudanese distribution electricity company (sedc) and the Sudanese thermal production company (stpc) to generate synthesis reports that help in decision-making by using the pentaho program, It is an open source program contains many build-in tools that help the developer to build business intelligence solution