PAINÉIS DOS VALORES PAGOS PELO PROGRAMA NACIONAL DO LIVRO DIDÁTICO DO MEC UTILIZANDO BUSINESS INTELLIGENCE

Abstract

Theme: The historical panel of National Program for Books and Didactic Material (PNLD) of Ministry of Education (MEC) aims to assist the Negotiation Commission (CEN) in decision-making during annual negotiation period for the purchase of material didactic for all Brazilian public schools. Objective: To avoid acceptance of prices higher than estimated and allow control over the price suggestion during purchase negotiations, based on history of previous years. Methodology: Through Business Intelligence techniques using understood as data extraction and treatment, with appropriate use of specific tools panels were created with various indicators, such as General Values, Components, Publishers, among others. Results: The commission obtained historical data of pricing visualization, quantity and other essentials essential to guarantee reliability in the price suggested by participating publishers. Final considerations: For purchase of textbooks negotiation each year, the panels developed in this research will serve as input to support pricing decision. The user-friendly visualization of data masses provides program manager with an understanding of results obtained and progress of the program, as well as providing transparency throughout processes, both for higher entities of the agency as well as for Brazilian taxpayer.