Data Transformation is referred to asa.Process to change from detailed level to summary levelb.Join data from one source to multiple sourcesc.Process to change from summary level to detailed leveld.Separate data from one source into various sources

...... is the process of transforming data from one format or structure to another.a.Data singlingb.Data mappingc.Data samplingd.None of the options

Elaborate on the process of data transformation, highlighting the role it plays in preparing data for effective analysis

Question 28Imagine you are a Data Analyst at Adventure Works using Microsoft Power Query to transform raw sales data into a more usable format. The transformation involves multiple steps, like removing duplicates, filtering rows, and replacing values. What are some of the functionalities of the Applied Steps pane? Select all that apply.1 pointTo connect various data sources and select specific datasets or tables.To show the history of actions performed on the dataset.To record the transformation steps in data preparation.To clean, reshape, and transform data into a structured, usable format.

__________ is a system where operations like data extraction, transformation and loading operations are executed.Question 19Answera.None of the aboveb.Data stagingc.Data integrationd.ETL

Question 2Fill in the blank: _____ is the process of changing data to make it more organized and easier to read. 1 pointData manipulationData replicationData gatheringData transfer