Publications by George Mount

A basic Python Excel workflow

20.07.2021

If you’re just getting started with building reports and other analyses in Excel using Python, it be can be confusing to see how all the steps and packages fit together. This post and accompanying visual is meant to map the basic process. If you’re not familiar with the concept of packages in Python, check out this post.There are many possibl...

4746 sym 2 img

Learning guide: Introduction to Python, half-day workshop

20.07.2021

In 2011, Marc Andreesen claimed that software is eating the world.With hindsight, we can be more specific: Python is eating the world. The open source language is more popular than ever and sees no end in sight.While it may sound intimidating and like too much work to some analysts, I believe that data analysts should learn a scripting language l...

2847 sym 2 img

Sourcing Python packages: A decision tree

25.07.2021

I’m sure many readers got excited by the data science possibilities of the title. However, decision trees are more than statistical algorithms — in a broader sense they are any schematics used to help chart actions and consequences, whether probabilities are given or not.In this post, we’ll use a decision tree as a workflow for the best way...

4040 sym 10 img

Take the Advancing into Analytics event survey

25.07.2021

Have you attended a meetup or presentation related to my book Advancing into Analytics? Would you like to? I would love your feedback!Please let me know in the following form what you found most engaging and how your organization could benefit the most from the material. If you’d like to learn more about the book, visit this page. Once again, t...

652 sym 2 img

Can you crunch these nine data brain teasers?

26.07.2021

I’m a big fan of using art and drawings to clarify data problems and workflows. But in this case, let’s use them to conceal the identity of common data procedures, methods and more.Below you’ll find nine images; based on the figures and words in them, can you sound out what data concept each represent? Some are stats-related, others about p...

1251 sym 20 img

Free white paper: Five things Excel users should know about Python

02.08.2021

If you’ve visited my blog before you’ll know that I see Excel as a valuable slice of the data analytics stack. In fact, I think it’s the best way to learn analytics. Another slice of that stack is programming languages, including Python.All signs point to Python becoming integrated with Excel, and there’s lots of interest about the langua...

2349 sym 6 img

Welcome to my data meme page

05.08.2021

If you work with data, you need a good laugh every now and again. And nothing says “Internet break” like a good meme trawl.Now, I like a meme just like the next guy, but I have trouble thinking of my own. One (possible) exception is in the category of data memes — I’m not saying they’re the best, but they’ve been known to bring a micr...

1450 sym 12 img

Your Python launch checklist

09.08.2021

I have written about Python, the open source programming language, throughout the blog. However, I understand that my readers, traditionally Excel users, may not have Python installed on their machines or done much programming before.The purpose of this resource guide, then, is to serve as a “mission control” for getting you off the ground w...

1459 sym 6 img

Free workshop: Advancing into Analytics — Getting started

12.08.2021

Advancing into Analytics is a wide-reaching a technical book: starting with the foundations of analytics of Excel, readers are introduced to data manipulation, visualization and hypothesis in both Python and R. Learning all this in one book is possible because of what Excel users already know about working with data: they’ve sorted, filtered a...

2501 sym 4 img

Advancing into Analytics course wait list

26.08.2021

Getting into analytics can be overwhelming: so many tools to learn and techniques to apply. Advancing into Analytics is a great start made even better with practice and supplemental knowledge.That’s where a class can come in handy, and I’m excited to share that I’m working on a companion course to the book.It culminates with what I call...

1378 sym 4 img