Analytics & AI for Modern Excel
Many data professionals overlook descriptive statistics, thinking their datasets aren't suited to it or that it doesn't add significant value. But descriptive statistics are foundational: they allow …
Continue Reading about Python in Excel: How to generate descriptive statistics →
Excel faces an interesting challenge with integrating artificial intelligence tools like Copilot. Ironically, Excel's exceptional user experience might be precisely why AI integration feels slow and …
Continue Reading about Is Excel’s user interface just too good for AI? →
Over on LinkedIn, Dennis Sawyers is always a lively and outspoken voice worth following. His latest post has sparked my interest, compelling me to share my own thoughts candidly. Dennis argues …
Continue Reading about Will Python, Copilot, and Excel make Power BI obsolete? →
One of the best things you can do as an analyst is add context to your numbers. As Edward Tufte put it, frame the problem with the question "Compared to what?" in mind. Often in business …
Continue Reading about How to add a date table to the data model in Excel Power Pivot →
It seems like it would be hard to beat the data scientist, the so-called "sexiest job of the 21st century," but it looks as if the humble data analyst may have just done that. What do I mean? And why? …
Continue Reading about Why data analysts are becoming more popular than data scientists →
BIG congratulations to Tobias Zwingmann as his new book AI-Powered Business Intelligence went to the printer this week. Back when writing my own book, Advancing into Analytics, Tobias graciously …
Continue Reading about AI-Powered Business Intelligence: Congratulations! →
