Using Power Query, the raw transactional data was cleaned and shaped—handling disparate inputs from Argentina, Colombia, Brazil, Ecuador, Peru, Chile, and Bolivia into a unified, tabular format. This automated ETL process ensures that currency values and date formats are standardized across all Latin American markets