News

Power Query Workshop in Estonia

18 May 2026

Aether delivered a two-day workshop in Estonia to build the inventory team’s capacity on Excel power queries.

Estonia is required to annually report GHG emissions data to the European Union and under the United Nations Framework Convention on Climate Change (UNFCCC). Since Aether set up the spreadsheet-based GHG inventory files, the GHG inventory team has experienced challenges with running the power queries that automate data flows in the files. This has included staff changes and changes to activity data collection templates in recent years.

The inventory team also wanted to improve their use of Aether’s key category analysis tool set up to help automate the process of determining key categories in Estonia’s inventory, as well as to gain an improved understanding of the available QA/QC tools to improve the inventory’s QA/QC procedures.

The workshop focused on providing detailed practical training on the power query editor, in the context of Estonia’s inventory files. Over the course of the two days, the inventory team developed expertise in building power queries that have improved flexibility to respond to template changes over time.

The Aether team presented and demonstrated their bespoke key category analysis and Q-Comments tools to showcase potential options to simplify the inventory team’s reporting of key categories and QA/QC procedures.

From the feedback received, the Estonian GHG inventory team now have an improved understanding in building and editing power queries in the inventory files to automate the flow of activity data into the compilation files and have the confidence to use Aether’s KCA and Q-Comments tools.

See all news


News topics

Aether Blog Air Pollution Air Quality Assessments Barriers to Net Zero Capacity Building Carbon Footprint Climate Emergency Climate Equality Climate Finance Consumption COP28 Culture Data Visualisation Economic Status Emissions Reporting European Topic Centre GHG Infrastructure Inventories Local Government Mitigation MRV National Government Net Zero Oxfam Paris Agreement Policy Recruitment Society Stakeholder Engagement Waste Sector Wider Impacts

Testimonial

Don't just take our word for it...

“ The Aether team were a joy to work with and I would recommend the consultancy - the service provided throughout the process was exceptional. ”

Clare Bayley, Defra

“ Professional team and very collaborative communication. Effective result in terms of suggestions for improvement in the quality of the inventory and proposals on how to streamline specific topics. ”

Italian Institute for Environmental Protection and Research

“ Aether is a great partner for work in the area of European Air Emissions. The team was committed, reliable, well organised and had a deep technical understanding and motivated other partners with their good spirit. ”

Umweltbundesamt: Environment Agency Austria

“ Saint Lucia embraces the professional approach with which this project was undertaken by Aether, particularly their ability to develop mentorship relations with local government experts. This provides a basis for ensuring that the pool of local experts remain engaged and recognized over successive processes. ”

Annette Rattigan-Leo, Chief Sustainable Development and Environment Officer

“ It is always an absolute pleasure working with Aether. I always know what is expected of me. Their work ethic is of a very high standard and projects are always handled in a very professional manner. I have learnt many skills in terms of project management, quality control and workshop training styles from Aether and I hope to carry these principles forward in my own work. I look forward to collaborating with Aether more in the future. ”

Luanne Stevens, Gondwana

“ From their winning bid to final delivery, Aether's work with North Norfolk District Council was positive and thorough. They brought a clear understanding of the challenges local authorities face regarding carbon emissions and quickly understood the unique nature of the Coastwise project. Communication was effective, and the outcomes combined a depth of research with real-world utility for the council's activities around carbon emissions and mitigation. ”

Alastair Zangs, North Norfolk District Council

Contact us

Get in touch

Call us on +44 1865 259 200, complete the short form below, or go to the Contact page

Aether would like to keep in touch with you via email with news and updates. Please be assured that we'll treat your information with the utmost care and will not share it with other companies for marketing purposes. See our privacy policy.

Newsletter