Skip to content

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_testing.py Main script for testing and running the ETL pipeline.
etl_pipeline_production.py ETL pipeline script for production use, designed to process full datasets reliably.
OpenTriviaDB-Job.bat Batch file which will be scheduled to run hourly, daily, weekly or monthly on Windows.

About

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

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages