Teaching analytics with modern Excel
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 →
Analytics tools are best thought of as a "stack," so that each slice is seen in context with the others. The most exciting analytics products span multiple slices, combining the advantages of …
Continue Reading about Learning guide: Python + SQLAlchemy, half-day workshop →
The first personal spreadsheet computer application was released in 1979. Its name, "VisiCalc," was short for "visual calculator." I like to bring this up when explaining the benefits of using …
Continue Reading about Learning guide: Financial modeling in Excel, half-day workshop →
Multiple groups and points in time I tend to start teaching inferential with the independent samples t-test, which allows users to compare means between two groups. That may sound so …
Continue Reading about Learning guide: Intermediate statistics in Excel, one-day workshop →
At this point in my career, I shouldn't be surprised by how many professionals use a lot of Excel. But teachers are another example I hadn't considered... and once I did, I couldn't stop thinking …
Continue Reading about Excel for teachers learning guide, half-day workshop →
Data analytics isn't just about crunching numbers and hacking data pipelines. It's about telling stories and, as Rod Stewart tells us, every picture tells a story. So, data visualization goes …
Continue Reading about Learning guide: Introduction to Tableau, half-day workshop →
