Pass Analytics-DA-201 Exam Guide

Tableau Desktop supports custom mark shapes by loading image files from the Shapes folder inside My Tableau Repository. The analyst should copy the new shape files into a folder under My Tableau Repository\Shapes. Tableau uses that folder as a custom shape palette, and the analyst can then select the shapes from the Marks card by choosing Shape and editing the shape assignment. Once custom shapes are used, they are stored with the workbook, which supports sharing the visualization with other users. Dragging image files directly into a workbook does not register them as reusable mark shapes, and a URL cannot be used as the workbook’s shape repository. My Tableau Prep Repository is also incorrect because Tableau Prep is not where Tableau Desktop mark-shape palettes are stored.

Both the ZN and IFNULL functions in Tableau can be used to replace NULL values with zeros. The ZN function converts NULL to zero directly, while the IFNULL function allows you to specify that NULL should be replaced with zero. Both will result in showing zero for any NULL values in the Profits field.