Hackers and Slackers

Data Analysis

Drawing meaningful conclusions from data. Includes a broad spectrum from interpretation, dashboard creation, and data manipulation.

Getting Iffy With it

Adventures in Excel

If you've been following along, we discussed in the last several posts of this series how, if you're not working in a very "tech forward" organization (like my two compatriots on his site), but you have the same title, you're

Excel Author imageMax Mileaf Author imagesnacks Jun 10
Read

Taking Out the Trash

Dealing With Dirty Data Pt 2

In my last post, we explored the organizational structure of many large companies and how this pertains to one's duties as a fledgling data analyst. I highly recommend you go back and read the first post on "dirty" data, but

Excel Author imageMax Mileaf Author imagesnacks Jun 05
Read

Dealing with Dirty Data

Adventures in Excel

In my last post, we discussed what separates a true analyst (read: technical) from a project manager wearing the mask of an analyst like some Scott Snyder era Joker (I figure that there's a solid overlap between fans of comic

Excel Author imageMax Mileaf Author imagesnacks May 31
Read

Doing the Data Dance

Adventures in Excel

If you've been reading along, over the last several posts you've learned the two major skills that any self-respecting Excel jockey counts as their go-tos: the ability to lookup (remember, I'm partial to index-match, but if you learned VH lookup,

Excel Author imageMax Mileaf Author imagesnacks May 29
Read

Power to the Pivot

Adventures in Excel

During the last discussion, you've (hopefully) learned how to generate a pivot table, and learned about the four "buckets" that can house your columns:

  • Filter
  • Row
  • Column
  • Value

I'm also going to make the wild assumption that you've played around

Excel Author imageMax Mileaf Author imagesnacks May 24
Read

The One Formula to Rule Them All

Adventures in Excel

In my last entry, we discussed how to write a formula, and you've been armed with what each piece of the formula represents (the command, the variables, and the definition of an array). With this knowledge, you've actually been armed

Excel Author imageMax Mileaf Author imagesnacks May 18
Read