To save re-inventing the wheel, he is how wikipeda defines ETL:
In computing, extract, transform, load (ETL) is the general procedure of copying data from one or more sources into a destination system which represents the
data differently from the source(s) or in a different context than the source(s). The ETL process became a popular concept in the 1970s and is often used in data warehousing.
Data extraction involves extracting data from homogeneous or heterogeneous sources; data transformation processes data by data cleaning and transforming them into a proper
storage format/structure for the purposes of querying and analysis; finally, data loading describes the insertion of data into the final target database such as an operational
data store, a data mart, data lake or a data warehouse.
A properly designed ETL system extracts data from the source systems, enforces data quality and consistency standards, conforms data so that separate sources can be used together,
and finally delivers data in a presentation-ready format so that application developers can build applications and end users can make decisions.
ETL systems commonly integrate data from multiple applications (systems), typically developed and supported by different vendors or hosted on separate computer hardware.
The separate systems containing the original data are frequently managed and operated by different employees. For example, a cost accounting system may combine data from
payroll, sales, and purchasing.
To summarise - we can take your current "database" (often stored in a plethora of Excel Sheets), and re-engineer this into a perfect relational SQL Server database.
For more information on this, please Contact Us.
Due to over 25 Years of data manipulation, we can give a 100% Money Back Guarantee for all ETL work!