March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
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.
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.
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.
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 provides the standard table view of the data with the ability to select by season and team.
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
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.
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.
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.
I got it. Good.
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
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.