Any work in progress is out of the scope of the course as I have already passed the course/project with all the required components.
Current Work in Progress:
- Load data into PowerBI
Setup a connection to MySQL and PostgreSQL and verify their connections
Copy the schema.sql into DataGrip or MySQL Workbench and run it
then run the following command:
python load.py reports staff
Afterwards, verify that all tables have been created and imported to MySQL Workbench / DataGrip
run the following command:
python transform.py
Verify that all tables have been created and imported to PostgreSQL, the tables should be made automatically.
- Kathia Y. Couret-Cruz (kathia.couret@upr.edu)
- Ricardo A. García-Izcoa (ricardo.garcia13@upr.edu)
- Songiemar S. García-Curbelo (songiemar.garcia@upr.edu)
- José C. Ventosa-Rodríguez (jose.ventosa1@upr.edu)