topic Re: MLB Baseball Batting Statistics in Data Stories Gallery

MLB Baseball Batting Statistics

dsecpa — Mon, 20 Mar 2023 21:51:26 GMT

An overview of the pages: (update 2015 to 2022)

Cover Page:

This page uses wallpaper as well as buttons and is the home page of report. The other pages are all hidden, so the user will use the menu to navigate the report. The buttons use actions and bookmarks to act as the menu.

Top 10 Batting Categories:

This page allows users to see the Top 10 Players in various batting categories. The data can be sliced by season and position. Also this page uses Chiclet Slicer visualization from the marketplace. This provides a visual slicer using league and team logos to slice data.

Since there are too many batting categories to easily fit on one page, there are shape objects acting as "radio buttons" at the top of the page to allow a user to move from Page 1 to Page 2. These shape objects use actions, bookmarks and selection pane to control which visualizations show on the screen.

Batting Analysis:

This page has two components. On the right side of the screen, users can see league averages as well as leaders in various categories and an analysis homes runs and strike outs per at bat. On the left side there are slicers along with the selection of one player. The player name slice does not interact with the right side of the screen. This allows the user to compare one players statistics to the league leaders and league averages. The player stats are shown using the Advance Card visualization from the marketplace that allows for conditional formatting.

There are a couple custom tooltips used on this page including on the individual player name and the Strike Outs per At Bat and Home Runs per At Bat visuals.

This page also uses a page background to provide some outlines and shading around the visualizations.

Seasonal Trends:

This page looks at the three years of data across major batting categories. Again the page uses the Chiclet Slicer to select the team as a filter.

Position Analysis:

This page gives two different views of the batting categories with the ability to slice by season, position and team. The initial (graphical) view of the data uses Box and Whisker charts to show the high, low and medians of the data. The secondary (detail) view provides a table view of the data with conditional formatting. The views are switched by buttons on the left side using buttons, actions, bookmarks and selection pane.

Player Details:

Player details provides the standard table view of the data with the ability to select by season and team.

Drill Throughs:

There is a drill through setup on the player name field, so users can select to drill through on any player name in a visual to see more detail statistics.

This is just a sample of what can be done with Power BI and baseball statistics. The data model also includes data by team, but I have not had a chance to play with it yet. Feel free to download the file and build out your own reports.

eyJrIjoiZDdhMTQ1Y2MtZmVkZC00ZGE1LWI3MGMtNjAxNGY1NzQ0NWNlIiwidCI6ImJiOWNlYmY0LTdmY2YtNGFiOC05Njg5LTQxNWZlMzY4NGYwZCIsImMiOjN9&pageName=ReportSection62db92a735f96b9442cb

Re: MLB Baseball Batting Statistics

Anonymous — Wed, 14 Nov 2018 23:50:44 GMT

Sweet report! Do you know of any way to get data on where balls were hit? It would be awesome to create a dynamic spray chart!

Good work dsecpa

Re: MLB Baseball Batting Statistics

dsecpa — Thu, 15 Nov 2018 01:03:48 GMT

That would be a great report, but it would certainly take a lot of data. It appears there might be some data available at www.retrosheet.org, for every play and it looks like it has information about were the hit went. Might be an interesting project, but I would expect it would take some time to manipulate the data.

Re: MLB Baseball Batting Statistics

enmanuel — Mon, 20 Mar 2023 00:58:52 GMT

That's excellent report. I like it.

A question, How can I modified to update all season that have MLB? I mean, 2016 to 2023

Please.

Thanks.

Re: MLB Baseball Batting Statistics

dsecpa — Mon, 20 Mar 2023 21:53:09 GMT

Thanks for your comment - I have gone through the report and updated it through 2022. I am using stats from Baseball Reference, so they do not have anything on 2023 until the season starts.

Re: MLB Baseball Batting Statistics

enmanuel — Sun, 26 Mar 2023 17:29:38 GMT

I got it. Good.

Re: MLB Baseball Batting Statistics

DeGarcia10 — Sat, 17 Jun 2023 01:12:18 GMT

hi man, I loved your report, it helped me a lot in one of my own that I just finished, I intended to provide a comparison of the Red Sox champions in the century, I would like you to see it and give me your opinions, thanks in advance.

https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Comparison-of-World-Series-Champions-Boston-Red-Sox-20th-Century/m-p/3288692