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 →
Every dataset in Excel should include these two features
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 →
What data analysts should know about open source
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 →
What the Hedgehog and the Fox says about Power Query and Python
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 →
Free checklist: 30 days to Excel Power Query
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 →
Expert Roundtable: Python or R for Power BI? (Enterprise DNA)
If you've read my blog for any amount of time, you'll see I'm a big fan of helping analysts mix, match and augment their analytics stack. Heck, I've even written a book on how to learn Python and R as …
Continue Reading about Expert Roundtable: Python or R for Power BI? (Enterprise DNA) →