Introduction to using PowerBI and R together

# How to Speed Up Analysis In R

Part 1 of looking at improving analysis time

# Our Next Steps in Velocity Analysis in R

Creating days since max velocity and colour coding

# Using PowerPivot To Analyse Velocity Data: 2

Previously we arranged our data to look at the max velocity reached over the last 12 days. This may give us an indication of maximum velocity reached recently but we also need an indication of how many exposures at or near max velocity an athlete has had. There is likely to be a quicker way... Continue Reading →

# Using PowerPivot to Analyse Velocity Data

How to extract max velocity achieved in a given time-span

# Excel Basics: Named Ranges

Explaining ranges and named ranges in Excel

# Excel Basics: Cell References

Explaining relative and absolute references in Excel

# Excel Basics: DAX in PowerPivot

Showing how to use power pivot to add percentage of max velocity data

# Excel Basics: Linking Files in PowerPivot

How to create connections between tables in Excel with an example based around velocity data