ETL – What Is This?

Data is often in unstructured formats, which makes ETL (extract, transform, and load) very useful.  The data integration process gathers data from multiple data sources (sql, csv, txt) and combines them into a single, consistent data source.

Excel and Power BI both have a powerful data analysis pack named Get and Transform (previously known as Power Query). It is an ETL pack for cleaning and sorting raw data from a range of sources.