You are an analyst for Game Freak, the developers behind the successful Pokmon series of games Youve worked for the company for a long time and are now working under a new manager Your new manager is new to Pokmon and has some questions about the state of the game Therefore, you have to give answers to his most important questions Please note that you may do research about Pokmon on the internet to help you in this task Dataset Description This data set has been originally uploaded in this Kaggle repository kaggle com abcsds pokemon by Alberto Barradas Below is his description of the dataset The data includes 721 Pokemon, including their number, name, first and second type, and basic stats HP, Attack, Defense, Special Attack, Special Defense, and Speed The Columns are ID for each pokemon Name Name of each pokemon Type 1 Each pokemon has a type, this determines weakness resistance to attacks Type 2 Some pokemon are dual type and have 2 Total sum of all stats that come after this, a general guide to how strong a pokemon is HP hit points, or health, defines how much damage a pokemon can withstand before fainting Attack the base modifier for normal attacks (eg Scratch, Punch) Defense the base damage resistance against normal attacks SP Atk special attack, the base modifier for special attacks (e g fire blast, bubble beam) SP Def the base damage resistance against special attacks Speed determines which pokemon attacks first each round The data for this table has been acquired from several different sites, including com pokemondb bulbapedia Your Tasks Load the data in Excel and then do the following You may use any tool taught in the course Make a summary sheet including summary statistics about all the Pokmon this may include Strongest Pokemon, Pokemon Type Distribution, Average Pokemon Stats, etc Your manager believes that Fire Type Pokemon are on average better than Water Type Pokemon make another sheet that compares Fire Type Pokemon against Water Type Pokemon How will you explain what better is Is a higher Total value the same as a Pokemon being better You can use any calculation you want to describe if a pokemon is better Use Pivot Charts to explain your findings visually Your manager also wants to be able to see any Pokemon stats he wants using a search function Make a search page where your manager can type in any Pokemon name and get that Pokemons stats Your search page should contain graphs and analysis that change when a new pokemon name is put in Research about Pokemon and make another analysis page that contains 10 of your most recommended Pokemon based on what type your Opponent chose Your manager wants to also release your findings to the public Make a Power BI dashboard with the same analysis in your Excel sheet so you can publish it

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 31, 2024

You are an analyst for Game Freak, the developers behind the successful Pokmon series of games. Youve worked for the company for a long time

You are an analyst for Game Freak, the developers behind the successful Pokmon series of games. Youve worked for the company for a long time and are now working under a new manager.

Your new manager is new to Pokmon and has some questions about the state of the game. Therefore, you have to give answers to his most important questions.

Please note that you may do research about Pokmon on the internet to help you in this task.

Dataset Description

This data set has been originally uploaded in this Kaggle repository: kaggle.com/abcsds/pokemon by Alberto Barradas. Below is his description of the dataset:

The data includes 721 Pokemon, including their number, name, first and second type, and basic stats: HP, Attack, Defense, Special Attack, Special Defense, and Speed.

The Columns are:

#: ID for each pokemon
Name: Name of each pokemon
Type 1: Each pokemon has a type, this determines weakness/resistance to attacks
Type 2: Some pokemon are dual type and have 2
Total: sum of all stats that come after this, a general guide to how strong a pokemon is
HP: hit points, or health, defines how much damage a pokemon can withstand before fainting
Attack: the base modifier for normal attacks (eg. Scratch, Punch)
Defense: the base damage resistance against normal attacks
SP Atk: special attack, the base modifier for special attacks (e.g. fire blast, bubble beam)
SP Def: the base damage resistance against special attacks
Speed: determines which pokemon attacks first each round

The data for this table has been acquired from several different sites, including:

com
pokemondb
bulbapedia

Your Tasks

Load the data in Excel and then do the following. You may use any tool taught in the course.

Make a summary sheet including summary statistics about all the Pokmon this may include Strongest Pokemon, Pokemon Type Distribution, Average Pokemon Stats, etc.
Your manager believes that Fire Type Pokemon are on average better than Water Type Pokemon make another sheet that compares Fire Type Pokemon against Water Type Pokemon.
- How will you explain what better is? Is a higher Total value the same as a Pokemon being better? You can use any calculation you want to describe if a pokemon is better
- Use Pivot Charts to explain your findings visually
Your manager also wants to be able to see any Pokemon stats he wants using a search function
- Make a search page where your manager can type in any Pokemon name and get that Pokemons stats
- Your search page should contain graphs and analysis that change when a new pokemon name is put in
Research about Pokemon and make another analysis page that contains 10 of your most recommended Pokemon based on what type your Opponent chose.
Your manager wants to also release your findings to the public. Make a Power BI dashboard with the same analysis in your Excel sheet so you can publish it.