Power BI for S&C Coaches - Level 1

1. Introduction to Power BI for S&C Coaches Level 1

   3 lessons

   1. Welcome & Course Overview
   2. Support and Resources
   3. The Sport Horizon Platform

2. Module 1 - Introduction to Power BI

   9 lessons

   1. Data Download
   2. Introduction
   3. 1.1.1 Why Power BI for S&C coaches
   4. 1.2.1 Downloading Power BI Desktop
   5. 1.2.2 Power BI Desktop Interface
   6. 1.3.1 Power BI Mobile and Cloud
   7. 1.3.2 Power BI Licensing
   8. 1.4.1 Example reports
   9. Module 1 Quiz

3. Module 2 - Connecting to Data

   8 lessons

   1. Introduction
   2. 2.1.1 Preparing your raw data file
   3. 2.2.1 Connecting locally to Excel
   4. 2.2.2 Connecting to a folder
   5. 2.2.3 Common mistake when using folder
   6. 2.3.1 Connection options in Power BI
   7. 2.4.1 Conneting to SharePoint
   8. Module 2 Quiz

4. Module 3 - Data Preparation in Power Query Editor

   18 lessons

   1. Introduction
   2. 3.1.1 Power Query Editor walkthrough
   3. 3.2.1 Removing and modifying columns
   4. 3.2.2 Filtering data
   5. 3.2.3 Tips and tricks
   6. 3.2.4 Date formatting error
   7. 3.3.1 Split and extract info from column
   8. 3.3.2 Creating a Session ID
   9. 3.3.3 Creating a Week ID
   10. 3.3.4 Conditional column
   11. 3.3.5 M Language if statement
   12. 3.3.6 Max speed m/s to km/h
   13. 3.3.7 Calculating % of max speed
   14. 3.3.8 Changing time format to duration
   15. 3.3.9 Creating intensity metrics
   16. 3.4.1 Basic Group By
   17. 3.4.2 Advanced Group By
   18. Module 3 Quiz

5. Module 4 - GPS Session Report Team

   19 lessons

   1. Introduction
   2. 4.1.1 Session and week table
   3. 4.1.2 Data model theory
   4. 4.1.3 Relationships
   5. 4.1.4 Data model practical
   6. 4.1.5 Data model problem solving
   7. 4.2.1 Adding a background and logo
   8. 4.2.2 Adding lines and text boxes
   9. 4.3.1 Creating a drop-down list
   10. 4.3.2 DAX theory
   11. 4.3.3 Columns vs measures calculations
   12. 4.3.4 Switch function
   13. 4.4.1 Edit interactions
   14. 4.4.2 Chart formatting
   15. 4.4.3 Sorting axis based on tooltip
   16. 4.4.4 Date filter across tables
   17. 4.4.5 Team averages
   18. 4.4.6 Average line
   19. Module 4 Quiz

6. Module 5 - GPS Load Planner

   14 lessons

   1. Introduction
   2. 5.1.1 Match benchmarking table
   3. 5.1.2 Considerations for match benchmarking
   4. 5.2.1 Data modelling
   5. 5.3.1 Parameters
   6. 5.3.2 Creating a target
   7. 5.3.3 Target with conditional formatting
   8. 5.4.1 Chart building
   9. 5.4.2 Column formatting tips
   10. 5.4.3 Merging tables
   11. 5.4.4 DAX calculation
   12. 5.4.5 Targets calculation
   13. 5.4.6 Page selection function
   14. Module 5 Quiz

7. Module 6 - Training Attendance

   11 lessons

   1. Introduction
   2. 6.1.1 Power Query Editor challenge
   3. 6.1.2 Challenge solution
   4. 6.1.3 Column from example
   5. 6.2.1 Data modelling
   6. 6.2.2 Filtering (report, page and visual)
   7. 6.3.1 Report layout
   8. 6.3.2 Dax calculations
   9. 6.3.3 Chart developments
   10. 6.3.4 Final chart edits
   11. Module 6 Quiz

8. Module 7 - CMJ Team Report

   14 lessons

   1. Introduction
   2. 7.1.1 Data preparation
   3. 7.2.1 Report setup
   4. 7.2.2 Drop down menus
   5. 7.2.3 Ranking based on date
   6. 7.2.4 Metric selection with switch function
   7. 7.2.5 DAX: combining switch functions
   8. 7.2.6 DAX: filtering based on jump height
   9. 7.2.7 DAX final code
   10. 7.3.1 Report design part 1
   11. 7.3.2 Report design part 2
   12. 7.3.3 Color formatting based on a measure
   13. 7.3.4 Final report edits
   14. Module 7 Quiz

9. Module 8 - CMJ Individual Report

   14 lessons

   1. Introduction
   2. 8.1.1 Ranking trials
   3. 8.1.2 Finding previous performance
   4. 8.1.3 Allowing blank cell for first trial
   5. 8.1.4 Percentage change
   6. 8.2.1 Report setup
   7. 8.2.2 Bookmarks – show and hide filter
   8. 8.3.1 Performance line chart
   9. 8.3.2 Asymmetry bar charts
   10. 8.3.3 RSI mod - line chart
   11. 8.3.4 Metric relationships with scatterplots
   12. 8.3.5 Bookmark layout
   13. 8.3.6 Filtering and highlighting
   14. Module 8 Quiz

10. Module 9 - Gym Report

    13 lessons

    1. Introduction
    2. 9.1.1 Data exploration
    3. 9.1.2 1RM estimation
    4. 9.1.3 Group sets together
    5. 9.1.4 Session ID
    6. 9.2.1. Report setup
    7. 9.2.2 Summary cards part 1
    8. 9.2.3 Summary cards part 2
    9. 9.2.4 Bookmarks on summary cards
    10. 9.3.1 Chart developments
    11. 9.3.2 1RM estimation chart
    12. 9.3.3 Joining the athlete table
    13. Module 9 Quiz

11. Module 10 - Publishing and Sharing

    6 lessons

    1. Introduction
    2. 10.1.1 Exporting to PDF
    3. 10.1.2 Publish to Power BI service
    4. 10.1.3 Refreshing data in Power BI service
    5. 10.1.4 Features in Power BI service
    6. Module 10 Quiz

12. Module 11 - Moving Forward

    5 lessons

    1. Key takeaways
    2. Trends
    3. Next steps
    4. One last message!
    5. Power BI S&C Level 1 - Course Feedback