Breaking Bad Data Habits

It’s a common mistake to get creative with your data in excel to such an extent that its next to impossible to use that data effectively.

The concept of keep it simple stupid is hard to follow as once a person has some data they tend to spend far more time formatting and decorating it then they do analyzing it. Its just human nature.

However when we don’t keep data in clean and easy to access formats, we pretty much make that data useless to anyone else who really wants to play with it.

The best and really only way to keep data useful is to have it in a simple column with 1 header row format. From that we can use numerous tools to both format and analyze the data like pivot tables and Tableau.

10592750_728053387243786_8229253185490727991_n

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s