HOTSPOT You are enhancing a Power BI model that has DAX calculations. You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year. Which DAX functions should you use? To…
HOTSPOT You are creating a Microsoft Power BI imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories. You import…
DRAG DROP You have the line chart shown in the exhibit. (Click the Exhibit tab.) You need to modify the chart to meet the following requirements: Identify months that have order counts above the mean. Display the mean monthly order…
HOTSPOT You view a query named Transactions as shown in the following exhibit. The query gets CSV files from a folder. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in…
DRAG DROP You have a query named Customer that imports CSV files from a data lake. The query contains 50,000 rows as shown in the exhibit. (Click the Exhibit tab.) Each file contains deltas of any new or modified rows…
Your company has employees in 10 states. The company recently decided to associate each state to one of the following three regions: East, West, and North. You have a data model that contains employee information by state. The model does…
HOTSPOT You have a column named UnitsInStock as shown in the following exhibit. UnitsInStock has 75 non-null values, of which 51 are unique. Use the drop-down menus to select the answer choice that completes each statement based on the information…
You have a Power BI report. The report contains visualizations that have interactions. You need to identify which visualizations take the longest to complete. What should you use? A. Query Diagnostics in Power BI B. Performance Analyzer in Power BI…
You have a Microsoft Power BI dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.) What occurred at 12:03:06…
You are creating a visual to show the ranking of product categories by sales revenue. Your company’s security policy states that you cannot send data outside of your Microsoft Power BI tenant. Which approach provides the widest variety of visuals…