A Data Analyst has two tables named EmployeeInfo and DepartmentInfo. EmployeeInfo contains four fields named Full Name, Department ID, Start Date, and Salary. DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP. The analyst wants to combine the tables to meet the following requirements:
* EmployeeInfo is the first table that is dragged to the canvas,
* The records must contain the Full Name, and the Department Name, Size, and VP fields if available,
* Not all records have an exact match.
Which type of join should the analyst use?
You have the following chart that shows profits and discounts over time.
You need to combine the lines to appear as shown in the following chart.
What should you do?
You have a data source that contains the following columns.
You want to sort customers based on the most expensive orders.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
You plan to create a visualization that has a dual axis chart. The dual axis chart will contain a shape chart and a line chart will use the same measure named Population on the axis.
You need to configure be shapes to be much larger than the line.
What should you do?
You have a workbook that connects to a database. The database requires authentication.
You plan to publish the workbook and schedule a daily refresh of the data.
Which two conditions must be met to schedule the refresh? Choose two.
