Transform in Excel), you can import or connect to external data, and then shape that data, for example remove a column, change a data type, or merge tables, in ways that meet your needs. Then, you can load your query into Excel to create charts and reports. Periodically, you can refresh the data to make it up to date. Power Query is available on three Excel applications, Excel for Windows, Excel for Mac and Excel for the Web. For a summary of all Power Query help topics, see Power Query for Excel Help.Note: Power Query in Excel for Windows uses the .NET framework, but it requires version 4.7.2 or later. You can download the latest .NET Framework from here. Select the recommended version and then download the runtime.The four phases of Power QueryConnectTransformCombineLoadApplication support for Power Query in ExcelA history of Power Query in Excel Need more help?Want more options? DiscoverCommunityExplore subscription benefits, browse training courses, learn how to secure your device, and more.Microsoft 365 subscription benefitsMicrosoft 365 trainingMicrosoft securityAccessibility center

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.

Question 4From the Table Tools tab in Power BI desktop, you can ________ . (Select all that apply.) 1 point Edit the table and manage relationshipsSelect new data sources to connect to Create new measures, columns, and tables with DAX expressions, or formulasRefresh the visuals in the report with the latest data from the original data source

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 9I have a table that contains the data of the monthly sales figures of my company. I was tasked with creating a chart to display the change in sales on a monthly basis. What is the best chart to use to effectively display the change over time of monthly sales?1 pointBubble ChartPie ChartLine ChartBar Chart

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