A Data Analyst has received a request to provide a dashboard related to employee time logs. The employees are entering their time using mobile devices throughout the day and data is stored in a cloud-based database. The end users would like to receive data on their dashboard in as close to real-time as possible.
How should the analyst best create a data source to meet these requirements?
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 dashboard.

Currently the map is used as a filter that affects the data on the otter sheets of the dashboard
You need to configure the dashboard to ensure that selecting a data point on the map only tillers the Detail table
What should you do?
A Data Analyst has the following chart that shows the sum of sales made in different cities.

The analyst wants to show the average sale amount for a city when users hover their mouse over any of the bars.
What should the analyst do?