Baseball Performance Metrics Dashboard

High Level Design

Overview

For professional baseball teams, understanding the team’s performance is highly valuable for game and business strategies. Insight about team and player performance can drive important decisions for in-game strategies and possible trade business deals.

Goals

Increase the total number of games won by increasing the runs scored per game ratio. Increase the player’s productivity by optimizing their every at-bat and optimizing batting averages.

Objectives

  • Understanding current performance by using high-level KPIs.
  • Increase batting average per at-bats.
  • Ability to identify and prioritize pitching rotation and batting orders.

KPI Architecture

Objectives

KPIs

Measures

Data Source

 

# Wins

Total number of wins

Count(Wins)

FACT Teams

Total Runs

Total number of runs scored

Sum(Runs)

Fact_Teams

Total Hits

Total number of hits by team and player and by category

sum(hits)

Fact_Teams and dim_player

dim_hitType

 

Stolen Bases

Total number of stolen bases

sum(SB)

Fact_Teams

 

Total hits by type

sum(hits) by category(1B, 2B, 3B, HR)

FACT_Team and Dim_HitType

Entities Relationship Diagram

Baseball Performance Metrics Entities-Relationship-Diagram

Plugins & Scripts

  1. Blox plugin
  2. Tabber plugin
  3.  Widget Title Style plugin

Implementation
Kit

The following resources will enable you to design your dashboard and data model with sample data and then apply it to your own data. Note that you will need to have a previously installed version of Sisense (you can use the free trial version if you’re not a customer).

Sample data and dashboard examples (direct download)

Documentation