Question 9The Power Query Editor allows you to ____ , ___ , and ____ data before loading it into Power BI. (Select all that apply.) 1 pointCreateSelectTransformEdit

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.

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

Question 4True or False.One must convert the dataset into a csv format before importing into Power BI. 1 pointTrueFalse

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

Question 17You are creating calculations in Microsoft Power BI. Which languages are supported in Power BI to perform this task? Select all that apply.1 pointData Analysis Expressions (DAX)SQLRPython