A lot of people look at today’s AI boom and worry: “Are my Excel skills still useful? Will AI take my job and my spreadsheets?” The truth is the opposite. There’s never been a better time to lean into …
The End of DAX and M? How AI and Python Are Transforming Excel
As we delve deeper into the age of artificial intelligence and AI-assisted programming, a question arises: Are the plethora of programming languages in Excel becoming obsolete? With the advent of AI, …
Continue Reading about The End of DAX and M? How AI and Python Are Transforming Excel →
From beetles to beaches: The 2024 Stringfest year in review
Here’s a little secret: I usually start writing my year-in-review posts in November. By then, I’m often feeling a bit worn out and in need of some perspective. Reflecting on the year gives me the …
Continue Reading about From beetles to beaches: The 2024 Stringfest year in review →
Python in Excel: Why use Python for data visualization?
Excel has for decades been a mainstay for business and data professionals, providing a familiar environment for organizing, analyzing, and visualizing data. Its built-in charts and graphs offer a …
Continue Reading about Python in Excel: Why use Python for data visualization? →
How to understand the differences between matplotlib, seaborn and plotnine for Python in Excel data visualization
Data visualization is a fundamental aspect of effective data analysis. And although Excel is a versatile tool, certain visualization types remain difficult or even impossible to create with its …
Python in Excel: Creating layered and faceted visualizations with Plotnine
In a previous post, we explored the plotnine package in Python in Excel, highlighting how its implementation of the Grammar of Graphics allows for an almost limitless array of possibilities in …
Continue Reading about Python in Excel: Creating layered and faceted visualizations with Plotnine →