Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Energy - EU - ESG Reports #14

Open
igrypari opened this issue Nov 8, 2023 · 1 comment
Open

Energy - EU - ESG Reports #14

igrypari opened this issue Nov 8, 2023 · 1 comment
Assignees
Labels
Energy-EU-ESG report-request Requests to create/edit reports and charts.

Comments

@igrypari
Copy link
Collaborator

igrypari commented Nov 8, 2023

I would like to request additions to the Energy-EU report, in the tab “ESG Reports”. You have already received the data for this request

The user flow that leads to the report is the following:
Browse topics for Climate > EU > select category "Energy" > Overview

Charts:

Chart Group 1: ESG Reporting

Chart 1:
Title: Companies with ESG Reports by Turnover
Description: This chart ranks companies by turnover based on their published ESG reports. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2006 to 2022, covering around 150 companies. Datasource: Company Websites, Orbis.
Type: Bar Chart (ordered by turnover)
Indicator: I42, SV00
xAxisName: company
yAxisName: turnover
xColumnField: key
yColumnField: value
GroupByField:

Chart Group 2: ESG Metric Reporting Breadth

Chart 1:
Title: Top Companies by Number of ESG Metrics Reported
Description: This chart displays companies ranked by the number of ESG metrics reported in their filings. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2006 to 2022, covering around 150 companies. Data Source: Company Websites, Orbis.
Type: Bar Chart (ordered by number of metrics)
Indicator: I42B, SV06
xAxisName: company
yAxisName: # metrics
xColumnField: key
yColumnField: value
GroupByField:

Chart 2:
Title: Number of Metrics Reported by ESG Scope
Description: This chart shows the number of metrics reported, categorized by ESG scope. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2006 to 2022, covering around 150 companies. Data Source: Company Websites, Orbis.
Type: Radial Polar Chart
Indicator: I42B, SV17
xAxisName: ESG scope
yAxisName: # metrics
xColumnField: key
yColumnField: value
GroupByField:

Chart Group 3: ESG Metric Coverage Insights

Chart 1:
Title: Most Reported Metrics: Top 10 Metrics by Coverage
Description: This chart illustrates the top 10 most reported ESG metrics, based on coverage percentage. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2006 to 2022, covering around 150 companies. Data Source: Company Websites, Orbis.
Type: Horizontal Bar Chart
Indicator: I42C, SV18
xAxisName: metric
yAxisName: coverage percentage
xColumnField: key
yColumnField: value
GroupByField:

Chart 2:
Title: Least Reported Metrics: Bottom 10 Metrics by Coverage
Description: This chart highlights the bottom 10 least reported ESG metrics by coverage percentage. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2006 to 2022, covering around 150 companies. Data Source: Company Websites, Orbis.
Type: Horizontal Bar Chart
Indicator: Ι42D, SV18
xAxisName: metric
yAxisName: coverage percentage
xColumnField: key
yColumnField: value
GroupByField: metric

Chart Group 4: ESG Reporting Trends

Chart 1:
Title: Average Share of Non-null Metrics per Report by ESG Scope and Year
Description: This chart presents the average share of non-null metrics in ESG reports, segmented by ESG scope and year. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2006 to 2022, covering around 150 companies. Data Source: Company Websites, Orbis.
Type: Line Chart
Indicator: I42E, SV21
xAxisName: Year
yAxisName: Average Share (%)
xColumnField: key
yColumnField: value
GroupByField: ESG Scope

Chart Group 5: ESG Performance

Chart 1:
Title: Average ESG Score per Company by Scope and Year
Description: This chart illustrates the average ESG score per company, segmented by ESG scope and year. To calculate the ESG Score per Company and Year, the actual values of each ESG metric was ranked for each year, meaning that better performance on a metric will conclude to higher ranking. After that, the weight of each metric is calculated based on the coverage of the metric in the dataset. The higher the coverage of the metric, the higher its weight and all the weights sum up to 1. Finally, the weight is multiplied with the ranking and the final Score for each metric per Company and Year is calculated. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2006 to 2022, covering around 150 companies. Data Source: Company Websites, Orbis.
Type: Stacked Bar Chart
Indicator: I43, SV21
xAxisName: year
yAxisName: ESG score
xColumnField: key
yColumnField: value
GroupByField: scope

Chart 2:
Title: Average ESG Score per Company by Metric and Year
Description: This chart presents the average ESG score per company, broken down by specific metrics and year. To calculate the ESG Score per Company and Year, the actual values of each ESG metric was ranked for each year, meaning that better performance on a metric will conclude to higher ranking. After that, the weight of each metric is calculated based on the coverage of the metric in the dataset. The higher the coverage of the metric, the higher its weight and all the weights sum up to 1. Finally, the weight is multiplied with the ranking and the final Score for each metric per Company and Year is calculated. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2006 to 2022, covering around 150 companies. Data Source: Company Websites, Orbis.
Type: Stacked Bar Chart
Indicator: I43, SV18.01
xAxisName: year
yAxisName: ESG score
xColumnField: key
yColumnField: value
GroupByField: metric

@igrypari igrypari assigned igrypari and dtziotzios and unassigned igrypari Nov 8, 2023
@igrypari igrypari added report-request Requests to create/edit reports and charts. Energy-EU-ESG labels Nov 8, 2023
@dtziotzios
Copy link
Collaborator

Requested changes are deployed.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Energy-EU-ESG report-request Requests to create/edit reports and charts.
Projects
None yet
Development

No branches or pull requests

2 participants