ETL stands for Extract, Transform, Load.

Copy of Copy of class Car def init(self, brand, model) self,brand = brand self,model = model (19)_enhanced.png

Extract the data

Open Excel > Data Tab > Get Data > From File > From Folder > Select Folder

Copy of Copy of class Car def init(self, brand, model) self,brand = brand self,model = model_enhanced.png

Copy of Copy of class Car def init(self, brand, model) self,brand = brand self,model = model (2)_enhanced.png

Right Click on Binary > Drill Down

Copy of Copy of class Car def init(self, brand, model) self,brand = brand self,model = model (1)_enhanced.png

Do the same for all 4 files

Copy of Copy of class Car def init(self, brand, model) self,brand = brand self,model = model (3)_enhanced.png

We already started data Transform