I have been an avid gamer since I was old enough to grasp a controller so it was only right that I would choose video games as the top of my very first personal project. I will be analyzing every video game I've ever played.
1. Defining the objective:
To use as a video game suggestion model and discover trends in gamer preferences based on publishers, consoles, and video games itself.
2. Collecting the data:
Excel was used to create and clean the data. I created two tables, "Video Games" and "Platforms", listing every video game that I've ever played based on memory, checking my achievements and history on consoles and accounts, and researching a few video games that I remembered gameplay details of but couldn't name.
Designated columns detailed their respective release dates, developers, publishers, release dates, genres, and Metacritic/user scores. I then used the "Platforms" table to show which consoles each game was played on. Ran cleaning operations to remove duplicates, typos, and other errors.
4. Database Creation:
DB Browser for SQLite was used to transform this data into a database.
5. Analysis
SQLite was used to analyze and re-verify the data by running queries.
6. Visualization
Transferred data into Tableau to create a dynamic dashboard.
1. What is the oldest video game I've ever played and on what console?
Super Mario 64 (1996) played on Nintendo 64
2. What are my top 5 favorite publishers?
Electronic Arts, Rockstar Games, Activision, Bethesda Softworks, and Ubisoft
3. Out of which genre am I more likely to purchase a game?
Action-Adventure
4. What game series (plural) am I a fan of?
Assassin's Creed, Battlefield, Call of Duty, Dead Rising, Deus Ex, Dishonored, Dying Light, Fable, Fallout, Grand Theft Auto, Hitman, Kane & Lynch, Mafia, Manhunt, Mass Effect, NFL Street, Midnight Club, PAYDAY, Red Dead Redemption, Saints Row, Skate, The Sims, Super Mario, The Godfather, True Crime, and Wolfenstein
5. How many games have I played that have a "Universal Acclaim" Metacritic score?
22
6. Which games have I played that have a "Generally Unfavorable" Metacritic score?
Bad Boys: Miami Takedown, 25 to Life, Crime Life: Gang Wars, and Shrek
7. Which platform have I played the most games on?
Xbox 360, 62 video games
- Video Game Database: downloadable database compatible with DB Browser and SQLite if you would like to analyze the data
- SQL Queries: queries I ran to analyze the data
- Viz: visualization shared in Tableau