Single Source of Truth, SSOT for short – a state that is not achievable with Excel and yet would offer so many advantages…
How do you tame the time-consuming Excel beast?!
The switch to using MySQL databases, the supporting data analysis software KNIME and the visualization software Tableau represents the ideal solution.
First, this interaction involves users dragging and dropping their data into Nextcloud. KNIME automatically extracts and processes CSV files every hour and loads the processed files into a MySQL database. ETL processes can also be programmed graphically via KNIME. Tableau can then be used to provide interactive analysis across multiple dashboards.
A change is possible for small CSV files up to databases with billions of rows and usually takes only 2-3 weeks!
A change is possible for small CSV files up to databases with billions of rows and usually takes only 2-3 weeks!