Build a local database and perform time series analysis with machine learning with processed data from the database.
Build your own local database
Manage the database: Create, modify, and delete tables and table elements- 🗒️ Query your database for insights using SQL
- 🤖 Perform time series analysis using machine learning with data from your processed database.
Create a local data base using Python and SQLalchemy
Load data onto the database
Use advanced SQL queries to perform cleaning operations (create tables and table relationships) (modify tables and table elements)
Perform ANOVA and correlation statistical tests to determine statistical relationship between attributes
Test for seasonlity in the data using seasonal decomposition
Time series analysis with ARIMA model in Python
Generate predictions and test model performance using Deep Neural Networks and Random Forest algorithm)