Give me six hours to chop down a tree and I will spend the first four sharpening the axe.Lincoln’s wisdom is easily applied to data analysis. Very little of working with data is actually running the …
30 Seconds Spent Better: Resume Visualization
One of the first things job-seekers will hear is that a recruiter is only going to spend about 30 seconds reading your resume. This seems overstated. With the average job posting getting dozens of …
Continue Reading about 30 Seconds Spent Better: Resume Visualization →
VLOOKUP with a Crystal Ball
I call vlookup the "duct tape of Excel" -- it's a cheap, easy way to patch together two sets of data. Like with any patchwork solution, things can get out of order. How to avoid constantly …
“The End of College” and the Future for Analysts
I read Kevin Carey’s The End of College, a surprisingly controversial book. Carey lists the flaws of American higher education and predicts how "creative destruction" will upend it. These …
Continue Reading about “The End of College” and the Future for Analysts →
Highlight Every Cell Containing a Formula
Checking for data accuracy is tricky in Excel. In this blog, I have been presenting some of my tips. This is a great one for more visually-oriented users. We have a simple inventory model below. …
Continue Reading about Highlight Every Cell Containing a Formula →
The Unified Theory of Analysts
When looking for my first full-time job, I knew I wanted to be an “analyst.” But there were so many analyst titles – financial business, and systems, to name a few. How are they all alike and …