Teaching analytics with modern Excel
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 →
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) →
You may have heard that my business name, Stringfest Analytics, is in part musically inspired. So it was great to speak with another data professional with a similarly-named YouTube channel: Gašper …
