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

“ 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

“ 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

“ Engaging Aether to support us to develop the first GHG Inventory System and first Nationally Determined Contribution (NDC) for the United Republic of Tanzania has been a rewarding experience due to their high level of professionalism, creativity, timeliness and value for money. We will definitely consider Aether in our future initiatives. ”

Abbas Kitogo, Programme Specialist Energy and Climate Change, UNDP Tanzania

“ A heartfelt thank you to all the Aether team for this very comprehensive review – this is certainly turning out to be one of the most beneficial capacity building projects I have ever been involved in. ”

Saviour Vassallo, Senior Environment Protection Officer, Malta Resources Authority

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

Umweltbundesamt (Germany)

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

Alan Hardy, Kyson Design

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