Teaching analytics with modern Excel
John Michaloudis reserves an annual edition of his MyExcelOnline podcast to a roundup of the top Excel tips and tricks of the year from community leaders. I was happy to again be invited to …
Continue Reading about Consider learning Python: MyExcelOnline Podcast Top Excel Tips of 2021 →
This event has concluded. A replay of the webinar is available below. I'll be giving a free, online presentation in partnership with Data Science Dojo entitled "Python for Excel Users Crash …
Continue Reading about Python for Excel Users Crash Course (Data Science Dojo online presentation) →
Anscombe's quartet is a well-known statistical parlor trick with a powerful message. Fortunately, with the help of the seaborn package as well as pandas, it can be demonstrated in Python with just a …
Continue Reading about How to visualize Anscombe’s quartet in Python →
I'm a big believer that data analysts will derive far more value from their tools when they understand the underlying philosophy and worldview of those tools. For example, the way that open source …
Continue Reading about Here’s how R and Python think differently about data →
For a long time, many data analysts worked firmly ensconsed in the Microsoft stack -- definitely Excel, maybe some Access, PowerPoint or VBA serving as the automative glue. If it wasn't Microsoft, it …
Continue Reading about What data analysts should know about open source →
Disclaimer: I realize comparing Python to another animal is a little confusing, but bear with me (pun intended)... If you hadn't noticed, I am a big fan of helping data analysts see that the …
Continue Reading about What the Hedgehog and the Fox says about Power Query and Python →
