Jump to content
Click or hover over image to zoom in

PS Hack 8 - Challenge 13 - Emissions Tracker

Free
The first part of this challenge is to visualise the emissions associated with with vehicle and flight travel. Vehicle emissions can be extracted from the expenses data. Based on the logic recorded by the challenge sponsor,  you should report:

Total Own car emissions (CO2e) 
Total Own car energy (kWhr) 
Total Vehicle rent and running emissions (CO2e) 
Total Vehicle rent and running energy (kWhr) 

Emissions should be reported by project, cost centre and location where possible. Flight data reports an associated emission with each flight and should be reported similarly to vehicle data, along with any suitable geographical insights.

The second part of this challenge is to build a data capture tool to record relevant data for the reporting of emissions. It is suggested that this would be a Microsoft PowerApp.

The structure of the data captured should be consistent with the visualisations created in Part 1, but should also strive for a gold standard of environmental reporting for business related travel, i.e. you should liaise with the challenge sponsor if possible to ensure all that their "dream data scenarios" are catered for.
CHALLENGE 13.pptx Demo Data.xlsx Demo Solution.txt

 Share

About PS Hack 8 - Challenge 13 - Emissions Tracker

The first part of this challenge is to visualise the emissions associated with with vehicle and flight travel. Vehicle emissions can be extracted from the expenses data. Based on the logic recorded by the challenge sponsor,  you should report:

Total Own car emissions (CO2e) 
Total Own car energy (kWhr) 
Total Vehicle rent and running emissions (CO2e) 
Total Vehicle rent and running energy (kWhr) 

Emissions should be reported by project, cost centre and location where possible. Flight data reports an associated emission with each flight and should be reported similarly to vehicle data, along with any suitable geographical insights.

The second part of this challenge is to build a data capture tool to record relevant data for the reporting of emissions. It is suggested that this would be a Microsoft PowerApp.

The structure of the data captured should be consistent with the visualisations created in Part 1, but should also strive for a gold standard of environmental reporting for business related travel, i.e. you should liaise with the challenge sponsor if possible to ensure all that their "dream data scenarios" are catered for.

CHALLENGE 13.pptx Demo Data.xlsx Demo Solution.txt

×
×
  • Create New...