Welcome,
This course brings a real-world perspective on managing and scrubbing data as an essential step in ensuring reporting integrity. Providing "hands on" experience in cleaning an inventory data set in preparation of analysis, the course explains ETL (Extract, Transform, Load) and discusses the five-step process that can be used to clean data.
Sorry, this item can only be purchased by current members.
Would you like to...
This course brings a real-world perspective on managing and scrubbing data as an essential step in ensuring reporting integrity. Providing "hands on" experience in cleaning an inventory data set in preparation of analysis, the course explains ETL (Extract, Transform, Load) and discusses the...
This course brings a real-world perspective on managing and scrubbing data as an essential step in ensuring reporting integrity. Providing "hands on" experience in cleaning an inventory data set in preparation of analysis, the course explains ETL (Extract, Transform, Load) and discusses the five-step process that can be used to clean data. The course covers importing data, XLOOKUP, VLOOKUP, column width adjustments, removing duplicate records, removing unwanted characters, find and replace, changing uppercase to lowercase, field splitting, sorting data, formatting numbers, converting text to number, correcting spelling errors, text date to calendar date, transposing, and field combining.
0