Modern business intelligence demands speed, and utilizing AI tools for Excel is the ultimate way to hyper-charge your data workflows this year.

My reports update themselves now.

Learn how to use Excel's new GROUPBY and PIVOTBY functions through five real-world examples, ranging from easy to hard. This ...

An unpatched SQL injection vulnerability in the Ghost content management system has been weaponized in an active, large-scale cyberattack that has compromised more than 700 websites worldwide — ...

Power Query and Power Pivot help Excel users manage large datasets more efficiently. Power Query focuses on cleaning and preparing data, while Power Pivot handles analysis and reporting. Together, ...

DuckDB is an amazing tool with deep integration with Python and R, but sometimes you just need data in Excel. xlDuckDb allows DuckDB SQL to be run within Excel. Query results are returned as regular ...

This article is not about ethics, privacy, security, ownership, or corporate governance — I am going to circumvent all of this here by using some made-up data relating to supermarket sales: Here, I ...

Tenable Research discovered two novel vulnerabilities in Google Looker that could allow an attacker to completely compromise a Looker instance. Google moved swiftly to patch these issues.

Another year passes. I was hoping to write more articles instead of just these end-of-the-year screeds, but I almost died in the spring semester, and it sucked up my time. Nevertheless, I will go ...

Every data engineering team right now is being asked the same question: "How do we build a chatbot that talks to our data?" The prototypes are deceptively simple. A developer connects GPT-5.1 to a ...