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 …
Why data analysts need to get out of the building
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 →
Derek Jeter and the myth of “On pace for”
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” →
Looking for a data job? Google Trends shows you should focus on the basics
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 →
Six spreadsheet tips from Nature
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 …
“I want to get into data analytics… but as an independent professional, not a full-time employee”
"I want to get into data analytics... but as an independent professional, not a full-time employee" Big surprise -- I get a lot of questions about how to get started in data analytics. My typical …