Initial Steps in a Data Analysis Pathway

So instead of starting straight out the door with some deep insight into Excel, I thought it better to provide an overview of a data analysis pathway (of sorts ;)).

Generally when working in sport we collect 2 different “types” of data, one thats collected/altered intermittently (player information, testing data, anthropometrics, max velocity, min/max heart rate, seasonal information) and one thats collected on a regular basis (GPS/HR, VBT, Wellness, Screening, HRV etc.).

I like to store these 2 “types” on separate spreadsheets and then pull them together when needed using PowerPivot (will be covered later in the blog) to produce reports or further analyse the data. The benefit of having it this way is that it helps reduce excessive data building up in one sheet which can really slow down some computers (and most people in sport won’t have the newest processor to speed things up either!). Similarly if you go down the analytics rabbit hole too far, over time data such as GPS can really buildup quickly so having the ability to quickly access a personal details file can be quite beneficial.

So that’s the first tip done with……short and sharp!

Join me the next blog….The first step…2!

EDIT – 30/01/2019

If you have experience with R, it can help streamline these processes by automating them to a much greater degree than PowerPivot/PowerQuery allow.

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Blog at WordPress.com.

Up ↑

%d bloggers like this: