Homework answers / question archive / 4-2 Activity: Checkpoint Instructions In this activity, you will look back at what you have learned in the video series

4-2 Activity: Checkpoint Instructions In this activity, you will look back at what you have learned in the video series

Statistics

Share With

---

4-2 Activity: Checkpoint

Instructions

In this activity, you will look back at what you have learned in the video series. In Module Six, you will create a written report on these insights and use this visualization to create a report.

To complete this assignment, review the Checkpoint Guidelines And Rubric document.

MIS 350 Checkpoint Guidelines and Rubric  

Overview: In this activity, you will look back at what you have learned in the video series. In Module Six, you will create a written report on these insights and use this visualization to create a report.

 

Prompt: To complete this activity, use the Excel data set to complete the following:

 

1. Upload the dataset into Power BI.
2. Generate visualizations to accurately display the data.
3. In a paragraph, describe how the visualization used is best suited for conveying information.

 

You are looking for a video game system that will allow you to have the most games possible. You have a set budget and you want the highest return on your investment. Using the dataset provided, analyze and develop visualizations in MS Power BI to display the following:

 

• Which Platform has the most games (one visualization)
• Which Platform has the highest critic score (one visualization)
• Which Genre has the highest critic score (one visualization)
• Which Game has the highest critic score (one visualization)
• Which Platform has the highest user score (one visualization)
• Which Genre has the highest user score (one visualization)
• Which Game has the highest user score (one visualization)

 

               

 

In addition to Gregory Smith's web scrape of video games sales on VGChartz, this data set extends the number of variables (columns) with another web scrape from Metacritic. Unfortunately, there are missing observations (rows), as Metacritic only covers a subset of the platforms. The variables defined below may not be in all observations. There are 6,900 complete observations. Some of the data definitions are listed below:

 

• Critic_score: Aggregate score compiled by Metacritic staff
• Critic_count: The number of critics who contributed to the Critic_score
• User_score: Score by Metacritic's subscribers
• User_count: Number of users who contributed to the User_score
• Developer: Party responsible for creating the game
• Rating: The ESRB rating of the game

 

Rubric  

 

Guidelines for Submission: You will submit seven visualizations developed in Microsoft Power BI.

 

Critical Elements	Exemplary	Proficient	Needs Improvement	Not Evident	Value
Software Integration: Upload		Data set was uploaded into Power BI (100%)		Data set was not uploaded into Power BI (0%)	25
Visualizations: Accurately Display		Generates visualizations to accurately display the data (100%)	Generates visualizations to display the data, but data is not accurately displayed (55%)	Does not generate visualizations to display the data (0%)	50
Visualizations: Conveying Information	Meets “Proficient” criteria, and description demonstrates a sophisticated awareness of how the visualization is best suited to conveying information (100%)	Describes how the visualization is best suited for conveying information to the targeted user audience, as well as their interaction needs across multifunctional teams (85%)	Describes how the visualization is best suited for conveying information to the targeted user audience, as well as their interaction needs across multifunctional teams, but the description is cursory or contains inaccuracies (55%)	Does not describe how the visualization is best suited for conveying information to the targeted user audience or their interaction needs across multifunctional teams (0%)	25