Analytics & AI for Modern Excel
Ever needed to do the following in Excel or Power BI? Process and analyze text data (regular expressions, sentiment analysis, etc) ⌨️Load in very large or unusual datasets using parallel …
Continue Reading about 👉 Microsoft wants YOU to learn Python! 👈 →
This is something that happens to me all the time: I've got data in an Excel table and want to add an index column (because I believe every dataset should have an index column). Index columns …
Continue Reading about How to add data to the left of an Excel table →
Over the past couple of years, I've had the fortune of managing the data science and data analytics programs of a leading coding bootcamp. Before this experience, I was skeptical of the market. I …
Continue Reading about Busting the myths about data bootcamps →
Recently I was a guest on the Enterprise DNA podcast, "The Analytic Mind" on the topic of improving literacy. As an analytics book author, trainer and course developer, developing analytic talent …
Continue Reading about Catch me on the Analytic Mind podcast: Improving Data Literacy →
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! →
If you've heard that Excel can only handle 1,047,576 rows... well, that's not so true anymore. With Power Query, it's now possible to work with millions of rows, building a fully reproducible …
Continue Reading about Sigma Rule #1,048,576: Never underestimate Excel →
