Skip to content

SportSciData

Data analysis solutions for sport science/S&C

  • Home
  • About Me
  • Contact Form

Excel

Using PowerPivot to Analyse Velocity Data

Posted on 7th Oct 201830th Jan 2019 by SportSciData

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

Posted in Excel, GPSTagged Data Analysis, GPS, Intermediate, PowerPivot, S&C, Sport ScienceLeave a comment

Excel Basics: Named Ranges

Posted on 6th Oct 201830th Jan 2019 by SportSciData

Explaining ranges and named ranges in Excel

Posted in Excel, GeneralTagged Basic, Data Analysis, Excel, FormulasLeave a comment

Excel Basics: Cell References

Posted on 5th Oct 201830th Jan 2019 by SportSciData

Explaining relative and absolute references in Excel

Posted in ExcelTagged Basic, Data Analysis, Formulas, S&C, Sport ScienceLeave a comment

Excel Basics: DAX in PowerPivot

Posted on 4th Oct 201830th Jan 2019 by SportSciData

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

Posted in Excel, GPSTagged Data Analysis, Excel, GPS, Intermediate, PowerPivot, S&C, Sport ScienceLeave a comment

Excel Basics: Linking Files in PowerPivot

Posted on 3rd Oct 201830th Jan 2019 by SportSciData

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

Posted in Excel, GPSTagged Basic, Data Analysis, Excel, GPS, PivotTables, PowerPivot, S&CLeave a comment

Excel Basics: PowerPivot

Posted on 2nd Oct 201830th Jan 2019 by SportSciData

Our 1st steps to producing graphs and reports using PowerPivot!! #LetxExcel #SportScience #DataAnalytics

Posted in ExcelTagged Basic, Data Analysis, Excel, GPS, PowerPivot, S&C, Sport ScienceLeave a comment

Initial Steps in a Data Analysis Pathway: 5 (2)

Posted on 1st Oct 201830th Jan 2019 by SportSciData

Using pivot tables to produce full session data from individual periods.

Posted in ExcelTagged Data Analysis, Excel, GPS, Intermediate, PivotTables, S&C, Sport ScienceLeave a comment

Initial Steps in a Data Analysis Pathway: 5

Posted on 30th Sep 201830th Jan 2019 by SportSciData

Separating data from multiple periods into session

Posted in ExcelTagged Data Analysis, Excel, GPS, PivotTables, S&C, Sport ScienceLeave a comment

Initial Steps in a Data Analysis Pathway: 4

Posted on 28th Sep 201830th Jan 2019 by SportSciData

Merge data-sets through PowerQuery

Posted in ExcelTagged Data Analysis, Excel, PowerQuery, Sport ScienceLeave a comment

Dealing with Dates (It can get complicated!)

Posted on 27th Sep 201830th Jan 2019 by SportSciData

Date format tip when using multiple systems

Posted in ExcelTagged Data Analysis, RStudio, Sport Science, TableauLeave a comment

Posts navigation

← Older posts
Newer posts →

Follow me on Twitter

My Tweets

Previous Posts

  • Aug 2022 (6)
  • Apr 2019 (1)
  • Mar 2019 (2)
  • Feb 2019 (4)
  • Jan 2019 (4)
  • Dec 2018 (2)
  • Nov 2018 (7)
  • Oct 2018 (15)
  • Sep 2018 (12)

Tags

Advanced AMS Basic Conference Data Data Analysis Data Visualisation Excel Formulas ggplot Googlesheets GPS Guest Blog HRV Intermediate Load Monitoring Markdown Monitoring MSK MyTwoCents NewBlog PivotTables PowerBI PowerPivot PowerQuery Python Questionnaires R Report RStudio S&C Soapbox SportScience Sport Science Statistics Tableau Video Wellness

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 3,015 other subscribers.
Create a free website or blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • SportSciData
    • Already have a WordPress.com account? Log in now.
    • SportSciData
    • Customise
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...