What is the purpose of creating relationships between tables in Power Pivot?Options :To merge tables into oneTo establish connections with external databasesTo enable more complex calculations and analysisTo import data from web sources

Where do you create relationships between tables in Power Pivot?Options :In data viewIn diagram viewIn Design viewRelationships are automatically created during data import

You have three tables relating to sales information in various states and various products. Why would you create relationships in Power BI?Select an answer:to merge the three tables into a single tableto quickly navigate between the multiple tablesto identify customers with more than one locationto work in one table and not the three separate tables

A pivot table is a data-summarization tool used in data processing. Which of the following tasks can pivot tables perform? Select all that apply.1 pointClean dataReorganize dataGroup dataCalculate totals from data

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

Question 1When you create a Pivot Table, your data must be in a Table beforehand.