Teaching analytics with modern Excel
A field in technology such as data analytics moves quickly. Tools come and go. Methodologies are hyped and scrapped. How do you keep up with changes in the industry? In this post I'll show you some …
Continue Reading about How to follow trends in data analytics (free resources) →
Here’s an overlooked way to grow your analytics career: become a book reviewer. 📚 Why technical book reviewers are needed Have you ever thought about what could go wrong with a technical book? …
Continue Reading about How to get started reviewing technical books →
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 →
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 →
It seems like it would be hard to beat the data scientist, the so-called "sexiest job of the 21st century," but it looks as if the humble data analyst may have just done that. What do I mean? And why? …
Continue Reading about Why data analysts are becoming more popular than data scientists →
Power Query is rightly known for its abilities to clean data in Excel. But did you know about its data profiling powers? Let's take a look now at a modified version of the penguins …
Continue Reading about How to profile data in Excel with Power Query →
