Teaching analytics with modern Excel
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 →
Not only is Power Query a phenomenal tool for transforming data in Excel, it also enforces good data hygiene 🧼. What do I mean by that? Think about the steps that you take every day to present …
Continue Reading about How Power Query enforces good data hygiene in Excel →
The other day the family ordered Chinese takeout.Normally one of us would take out a notepad and scribble notes, which often became illegible and ran across multiple pages. There has to be a better …
Continue Reading about I ordered Chinese takeout… then this happened →
As an analyst you will frequently receive data in FNAME LNAME format. This is poor data design -- it does not allow you to sort the data A-Z by last name. In this video I will show you how to convert …
Continue Reading about Convert from FNAME LNAME to LNAME, FNAME in Excel →
A reader had a group of items separated by commas which he wanted to turn into a vertical list. In this video I show how to transform the data using text-to-columns and paste special: …
Continue Reading about Excel Tip: Turning a comma-separated group of items into a vertical list →
The other day at work I was presented with a list of physicians for whom I needed to find some information. This was necessary only for physicians with ID numbers over 3 characters long.Rather than …
