Use the following data source and follow the instructions /questions below to create a Power BI dashboard/analytics report.

• MLB_Data_forDashboardProject_005.xlsx - CORRECTED FILE(08/06/2018)

Congratulations. You are a finalist for a data analyst position for a Major League Baseball (MLB) team. As you prepare for the final round of interviews, you've been asked to use the above data set to create a series of analytics/dashboards to help show how well the team is doing in two important KPIs: home-game attendance and salaries.

Team Information:

Within the MLB, the Chicago White Sox are in the:
League = American League
Division = Central (C) Division

The intended audience for this dashboard is the Director ofAnalytics.

Limitations: Clearly this project is limited in terms of the scope of data. In the real world setting there would be ticket sales, customer demographic information, television viewership ratings, social media mentions/hits, and a whole host of additional data to churn through. But (realistically) like any project, it's good to start with a piece of the puzzle at a time, and in sequence. So consider this an initial step in what could be a much larger project.

Two files are needed for this submission: Your Power BI dashboard file and the answers to the questions below (in a Word document).

Broadly speaking this project's learning outcomes include:

• -Assigning KPIs
• -Trend analysis
• -Comparative analysis
• -Creating columns and measures
• -Creating relationships between multiple data sources
• -Creating the best visualization to appropriately show the data

Hint: Use the TeamsMostRecent table as your centralized table that all others are related to (connected with). But only connectSalaries to Team_Statistics and Team_Statistics to TeamsMostRecentas you don't want to have unnecessary relationships that will cause circular logic in your design.

Hint2: you will need to create a new column to join the Salaries and Team_statistics tables together. What 2 (or more fields) createa unique identifier for each individual row that exists in both of these tables? You will need to use this field to join these tables together.

Additional Requirements:

• As in other assignments, make sure each visualization has a name and that I can quickly associate it with the question.

• Make sure each visualization has the appropriate data labels showing (the only case where this should be ignored is where the visualization itself would be over-crowded with numbers, but PowerBI is different than Excel in that it can format the labels in better ways).

• Whenever a question says "the most appropriate visualization" typically this is not a table or matrix (unless the question says otherwise or there's a good reason to break this "rule").

Analytics portion:

1. Get a sense of the data to start. Create a matrix that has every ball club, each year (2006-2014) and total games played. This will allow you to see if there are any significant gaps in the data. Are there? Explain.
2. a. Choose the most appropriate visualization to show the total attendance for the team from 2006 - to 2014. What's their trend?
3. b. Choose the most appropriate visualization to show the total attendance for each year and each club in their division for 2006 -2014. What is the trend for the team and how do they compare with other teams? 
4. c. Choose the most appropriate visualization to show how the team's attendance average (combined for all years, 06-14)compares with the attendance average of all other teams in the league. Sort by average attendance in descending order (Most to least). How are they ranked? Overall is their attendance numbers considered "good" or "bad"? How do you know?  
5. Plot all stadium addresses on a map. Include the club names in the legend. Include in the plot the average attendance (for the size of the circles). How does the team compare with other clubs in the region? Between the visualizations, you created in problems 2and 3, which do you think best tells the "attendance" story and why?
6. a. Create a visualization to show the total salary for every ball club in 2013. (2014 salary information is incomplete for some clubs.) Who are the top 5 ball clubs that have the highest salary? Who has the least? Where does the team reside in the salary" rankings"? Highlight where they rank (you do not need to create a function to calculate rank specifically). 
7. b. Create a visualization to show what the Team salary has been like for the last 5 years. What is the trend? 
8. c. Again for 2013, show the number of wins per ball club, highlight where the Team ranks. Create a measure that calculates Salaries by Wins to measure how much each win "costs" based on the player's salary (total salary/total wins). Where does the team rank? Describe your findings.
9. a. Select the best visualization type to show the average salary of every ball club in 2013. Which club has the highest average salary? The Lowest? Where does the team sit? 
10. b. Create a slicer by ball club name and create an additional visualization that lists out all ballplayers and total salary. Filter on the team. And sort by salary in descending order (highest to lowest). Who were the top5 players by salary in 2013? What was the most common amount (mode)paid to the players (this can be "eye-balled" and doesn't need to be calculated)?
11. c. Create your own visualization here that does not repeat one of the above questions. And describe what you are showing, the question being addressed, and the results of the analysis. Make this visualization complicated. It should be more than showing a number of wins or total salary. You have multiple measures in the data set, making the visualization have some depth and detail.

Answer rating: 100% (QA)

Here are the answers to the questions you asked There are no significant gaps in the data The number of games played by each team each year is consistent The most appropriate visualization to show the ... View the full answer