Analysing VE results using Google's powerful suite of data analysis, visualisation and productivity tools

  Enroll in Course

This course is designed to show you how to use the powerful suite of free tools in the Google Apps environment. Google has a range of smart data analysis, visualisation and productivity tools available, all of which are completely online. We show how to analyse your VE project data in Google Sheets, Google Data Studio and the Explorer data analysis feature (beta):

  • Set-up and run a basic VE model and view results in Vista Pro
  • Run a python script to export and format your results into an Excel Workbook
  • Add the Excel workbook to your Google Drive account
  • Set-up a Google Sheet, import your VE data and specify sharing and editing permissions
  • Using Google Sheets to analyse your VE data
  • Using the new Explorer feature (beta) in Google Sheets to automate your data analysis and visualisation
  • Create and explore geographic data
  • An introduction to Google Data Studio
  • Getting started with importing data into Google Data Studio and creating your first reports

The power of the G-Suite of online apps is vast and expanding at a rapid rate. Google has released dozens of productivity apps which can assist your data analysis, visualisation, exploration and management of your large project data sets. It is relatively simple to link your live Google Sheet to multiple colleagues and project team members whilst allowing Google Apps to automate a lot of the ‘discovery’ in your data. This is a hugely exciting area for anyone looking to maximise their workflow and get up to speed with a range of new digital tools.

Your Instructor

Dr. Naghman Khan
Dr. Naghman Khan

Dr. Naghman Khan has been working in the field of building simulation, performance modelling and data visualisation for over 10 years. Naghman has been working with IES for 4 years and was previously an Energy and Data consultant for the NHS, Higher Education sector and commercial real estate. Naghman is also a user of multiple data visualisation software tools including Tableau, IBM Watson, the IESVE and many more. He is Secretary of the CIBSE Building Simulation Group and co-author of CIBSE AM11: Building Performance Modelling. He has combined his passion for big data and data visualisation with simulation and modelling and regularly discusses these topics on his Vizfully blog.

Frequently Asked Questions

When does the course start and finish?
The course starts as soon as the purchase is made and never ends as your yearly subscription will automatically renew each year.
What if I want to cancel the course?
No problem, you can cancel your course subscription at any time and the year access that you have paid for will not end until the year is up.
Any other questions?
If you have any other questions please contact our training team via [email protected]

Get started now!