Tag: #DataAnalysis

Boston Crime Stats Revisited – Excel Labs Agent Mode Does The Job.

Earlier this year I compared Google Colab and Excel Copilot for analyzing Boston Crime Statistics (Google Colab vs Excel Copilot). This time I tried the same data set with Excel Labs Agent Mode and it was a completely different experience in Excel.

With the same dataset – 260,000 records of Boston crime incidents – and the difference is night and day. Where Copilot stumbled and failed, while Agent Mode delivered a complete analysis with explanations and recommendations, all while staying comfortably within Excel.

From Formulas to Conversations: How Excel’s Agent Mode Will Redefine Data Analytics

It used to be great to find others that ‘spoke Excel’ – understood the intricacies of the various lookup formulas or when to use index…match. I have spent some time working with Excel Labs Agent Mode and the ‘old’ Excel world is about to change dramatically.

Excel Agent Mode has arrived as part of Microsoft’s Frontier preview program, and after testing it myself to create survey data for my training courses, I can see this isn’t just another incremental update (spreadsheet link included in Further Reading section below). It might make those ribbon menus obsolete.

GenAI Data Analysis: Google Colab’s Gemini vs. Excel Copilot — Which One Should You Use for Conversational Data Analytics?

AI assistants are now integrated into the data tools you use daily, helping to reveal the stories and patterns in your data with natural language commands. Two of the tools I have been working with lately are Google’s ‘Analyse with Gemini’ in their Colab Notebooks and Microsoft’s Copilot in Excel with it’s ‘Advanced Analysis’ prompt. These tools, while on the surface appear similar, do have differences that make them suitable for different types of users.

Why Deep Research AI Models Are the New Power Tool for Business Professionals

I wrote about Deep research models back in February and since then I have been actively integrating them into my business processes (both ChatGPT and Gemini version) and I thought the subject was worth revisiting in more depth. For me they have made a huge difference in everything from developing strategic plans to pre-meeting research.