Welcome to the AI ESG Report Builder repository! This project showcases the power of AI-ready data management by automating and enhancing Environmental, Social, and Governance (ESG) reporting. The solution leverages a combination of data from gather360, natural language processing with OpenAI's GPT, and Streamlit for an interactive user interface.
The AI ESG Report Builder tool is designed to simplify and improve the generation of ESG reports. ESG reporting is critical for companies to assess and communicate their impact on environmental, social, and governance factors. Traditionally, creating these reports is time-consuming and resource-intensive. Our solution automates this process, saving time and ensuring accuracy and consistency.
I’m Tony, the Applied AI Lead at a stealth startup in Dublin. Our mission is to make AI more robust and trustworthy by leveraging a unique data supply chain platform.
I work at a mission-driven company. We believe that data is key to successful AI business implementation. The current state of business data consistently falls short of what AI needs to deliver its full potential. This gap is where our data supply chain comes into play. We aim to create a consistent, reliable interface for accessing and utilising data, ensuring it is enriched with context, history, provenance, and attribution. This approach transforms data into a powerful asset that AI can leverage with confidence and trustworthiness.
Our thesis is simple yet profound: The right data unlocks AI's potential. By providing AI with well-structured, contextualised data, we can enable organisations to deploy AI solutions that are not only effective but also transparent and verifiable. This leads to better decision-making, optimised operations, and greater success. We want to democratise AI by making it easier for organisations without deep AI expertise to realise its benefits.
- Data Integration: Connects to gather360 to fetch survey data.
- Data Processing: Processes survey data to generate detailed reports.
- AI-Powered Reporting: Uses OpenAI's GPT to create comprehensive ESG reports.
- User-Friendly Interface: Built with Streamlit for easy interaction and report generation.
- Input Credentials: Users input their gather360 and OpenAI credentials via the Streamlit sidebar.
- Fetch Data: The app fetches survey data from gather360.
- Process Data: Processes the data according to predefined mappings of questions and answers.
- Generate Report: Uses OpenAI's GPT to generate a detailed ESG report, comparing selected company data with cohort data.
- Download Report: Users can download the generated report in Markdown format.
- Streamlit Interface: For user input and report generation.
- gather360 Connector: For fetching survey data.
- Data Processing Functions: To handle and process survey responses.
- OpenAI Integration: For generating narrative reports based on processed data.
You can directly use the app without cloning the repository by visiting the web app page.
If you still want to run it locally, follow these steps:
-
Clone the repository:
git clone https://github.com/tonyohalloran/ESG-Solution.git cd ESG-Solution -
Install the required packages:
pip install -r requirements.txt
-
Run the Streamlit app:
streamlit run app.py
Sign Up for gather360 Trial
- Visit gather360: Go to the gather360 signup link
- Sign Up: Sign up for a trial account by providing the required information.
- Activate Account: Check your email for an activation link and complete the registration process.
- When you create the workspace, ensure to leave 'Workspace table prefix' blank.
Access the ESG Recipe on gather360
- Login: Login to your gather360 account.
- Go to 'Datasets' tab and then select 'Open Marketplace' when you land on the home workspace in g360 after first sign-in
- Navigate to the Data Solutions tab
- Select the "ESG Investor Reporting" solution.
- Press install and wait for 3 to 4 minutes while the recipe downloads
- Once completed, navigate back to the home workspace and go to the "Live" tab
- See the 7 datasets that form the ESG Analysis data model
- Sample data has been loaded as part of the installation process
Obtain gather360 Credentials
- Go to Settings: In gather360, navigate to the 'Workplace Settings' section and then select 'Connection'.
- API Keys: Locate the API keys section to find your credentials (user, password, account, warehouse, database, schema).
- Obtain OpenAI Credentials
- Visit OpenAI: Go to the OpenAI website.
- Sign In/Sign Up: Sign in to your account or sign up if you don’t have one.
- API Keys: Navigate to the API section to retrieve your API key.
- Unless you have specified otherwise, the account is 'yi47469.north-europe.azure'
- Input Credentials: Enter your gather360 and OpenAI credentials in the sidebar.
- Select Company: Choose the company for which you want to generate the report.
- Generate Report: Click on 'Generate Report for Selected Company' to create a report.
- Download Report: Once generated, download the report as a Markdown file.
gather360 is our innovative data supply chain platform that ensures data is enriched with context, supply status and attribution. This approach transforms data into a powerful asset that AI can leverage with confidence and trustworthiness. By providing AI with well-structured, contextualized data, we enable organizations to deploy AI solutions that are not only effective but also transparent and verifiable. This leads to better decision-making, optimized operations, and greater success.
We welcome contributions from the community. If you have suggestions or improvements, please create a pull request or open an issue.
We are building a community of AI and data enthusiasts committed to advancing AI through better data. Join us to share ideas, discuss challenges, and develop solutions together. Together, we can unlock the full potential of AI for businesses worldwide.
This project is licensed under the Apache 2.0 License. See the LICENSE file for details.
Be the first to experience the transformative power of our AI-ready data platform. Join the waitlist.