{"id":115675,"date":"2024-03-28T08:00:00","date_gmt":"2024-03-28T15:00:00","guid":{"rendered":"https:\/\/cm-edgetun.pages.dev\/en-us\/industry\/blog\/?p=115675"},"modified":"2025-04-10T17:22:47","modified_gmt":"2025-04-11T00:22:47","slug":"use-natural-language-and-generative-ai-to-create-calculation-models-streamline-data-collection-and-improve-reporting","status":"publish","type":"post","link":"https:\/\/cm-edgetun.pages.dev\/en-us\/industry\/blog\/sustainability\/2024\/03\/28\/use-natural-language-and-generative-ai-to-create-calculation-models-streamline-data-collection-and-improve-reporting\/","title":{"rendered":"Use natural language and generative AI to create calculation models, streamline data collection, and improve reporting"},"content":{"rendered":"\n

As announced in our This is AI \u2026 for Sustainability<\/a> event in February 2024, Copilot in Microsoft Sustainability Manager<\/a>, now in preview, simplifies and accelerates complex processes to help you accomplish tasks more efficiently. New AI-powered features include create calculation models with Copilot (preview)<\/strong>, which uses natural language input to generate calculation models based on your requirements. Read about this and other new capabilities that will enable your organization to streamline and enhance sustainability reporting, demonstrate compliance, and drive change.<\/p>\n\n\n

\n\t
\n\t\t
\n\n\t\t\t\n\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\n\t\t\t\t\t

Copilot in Microsoft Sustainability Manager<\/h2>\n\n\t\t\t\t\t
\n\t\t\t\t\t\t

Streamline and expedite several processes with the sustainability lifecycle<\/p>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\tRead the overview<\/span>\n\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\"Man\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t<\/div>\n<\/div>\n\n\n\n

Save time and effort creating calculation models with Copilot in Microsoft Sustainability Manager<\/h2>\n\n\n\n

In the dynamic landscape of sustainability, accurate calculations are the bedrock of informed decision-making. Whether measuring carbon emissions, water usage, or waste reduction, sustainability practitioners rely on robust calculation models<\/a>. However, creating these models can be complex and time-consuming. That\u2019s where the new create calculation models with Copilot<\/a> feature, now in preview, comes in. <\/p>\n\n\n\n

The driving force behind creating calculation models with Copilot is accessibility<\/strong>. We recognize that sustainability practitioners come from diverse backgrounds, and not all are experts in mathematical modeling. Our goal is to democratize the process by allowing you to express your calculation requirements in natural language<\/strong>. By bridging the gap between technical jargon and practical needs, we\u2019re empowering you to focus on sustainability outcomes rather than wrestling with formulas. <\/p>\n\n\n\n

Here’s how it works:<\/p>\n\n\n\n

1. Natural language input<\/strong>. To generate a calculation model, simply describe the calculation you need. For example, you can input \u201cDetermine emissions from mobile combustion based on distance.\u201d <\/p>\n\n\n

\"Screenshot
Input natural language to describe the calculation you need.<\/em><\/figcaption><\/figure>\n\n\n\n

2. Automated model generation<\/strong>. Behind the scenes, intelligent algorithms parse the input, identify relevant variables, and construct a calculation model.<\/p>\n\n\n

\"Screenshot
Sustainability Manager uses an AI algorithm to generate the calculation model.<\/em><\/figcaption><\/figure>\n\n\n\n

Once generated, the calculation model is ready for immediate use. You can now integrate it into your sustainability reports, dashboards, and compliance assessments. <\/p>\n\n\n\n

By automating the model creation process, Microsoft Sustainability Manager<\/a> reduces the time and effort required for you to build the calculations you need, freeing you up to allocate your time toward strategic initiatives rather than number-crunching. Create calculation models with Copilot provides a user-friendly experience. It isn\u2019t just about formulas, it\u2019s about empowering sustainability practitioners to drive positive change. By simplifying the complex, together we can move closer to a greener, more sustainable future.<\/p>\n\n\n\n

Demonstrate compliance with the energy data model in Microsoft Cloud for Sustainability<\/h2>\n\n\n\n

Energy is often a priority area for organizations when kickstarting their sustainability journey, largely due to availability of data and the ability for organizations to quantify both financial and carbon-related benefits. Customers, investors, employees, and the public increasingly expect organizations to demonstrate their commitment to sustainability and responsible energy management. Providing accurate and transparent energy-related data can enhance your organization’s reputation and potentially generate support from stakeholders.  <\/p>\n\n\n\n

Microsoft Cloud for Sustainability<\/a> provides a dedicated energy data model<\/strong> (preview)<\/strong><\/a> to help you track generated, purchased, and used energy for your portfolio, independent of the carbon tracking available within Sustainability Manager. This data model will enable you to unify, standardize, and streamline energy data collection and storage from utility bills, smart meters, utility solutions, and on-site energy generation systems, along with associated consumption patterns across multiple sites and geographic components, within the unified data model. You can utilize the energy lifecycle components to consolidate, standardize, and integrate energy to ensure data integrity, confidentiality, and compliance with regulatory requirements, thereby enhancing trust, transparency, and accountability in internal and external sustainability disclosures. By leveraging a centralized and structured energy model framework, you can demonstrate compliance with renewable energy targets and regulatory requirements. <\/p>\n\n\n

\"Screenshot
Leverage the energy data model in Microsoft Cloud for Sustainability to manage your energy portfolio.<\/em> <\/figcaption><\/figure>\n\n\n\n

Improve carbon emissions reporting with activity to emissions traceability<\/h2>\n\n\n\n

In today’s sustainability-driven landscape, organizations turn to advanced solutions such as Sustainability Manager to monitor and mitigate their environmental footprint, with a primary focus on reducing greenhouse gas emissions and other pollutants. However, ensuring the accuracy and credibility of emissions data poses a significant challenge, given the intricacies of global supply chains, diverse data collection methods, and the potential for errors or discrepancies. This underscores the critical need to meticulously trace underlying activity data within Sustainability Manager to bolster transparency, accountability, and precision in tracking and reporting emissions data.  <\/p>\n\n\n\n

Activity to emissions traceability<\/strong> (preview)<\/strong><\/a> <\/strong>is a new feature in Sustainability Manager that enables you to trace and link underlying source activity data to emissions records, provided those calculations occur within the system. This capability addresses the pressing need for accurate, transparent, and reliable emissions reporting by providing a comprehensive traceability mechanism for all activity records tied to carbon emissions quantification. Not only does this feature empower you to gain deeper insights into your organization\u2019s environmental impact, but it also streamlines the verification process for external auditors, regulators, and stakeholders. Activity to emissions traceability also enhances the credibility of sustainability reports and minimizes the risk of misrepresentation or greenwashing.  <\/p>\n\n\n

\"Screenshot
Trace underlying activity data within Sustainability Manager with the new activity to emissions traceability feature.<\/em><\/figcaption><\/figure>\n\n\n
\"Screenshot
Activity to emissions traceability helps you gain deeper insights and generate more accurate sustainability reports. <\/em> <\/figcaption><\/figure>\n\n\n\n

Create a Microsoft Power Query template to streamline and accelerate data import<\/h2>\n\n\n
\n\t
\n\t\t

\n\t\t\tMicrosoft Power Query \t\t<\/p>\n\t\t\n\t\t\tLearn more<\/span> <\/span>\n\t\t<\/a>\n\t<\/div>\n<\/div>\n\n\n\n

The new Power Query guided experience is a comprehensive ingestion approach available within Sustainability Manager. It allows you to import data for multiple entities through multiple sources, all through a single import. Power Query templates<\/a> in Sustainability Manager are available to help you with Power Query data imports. The templates automatically provide the right structure for all data attributes required to successfully import your data.<\/p>\n\n\n\n

When designing a Power Query template, you can save and reapply a pattern for different activity details or sources. Power Query templates also support transfer of usage between users. An advanced user can set up a Power Query template for other sustainability practitioners to use on known input data shapes, as well as reuse a repeatable pattern to accelerate setup consistently.  <\/p>\n\n\n\n

Let\u2019s say a user wants to create a template for mapping electricity, but the patterns need to be repeated from different sources. The source could be a parameter, or the \u201cevidence\u201d is different but everything else is the same. Previously, you would have to re-create the Power Query ingestion, mapping, and more. Using a Power Query template, you can create once and enter only the parameters that need to change for a new connection. The advanced user can create the template but can\u2019t run it if they don\u2019t know the connection details. The sustainability practitioner can use the template to create the connection.<\/p>\n\n\n

\"Screenshot
Microsoft Sustainability Manager provides a guided experience and templates to help you with Power Query data imports.<\/em> <\/figcaption><\/figure>\n\n\n
\"Screenshot
Microsoft Sustainability Manager provides a guided experience and templates to help you with Power Query data imports.<\/em> <\/figcaption><\/figure>\n\n\n
\"Screenshot
Enter the parameters you want to use for your Power Query data import.<\/em> <\/figcaption><\/figure>\n\n\n\n

Further, with a new feature coming soon that will allow our growing list of partners to develop ingestion connections, you can package Power Query templates as a standalone package that can be distributed publicly and applied by customers. <\/p>\n\n\n\n

New Sustainability Manager features coming soon<\/h2>\n\n\n\n

Starting April 2024, a new what-if analysis (preview) feature will allow you to forecast the impact of business practice changes on your overall emissions. Look for this and other changes coming to Sustainability Manager that will help you make informed decisions on how to reduce your organization\u2019s carbon footprint and achieve your sustainability goals.  <\/p>\n\n\n\n

Learn more about sustainability solutions with Microsoft<\/h2>\n\n\n\n