Free Practice Questions for Salesforce Analytics-DA-201 Exam

To connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet, you need to select New Data Source from the Data menu. This will open the Connect pane, where you can choose Microsoft Excel as your data source and browse for your spreadsheet file. You can then drag and drop your sheets or tables to join or union them in the data source page. References: https://help.tableau.com/current/pro/desktop/en-us/connect_basic.htm https://help.tableau.com/current/pro/desktop/en-us/connect_excel.htm

When connecting to a dataset in Tableau Desktop, you would go to the ' Data ' menu and select ' New Data Source ' . This allows you to connect to various types of data sources, including Microsoft Excel spreadsheets, where you can then select the specific file you wish to connect to.

To show the corresponding region when users hover their mouse over any of the bars, you need to drag Region to Tooltip on the Marks card. This will add Region as a field in the tooltip text that appears when users hover over a mark. You can also customize the tooltip text by editing it in the Tooltip dialog box. References: https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/formatting_tooltips.htm

To show additional information such as the corresponding region when hovering over a bar in Tableau, you can drag the ' Region ' field to the ' Tooltip ' shelf on the ' Marks ' card. This will ensure that when a user hovers over a bar representing a city, the tooltip will dynamically display the region associated with that city.

Based on the line chart provided, each point on the line chart represents the average sales for a given month, and the percentage values indicate the change in average sales compared to the previous month. The month of November shows a significant increase from the month of October, indicated by a large upward spike on the chart and a high percentage increase.

1) Open Tableau prep

2) Create a new column ...

3) Union the sales ...

4) Join the sales ...

To configure the shapes to be much larger than the line, you need to duplicate Population and drag it to the second Marks card. This will create a dual axis chart with two measures on one axis. You can then select Shape on one Marks card and Line on another Marks card, and adjust the size of each mark independently using the Size slider or menu. References: https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures_dualaxes.htm https://help.tableau.com/current/pro/desktop/en-us/marks_markproperties_size.htm

In a dual-axis chart in Tableau, if you want to have two different visual mark types (like a shape and a line) and configure them differently (such as making one larger than the other), you would need to duplicate the measure. You then drag this duplicate to the second Marks card (which represents the second axis). There, you can adjust the size of the marks (shapes, in this case) independently of the line marks on the first Marks card.

To calculate the ranking shown in the Rank field, you need to use the RANK_UNIQUE function, which returns the unique rank of each value in a partition. You need to specify the expression as SUM([Sales]), which calculates the total sales for each product. You also need to specify the order as descending, which means that the highest sales will have the lowest rank. Finally, you need to specify the restart as every [Category] , which means that the ranking will reset for each category. References: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_rank.htm

A .hyper file is an extract file that contains a snapshot of data from a data source. It is a compressed and optimized file format that can be used to improve the performance and portability of dashboards and workbooks. A .twb file is a workbook file that contains the visualization and connection information, but not the data itself. A .csv file is a comma-separated values file that contains plain text data. A .mdb file is a Microsoft Access database file that contains tables, queries, forms, and other objects. References: https://help.tableau.com/current/pro/desktop/en-us/save_savework_packagedworkbooks.htm https://help.tableau.com/current/pro/desktop/en-us/extracting_data.htm https://help.tableau.com/current/pro/desktop/en-us/examples_csv.htm https://support.microsoft.com/en-us/office/introduction-to-access-database-files-9f9a0f8c-9a3c-4a0b-8e6c-6d1f1f7c2b7e

In Tableau, a .hyper file is an extract file created by the Hyper database engine. It contains a snapshot of the data pulled into Tableau and is used to perform data analysis without the need for a live connection to the data source.

To combine the tables and meet the requirements, you should use a left join. A left join will keep all the records from the left table (Employeelnfo) and match them with the records from the right table (DepartmentInfo) based on the common field (Department ID). If there is no matching record in the right table, the fields from the right table will be null. This way, you will retain all the records from Employeelnfo, and also include the Department Name, Size, and VP fields from DepartmentInfo. Every record will have a full name because it is a field from the left table. A left join will look like this: