GameStatsHub - Analysis Of Gaming Profiles

About

The goal of creating this dataset is to perform a comprehensive analysis and study of various aspects of gaming platforms, including user behavior and price dynamics. The project involves user segmentation, enabling the identification of key user groups and their preferences. This dataset is ideal for training in data analysis and the use of analytical tools such as statistical methods, machine learning, and data visualization. It aims to uncover hidden patterns and insights that can significantly assist indie developers and companies in making more informed decisions, improving user experience, and optimizing pricing strategies across different platforms

Why Choose This Dataset?

• Real User Data: Based on real-world information for practical insights
• Rich and Diverse Information (~60GB): Offers a wide variety of data to explore
• Regular Updates: Ensures the dataset remains relevant and up-to-date
• Tailored for Educational Projects: Designed specifically for learning and project development
• Documented and Open Source: Fully documented and openly accessible for transparency and ease of use

Sources

• Steam + Steam Web API: Comprehensive data on Steam games and users
• Exophase: Rankings and history of PlayStation and Xbox users
• TrueAchievements: General information about Xbox games
• TrueTrophies: General information about PlayStation games
• PSPrices: Daily price changes for PlayStation and Xbox games

Coverage

Temporal Coverage Start Date	Temporal Coverage End Date	Geospatial Coverage
12-09-2008	12-01-2025	World

If you found this dataset useful, please rate it on Kaggle

Install

The size of the .sql file (3.8GB) prevents it from being uploaded to GitHub, so I uploaded it to Google Drive

Note: You should have at least 60GB of free space when deploying the dump

psql -f gamestatshub-YYYYMMDD.sql -U user

Data Pipeline

ER Diagrams

Click to see the Steam ERD

Click to see the PlayStation ERD

Click to see the Xbox ERD