Presentations/Papers

Use Case: SWIFT AI Custom Solution for ESG Reporting Automation

Background

An Environmental, Social, and Governance (ESG) company faced a significant challenge in automating their ESG reporting processes. This company needed to calculate total amounts for various ESG metrics from data generated by Oil & Gas (O&G) activities for their clients. The data was scattered across multiple disparate spreadsheets, each with different formats and measurement units. Previous attempts by several companies to develop a solution had failed, leading the ESG company to turn to SWIFT AI for a custom solution.

Objectives

  • Automate the extraction and aggregation of data from various spreadsheets.
  • Standardize the data formats and measurement units.
  • Calculate accurate total amounts for ESG reporting.
  • Seamlessly integrate the solution with the existing ESG reporting software.

Challenges

Data Disparity: The data was in numerous spreadsheets, each with different structures, formats, and measurement units.

Complex Calculations: The required calculations were complex due to the diverse nature of the data.

Integration Needs: The solution had to integrate smoothly with the existing ESG reporting software.

Solution by SWIFT AI

SWIFT AI tackled the problem with a multi-step approach.

Data Ingestion and Standardization

Data Processing: We wrote scripts to import spreadsheet data into a database with populated encodings and formats that SWIFT LLMs can read. This automated data processing imports the spreadsheets regardless of format type e.g. pdfs, word, .txt, etc.

Calculation Engine and Logic: SWIFT developed specific features that work with LLMs to conduct a powerful core AI capability called data extraction providing structured data extraction from unstructured data e.g. text content, tables, docs, etc. in a LLM compatible format as well as traditional relational databases.

This engine performs all mandatory calculations to aggregate the data into total amounts required for ESG metrics. Clients could extract specific data from compliance report documents and combine it with fuel usage data from spreadsheets to calculate emissions at various scope levels,

as well as waste metrics. Instead of having employees sift through hundreds of reports to find specific numbers with varying terminologies, SWIFT AI could retrieve the most relevant figures from these documents in seconds, using either a simple script or a prompt. The output format could also be customized, including a summary of available data points and citations of the document name and page number.

AI Inference Deployment: Once specific data extraction was operational, the solution could be deployed in various ways depending on the user context. Initially, the client wanted a customer success manager to be able to request data transformations using natural language. As a result, SWIFT first developed a natural language interface extending from an API endpoint, which could later be integrated into a custom solution.

Normal Language Interface: We developed an interface that allows users to enter prompts to manage the necessary coding, eliminating the need for specialized skills like advanced Excel or SQL commonly used by database administrators and data scientists.

Automated Data Extraction: Once the calculations and output format met the client’s requirements using the natural language interface, SWIFT packaged the files and AI into a container for custom deployment as a microservice and to handle LLM calls via an API endpoint. Since the client had predefined the calculations and unit conversions they needed, SWIFT AI developed custom features to automatically extract data from various spreadsheets, regardless of format. This functionality could be triggered either by a button or a prompt, streamlining the process within the deployed solution.

Context and Error Handling: Built-in error handling ensured that any data discrepancies or anomalies were automatically flagged and addressed. Additionally, SWIFT implemented guardrails as requested, so that if a prompt to the LLM was outside the scope of the functionality or lacked sufficient information/data, the LLM would provide a default response. This was achieved using an advanced retrieval similarity method, preventing unwanted or irrelevant answers from the LLM.

Advanced Calculation Engine:

Integration with ESG Reporting Software

Seamless Integration: The solution was designed to integrate seamlessly with the existing ESG reporting software, allowing calculations to be directly imported into the reporting tool without manual intervention. Previously, the client relied on the OpenAI API for these calculations. To simplify the process, SWIFT created an API endpoint that mimicked the OpenAI API format, offering a plug-and-play solution where the client only needs to change the AI model’s name and a few lines of code. SWIFT AI now develops its endpoints following the OpenAI standard, enabling plug-and-play replacements for nearly any AI application that uses ChatGPT as its backend.

API Development: In addition to the endpoint standard that mimics OpenAI, one of the challenges and core features of the SWIFT AI API is guaranteeing structured outputs from API requests. This functionality allows for production grade accuracy and performance expected in every industrial

grade integration. SWIFT AI has developed custom APIs that easily facilitate smooth data transfer between the calculation engine and the ESG reporting software. Both non-technical staff and the ESG client’s developers can call the SWIFT AI API directly to build other custom applications.

User Interface and Reporting

Intuitive Dashboard: A user-friendly dashboard was created to allow ESG analysts to monitor data ingestion, calculation processes, and integration status in real-time.

Automated Reporting: The system generated automated reports with the calculated totals, ready for submission in the required format.

Implementation and Results

Rapid Deployment: The solution was deployed within a few months, significantly faster than previous failed attempts by other companies.

Increased Accuracy: The standardization and calculation engine ensured high accuracy in the ESG metrics.

Efficiency Gains: The automation reduced manual data handling and calculation time, allowing ESG analysts to focus on higher-value tasks.

Improved Compliance: The automated and accurate reporting helped the ESG company maintain compliance with regulatory requirements and stakeholder expectations.

Conclusion

SWIFT AI successfully developed a custom solution for the ESG company, overcoming the challenges of disparate data sources and complex calculations. The integration with existing software and automation of reporting processes not only streamlined operations but also enhanced the accuracy and reliability of the ESG reports. This project exemplifies SWIFT AI’s capability to deliver tailored solutions for complex industry-specific problems.

Practical Applications of AI in Politics Video

Presented by: Zach Adolphe, SWIFT AI, SWIFT Learning Inc., Calgary, Alberta, Canada

General trends with Retrieval Augmented Generation (RAG) and AI assistants, with a focus on practical applications in political contexts.

Play Video

Presentation at Alberta Enterprise Group

Presented by: Kim Adolphe and Zach Adolphe, SWIFT AI, SWIFT Learning Inc., Calgary, Alberta, Canada

Relevant and Current AI Outputs

SWIFT explains how our AI can be used to curate content that is relevant and up-to-date! We work closely with our clients to create hyper custom solutions that are cost-effective and highly scalable.

Modern Miracle Network (MMN) AI Solution

MMN presented a problem they wanted to solve to combat AI bots flooding government sites seeking public opinion for energy-related projects. SWIFT developed an AI solution to mobilize MMN Though Leaders that represented real people and factual public sentiment.

Content Integrity with AI Generated Outputs

SWIFT AI is delivering and democratizing world-class, custom AI software products that EXCELerate corporate and people performance.

SWIFT collaborates with our clients to leverage artificial intelligence technology to create custom services that optimize operations and workflow processes. SWIFT will develop a custom AI solution that you can choose to own.

Cited Source for Every AI Generated Output

Never second guess whether content is factual or false! SWIFT judiciously curated content from reliable sources for our three main corpuses – Energy, Politics, and you choose only the data you want in your own private AI corpus.

Connecting Your Proprietary Data

SWIFT provides you with an AI solution that gives you complete control of your data and rather than you forced to connect to a remote AI somewhere in the states, SWIFT AI connects to you.

About the SiS (Safety in Schools) Foundation of Canada

SWIFT Learning founded SiS in 2011 to deliver free Occupational Health and Safety courses to high school students. Over 160,000 mastered certificates in safety training aligned with the Alberta Curriculum.

The Energy Career Literacy Program

We developed this program aligned with the CALM curriculum to educate youth about the industry and the incredible career opportunities right here in our province.

At an interview for a good paying summer job with an oil company, the interviewer said one of the reasons I was selected was the safety courses on my resume. When she offered me the job, she said the safety courses made me the top candidate.

edmontonMap

eLearning Expo for the Institute of Performance and Learning 2016 Presentation

Presented by: Kim Adolphe, President and CEO SWIFT Learning Inc. Calgary, Alberta, Canada

SWIFT Learning was a presenter at the 2016 eLearning Expo for the Institute of Performance and Learning.

Explore how Subject Matter Experts (SMEs) are using a next generation eLearning platform to create and launch mobile, adaptive learning. Using an authoring tool that guides development, automates responsive design, and has built-in features like test marking and an app, SMEs can create competency-based, mobile learning independent of a technical team. SMEs can then publish their courses to the cloud so that they are automatically accessible on all devices. Tracking, reporting, automated marking, and notifications then allow data analysis to identify opportunities for continuous improvement. How SMEs can engage and interact with learners through our integrated social media tool SPOC (SWIFT Point of Contact). The presentation will show you how you can take advantage of this platform, designed for learner-centric preferences, mobile standards, ubiquitous learning, and the ever-changing status of knowledge and information.

dubaiMap

Dubai Presentation

Presented by: Kim Adolphe, President and CEO SWIFT Learning Inc. Calgary, Alberta, Canada

SWIFT Learning was a corporate sponsor and presenter at the 3rd HCT Annual Dubai Colleges Mobile Learning Conference.

istanbulMap

SWIFT, the Evolution of a Mobile Adaptive Learning Environment: A Successful Experiment

Presented by: Kim Adolphe, President and CEO SWIFT Learning Inc. Calgary, Alberta, Canada
This paper was presented at the 13th World Conference on Mobile and Contextual Learning in Istanbul, Turkey.
washingtonMap

Intelligent eLearning with XML

Presented by: Kim Adolphe, President and CEO SWIFT Learning Inc. Calgary, Alberta, Canada

This paper was presented at the XML 2000 Conference in Washington, DC.

grazMap

Bringing ITS to the Marketplace: A Successful Experiment in Minimalist Design

Presented by: Kim Adolphe, President and CEO SWIFT Learning Inc. Calgary, Alberta, Canada

Dr. Marlene Jones and Carl Gutwin Alberta Research Council Calgary, Alberta, Canada

This paper was presented at ED-MEDIA 95 at the World Conference on Educational Multimedia and Hypermedia in Graz, Austria and won a Best Paper award.

Shopping Basket
👉 Translate