Excel Data Preparation

This chapter is from the book

Data at Work: Best practices for creating effective charts and information graphics in Microsoft Excel

Learn More Buy

This chapter is from the book

This chapter is from the book 

Data at Work: Best practices for creating effective charts and information graphics in Microsoft Excel

Learn More Buy

Loading the Data Table

The last stage of the ETL process occurs when the data becomes usable. This can take many forms, such as uploading the file to a system such as a new table, appending the file to an existing table such as an update, or, in Excel, simply changing the data format from a range to a table. In recent Excel versions, you can also add the file to the data model.