Skip to main content

Posts

"So… what's the ROI?" How I automated Copilot business cases with MCP

Every Microsoft 365 Copilot conversation I have with a client ends with the same question: "So… what's the ROI?" For a long time my answer was a spreadsheet, a few screenshots and a slide deck I rebuilt by hand for every client. It took half a day, and the numbers were only as consistent as my copy-and-paste. AI assistants can help, and I use Copilot Chat, Researcher and Cowork skills. But when I asked them for an ROI dashboard, I got a slightly different formula and a different layout each time. That's fine for a one-off. It isn't fine for a number a CFO will question. So I built my own Model Context Protocol (MCP) server : the Copilot Consultant MCP . It gives an AI assistant a set of consulting tools (readiness, build path, use cases and ROI), plus tools that produce a client-ready dashboard and PowerPoint deck. The maths lives in Python code, so the same inputs always give the same answer. What the Copilot Consultant MCP does Scores Copilot readiness ...
Recent posts

Power Automate from the terminal: GitHub Copilot CLI + Microsoft's Power Platform plugin

PS C:\> copilot-win32-x64 -p "List my Power Automate environments" Power Automate from the Terminal GitHub Copilot CLI + Microsoft's Power Platform plugin What if you could create, debug and manage Power Automate flows by typing plain English into a terminal? Microsoft now publishes a Power Platform plugin for GitHub Copilot CLI that does exactly that. I set it up end to end and wrote a runbook, so you don't have to hit the same walls I did. The runbook covers installing everything, the three errors that will almost certainly trip you up, the prompts that actually work, and how to build flows your Copilot Studio agents can call. It was verified on Windows 11 Pro (26200) with PowerShell 7.6.5 and Node v20.2.0. What you can do with it Discover : list environments and flows, find the flows that failed in the last 24 hours, and get an inventory report of every flow and its owner. Create : describe a flow in a sentence ("runs weekdays at 9am, reads...

ADTD Modern: I rebuilt Microsoft's Active Directory Topology Diagrammer for Windows Server 2025

If you've worked with Active Directory for a while, you probably remember ADTD, Microsoft's Active Directory Topology Diagrammer. You pointed it at a domain, and a few minutes later you had Visio diagrams of your sites, replication and domains. It was brilliant, but it stopped in 2011. ADTD only understands Windows Server up to 2008 R2 and Exchange 2010. It needs .NET 2.0, draws only in old versions of Visio, and knows nothing about Microsoft Entra ID (Azure AD). So I built a modern replacement: ADTD Modern . It's free on GitHub, and this post walks through what it does and how to use it. What ADTD Modern does In one run, ADTD Modern: Draws your Active Directory in draw.io (desktop or web, both free): sites, subnets and site links, replication connections, domains and trusts, FSMO roles, application partitions, OUs and GPO links, DFS Replication and Exchange. Visio output is still there if you want it. Understands current versions : Windows Server up...

Microsoft Copilot: Your AI-powered Productivity Partner

Microsoft Copilot is not just a name; it's a vision for the future of work. It's a suite of AI-powered tools designed to revolutionize the way we work, making us more efficient, creative, and productive. Copilot isn't just one tool; it's an ever-evolving ecosystem of features and functionalities that are constantly being updated and improved. What is Microsoft Copilot? At its core, Microsoft Copilot is a large language model (LLM) chatbot developed by Microsoft. It was initially launched as Bing Chat in February 2023 and has since evolved into a more comprehensive suite of tools integrated into various Microsoft products and services. Copilot leverages the power of LLMs to understand your needs and provide assistance in various ways, from simple tasks like answering questions to more complex tasks like generating creative content or summarizing documents. Copilot in Action Here are some of the ways Copilot can be used to enhance your productivity: Microsoft 365 Copilot:...

Adding a user to multiple teams and channels in it from ps

  To add a user to a set of teams and all channels in those teams from PowerShell, you can use the Microsoft Teams PowerShell module. Here's an example script that you can modify to suit your needs: # Import the Microsoft Teams PowerShell module Import-Module MicrosoftTeams # Set variables for the user and teams $user = "user@contoso.com" $teams = "Team1", "Team2", "Team3" # Connect to Microsoft Teams using your admin credentials Connect-MicrosoftTeams # Loop through each team and add the user to all channels foreach ($team in $teams) {     # Get the team object     $teamObject = Get-Team -DisplayName $team          # Add the user to the team     Add-TeamUser -GroupId $teamObject.GroupId -User $user          # Get all the channels in the team     $channels = Get-TeamChannel -GroupId $teamObject.GroupId          # Loop through each channel and add the user    ...

Microsoft Viva Insights and Viva Insights Manager app

  Microsoft Viva Insights is a platform designed to help organizations promote employee well-being and productivity by providing data-driven insights and recommendations. It is an AI-powered tool that provides personalized insights to individuals, managers, and leaders. Viva Insights uses data from multiple sources such as Office 365, LinkedIn, and other business applications to analyze work patterns and provide insights on employee well-being, productivity, and collaboration. The platform is designed to help individuals manage their work-life balance by providing insights and recommendations on managing work hours, prioritizing tasks, and taking breaks. It also enables managers to identify potential burnout risks, track employee engagement, and support their team's well-being. Viva Insights provides a range of reports and dashboards that allow organizations to track employee well-being and productivity metrics and make data-driven decisions to support their employees. Additionally...