Analytics & AI for Modern Excel
Are you a data analyst? Then you probably work too hard and need a break, otherwise you wouldn't be one 😼... OK, are you a data analyst and not convinced you need a break? Well, what if I made that …
Continue Reading about Every data analyst should watch The Joy of Stats (Review) →
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 one-hour …
Over on LinkedIn Paul "The FP&A Guy" Barnhurst wrote this post starting with a real throwdown: FP&A needs to spend less time with Excel and more time understanding the business. This can …
Continue Reading about Why data analysts need to get out of the building →
From Jordan Ellenberg's How Not to Be Wrong: The Power of Mathematical Thinking (a fantastic book for analysts): Derek Jeter, when bugged about being on pace to break Pete Rose’s career hit record, …
Continue Reading about Derek Jeter and the myth of “On pace for” →
Way too many people looking to get into data try running before they can walk: they want to train a neural network, for example, before they can append files together in Excel. But if you're looking …
Continue Reading about Looking for a data job? Google Trends shows you should focus on the basics →
From botched dates to missing records and more, poor spreadsheet management has led to major problems in scientific research. The prestigious journal Nature last week shared six tips for better …
