Energy Consumptions Dashboard in Power BI

The Energy Consumptions Dashboard in Power BI is a reporting tool that tracks, analyzes and helps optimize electricity, gas and water consumption across multiple cities, buildings and time periods. It is built for facility managers, sustainability teams and business leaders. It turns raw usage data into clear visuals of total cost, units consumed, cost per unit and consumption trends, so you can make data-driven decisions on energy efficiency and cost savings.

Key Features of the Energy Consumptions Dashboard in Power BI

Step-by-Step Data Transformation

• Uses Power Query to clean and transform raw data into structured, meaningful insights.
• Removes data inconsistencies and keeps reporting accurate.

Fact and Dimension Relationships

• Sets up clear relationships between fact and dimension tables for accurate data modeling.
• Allows easy filtering by City, Building, Consumption Type and Date through slicers.

Advanced DAX Measures

• Uses DAX (Data Analysis Expressions) to calculate total energy consumption, cost per unit, and monthly and yearly variances.
• Supports custom measures for forecasting future energy trends.

Interactive Navigation and Bookmarks

• A navigation bar with bookmarks and page navigators lets you switch between the Overview, Electricity, Gas and Water consumption reports.
• Drill down into specific energy sources for in-depth insights.

Dynamic Filters and Slicers

• Filter data by consumption type (Electricity, Gas, Water), city, building and time range.
• Spot energy usage patterns across different locations.

Comprehensive Visualizations

• Total Cost by City Map – shows how energy cost is distributed across cities.
• Total Cost by Consumption Type – compares the cost of electricity, gas and water.
• Trend and Forecast Analysis – tracks energy cost trends over time with predictive analytics.
• Total Cost by Building – highlights building-level energy costs to support cost-saving strategies.

Comparative Analysis of Energy Sources

• Separate dashboards for Water, Electricity and Gas, each with detailed reports.
• Key insights into total cost, unit consumption and cost per unit for each energy type.

Summary and Business Insights

• A summary panel gives high-level insights, including the most expensive energy source and the highest-cost city.
• Helps businesses reduce energy wastage and put cost-saving strategies in place.

What’s Inside: Report Pages

All pages are linked through the navigation bar and bookmarks, and can be filtered by city, building, consumption type and date.

Why Use This Dashboard?

• Monitor and control energy expenses across locations.
• Identify high-cost areas and reduce energy inefficiencies.
• Analyze trends to predict future consumption.
• Improve sustainability efforts by tracking and managing energy consumption effectively.

Who It’s For

• Facility managers who need to compare energy costs across buildings.
• Sustainability teams working on energy consumption analysis and efficiency goals.
• Business leaders who want a clear view of energy spend by city and energy source.
• Organizations running multiple locations that want electricity, gas and water data in one Power BI report.

How to Use It

1. Load your energy data into the dashboard; Power Query cleans and transforms it into a structured model.
2. Open the Overview page to see total cost by city, consumption type and building, plus trends and the forecast.
3. Use the slicers to filter by city, building, consumption type and date range.
4. Use the navigation bar to move to the Electricity, Gas or Water pages for detailed analysis.
5. Review the summary panel to find the most expensive energy source and the highest-cost city, then plan cost-saving actions.

Click here to read the detailed blog post Energy Consumptions Dashboard in Power BI

Watch the step-by-step video tutorial: Energy Consumptions Dashboard in Power BI

Frequently Asked Questions

What does the Energy Consumptions Dashboard in Power BI track?

It tracks electricity, gas and water consumption, showing total cost, units consumed, cost per unit, and monthly and yearly variances across cities, buildings and time periods.

Can I filter the data by location?

Yes. Slicers let you filter by city, building, consumption type (Electricity, Gas, Water) and date or time range.

Does the dashboard include forecasting?

Yes. The Trend and Forecast Analysis visual tracks energy cost trends over time with predictive analytics, and custom DAX measures support forecasting of future energy trends.

How is the data prepared?

Raw data is cleaned and transformed with Power Query, then organized into fact and dimension tables with clear relationships for accurate data modeling.

Are there separate reports for each energy type?

Yes. Alongside the Overview page, there are dedicated Electricity, Gas and Water pages, reachable through the navigation bar and bookmarks.

What insights does the summary panel provide?

The summary panel highlights high-level insights such as the most expensive energy source and the highest-cost city, helping you reduce energy wastage.

Also check our Inventory Management Form in Excel

Last updated: October 2026