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 few lines of code, which you can follow along with below: Moral of the story What ...

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 code is created and maintained gives it distinct advantages and disadvantages over proprietary software. And if ...

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 was some other proprietary toolkit from IBM or Oracle, paid off-the-shelf software, and so forth. These days? ...

Disclaimer: I realize comparing Python to another animal is a little confusing, but bear with me… If you hadn’t noticed, I am a big fan of helping data analysts see that the marginal benefit of them learning to code exceeds the marginal cost. For heavy Excel users, I tend ...

I recently presented a ~45min session at the Enterprise DNA Analytics Summit on the topic of automating & augmenting Excel with Python. This is an in-demand topic and there’s likely to be an official Python Excel integration in the future. Until then, there are lots of great opportunities to using ...

What makes a great analyst, and how do you interview to find one? These are topics close to my heart and mission, and I had a great time speaking with those who feel the same at Enterprise DNA, an analytics community specializing in Power BI. Among other topics, we discussed ...

I’m excited to share that I’ll be presenting to the MS Excel Toronto meetup on Weds 12/8 at 5p Eastern. The topic is “What Excel Users Should Know about Python.” This is a free online event. Register now for this free online event. I’ve presented to this meetup ...

Kick-start your journey into data analytics; read the book later About this event Free signed copy of Advancing into Analytics Workshop recording Demo notes and handouts If you’re an analyst or researcher looking to level up your data analysis skills, this is the workshop and book for you. After ...