As Facilities Intern, Neha Miryala Builds Dashboards to Raise Awareness 51视频 Campus Energy Consumption

A young woman in a black and white striped shirt looks at a monitor while working on a laptop while sitting at a desk near a window. Image by Ed Brennen
Computer science graduate student Neha Miryala checks a campus building energy dashboard page that she developed as an intern with Facilities Management.

10/18/2024
By Ed Brennen

Neha Miryala was looking for work that would enhance her data analytics and visualization skills while she pursues a master鈥檚 degree in computer science at 51视频.聽

UML Energy Manager Daniel Abrahamson needed someone to build to display the real-time energy use, cost and emissions information on campus 鈥� and to develop a data warehouse that could be used to help the university improve operational efficiency.

An internship with Facilities Management proved to be a perfect match.

Miryala, a graduate student from Hyderabad, India, has spent the past year working with Abrahamson on new energy dashboards designed to raise student awareness of their carbon footprint and promote energy efficiency.聽

The dashboards will be featured on Hawki monitors in the university鈥檚 10 residence halls, showing real-time electric and natural gas consumption for each building and offering energy-saving tips.聽

Miryala also created a scorecard system for residence halls that tracks the monthly electric cost per resident. The scorecards can be used for future energy-saving competitions, perhaps hosted by Residence Life or the Office of Sustainability.

Two young people walk past a monitor on a wall in the lobby of a college residence hall. Image by Ed Brennen
Students walk past the new residence hall energy scorecard in the first-floor lobby of Fox Hall. The scorecard was part of Neha Miryala's dashboard work.
鈥淚 was excited to get this opportunity,鈥� says Miryala, who works 15 hours a week as a Facilities intern. 鈥淚t鈥檚 a project that makes my profile stronger, and I enjoy working with real-time data that can actually make a difference.鈥�

The project began last fall with the Wannalancit Mills building on East Campus, where Miryala collected a year鈥檚 worth of energy data from Automated Logic, the university鈥檚 building management system. Because electric meters can sometimes malfunction, Miryala had to clean the data before creating a beta version of the dashboard with the data visualization tool Tableau.

When the project shifted to the 16 buildings on North Campus, she switched to ArcGIS Online, a geographic information system (GIS) platform that allows for more flexible and dynamic dashboards.

鈥淚f you want to see energy data for Ball Hall or Cumnock Hall, you can select that building on the dashboard,鈥� Miryala explains. 鈥淭he dashboard is dynamic, so anyone can explore energy trends for the past year, month or day.鈥�

Meanwhile, Miryala used Microsoft SQL Server, a database management system, to build a data warehouse on the back end to store all of the university鈥檚 energy data. The SQL Server will automatically feed data to the dashboards and support future analytics that can lead to further improvements and efficiencies.

A man in business attire smiles while pointing to a laptop screen while standing next to a young woman in an office. Image by Ed Brennen
Energy Manager Daniel Abrahamson has worked with computer science graduate student Neha Miryala, a Facilities Management intern, for the past year on the energy dashboard project.
Miryala hopes the dashboards will encourage students to think more about sustainability. Rather than show them how many kilowatt hours (kWh) of electricity their residence hall uses, Miryala integrated the Environmental Protection Agency鈥檚 online to show the consumption as a measure of the number of smartphones charged. For instance, University Suites consumed nearly 110,000 kWh of electricity in September, which is the equivalent of charging 2.9 million phones.

鈥淲e wanted to make the data relatable to students to help them understand the impact of their energy use,鈥� says Miryala, who notes that the project has reinforced her own environmental awareness.

The internship has also given Miryala invaluable experience in both front-end data visualization and back-end data engineering. Her work with ArcGIS and building the SQL Server data warehouse 鈥渇rom scratch鈥� has helped her develop skills that she hopes to use in a future career as a full-stack developer or data engineer.

鈥淚 feel so honored to work on this project,鈥� she says. 鈥淚t鈥檚 been a great learning experience, and I鈥檓 excited to see how it helps the university achieve its sustainability goals.鈥�

For Abrahamson and the Facilities Management team, having a talented student like Miryala has been a major asset.

鈥淪he鈥檚 done a phenomenal job,鈥� Abrahamson says. 鈥淲e鈥檙e excited to see how this dashboard will make a difference for the campus community.鈥�

Share