Build an ETL Pipeline With No Code — Apache Hop Tutorial | From Excel to Product (Ep. 2)
Jun 24, 2026
Real data engineering without living in a Jupyter notebook — build an ETL pipeline visually in Apache Hop and load clean data into Postgres.
Work with us: https://concepttocloud.com
Episode 2 of "From Excel to Product." We take the messy pharma Excel model and turn it into a proper, repeatable pipeline — no code required:
- Why no-code ETL beats notebooks for production pipelines
- Building the flow visually in Apache Hop
- Cleaning and transforming the raw Excel data
- Loading it into PostgreSQL, ready to model
Chapters:
0:00 Why not notebooks?
5:09 Trimming the model: pivots & dictionaries
12:43 Apache Hop inputs (Tika, Avro...)
17:50 Creating the database
Tools: Apache Hop, PostgreSQL, Excel
Saiku (open source): https://github.com/spiculedata/saiku
Concept To Cloud builds critical systems for missions that can't afford to fail — MVPs, legacy modernisation, cloud, data and AI infrastructure. Ex-NASA engineers.
Start a project: https://concepttocloud.com
#dataengineering #ETL #ApacheHop #postgres #nocode
Show More Show Less #People & Society

