General Motors (GM) has publicly committed to reducing its energy consumption, water consumption, and greenhouse gas emissions across its 118 U.S. sites. All sites were tasked with evaluating potential contributions to the goal, as well as mapping glide paths to the targets. To better facilitate and standardize this process, GM developed a new Energy and Carbon Optimization (ECO) Metrics Dashboard. The dashboard helps energy managers and plant leadership by tracking monthly performance for energy, water, and emissions and allows users to estimate site-specific potential savings from their existing project roadmap.
GM has pledged to reduce operational energy and water intensity by 35% by 2035 against a 2010 baseline. Before developing the ECO Metrics Dashboard, GM developed the Energy and Carbon Optimization (ECO) toolbox to organize energy management processes across their facilities. The ECO toolbox provided resources for plants to conduct energy treasure hunts and explore other savings strategies. The ECO Metrics Dashboard also provides a way to project and track progress based on ECO toolbox strategies.
The GM energy team started a collaborative project with the internal Manufacturing Engineering (ME) group to develop a dashboard that would serve as a data visualization tool for performance tracking against 2035 goals. The new dashboard, called the ECO Metrics Dashboard, is fed from a raw data download file generated within the GM Utility Billing Management (UBM) system and uses Microsoft’s Power BI (PBI) software. The design criteria used in the development of the ECO Metrics Power BI Dashboard includes the following data components and reporting functionalities:
Intensity-Based Metrics:
Glide Path for Energy, Water, and CO2e Metrics:
Automatic Multi-level Reports:
Simple Data Refresh Process:
Addition of Potential Savings Database:
The cross-team collaboration allowed GM to fully utilize the Power BI database management capability and skills of their employees. The project planning phase took two weeks followed by a two-month implementation phase to develop the dashboard itself. The project was completed at no cost because it used solely in-house resources. Working with existing data and resources greatly simplified the project, but the aggressive timeline added a layer of difficulty. To simplify the data refresh process and meet time requirements, the team decided to minimize manual data pre-processing and complete most calculations inside the dashboard. This required updating the source code, which was something the team had not previously done. While it increased the complexity of using the dashboard software, the outcome justified it.
Use of the ECO Power BI dashboard was meant to serve General Motor’s internal Energy team. After collecting and analyzing initial data, the team saw opportunity to benefit from broadening the intended audience. To ensure effective rollout and use of the Power BI dashboard, the ECO team solicited feedback on the user interface from internal customers across the manufacturing and non-manufacturing portfolios. The team ensured there was an array of user types included in the test group, ranging from Plant Directors to Engineering Managers, and Continuous Improvement Leads. Based on the feedback received, the ECO team was able to simplify the dashboard options and minimize the number of user selections to drill down to individual site information. Once the dashboard was streamlined, the ECO team integrated a rollout demonstration into existing forums that brought together various user groups.
GM used Microsoft Power BI, a data visualization software, to design and execute the ECO Metrics Dashboard. The source data represents actual invoice data stored in GM’s third-party bill pay system.
The ECO Metrics Dashboard enables staff to measure progress by showing consumption-based glide paths, a rolling 12-month performance chart, current year actuals, and GM’s 2035 target performance evaluations. These visualizations provide a means to monitor monthly progress and help identify gaps between actual monthly data and future targets. As plants improve through energy and emissions reduction projects, these impacts can be tracked and shared across the company. Incorporating savings from potential projects will also help plants make decisions to implement projects based not only on simple payback from utility savings but also on the impact of potential emission savings.
In addition to plant-specific metrics, the ECO Metrics Dashboard can also display data by business sector, country, and company-wide. Pareto charts were added to highlight plants with the biggest opportunities for improvement. Initial feedback received from plants and GM leadership indicates that the team exceeded the required objectives and unveiled a new perspective on existing data that could potentially change or impact GM’s ECO scorecard strategy.
Overall, the new ECO Metrics dashboard provides a variety of effective visualization tools to help plants, energy leaders, and GM leadership navigate their journey to achieve the company’s 2035 energy, water, and emissions reduction goals. Since the dashboard was designed to mesh with existing data systems, visualizations can be updated easily and aggregated to understand both plant-level and company-wide performance. Additionally, the dashboard’s ability to estimate potential savings from planned projects gives managers a powerful tool to prioritize project development and consider upgrades that could produce even greater energy, water, or emissions savings.