We use cookies to operate our site, help keep you safe, improve your experience, perform analytics, and serve relevant ads. Click on 'I accept' to accept all cookies.

Microsoft Power Query for Quantity Surveyors

Course Description

Microsoft Power Query is a powerful data connectivity and transformation tool within Excel that allows participants to seamlessly connect, clean, manipulate, and analyze vast amounts of data from various sources with efficiency and precision.

This course offers an exploration of Power Query’s robust features, designed to streamline and enhance the tender evaluation process. Over the span of four in-depth sessions, participants will gain hands-on experience in importing, cleaning, and transforming tender data, utilizing advanced data analysis techniques that ensure accuracy and cost-efficiency. Additionally, the course will guide participants in creating dynamic, refreshable reports, crucial for ongoing project management and tender reassessment.

By the end of this training, participants will be equipped with the skills to integrate Power Query into their existing workflows, automating and optimizing key processes to drive more informed decision-making. This course not only enhances their technical capabilities but also empowers them to contribute more effectively to their organization’s success in managing tenders and projects.

 

 

COURSE OBJECTIVES

 

  • Equip Quantity Surveyors with the ability to efficiently import, clean, transform, and analyze tender data using Power Query.
  • Enable participants to apply advanced data analysis techniques to streamline the tender evaluation process, ensuring accuracy and cost-efficiency.
  • Develop skills in creating dynamic, refreshable reports that aid in ongoing project management and tender reassessment.

 

 

VENUE

 

The training topics will run as VILT (virtual instructor-led training) via Microsoft Teams.

Schedule

October 2024: 8, 15, 22, 29
Time: 2:00 - 4:00 PM (Beirut Time)

Topics

Introduction to Power Query and Basic Data Handling

Comprehensive Data Transformation

Data Analysis Techniques and Reporting

Applying Power Query in Tender Evaluation
 

 

Contact us
at DGJ Academy

For more information about the courses, fee structures and dates, or to discuss tailored training programmes, call us on: