to extract valuable insights from data, the firm needs to make necessary transformations before storing it in an analytical database. selact all types of transformation firms apply to raw data. correcton of common spelling mistakes, e$.$g$.,$ in the street names. Flilling in the missing values. deleting the records that use outdated email domain names. aggregating transaction information into hourly or daily. all of the above. removing duplicate transactions from the same customer