In a previous post, I showed how to take a tenancy schedule from a real estate brochure PDF and turn it into a Power BI dashboard. In the last post, we focused on retrieving and cleaning the …
Python in Excel: How to do hierarchical clustering with Copilot
Hierarchical clustering is a technique that groups similar data points into clusters based on their attributes, forming a hierarchy or tree-like structure. Imagine organizing customers based on their …
Continue Reading about Python in Excel: How to do hierarchical clustering with Copilot →
Python in Excel: How to generate descriptive statistics
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 →
Is Excel’s user interface just too good for AI?
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? →
Will Python, Copilot, and Excel make Power BI obsolete?
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? →
How to add a date table to the data model in Excel Power Pivot
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 →