Time to toss out your spreadsheets!

This is a big announcement, so let’s get straight to it. This week we launched a fully integrated business intelligence solution that allows you to slice, filter, and display your energy use data via dynamic visualizations.

To put this in plainer English: if you have a portfolio of buildings, you probably laboriously manage one or more spreadsheets to help you track some key metrics and maintain a broader view of your energy use. Well, the new Gridium dashboards are like those spreadsheets, except the data is always kept automatically up to date and the graphics are more powerful.

Dynamic visualizations

Our new dashboards include a customizable library of visualizations, including KPIs, charts, pivot tables, and more:

The example above shows year-to-date energy use for both electricity and gas vs. energy use during the same period a year ago. These are important metrics for many teams who are managing toward energy and cost reduction goals. The accompanying chart shows energy use over time.

Unlike spreadsheets, these visualizations are interactive. Select any building in the line chart, for example, to drill down to individual meters. Or filter the display along different dimensions to focus in on the data that is most interesting:

These portfolio-level summaries are especially useful for benchmarking. Calculate and sort according to intensity figures such as cost per square foot to understand which buildings are the likeliest source of savings:

More coming — feedback needed

Now that the basic infrastructure is in place for creating these dashboards, we can continue to roll out new data fields and new visualizations at a rapid pace. Take a look and let us know what you would most like to see. What would it take for you to scrap the spreadsheets you now have to maintain? What analyses would you like to see that aren’t even possible for you to generate yourself?

For some customers, we can also create custom dashboards with tailored visualizations and unique metrics. We may even be able to incorporate novel data sets so that you can perform bespoke analysis on your energy use. Get in touch to find out more.​

Available now

The new dashboards are generally available to all customers, although they remain a beta feature while we collect feedback. You can kick the tires by going to “Reports” and then choosing the “Dashboards” tab. Note that the dashboards include data downloads and other useful helper functions, so you can export the info for sharing, inclusion in reports, or further analysis.

About Adam Stein

Adam runs the product team at Gridium. Formerly he co-founded TerraPass, and before that worked at Tellme and Trilogy. He has an MBA from Wharton and a BS from Stanford, neither of which impress his young daughter.

0 replies on “Time to toss out your spreadsheets!”

You may also be interested in...

4CP Season 2024: A Look Back & Lessons Learned
4CP Season 2024: A Look Back & Lessons Learned

How did our new 4CP alerting service help Texas building operators and owners get ahead of costly demand charges this summer? Check out the results and learnings from another active, heatwave-y 4CP season in ERCOT territory.

Boosting Building Performance on a Budget: 4 Takeaways from BOMA 2024
Boosting Building Performance on a Budget: 4 Takeaways from...

Earlier this month, the Building Owners and Managers Association (BOMA) International hosted its 2024 conference in Philadelphia, PA. Here are a few of our takeaways from the event for those of you who couldn’t make it out! Focus on the…