Work Smarter, Not Harder: Learn In About 3 Minutes! — We’ve all been there: pulling data from a large table with LOTS of numerical columns that need to be aggregated. Why type out ‘SUM(col_1) AS col_1, etc’ for each of the 30+ columns when it can be much simpler? Note: The second super time-saver follows this first magic trick! Excel Can Be Used For More Than Just Pivot Tables In…

Everybody’s Using It, Make Sure They Know How! — Excel is king. It’s probably used by a lot of the stakeholders in your company. It’s commonly used for quick analysis. It has a rather low barrier of entry when compared to coding. …

You’ll Need More Than Just Reading and Videos — In a recent article, I talked about what makes a great data analyst while focusing more on traits or characteristics and sprinkling in some hard skills/technologies. …

Open Data Sets: They’re Not Just For Visualizations and Models — I’m going to explain how you can add value as a data analyst to your current/future potential employer without actually ‘analyzing’ data! ‘Boom!’ — Your Mind, Because It’s Just Been Blown What’s This Crazy Talk?!? Acquire, prep, and explore are three of the earlier stages of the data pipeline. ‘Ok, but how does that…

Your Stakeholders Deserve Better Than Low Hanging Fruit — ‘…And this is the group that no one ever comes into Career Day and addresses, AND IT’S CRIMINAL!’ — The Great Philosopher, Randolph Dupree Questions and ideas are very important when working with data. Moving numbers around and just focusing on when a KPI goes up or down can be…