This module explores how to create a report meant for coaches to evaluate an opposing hockey team.
On this Page
Learning Objectives
By the end of this module, you will be able to:
- Source, clean and use AHL data and create a light data pipeline that can be refreshed daily.
- Use the AHL data to create custom metrics, which can be used to build a team comparison report.
- Build the team comparison report in a professional, clean and intuitive way.
Module Map
This module contains the following progressive lessons.
- Lesson 1: Sourcing AHL Data and Setting Up Your Data Pipeline
- Introduces how to source, clean and normalize the AHL data and set up a data pipeline that runs on a daily basis.
- Lesson 2: Building a Simple Coaches Report
- Walks through how to build a simple Coaches Report to compare teams.
- Lesson 3: Current and Historical Views for the Coaches Report
- Augments the Python code to create views that can be used for trend analyses.
- Lesson 4: Final Design of Coaches Report
- Adds design and readability elements to the Coaches Report.
Module Resources
For all of the module resources, such as data, code, analysis/project files, and so on, be sure to check out our GitHub Repository. We reference specific links throughout the module, but there are many more code and data resources we included in the repo for your learning.
Key Takeaways
In our experience, we've seen some amazing dashboards and some duds. If you are a sports or data analyst, and you'll need to be building dashboards on a daily basis, here are a few takeaways for you.
- Scope the dashboard or report around a specific topic - a dashboard shouldn't wander.
- Structure the dashboard or report from high-level to more detailed within that topic. Context on the summary level is helpful for audiences who don't have the full context.
- Keep titles intuitive and descriptive of what's in the report or visualization. This helps call consumers of your report to the point of the visualization.
- Storytelling is just as important in a report as it is in a social post; it's just a different audience.
- Build templates and reusable designs for your Power BI (and Tableau) reports and dashboards. It'll save you time and help people consume your reports.