1 Answers
Database is Simple Table
First Column — Date
Then — Production Per Day
Then Energy Consumption of Dept A — Machine 1 / Dept A — Machine — 2 / Dept B / Dept C etc
So we know relation between production and energy consumption / similarly breakdowns per day and energy consumption / number of shifts and energy consumption / new machine & energy consumption etc