🕹️Steam Sales Analysis

less than 1 minute read

Created and deployed a (open-source contribution) Python PyPI package (library): -
  • Developed and implemented a comprehensive ETL pipeline for extracting, transforming, and loading game-related metadata, details, and sales figures from Steamspy and Steam APIs (requests library) into a MySQL database on Aiven Cloud.

  • Engineered data retrieval and processing with batch processing and bulk inserts to ensure accurate and efficient data ingestion and validation.
  • Designed interactive Tableau dashboard to visualize data dynamically, providing actionable insights into gaming trends and sales performance (showcasing KPIs).
  • Created a command-line interface (CLI) for managing data ingestion processes, with commands for cleaning, fetching, and processing data, including customizable options for batch size and data handling.
  • Configured and maintained database integration, ensuring proper connection and storage of data within the MySQL database.
Code:
Medium blog:

Tags: Automation, Cloud computing, Data Analytics, Data pipeline, Docker, ETL, MySQL, Python, Tableau dashboard