Exploratory Data Analysis
Exploratory Data Analysis
Power BI in an interactive data visualization and analytics tools that is very useful especially to help people digest and understand the data.
Demonstration Video
In addition, using Gauge found that Kamal do 26 steal Score. While using the Card shows that Sum of Block Score Achieve by him is 4.
Based on the Player's Profile, players have been given names other than P1,P2 to ensure the data type is uniform when analyzing the data for each players.
As given on the dashboard, a player named Kamal shows year-round involvement using the Line Chart. This shows that he is very active on April with 5 matches.
Based on the Donut Chart, 60 Rebound attempted, there are 51 are successful and 9 that fail. As well as the Pie Chart showing 22 Free Throw attempted by Kamal where 13 are successful while the rest are fail. Clustered Column Chart shows that Kamal managed to do FG(3-PT) score 6 times but, 20 times failed. This makes it 26 attempts.
Based on the Top Player page we can see all the Top 10 Players in PelontarXI team such as in Assist, Field Goal, Winning Score and Rebound Score. On the top left which is using area chart, we can see player with highest assist i.e. Aavish followed by An Chong, Darsy, Kamal, Izzue, Liam, Muiz, Adlin, Sofian, Amir and Kian Yu.
For the next criteria, we measured Top 10 Player for Field Goal which is for player who successfully made a goal from a far distance which is 3-PT. The reason why we measure at this distance is because, not all players manage to score goals at this distance. From the record, it is found that Liam was the highest player who managed to score for 3-PT which is 37 times. In fact, even the second highest player, An Chong can only it for 16 times. Followed by the other player Kamal 6, Sofian 4, Aavish 3, Kianyu 3, Tenno 3, Blake 2, Sam 2 and Zhi Tao 2.
Top 10 Player's Highest Winning Score indicates the victory earned by the player for each game that have been participated. The Pie chart in dashboard above shown the number and percentage of winning scores for the top 10 players preceded by a player name An Chong with 10 wins as well as 12.66%. Pursued by Darsy, Liam and Tae Jun with 9 wins. The following is Amir with 8 wins and Aavish, Adlin, Kamal, Muiz and Sam with 7 and 6 wins.
At the bottom right of the dashboard by using Funnels, player with highest rebound scores has been successfully measured. Darsy is the player who got highest rebound score of 114. Next, as stated above that Muiz as much as 80 rebound scores, Amir 70, Izzue 66, Kamal 60, An Chong 52, Aavish 51, Tae Jun 45, Liam 31 and Sam 25.
The next dashboard is to show the strength of PelontarXI player. Based on the Table used, shows the schedule of players who participated in the game regardless of winning or losing. Also included with date, day and year.
On the right dashboard, using Donut Chart shows the Overall Total Point of all 18 players which is the sum of Rebound(REB), Block (BLK), Steal(STL) and Field Goal Made (FG TOT (MADE)).
Furthermore based on the Matrix, player's strength are measured by Average of PrePerTOT (summation of Steal(STL), Block(BLK) and Rebound(REB)) and Average of FG. If the Average of PrePerTot is higher than Average of FG, then the player is Defensive while if low it is the opposite which is Offensive.
Game involved by the team throughout the year have been calculated and visualize using Card. The total is 178 games.
The foremost dashboard here is to visualize the player's position. By using the Area Chart, shown that there are 4 players out of 18 who are defensive position. Toped by Izzue by 91.
While the results for Offensive positions that visualize by using Clustered Column Chart are showing that Liam is the best Offensive player as the Sum of FG (TOT ATT is 196.
There is also a statement stating that Darsy is the best player based on his Overall Total Point is the highest which is 208.