Extract, Transform and Load is a process to extract data from different types of systems, transform it into a new structure for reporting and analysis and loading it into the a database.