Automation & Efficiency Example (using Excel)
The idea of this workflow is to demonstrate, how quickly you can set up an automation.
This helps you to immediately gain efficiency in your daily workings.
Plus the whole process is documented along the way.
The automation is executed in only a few seconds (reading in multiple Excel files then cleaning and aggregating them) and took probably less than 10 minutes to set up.
This workflow goes along with my weekly newsletter about data analytics called "The Data Alchemist's Transformation Scroll", click on the link below to find out more or subscribe for free.
Nodes
- Excel Reader1 ×
- Date&Time Part Extractor1 ×
- GroupBy1 ×
- Row Filter1 ×
- String Manipulation1 ×
- Show all 6 nodes