Python has become in many ways the lingua franca of computing, with the open source language being used in everything from web development to artificial intelligence to… why, yes… data analytics. If you’re a heavy Excel or Power BI user, Python is a great tool to add to your ...

To be honest, Python is not the easiest program to manage on your PC. I suggest newcomers download it from Anaconda because it does most of the behind-the-scenes lifting for you. Completely new to Python? Check out my Python launch checklist Among other benefits, Anaconda comes with many of the ...

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 participate in this podcast. This year, I chose more of a general piece of advice than ...

About this event Conduct rigorous data analysis that is easy to reproduce and share with colleagues Create beautiful visualizations that aren’t available in basic Excel and Power BI Collaborate more effectively with engineers, developers, data scientists and other technical professionals Signal to employers that you can work with a ...

Everything you need to get started with marketing analytics About this event Free signed copy of Advancing into Analytics Workshop recording Demo notes and handouts If you’re a marketing analyst looking to level up your data analysis skills, this is the workshop and book for you. After attending this ...

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 ...