We kindly ask for help on following topic.
We have some database of electrical consumption (for 3 years, 1 hour interval...) of selected clients and another database of air temperatures for the same period. We would like to make a forecasting model for future electrical consumption based on linear regression of electrical consumption data (first database)in dependance on air temperature (second database).
Since we are new in using Knime and don`t know any tools or possibilities it offers, please give us some guidelines on how to start. Currently we succesfully connected both databases from Access to Knime. Please, suggest us the next step.