Diseño de una propuesta de mejora para el procesamiento, análisis y presentación de la información en el área de Trading agregados de Cemex Colombia mediante el software Power BI

Abstract

Cemex is a global leader in the building materials industry with more than 100 years of experience and presence in more than 50 countries. Cemex is a network of operations that produces, distributes, and markets cement, ready-mix concrete, aggregates, and other related products. The Trading Agregados area of Cemex Colombia is in charge of managing negotiations on purchases, sales, logistical issues and volumes of material, acting as an intermediary between suppliers and customers, subsidiaries and third parties around the aggregates. This area handles large volumes of data with multiple characteristics that are constantly generated about costs, prices, and product volumes that reflect in real time the situation of the aggregates business at the national level. In this order of ideas, it is important to consider a tool that allows to visualize the data and to share information with the whole organization in a fast and opportune way, which makes possible to connect to multiple data sources and to create reports in real time about the business when delivering statistics that allow to measure the results and to find opportunities of improvement. The Power BI business intelligence tool offers the possibility of accessing information requirements and timely satisfies the need to generate reports quickly, visually and dynamically, so that they are always available to the area and also to other interested parties of the organization reports and reports with valuable information about the processes of purchases and sales of aggregates, thus becoming a key tool for making decisions in an accurate and justified way that leads to improved performance and management of the area.