1 hour to Power Query in Excel (PDQ = Pretty Darn Quick!) It's the most exciting Excel development in a generation... but you'd be forgiven for not knowing about it! Overview This one-hour …
Demonstration of Anscombe’s Quartet in R
Due to the differences in scope between data analytics/business intelligence and data science, there's a school of thought implying that data visualization and statistics are more or less independent …
Continue Reading about Demonstration of Anscombe’s Quartet in R →
How to unpivot a dataset in Excel Power Query vs R vs Python
What makes data clean? You may not be able to name those qualities, but you likely know messy data when you see it. In this blog post, we'll look at a frequent offender: unpivoted data. You'll learn …
Continue Reading about How to unpivot a dataset in Excel Power Query vs R vs Python →
How to add data to the left of an Excel table
This is something that happens to me all the time: I've got data in an Excel table and want to add an index column (because I believe every dataset should have an index column). Index columns …
Continue Reading about How to add data to the left of an Excel table →
Free checklist: 30 days to Python programmer
Python has become in many ways the lingua franca of computing, with the open source language being used in everything from web development to artificial intelligence to... why, yes... data analytics. …
Continue Reading about Free checklist: 30 days to Python programmer →
Free checklist: 30 days to Pandas
Python is a curious animal (no pun intended) in that it wasn't exactly designed for data analysis, but with its many free packages this constraint is easily overcome. In particular, the pandas …