Energy Consumption Monitoring and Simulation System Using Power BI Applied to Industrial Processes

Abstract

This work developed a system to monitor and simulate the consumption of water, energy, and firewood using Power BI as the main platform. The data, initially organized in SharePoint spreadsheets, were processed in Power Query and arranged in a dimensional model that enabled the calculation of specific consumption indicators and the tracking of energy performance over time. During prototyping, it became clear that small changes in the production process can considerably affect total consumption, reinforcing the need for continuous monitoring. The dashboards designed for the project made these variations easier to visualize and helped highlight points that require attention or improvement. Even so, the model still relies on manually entered data and does not include several operational variables that influence consumption, which limits its accuracy. Moving forward, the project will need automated data collection, the integration of sensors or external APIs, and security mechanisms such as Row-Level Security (RLS). Migrating the solution to Power BI Service is also an important step toward adapting the prototype for use in an actual industrial environment.