Teaching analytics with modern Excel
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 →
Don't listen to the haters. Excel is a fantastic way to learn data analytics and a valued slice of the data analytics stack. That said, you may need to make a couple of tweaks from Excel's "default …
Continue Reading about Every dataset in Excel should include these two features →
For a long time, many data analysts worked firmly ensconsed in the Microsoft stack -- definitely Excel, maybe some Access, PowerPoint or VBA serving as the automative glue. If it wasn't Microsoft, it …
Continue Reading about What data analysts should know about open source →
Disclaimer: I realize comparing Python to another animal is a little confusing, but bear with me (pun intended)... If you hadn't noticed, I am a big fan of helping data analysts see that the …
Continue Reading about What the Hedgehog and the Fox says about Power Query and Python →
I liken finding Power Query in Excel for the first time to finding Narnia. A magical place... but hard to find, and maybe a little confusing. If you're not familiar, Power Query is an …
Continue Reading about Free checklist: 30 days to Excel Power Query →
