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...

“ Aether's approach to couple innovative visualisation with high expertise manpower delivered valuable insights for our inventory work. ”

Umweltbundesamt (Germany)

“ 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

“ Aether delivered training workshops and generated learning materials for our SSN members, providing technical content in a manageable and comprehendible format. We particularly benefitted from their extensive knowledge and ability to interpret the needs of our members into the training materials. ”

Jennifer Anderson, Sustainable Scotland Network

“ The team at Aether works very professionally and communicates very well which makes working with them a pleasure. Outputs are delivered on time to high quality. The team brings the rigour of technical knowledge and expertise and finds innovative ways of communicating complex messages. I would be happy to recommend the Aether team to organisations working on analysing and presenting emissions information in the public domain. ”

Fiona Glover, States of Jersey

“ The professional service provided by your company was of very high quality and completed within agreed timelines. ”

Matthew Dudley, UNFCCC Secretariat

“ We have worked with Aether since 2019 to baseline, and subsequently update, our council and borough greenhouse gas inventories. It is a pleasure working with Aether’s professional, responsive, collaborative and helpful team. ”

Merton 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