Skip to content

Automated ETL pipeline that ingests trivia data from the Open Trivia Database API into MySQL and delivers interactive analytics through a Power BI dashboard.

Notifications You must be signed in to change notification settings

ibrahimakerkouch/OpenTriviaDB-Analytics

Repository files navigation

Open Trivia Database Analytics

dashboard/ Power BI dashboard (.pbix) file and accompanying screenshot.
database/ MySQL database configuration and schema definitions.
docs/ Documentation files and usage guides.
scripts/ Supporting scripts and utilities.
etl_pipeline.py Main ETL pipeline script.
etl_pipeline_production.py ETL pipeline script for production use.
OpenTriviaDB-Job.bat Batch file which will be scheduled to run hourly, daily, weekly or monthly on Windows.

Releases

No releases published

Packages

No packages published