This project is a guided project from DataCamp (i.e. the data is already prepared and ready to use). The project is about analyzing and getting insights about video games sales, and users and critics reviews. The project's main goal is to answer some questions and get insights about the world of video games with the help of these answers.
All you need is to install MySQL Server on your machine. The following links will guide you to do this:
2. Connect to MySQL Server using VS Code
NOTE: This step is optional, you can work with the server on any software you want.
Then follow the steps in the Project Documentation folder to import the data into the server.
-
Importing the data into a database (Documentation)
-
Creating a database
-
Creating tables
-
Importing an existing data into the database
-
-
Data exploration phase (Documentation)
-
Showing the columns of each table
-
Understanding what each column represents
-
Showing top records of each table
-
-
Data analysis phase (Documentation) -> The phase at which the questions are answered. This is done using:
-
SQL simple queries such as SELECT ... FROM ... WHERE, JOINs, Grouping, and Ordering
-
Complex queries such as CTEs and Sub-queries
-
Some aggregate functions such as SUM, AVG, and COUNT
-
-
Reporting and visualization phase (Documentaion)
The final report is created using Power BI Desktop software (Click to have a copy to try filters):
These visualizations have shown me some insights:
- Most games are created by Nintendo and Playstation platforms
- For most of the years, users' average score are less than critics' average score
- According to the number of games created, the era of evolution is between 2000 and 2015
- In many years, Nintendo has the same (or more) number of games as Playstation in spite of the more number of developers who work for Playstation (approximately the double)
- For the last 20 years, Atari and GEN platforms are disappeared
- The top 10 developers (out of 133) have created more than 37% of the total created games