Tutorial
Create custom Envizi Power BI report for social and governance metrics
Capture social and governance metrics using IBM Envizi and create detailed Power BI reports from this dataIn today’s business world, Environmental, Social, and Governance (ESG) factors are more critical than ever. While environmental and governance issues often get the most attention, the social aspect—which includes the human elements related to society, communities, and individuals—is equally important. Tracking and analyzing social metrics provides valuable insights into areas such as employee engagement, human rights, health and safety, training programs, gender pay gaps, and diversity, equity, and inclusion.
IBM Envizi helps organizations capture these essential social and governance metrics. With Envizi, companies can collect data on important social aspects, such as employee onboarding and offboarding, and issues related to modern slavery. This data can be transformed into detailed and actionable Power BI reports, enabling organizations to make better decisions and foster a more socially responsible and inclusive workplace.
In this tutorial, we will explore how organizations can capture social metrics related to employee onboarding and offboarding, as well as aspects related to modern slavery, and create comprehensive Power BI reports from this data.
To get more information about IBM Envizi or to try it out yourself, start your 14-day IBM Envizi ESG Suite trial. You can also request a personalized IBM Envizi demo.
Prerequisites
- Ensure you have access to an Envizi instance with the
Account Style Wizardenabled. - Confirm that you have the
PowerReport Editwork role added.
Steps
Step 1. Enable social metrics
To display social metrics-related data in the monthly dataset of the Power BI report, you need to enable social metrics in the Organization Settings. Request the Product team to enable social metrics in the Organization Settings of the Power BI report.

Step 2. Create account styles
Create account styles for the social metrics-related data. Let's create three account styles with the following information.
Account Style 1: Emp Hires
This account style helps to maintain the Employee Engagement details of the organization. It contains information such as gender, total employee count, age-wise count, and the number of employees joined, relieved, and dismissed.
Go to
Admin>Account Style Wizard.
Create an account style with the following settings:
- Scope: Social Metrics
- Data Type: People - Headcount [Number]
- Primary Column: Qty
- Secondary Columns: Gender, Age-21-30, Age-31-40, Age-41-50, Joining, Leaving, dismissed (Fired)


Account Style 2: Modern Slavery
This account style helps to maintain the modern slavery details of the organization. It contains information such as forced labour, child labour, others, and country details.
Create an account style with the following settings:
- Scope: Social Metrics
- Data Type: People - Headcount [Number]
- Primary Column: Forced Labour
- Secondary Columns: Forced Labour, Child Labour, Others, Country
You can create the required fields in the account style as shown in the following figure.

Account Style 3: Forest Conservation
This account style helps to maintain the forest conservation details of the organization. It contains information such as converstation type, conservation area name and area details.
Create an account style with the following settings:
- Scope: Social Metrics
- Data Type: Social Metrics
- Primary Column: Area
- Secondary Columns: Conservation Type, Area Name, UnitOfMeasure
You can create the required fields in the account style as shown in the following figure.

Step 3. Create accounts
Create accounts with the account styles created above, as shown in the following figures:



Follow these steps:
Download the following sample files:
Make the required changes such as updating
Organization,Organization LinkandAccount Style Linkcolumns.Upload the files. Go to
Manage>Data Files>Upload Files screen.
Step 4. Create Power BI report
After the account styles are created, wait for a day for the daily refresh to occur. This allows the newly created account styles to be reflected in the Monthly Data Set of the Power BI report.
The account styles we created will be visible in PowerReport after a day.

View the Social Metrics PowerReport as shown below.



Useful resources
Summary and next steps
In conclusion, IBM Envizi ESG Suite provides a comprehensive solution for creating custom PowerReports with the social and governance data of your organization.
To get more information about IBM Envizi or to try it out yourself, start your 14-day IBM Envizi ESG Suite trial. You can also request a personalized IBM Envizi demo.