1 hour to Power Query in Excel (PDQ = Pretty Darn Quick!) It’s the most exciting Excel development in a generation… but you’d be forgiven for not knowing about it! Overview This free one-hour workshop will serve as an introduction to Power Query in Excel: How tables serve as the “...

What makes data clean? You may not be able to name those qualities, but you likely know messy data when you see it. In this blog post, we’ll look at a frequent offender: unpivoted data. You’ll learn what this is, how it can make for “tidier” data, and ...

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