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

“ We have been collaborating with Aether for several years, and our projects have greatly benefited from it. Aether staff are very knowledgeable, professional and flexible - and last but not least, very friendly and a pleasure to work with. ”

Umhverfisstofnun, Environment Agency of Iceland

“ Both the face-to-face training and the online version have been of high quality, with dynamic methods and a practical orientation that have allowed students to reach a solid knowledge base. The products have been delivered within the stipulated deadlines with an excellent quality and the team has always shown willingness to make adjustments according to the requirements of CONAF. We are very satisfied with the work. ”

Javier Cano Martín, Professional Unit for Climate Change and Environmental Services, CONAF (National Forestry Corporation), Chile

“ 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

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

Matthew Dudley, UNFCCC Secretariat

“ If we have a need for any more reports in the future Aether will be first on my list. ”

Alan Hardy, Kyson Design

“ The support provided by Aether for this project was especially remarkable considering the situation of the COVID-19 pandemic. The tools and methods used in order to engage local stakeholders really added value to the capacity building of the national team. ”

Shanna Emmanuel, Saint Lucia BUR Project Coordinator

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