Power BI Session Planner - Level 1

1. Welcome

   4 lessons

   1. Course Overview
   2. Support Mechanisms
   3. Sport Horizon Education Platform
   4. Course Material

2. Module 1 - Connecting to the Sport Horizon Insights API

   6 lessons

   1. 1.1 – What Is the Sport Horizon Insights API?
   2. 1.2 – Setting Up API Parameters in Power BI - Part 1
   3. 1.3 – Setting Up API Parameters in Power BI - Part 2
   4. 1.4 – Connecting to the Athletes API Using Advanced Editor
   5. 1.5 – Connecting to the Drills & Sessions APIs
   6. 1.6 – Quick Table Overview & Data Modelling Introduction

3. Module 2 - Data Preparation & Modelling

   8 lessons

   1. 2.1 – Date Formatting
   2. 2.2 – Additional Column Formatting
   3. 2.3 – Intensity Metric Calculations
   4. 2.4 – Data Filtering
   5. 2.5 - Renaming Drill Titles
   6. 2.6 - Grouping Data by Drill Titles
   7. 2.7 – Creating a Calendar Table
   8. 2.8 – Building the Data Model

4. Module 3 - Drill Overview Report (Team-Level)

   15 lessons

   1. 3.1.1 - Drill Report Design Layout
   2. 3.1.2 - Page Navigation
   3. 3.1.3 - Most Frequently Used Drill Chart
   4. 3.1.4 - Most Demanding Drills Chart
   5. 3.1.5 - Creating Drill Categories Using DAX
   6. 3.1.6 - Drill Frequency by Day Type Chart
   7. 3.1.7 - Modifying Day Type Categories
   8. 3.1.8 - Custom Sorting Day Type Values
   9. 3.1.9 Table Layout Edits
   10. 3.2.0 - Dynamic Metric Switching Using DAX
   11. 3.2.1 - Using Bookmarks With Filters
   12. 3.2.2 - Power BI Challenge
   13. 3.2.3 - Power BI Challenge Solution
   14. 3.2.4 - Adding Final Filters
   15. 3.2.5 - Dynamic Report Headers

5. Module 4 - Single Drill Analysis (Team Level)

   11 lessons

   1. 4.1.1 - Drill Layout Walkthrough
   2. 4.1.2 - Ranking Drills With DAX
   3. 4.1.3 - Conditional Formatting of Fonts
   4. 4.1.4 - Positional Breakdown
   5. 4.1.5 - Dynamic Text Headers
   6. 4.1.6 - Percentage of Max Speed
   7. 4.1.7 - Drill Usage Over Time Chart
   8. 4.1.8 - Chart Editing
   9. 4.1.9 - Drills URL Table
   10. 4.2.0 - Drill Picture With Custom Visual
   11. 4.2.1 - Final Report Edits

6. Module 5 - Session Load Planner

   13 lessons

   1. 5.1.1 - Report Layout
   2. 5.1.2 - Creating Parameters
   3. 5.1.3 - Table Filtering Limitations
   4. 5.1.4 - Session Load Measure
   5. 5.1.5 - Adding Additional Metrics
   6. 5.1.6 - Drill Card Layout
   7. 5.1.7 - Bookmark Development Tips
   8. 5.1.8 - Calculating Session Duration
   9. 5.1.9 - Day Type Benchmarking Table
   10. 5.2.0 - Estimated Load vs Benchmark
   11. 5.2.1 - Merging Drill URLs
   12. 5.2.2 - Hiding Drills
   13. 5.2.3 - Final Session Load Planner Edits

7. Module 6 - Wrap Up

   7 lessons

   1. 6.1.1 - Exporting Planned Session to PDF
   2. 6.1.2 - Creating a Home Page
   3. 6.1.3 - Practical Application
   4. 6.1.4 - Key takeaways - Power BI
   5. 6.1.5 - Next steps
   6. 6.1.6 - One last message!
   7. Power BI Session Planner Level 1 - Course Feedback