web analytics

You need to create a relationship between Date and Invoices. What should you do first?

You add two tables named Date and Invoices to a data model. Invoices contains a column named InvoiceDate that has a data Type of Date. Date contains a column named

You need to minimize the amount of memory used to load the model. The solution must ensure that you can create visualizations based on Price, Quantity, and Total. What should you do?

You have a table in a Power Pivot model that is loaded from a Microsoft SQL Server database. The source table has four columns named ID, Price, Quantity, and Total.

You need to ensure that the data is refreshed whenever you open the workbook. What should you do?

You have an Excel workbook query that loads data to a worksheet and the data model. You need to ensure that the data is refreshed whenever you open the workbook.

You need to ensure that the users can see the PivotTable and the PivotChart when they open the file. The data in the model must be removed. What should you do?

You create an Excel workbook named SalesResults.xlsx. You create a workbook query that connects to a Microsoft SQL Server database and loads data to the data model. You create a

You need to ensure that the workbook has the new data. What should you do?

You have multiple workbook queries that load data from tables in Microsoft Azure SQL Database to a Power Pivot data model. You discover that new rows were added to the

What should you do from Query Editor?

You have 20 workbook queries that load 20 CSV files to a local computer. You plan to send the workbook and the 20 CSV files to several users. The users

You need to combine all the data from Consultants and Employees into one table. Which command should you use?

You have an Excel workbook that has the following two workbook queries: A query named Consultants that retrieves a table named Consultants_Contact from a Microsoft SQL Server database A query

You need to ensure that you can publish the file to Power BI. What should you do first?

You open C:\Data\Data.xlsx in Excel. When you attempt to publish the file to Microsoft Power BI, you receive the following error message: “We couldn’t publish to Power BI. Make sure

You need to ensure that the users can query the term employee and receive results from the User table. What should you do before you publish to Power BI?

You have an Excel workbook that contains two tables named User and Activity. You plan to publish the workbook to the Power BI service. Users will use Q&A in the

You need to add a tile for the PivotChart to a Power BI dashboard. What should you do?

You have an Excel spreadsheet that contains a PivotChart. You install Microsoft Power BI Publisher for Excel. You need to add a tile for the PivotChart to a Power BI

You need to modify Goal to multiply the sales from the previous year by 1.15. What should you do?

You have a KPI named Goal that calculates the sales from the previous year and multiplies the sales by 1.1. You need to modify Goal to multiply the sales from