Analytics & AI for Modern Excel
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 →
I like to call SQL the cool old uncle of analytics because, no matter what you are trying to do with your data, SQL has probably done it before. For as impressive as the new Microsoft stack is, …
Continue Reading about Learning guide: SQL for Excel users, half-day workshop →
I remember my first days of coding R: I would search around for how to do X task, and find out that Y package would be really helpful. But that led to more questions: What are packages in the first …
Continue Reading about How open source packages are like smartphone apps →
I do, but I don't get the disdain toward Excel that's so common among many technically-inclined data and tech people. The way I see it, most tech professions have some medium for wireframing, …
Continue Reading about Learning path: Fundamentals of data visualization in 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 blog post I offered five ways to get help in R. This post serves as the Python equivalent, assuming you are working in Jupyter notebooks. 0. Web search it This one seems …
