Meet a recent Microsoft Learn Student Ambassador graduate Flora Oladipupo

Meet a recent Microsoft Learn Student Ambassador graduate Flora Oladipupo

This article is contributed. See the original author and article here.

This is the next segment of our blog series highlighting Microsoft Learn Student Ambassadors who achieved the Gold milestone, the highest level attainable, and have recently graduated from university. Each blog in the series features a different student and highlights their accomplishments, their experience with the Student Ambassador community, and what they’re up to now.


 


Today we meet Flora who recently graduated with a bachelor’s in biotechnology from Federal University of Technology Akure in Nigeria.



Responses have been edited for clarity and length.


 


When did you join the Student Ambassadors community?


 


July 2021


 


What was being a Student Ambassador like?


 


Being a student ambassador was an amazing experience for me. I joined the program at a crucial time when I was just beginning my tech journey and was on the verge of giving up on a tech career, thinking it might not be for me. Over the three years I served as an ambassador, I not only enhanced my technical skills but also grew as an individual. I transformed from a shy person into someone who could confidently address an audience, developing strong presentation and communication skills along the way. As an ambassador, I made an impact on both small and large scales, excelled in organizing events, and mentored other students to embark on their own tech career paths.


 


Was there a specific experience you had while you were in the program that had a profound impact on you and why?


 


One significant impact I made as an ambassador was organizing a Global Power Platform event in Nigeria, which is presumed the largest in West Africa, with around 700 students attending. During this event, I collaborated with MVPs in the Power Platform domain to upskill students in Power BI and Power Apps technology. Leveraging my position as a Microsoft ambassador, I secured access to school facilities, including computer systems for students to use for learning. This pivotal experience paved the way for me to organize international events outside the ambassador program.


 


These experiences aside helped me develop skills in project management, networking, and making a large-scale impact.


 


Tell us about a technology you had the chance to gain a skillset in as a Student Ambassador. How has this skill you acquired helped you in your post-university journey?


 


During my time as an ambassador, I developed a strong skillset in data analytics. I honed my abilities using various Microsoft technologies, including Power BI, Excel, and Azure for Data Science. I shared this knowledge with my community through classes, which proved invaluable in my post-university journey. Additionally, I honed my technical writing skills by contributing to the Microsoft Blog, with one of my articles becoming one of the top most viewed blogs of the year. This experience helped me secure an internship while in school and side-gigs via freelancing, and ultimately landing a job before graduating.


 


What is something you want all students, globally, to know about the Microsoft Learn Student Ambassador Program?


 


I want students worldwide to know that the Microsoft Learn Student Ambassador program is for everyone, regardless of how new they are to tech. It offers opportunities to grow, learn, and expand their skills, preparing them for success in the job market. They shouldn’t view it as a program only for geniuses but as a place that will shape them in ways that traditional academics might not


 


StudentDeveloperTeam_1-1724971573656.jpeg


Flora and other Microsoft Learn Student Ambassadors in her university.


 


What advice would you give to new Student Ambassadors, who are just starting in the program?


 


I would advise students just starting in the program to give it their best and, most importantly, to look beyond the SWAG! Many people focus on the swag and merchandise, forgetting that there’s much more to gain, including developing both soft and technical skills. So, for those just starting out, come in, make good connections, and leverage those connections while building your skills in all areas.


 


Share a favorite quote with us! It can be from a movie, a song, a book, or someone you know personally. Tell us why you chose this. What does it mean for you?


 


Maya Angelou’s words deeply resonate with me: ‘Whatever you want to do, if you want to be great at it, you have to love it and be willing to make sacrifices.’ This truth became evident during my journey as a student ambassador. I aspired to be an effective teacher, presenter, and communicator. To achieve that, I knew I had to overcome my shyness and embrace facing the crowd. Making an impact on a large scale requires stepping out of my comfort zone. Over time, I transformed into a different person from when I first joined the program.


 


Tell us something interesting about you, about your journey.


 


One fascinating aspect of my involvement in the program and my academic journey was when I assumed the role of community manager. Our goal was to elevate the MLSA community to a prominent position within the school, making it recognizable to both students and lecturers. However, through collaborative efforts and teamwork with fellow ambassadors, we achieved significant growth. The community expanded to nearly a thousand members, and we successfully registered it as an official club recognized by the Vice-Chancellor and prominent lecturers. I owe a shout-out to Mahmood Ademoye and other ambassadors from FUTA who played a pivotal role in shaping our thriving community.


 


StudentDeveloperTeam_2-1724971573664.jpeg


Flora and her mentor Olanrewaju Oyinbooke



You can follow Flora here:


 


LinkedIn: https://www.linkedin.com/in/flora-oladipupo/
X: https://x.com/flora_oladipupo
Github: https://github.com/shashacode
Medium: https://medium.com/@floraoladipupo
Hashnode: https://writewithshasha.hashnode.dev/
Linktree: https://linktr.ee/flora_oladipupo

New Microsoft Copilot Dashboard Features Now Available – August 2024

New Microsoft Copilot Dashboard Features Now Available – August 2024

This article is contributed. See the original author and article here.

Introducing exciting new features to help you better understand and improve adoption and impact of Copilot for Microsoft 365 through the Copilot Dashboard. These features will help you track Copilot adoption trends, estimate impact, interpret results, delegate access to others for improved visibility, and query Copilot assisted hours more effectively. This month, we have released four new features:


 


Updates to Microsoft Copilot Dashboard:



  • Trendlines

  • Copilot Value Calculator

  • Metric guidance for Comparison

  • Delegate Access to Copilot Dashboard


We have also expanded the availability of the Microsoft Copilot Dashboard. As recently announced, the Microsoft Copilot Dashboard is now available as part of Copilot for Microsoft 365 licenses and no longer requires a Viva Insights premium license. The rollout of the Microsoft Copilot Dashboard to Copilot for Microsoft 365 customers started in July. Customers with over 50 assigned Copilot for Microsoft 365 licenses or 10 assigned premium Viva Insights licenses have begun to see the Copilot Dashboard. Customers with fewer than 50 assigned Copilot for Microsoft 365 licenses will continue to have access to a limited Copilot Dashboard that features tenant-level metrics.


 


Let’s take a closer look at the four new features in the Copilot Dashboard as well as an update to more advanced reporting options in Viva Insights.


 


Trendline Feature


Supercharge your insights with our new trendline feature. Easily track your company’s Copilot adoption trends over the past 6 months. See overall adoption metrics like the number of Copilot-licensed employees and active users. Discover the impact of Copilot over time – find out how many hours Copilot has saved, how many emails were sent with its assistance, and how many meetings it summarized. Stay ahead with trendline and see how Copilot usage changes over time at your organization. For detailed views of Copilot usage within apps and Copilot impact across groups for timeframes beyond 28 days, use Viva Insights Analyst Workbench (requires premium Viva Insights license).



Learn more here.


MikeWalshPMM_0-1724939288836.png


 


 


Copilot Value Calculator


Customize and estimate the value of Copilot at your organization. This feature estimates Copilot’s impact over a given period by multiplying Copilot-assisted hours by an average hourly rate. By default, this rate is set to $72, based on data from the U.S. Bureau of Labor Statistics. You can customize it by updating and saving your own average hourly rate and currency settings to get a personalized view. This feature is enabled by default, but your Global admin can manage it using Viva feature access management. See our Learn article for more information on Copilot-assisted hours and value.


MikeWalshPMM_1-1724939288861.png


 


 


MikeWalshPMM_2-1724939288893.png



Metric Guidance for Comparisons


Discover research-backed metric guidance when comparing different groups of Copilot usage, for example, Copilot active users and non-Copilot users. This guidance is based on comprehensive research compiled in our e-book and helps users interpret changes to meetings, email and chat metrics. For the best results, compare two similar groups, such as employees with similar job functions or ranks. Use our in-product metric guidance to interpret results and make informed decisions with confidence. Click here for more information.


MikeWalshPMM_3-1724939288937.png


 


Delegate Access to Copilot Dashboard


Leaders can now delegate access to their Microsoft Copilot Dashboard to others in their company to improve visibility and efficiency. Designated delegates, such as the leader’s chief of staff or direct reports, will be able to view Copilot Dashboard insights and use them to make data-driven decisions. Learn more about the delegate access feature here. Admins can control access to the delegation feature by applying feature management policies.


MikeWalshPMM_4-1724939288946.png


 


Go Deeper with Viva Insights – Copilot Assisted Hours Metric in Analyst Workbench


For customers wanting a more advanced, customizable Copilot reporting experience, Viva Insights is available with a premium Viva Insights license. With Viva Insights, customers can build custom views and reports, view longer data sets of Copilot usage, compare usage against third party data, and customize the definition of active Copilot users and other metrics.


 


The Copilot assisted hours metric featured in the Microsoft Copilot Dashboard is now also available to query in the Viva Insights Analyst Workbench. When running a person query and adding new metrics, Viva Insights analysts will be able to find this metric under the “Microsoft 365 Copilot” metric category. The metric is computed based on your employees’ actions in Copilot and multipliers derived from Microsoft’s research on Copilot users. Use this new available metric for your own custom Copilot reports.


 


Summary


We hope you enjoy these new enhancements to Copilot reporting to help you accelerate adoption and impact of AI at your organization. We’ll keep you posted as more enhancements become available to measure Copilot.

Transforming ERP, and the speed of business, with generative AI

Transforming ERP, and the speed of business, with generative AI

This article is contributed. See the original author and article here.

Enterprise resource planning (ERP) platforms were designed to help integrate the fragmented processes that comprise the operation of a large enterprise. But the way we do business keeps fundamentally changing. New business models disrupt the way companies sell products and services, blurring industry lines and transforming customer experiences.

Business complexity continues to intensify, and the rise of data as a driver of business—plus the attendant proliferation of data streams—means reaping the full promise of comprehensive ERP platforms can still be elusive.

In fact, according to a Gartner® Research report, “by 2027, less than 30% of customers who adopted new solutions from ERP platform mega-vendors will have proven their original adoption business case.”1

The arrival of generative AI brings hope of renewed promise. AI is elevating performance and creating advantages for those who understand how to apply it to data-centric systems like ERP platforms. By 2027, according to the same Gartner report, at least 50 percent of ERP systems with AI-enabled features will be enabled through generative AI capabilities.1

People often think of generative AI as a tool to automate routine tasks, but its capabilities are so much broader. Improved decision-making is an area where AI becomes a valuable tool. In fact, a report from the market research firm IDC found that, by mid-2024, 30% of global organizations will take advantage of human-like interfaces in their enterprise applications to gain more insights quickly, improving decision velocity.2

While AI can inform and enhance any number of operations across an enterprise, it’s worth looking at some specific processes in detail to see how much AI can elevate ERP solutions. Learn more about current trends in ERP platform modernization in the age of generative AI in this webinar.

How AI creates a better plan-to-produce process

Most manufacturing firms implement a plan for how they will schedule production runs to meet materials capacity, deliver quality products on time, and maintain cost-effectiveness.

Sometimes, though, this plan-to-produce process becomes an accretion of good ideas at the time, a fragmented assemblage of tools and strategies trying to work together to paint the big picture of what’s happening on the production floor. This can lead to quality control issues, and manpower and equipment shortages that fail to meet production surges, or inaccurate forecasts that waste resources or leave customers high and dry—among other issues.

Generative AI integrated with a robust ERP system can aggregate data from across an enterprise—even data residing in multiple clouds—in real time, so managers have a clear picture of the state of play at any given moment, allowing them to reduce lead times necessary to plan or alter production runs.

The complicated interdependence of tasks on a manufacturing floor—for example, Part A must be installed before Part B can be attached—is a perfect puzzle for AI to help solve. The predictive analytics capacity of generative AI allows it to better forecast demand and synch production with supplies, and then optimize timing to match resource availability with manpower. AI can also forecast and build scenarios for supply chain disruption or changes in demand.

Whether a manufacturer needs to increase production volume to meet increasing demand or build whole new facilities, AI excels at building scalable networks, finding efficiencies, and reducing costly interventions.

Learn more about how Copilot in Microsoft Dynamics 365 Supply Chain Management and other applications optimize the plan-to-produce process.

Optimizing the procure-to-pay process

Another process most large organizations seek to optimize is the integration of procurement with accounts payable. When you need to spend the money, it’s good to know that you have the money. IDC reports that, by mid-2025, 70% of global businesses will use embedded financing to collect and make payments.2

More than most industries, healthcare organizations must reckon with a complex field of myriad payers, purchasers, and suppliers. Healthcare organizations face layers of challenging regulatory compliance and the need to control ever-rising costs. Many organizations in this field still rely on antiquated, paper-based invoicing and payables.

Fragmented processes and siloed data make regulatory issues more fraught, while also increasing attack surfaces to create security risks. AI can remove complexities by integrating processes in one ERP platform, helping to reduce vulnerabilities. By mapping operations to standards, AI supports compliance efforts, efficiently creating the audit trails and tedious reports that often take staff hours to produce.

AI streamlines procurement, reducing the potential for human error present when ordering supplies and equipment from a diverse range of providers. It tracks expenses to help control costs, providing easily accessible price information about competing products and services so the organization can continually find cost efficiencies.

An ERP solution enhanced with AI allows planners to automate the maintenance of inventory with both real-time and predictive information, reducing the risk of stockouts or overstock situations and more effectively communicating with suppliers.

Quicker quote-to-cash with personalization and automation

AI integrates and improves the sales, finance, and supply elements of an ERP platform by increasing automation in negotiations, contract lifecycles, production, order management, billing, and delivery. For businesses with retail components, making the quote-to-cash cycle faster and more accurate creates efficiencies—which can help keep customers happier.

Automating price and quote information speeds up the resolution of even highly complex deals. The same is true once a quote is accepted—an accurate, automatically generated proposal follows immediately. AI-generated purchase orders and invoices free sellers to spend more time interacting with customers and accounting teams to focus on tasks that increase the organization’s productivity.

AI’s predictive analytics ensure on-time delivery of products but also allow firms to quickly identify current and future trends and make data-driven decisions about ordering and pricing. Automating invoicing tracks payments accurately and creates a real-time picture of cash flow. AI can continually improve cash flow forecasts by comparing projections with results and adjusting from the outcomes over time. And analytics enabled by AI offer suggestions for improving sales performance and strategic decisions.

Learn more about how Copilot for Microsoft Dynamics 365 Finance optimizes the quote-to-cash and other retail business processes.

Get more from your business data with AI-enabled ERP processes

Across the organization, optimizing finance and supply chains can create a connected enterprise that allows enterprises to infuse AI, automation, and analytics into ERP processes. Today, companies can confidently move to the cloud with AI-powered ERP solutions, modernize business processes, and unlock the agility needed to lead the way in today’s rapidly evolving marketplace. 

A recent Forrester Research study interviewed IT leaders and professionals who had experience using Microsoft Dynamics 365 ERP software.3 Forrester aggregated the interviewees’ experiences and combined the results into a single composite organization that has 5,000 employees and generates USD1 billion in annual revenue. Forrester found that, over a three-year period, the value added to the composite included:

  • USD1.2 million in increased profitability from real-time visibility and enhanced decision-making.
  • USD8.9 million in increased productivity from unified data access, streamlined processes, automated workflows, and other gained efficiencies.
  • USD3.9 million in reduced infrastructure and IT operations spend from cloud migration.
  • USD8.9 million in productivity improvements in finance/accounting, supply chain/logistics, and other personnel.

The study estimated a net present value of USD8.1 million and an ROI of 106%, as well as additional benefits like an improved cybersecurity posture and enhanced employee experiences. The composite organization would pay back its investment in Microsoft Dynamics 365 ERP software in 17 months.

Microsoft Dynamics 365 ERP software

Learn more about the total economic impact of Microsoft Dynamics 365 ERP software

AI-enabled ERP platforms allow you to protect, connect, and get more from your business data while gaining security. With the right ERP solution, you can scale globally to drive business expansion and environmental, social, and governance (ESG) while ensuring regulatory compliance, supercharging productivity, and realizing the business impacts of generative AI even faster.

Microsoft Dynamics 365 Virtual Training Day

Join us at a Microsoft Dynamics 365 Virtual Training Day to gain the skills needed to help your organization sell, service, and deliver on the customer expectations of tomorrow. Register for free, in-depth training events, where you’ll uncover new efficiencies of scale, discover smarter connections, and utilize built-in intelligence for deeper insights into your business.


Sources

1 Predicts 2024: ERP Evolves Planning With Automation and AI, Denis Torii, Gartner Research, April 5, 2024

2 IDC FutureScape: Worldwide Intelligent ERP 2024 Predictions, doc #US51300923, October 2023

3 The Total Economic Impact™ Of Microsoft Dynamics 365 ERP, Cost Savings And Business Benefits Enabled By Dynamics 365 ERP, a Forrester Total Economic Impact™ Study commissioned By Microsoft, April 2024

GARTNER is a registered trademark and service mark of Gartner, Inc. and/or its affiliates in the U.S. and internationally and is used herein with permission. All rights reserved.

The post Transforming ERP, and the speed of business, with generative AI appeared first on Microsoft Dynamics 365 Blog.

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.

Elevating experiences with AI, from productivity to personalization 

Elevating experiences with AI, from productivity to personalization 

This article is contributed. See the original author and article here.

In a previous blog, we discussed how modern, AI-enabled customer relationship management (CRM) platforms and enterprise resource planning (ERP) systems help drive new, more effective ways of working for employees and more satisfying outcomes for the customers they serve in three key ways: by streamlining operations, by empowering more informed and insightful decisions, and by elevating customer and employee experiences.  

In this blog post, we’re going to focus on the third item: elevating customer and employee experiences by showing how AI-enabled CRM solutions help increase productivity and provide unprecedented levels of personalized service across three key business functions: marketing, sales, and customer service. We’ll also provide insights and best practices for how to help employees get the most from AI, including how they can be empowered to create personalized experiences for their customers.  

group of colleagues

Microsoft Dynamics 365 Sales

Grow your revenue with next-generation AI.

Revolutionizing marketing: How AI-enabled CRM software drives personalized experiences and enhance customer engagement 

Marketing is one area where generative AI is already in active use. According to a Forrester survey of CMOs, more than half (56%) of B2C marketing or advertising decision makers have been using generative AI in three key ways:  

  • To help employees minimize tedious tasks, allowing for more time to focus on strategically important work. 
  • To summarize insights and enable swift action without the need to dig through data manually. 
  • To boost the scale of creative output by generating starter ideas along with visuals and copy.1

AI is particularly capable of delivering personalized experiences in marketing, where AI-enabled CRM platforms can marry customer data to messaging to create memorable moments and impact sales. One example of a company using AI-enabled CRM solutions to generate marketing content is North Carolina-based sports club NC Fusion, which used Microsoft Copilot in Dynamics 365 Customer Insights to help its marketers create personalized messaging tailored to its audience segments, increasing the reach of the brand. Using AI-enabled content ideas, descriptions, and summaries has provided significant time savings, and personalizing campaigns has been more effective with Copilot.2  

“For families, we are able to tailor the message they receive. This means a family will only receive messages that apply to their situation, and not a multitude of emails that have no application to their family situation. With AI-assisted content production, our customer engagement has increased from 10% to 30%.”  

Chris Barnhart, Head of IT and Data Systems at NC Fusion

Empowering sales teams: How AI-driven personalization can transform customer interactions and boost revenue 

Another area where personalization can impact an organization’s bottom line is sales, where making authentic connections with customers at the right time is paramount. Few organizations know this better than superyacht brokerage Northrop & Johnson, which has used AI to deliver highly personal sales experiences tailored to the wants and needs of its high-value clients. 

“In this market, we have high-wealth customers who are considering very high-value purchases, and we can’t afford any interactions that leave them feeling anything less than special.”

Keith Perfect, Director of Technoloy & Intelligence at Northrop & Johnson 

Microsoft Dynamics 365 Sales, Microsoft Dynamics 365 Customer Insights, and Copilot provide Northrop & Johnson sales teams with comprehensive and timely data for each client, which helps them deliver personalized conversations at precisely the right time to engage. 

“Clients at this level want to know they are taken care of. And when you must make an impact in minutes, which is all you have with these busy clients, you need to be very attuned to them. Otherwise, it could cost you the sale. So, having a solution at your fingertips that connects the entire journey is huge for our sales team.” 

Daniel Ziriakus, President & Chief Operating Officer at Northrop & Johnson

Sales teams using AI-enabled CRM software also realize significant time savings as salespeople assign more tedious tasks to their AI assistants. In fact, according to new Microsoft research, 79% of Microsoft Copilot for Sales users say it reduces the amount of administrative work they have to do, 67% say it helps them spend more time with customers, and 64% say it allows them to better personalize customer engagements. 

Transforming customer support: How AI-driven assistants enhance productivity, satisfaction, and retention 

Customer service is still another area where AI-enabled CRM platforms can make an immediate impact. According to a November 2023 study from the National Bureau of Economic Research (NBER), customer service agents using a generative AI-based conversational assistant were able to increase productivity—specifically measured by the number of issues resolved per hour—by an average of 14%. The effect was even more pronounced with novice and low-skill workers, who experienced productivity increases of 34%. Researchers also found that AI assistance improves customer sentiment and increases employee retention.4 

One company using an AI-enabled CRM solution in customer service is Microsoft. We operate one of the largest customer support teams in the world and process more than 145 million contacts per year. We use Microsoft Dynamics 365 Customer Service to help utilize the full expertise of the engineers on staff and provide better resolution of customer issues across the board.5  

“The challenge for every support engineer is to connect with the human being on the other end of the call who has a problem that needs solving. You want to connect with them, but you also need to be able to pull in a great deal of technical information. Copilot provides us the support to offer the customer understanding while also sorting out their technical problems.” 

Ric Todd, Director of Support Strategy at Microsoft

Download The AI Advantage: Driving sales performance with next-generation tools.

Bringing AI to your organization  

For leaders looking to roll out AI solutions in their organizations, we have some encouraging news: people new to AI begin recognizing its value quickly. Recent Microsoft research shows it takes a time savings of just 11 minutes per day for most people to see its usefulness (a key factor in getting new work habits to stick). 6  

Encouragingly, most respondents report having saved more than 11 minutes. The most efficient among them are saving up to 30 minutes per day—the equivalent of 10 hours per month—and the average person is saving 14 minutes per day for a time savings of almost five hours per month. 

What’s more, the breakthrough moment by which respondents report seeing improvements in productivity (75%), work enjoyment (57%), work-life balance (34%), and the ability to attend fewer meetings (37%) happens within one business quarter—11 weeks.7  

While personal productivity gains from Copilot are real and significant, building an AI-powered organization requires committing to working in a new way. Some best practices to consider include:  

  • Encourage daily use. Realizing productivity gains from AI will take intentional everyday practice. Those who start building the habit early will pull ahead. And don’t forget—11 weeks is all it takes for people to recognize the effect.  
  • Help people manage their new assistants. Employees taught to treat their generative AI tools as assistants, not search engines, will get the most value. Teach team members to manage their new assistant and to recognize when to delegate a task to AI and when to apply their human intelligence, judgment, and skill. 
  • Find good use of reclaimed time. Help your team take advantage of time savings to focus on the higher-order and creative tasks only people can do. Salespeople can devote more time to building relationships with customers and closing deals. Marketers can carve out time to dream up new solutions. Customer service teams can focus on solving problems, and managers across the organization can spend more time coaching and caring for their teams. 

Taking the next step forward 

Take the next step in your AI adoption journey by learning more about Copilot and other AI-powered capabilities in Microsoft Dynamics 365. Discover how to keep your organization on the cutting-edge by realizing that a new paradigm of customer engagement through AI-enabled personalization empowers both customers and employees.  

Join us at a Microsoft Dynamics 365 Virtual Training Day to gain the skills needed to help your organization sell, service, and deliver on the customer expectations of tomorrow. Register for free, in-depth training events, where you’ll uncover new efficiencies of scale, discover smarter connections, and utilize built-in intelligence for deeper insights into your business. Register now

Microsoft Dynamics 365 Virtual Training Day

Join us at a Microsoft Dynamics 365 Virtual Training Day to gain the skills needed to help your organization sell, service, and deliver on the customer expectations of tomorrow. Register for free, in-depth training events, where you’ll uncover new efficiencies of scale, discover smarter connections, and utilize built-in intelligence for deeper insights into your business.


Sources

  1.  Leap Now, Not Later, into a Responsible Generative AI Strategy for Marketing (July 5th, 2023) 
  2. Microsoft Customer Story-NC Fusion expands youth marketing outreach, taught kids leadership and life skills with Dynamics 365 Customer Insights
  3. What Can Copilot’s Earliest Users Teach Us About Generative AI at Work? (microsoft.com) 
  4. Working Paper 31161; Generative AI at Work; NBER 
  5. Microsoft Customer Story-Microsoft empowers support engineers to shine brighter with Dynamics 365 Customer Service 
  6. AI Data Drop: The 11-by-11 Tipping Point 
  7. AI Data Drop: The 11-by-11 Tipping Point 

The post Elevating experiences with AI, from productivity to personalization  appeared first on Microsoft Dynamics 365 Blog.

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.

Save ingestion costs by splitting logs into multiple tables and opting for the basic tier!

Save ingestion costs by splitting logs into multiple tables and opting for the basic tier!

This article is contributed. See the original author and article here.

In this blog post I am going to talk about splitting logs to multiple tables and opting for basic tier to save cost in Microsoft Sentinel. Before we delve into the details, let’s try to understand what problem we are going to solve with this approach.


Azure Monitor offers several log plans which our customers can opt for depending on their use cases. These log plans include:



  • Analytics Logs – This plan is designed for frequent, concurrent access and supports interactive usage by multiple users. This plan drives the features in Azure Monitor Insights and powers Microsoft Sentinel. It is designed to manage critical and frequently accessed logs optimized for dashboards, alerts, and business advanced queries.

  • Basic Logs – Improved to support even richer troubleshooting and incident response with fast queries while saving costs. Now available with a longer retention period and the addition of KQL operators to aggregate and lookup.

  • Auxiliary Logs – Our new, inexpensive log plan that enables ingestion and management of verbose logs needed for auditing and compliance scenarios. These may be queried with KQL on an infrequent basis and used to generate summaries.


Following diagram provides detailed information about the log plans and their use cases:


absharan_0-1724862421015.png


 


I would also recommend going through our public documentation for detailed insights about feature-wise comparison for the log plans which should help you in taking right decisions for choosing the correct log plans.


**Note** Auxiliary logs are out of scope for this blog post, I will write a separate blog on the Auxiliary logs later.


So far, we know about different log plans available and their use cases.


 The next question is which tables support Analytics and Basic log plan?



You can switch between the Analytics and Basic plans; the change takes effect on existing data in the table immediately.


When you change a table’s plan from Analytics to Basic, Azure monitor treats any data that’s older than 30 days as long-term retention data based on the total retention period set for the table. In other words, the total retention period of the table remains unchanged, unless you explicitly modify the long-term retention period.


Check our public documentation for more information on setting the table plan.


I will focus on splitting Syslog table and setting up the DCR-based table to Basic tier in this blog.


Typically Firewall logs contribute to high volume of log ingestion to a SIEM solution.


In order to manage cost in Microsoft Sentinel its highly recommended to thoroughly review the logs and identify which logs can be moved to Basic log plan.


At a high level, the following steps should be enough to achieve this task:



  • Ingest Firewall logs to Microsoft Sentinel with the help of Linux Log Forwarder via Azure Monitor Agent.

  • Assuming the log is getting ingested in Syslog table, create a custom table with same schema as Syslog table.

  • Update the DCR template to split the logs.

  • Set the table plan to Basic for the identified DCR-based custom table.

  • Set the required retention period of the table.


At this point, I anticipate you already have log forwarder set up and able to ingest Firewall logs to Microsoft Sentinel’s workspace.


Let’s focus on creating a custom table now


This part used to be cumbersome but not anymore, thanks to my colleague Marko Lauren who has done a fantastic job in creating this PowerShell Script which can create a custom table easily. All you need to do is to enter the pre-existing table name and the script will create a new DCR-Based custom table with same schema.


Let’s see it in action:



  • Download the script locally.

  • Open the script in PowerShell ISE and update workspace ID & resource ID details as shown below.


absharan_1-1724862421047.png


 






  • Save it locally and upload to Azure PowerShell.

  • Load the file and enter the table name from which you wish to copy the schema.

  • Provide the new table name as per your wish, ensure the name has suffix “_CL” as shown below:


absharan_2-1724862421055.png


 


This should create a new DCR-based custom table which you can check in Log Analytics Workspace > Table blade as shown below:


absharan_3-1724862421064.png


 


**Note** We highly recommend you should review the PowerShell script thoroughly and do proper testing before executing it in production. We don’t take any responsibility for the script.


 


The next step is to update the Data Collection Rule template to split the logs


Since we already created custom table, we should create a transformation logic to split the logs and send less relevant log to the custom table which we are going to set to Basic log tier.


For demo purposes, I’m going to split logs based on SeverityLevel. I will drop “info” logs from Syslog table and stream it to Syslog_CL table.


Let’s see how it works:



  • Browse to Data Collection Rule blade.

  • Open the DCR for Syslog table, click on Export template > Deploy > Edit Template as shown below:


absharan_4-1724862421103.png


 


absharan_5-1724862421119.png


 



  • In the dataFlows section, I’ve created 2 streams for splitting the logs. Details about the streams as follows:

    • 1st Stream: It’s going to drop the Syslog messages where SeverityLevel is “info” and send the logs to Syslog table.

    • 2nd Stream: It’s going to capture all Syslog messages where SeverityLevel is “info” and send the logs to Syslog_CL table.




absharan_6-1724862421129.png


 



  • Save and deploy.


 


Let’s validate if it really works


Go to the Log Analytics Workspace > Logs and check if the tables contains the data which we have defined it for.


In my case as we can see, Syslog table contains all logs except those where SeverityLevel is “info”


absharan_7-1724862421133.png


 


Additionally, our custom table: Syslog_CL contains those Syslog data where SeverityLevel is “info”


absharan_8-1724862421137.png


 


 


Now the next part is to set the Syslog_CL table to Basic log plan


Since Syslog_CL is a DCR-based custom table, we can set it to Basic log plan. Steps are straightforward:



  • Go to the Log Analytics Workspace > Tables

  • Search for the table: Syslog_CL

  • Click on the ellipsis on the right side and click on Manage table as shown below:


absharan_9-1724862421145.png


 



  • Select the table plan to Basic and set desired retention period


absharan_10-1724862421152.png


 



  • Save the settings.


 


Now you can enjoy some cost benefits, hope this helps.