When working with data that requires transformations, which option provides you with the most robust options in Excel?changes by handIncorrectMaking data transformations manually can be helpful for small changes. However, with larger data sets that require extensive changes, this would not be the most time efficient option.VBAmacrosPower Query

What are benefits of modifying your Excel data source in the Power Query Editor rather than in Excel? (Select all that apply.) A. You can track the changes you make.B. It is less error prone than manual editing.C. It will not affect other users of the spreadsheet.D. It "locks down" the spreadsheet columns in Excel.

A data analyst is working in a spreadsheet application. They use Save As to change the file type from .XLS to .CSV. This is an example of a data transformation.1 pointTrueFalse

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.

If a feature has a highly skewed distribution, then which of the following transformations should be used to transform the data?Select an option Clear ResponseBinningLog TransformationsGeometric Means TransformationStandard Scaling

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