SG Analytics Interview Questions, Process, and Tips

Environmental, social, governance (ESG) refers to the three central factors in measuring the sustainability and ethical impact of an investment in a company.

• Environmental factors focus on a company's impact on the environment, such as carbon emissions, waste management, and resource conservation.

• Social factors assess how a company manages relationships with employees, suppliers, customers, and the communities in which ...read more

The most recognized certification company for Environmental compliance and Health & Safety management is ISO.

• ISO 14001 certification for Environmental compliance

• ISO 45001 certification for Health & Safety management

• Other relevant certifications include OHSAS 18001 and ANSI/AIHA Z10

Independent board members are not affiliated with the company, while dependent board members have ties to the company.

• Independent board members are considered to be more objective and less influenced by company interests.

• Dependent board members may include executives, shareholders, or individuals with close ties to the company.

• Independent board members are often brought in to provide unbiased perspectives and oversight...read more

Documents considered in ESG Research process include company reports, sustainability reports, industry publications, and third-party research.

• Company reports such as annual reports and financial statements

• Sustainability reports detailing environmental, social, and governance practices

• Industry publications providing insights on ESG trends and best practices

• Third-party research reports from organizations like MSCI or Sus

VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from another column.

• VLOOKUP stands for 'vertical lookup'

• It is commonly used to search for a value in the leftmost column of a table and return a value in the same row from a specified column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searches for t...read more