Teaching analytics with modern Excel
Have you ever needed to pull the first record of a dataset? What about the last, or maybe even the seventeenth? This is called indexing. There's a lot of data out there, and indexing gives us a set of …
Continue Reading about Zero-based indexing: What it is and when you’ve seen it before →
In an earlier post I offered a tour of RStudio, the popular integrated development environment and my preferred interface for teaching R. With Python, I favor Jupyter notebooks so figured a similar …
Continue Reading about A tour of Python + Jupyter Notebooks →
The Clark's Nutcracker has landed! That's the bird on the cover of Advancing into Analytics, copies of which I received the other day. There's that new author enthusiasm! You can now get your …
This event has concluded. Thank you to Danielle Stein Fairhurst for hosting and everyone for attending. A recording of the event follows and all materials are available at the GitHub repo. Dates …
Continue Reading about Advancing into Analytics: Financial Modelling in Excel Meetup (Australia) →
Excel is arguably the world's largest coding community, with 750 million users worldwide. Many of us, myself included, get introduced to the data world from Excel. But the thing is... Excel is not …
Continue Reading about Why most “coding for spreadsheet users” training fails →
I'm launching a book at a weird time. Toward the (one can only hope) end of a pandemic, book sales are booming, but it's so hard to …
Continue Reading about Five ways to support Advancing into Analytics (besides buying it) →
