Analysis can be overwhelming. Sometimes even the word “analysis” will cause panic in folks. Where do I start? How the heck do I pull insights out of all these numbers? Below you’ll find a few tips to help guide you in your analysis adventures.
Gathering data can be time-consuming, and you don’t want to have to do it twice. Before pulling data from your various sources, consider the following:
In addition, you should also have a general plan of how you’re attacking the problem. What tools are you using to manipulate the data? Excel, sheets, R? Have a rough idea of the steps you’re going to take. It’s worth it to spend some time in the front end preparing!
This one is closely related to the previous point of sorting out the details before rolling up your sleeves and getting into the nitty-gritty. With most analysis projects, you’ll have more direction (and an ultimately easier time) if you have a specific question you’re setting out to answer.
Some examples:
It’s easy to get bogged down in the weeds with data. When looking for insights, graphs can be incredibly useful in both finding and displaying learnings. Humans are visual creatures, we are designed to look for patterns. As you might guess, patterns can be hard to find when you’re looking at an Excel sheet or data table.
I don’t know about you, but I nerd out over a great graph or other data visualization. Here are some examples of some spruced up visuals.
Nothing is inherently wrong with tables…
But the takeaway is much clearer in graph form!
Here’s another example of some formatting tweaks that help drive the message home.
This one might seem like a no-brainer, but if there’s already a solution built for what you’re trying to accomplish, no sense in trying to reinvent the wheel (unless, of course, you can make improvements)! In some instances, you can take an existing tool and just modify it to fit your needs.
There are so many neat scripts and free resources out there, and many paid services also have tools built-in at your disposal. I’d recommend checking these options out before committing to creating a custom solution.
This article was originally published at Ppchero.com, by author Rachael Law. Original article >>
Recent Comments