George J. Mount

5 min read 2022-07-01 20:17:30

10 random tips for onsite training

I’ll be honest, it took some time to get back into the routine of onsite training. How many months had it been, anyway? (Don’t answer that.)

2 min read 2022-06-29 23:20:07

Here’s a little secret: No one is impressed by that giant Frankenformula you wrote in Excel. Just like with writing anything, the less verbose you

4 min read 2022-06-27 21:21:13

Ever needed to do the following in Excel or Power BI? Process and analyze text data (regular expressions, sentiment analysis, etc) Load in very

4 min read 2022-06-25 23:48:09

This is something that happens to me all the time: I’ve got data in an Excel table and want to add an index column (because I believe every dataset

3 min read 2022-06-22 19:06:19

Over the past couple of years, I’ve had the fortune of managing the data science and data analytics programs of a leading coding bootcamp. Before

2 min read 2022-06-21 20:01:15

Recently I was a guest on the Enterprise DNA podcast, “The Analytic Mind” on the topic of improving literacy. As an analytics book author,

1 min read 2022-06-14 19:17:14

BIG congratulations to Tobias Zwingmann as his new book AI-Powered Business Intelligence went to the printer this week. Back when writing my own

2 min read 2022-03-28 02:03:00

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

3 min read 2022-03-09 21:49:13

I love Excel. It’s a bedrock of my blog and largely my “claim to fame” as an authority. That said, early on I intended this not to just be an

3 min read 2022-02-26 16:03:00

Recently I was working on a project where I needed to convert a bunch of Jupyter notebooks to another format, specifically the .py Python script.

6 min read 2022-02-17 04:10:03

This may shock you, but here goes: I LOVE Project Runway. In fact, I find the show buried with lessons for anyone interested in marketing and

8 min read 2022-02-16 00:33:04

Back in the LinkedIn poll craze of 2021 I will admit I, like many users, got a little carried away. To my credit, all (or at least most ) of my polls

2 min read 2022-02-12 21:53:00

While one of the newer tools in the analytics toolkit (it’s not even 10 years old), Power BI has certainly made its mark on the landscape. I

1 min read 2022-02-04 01:58:51

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

3 min read 2022-02-03 20:35:00

Nearly every technical profession has some tool for wireframing, prototyping and down-and-dirty work. For data analysts, that’s Excel. So I find