Analytics & AI for Modern Excel
Here’s a little secret: No one is impressed by that giant Frankenformula you wrote in Excel. Just like with writing anything, the less verbose you can write your formulas, the better. ✂ A few ways …
Continue Reading about How to write less verbose Excel formulas →
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! →
