Teaching analytics with modern Excel
Not only is Power Query a phenomenal tool for transforming data in Excel, it also enforces good data hygiene 🧼. What do I mean by that? Think about the steps that you take every day to present …
Continue Reading about How Power Query enforces good data hygiene in 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 →
