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.

Your team at Adventure Works is working on a new project to analyze customer feedback. The feedback comes from various channels and in multiple formats. As a data analyst, you're asked to transform this data using Microsoft Power BI. What is the primary objective of data transformation in Power BI?1 pointTo automate the process of data entry. To create meaningful and impactful data visualizations. To facilitate real-time collaboration with team members. To convert raw data into a more meaningful and usable format.

Question 16As a data analyst, you work with the Microsoft Power Query Editor in Microsoft Power BI Desktop. What are some of the core functionalities provided by the Power Query Editor? Select all that apply.1 pointIt enables you to clean, transform, and reshape data.It allows you to merge and append queries.It provides a platform to share and collaborate on reports and dashboards.It permits you to visualize data using bar charts and maps.

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

Power QueryHow is the Power Query Editor used within Power BI?Review LaterUses an interface of ribbons, menus, and buttons to interact with a preview of our data and define transformation stepsConnects to a wide range of data sources to import data for our reportAutomates the data transformation steps so that they are repeatable as the data sources update with new informationRecommends the best visual types for the report canvas

What is the purpose of Power Query in Power BI?*To create custom visuals for data visualizationTo analyze and visualize dataTo create and manage data sourceTo import, transform, and combine data from various sources