Teaching analytics with modern Excel
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 were done in good faith to generate a …
Continue Reading about We should be teaching Tables and Power Query in Excel way earlier →
Nearly every technical profession has some tool for wireframing, prototyping and down-and-dirty work. For data analysts, that's Excel. So I find it humorous when the "tech bros" of the world …
Continue Reading about Free checklist: 30 days to Excel data analyst →
This event has concluded. A replay of the webinar is available below. I'll be giving a free, online presentation in partnership with Data Science Dojo entitled "Python for Excel Users Crash …
Continue Reading about Python for Excel Users Crash Course (Data Science Dojo online presentation) →
Steve Blank's famous dictum that entrepreneurs "get out of the building" is relevant to so many endeavors. Especially as analysts and professionals, how can we hope to do anything meaningful with data …
Continue Reading about Learning guide: Excel for healthcare administrators, half-day workshop →
If you're an Excel user interested in building one-of-a-kind visualizations and stretching your analytics limits, R is a great program to add to your toolkit. It's also a natural stepping-stone into …
Continue Reading about Here’s how R and Excel think similarly about data →
A tabular dataset is arranged in two dimensions -- what in Excel we would call rows and columns, but a fancier statistical way of saying this is observations and variables. …
Continue Reading about Variables vary… and why that matters →
