Tableau Certification

__________ is a technique in Tableau which will identify marks with similar characteristics - answer-Clustering Cluster analysis partitions marks in the view into clusters, where the marks within each cluster are more similar to one another than they are to marks in other clusters. _____________ charts are typically used to represent accumulated totals over time and are the conventional way to display stacked lines. - answer-area _____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source. - answer-twbx. tableau packaged workbook TWBX is all in one. It contains viz, info needed to build the viz, and a copy of the data source. It doesn't contain extracts of the data but can contain both live and data extracts. Best if want to eliminate the barrier of data access. _____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields. - answer-Tableau data extract (.tde) Tableau Data Extract (TDE) is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields. Performance is optimised because it queries its own database engine instead of the local data source. When you create an extract of your data, you can reduce the total amount of data by using filters and configuring other limits. After you create an extract, you can refresh it with data from the original data. When refreshing the data, you have the option to either do a full refresh, which replaces all of the contents in the extract, or you can do an incremental refresh, which only adds rows that are new since the previous refresh. Extracts are advantageous for several reasons: 1) Supports large data sets: You can create extracts that contain billions of rows of data. 2) Fast to create: If you're working with large data sets, creating and working with extracts can be faster than working with the original data. 3) Help improve performance: When you interact with views that use extract data sources, you generally experience better performance than when interacting with views based on connections to the original data. 4) Support additional functionality: Extracts allow you to take advantage of Tableau functionality that's not available or supported by the original data, such as the ability to compute Count Distinct. 5) Provide offline access to your data: Extracts allow you to save and work with the data locally when the original data is not available. For example, when you are traveling. ______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data. - answer-Unioning ______________ refers to the level of detail for a piece of data, wherever you are looking. - answer-data granularity Data is generated and analyzed at many different levels of granularity. Granularity is the level of detail of the data. For example, when looking at graduation data, granularity would describe whether a row in the data set represents a single person or the graduating class of a university. _______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server. - answer-tableau server Tableau SERVER enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server. Moreover, as a Tableau Server administrator you will control who has access to server content to help protect sensitive data. Administrators can set user permissions on projects, workbooks, views, and data sources. ________________ can only create header. _______________ will create header and axis both. - answer-dimensions, measures This is because only continous values form the AXIS. ________________ files are shortcuts for quickly connecting to the original data that you use often. Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on. - answer-.tds Tableau data source files have the .tds file extension. Data source files are shortcuts for quickly connecting to the original data that you use often. Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on. For more information, see Save Data Sources. ________________ is hosted by Tableau to share our visualisations publically with the world. - answer-tableau public Tableau Public is a free service that lets anyone publish interactive data visualizations to the web. Visualizations that have been published to Tableau Public ("vizzes") can be embedded into web pages and blogs, they can be shared via social media or email, and they can be made available for download to other users. _________________ are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance. - answer-.tde files Depending on the version the extract was created in, Tableau extract files can have either the .hyper or .tde file extension. Extract files are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance. For more information, see Extract Your Data. _________________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that don't allow relationships or joins - answer-data blending Data blending is performed on a sheet-by-sheet basis and is established when a field from a second data source is used in the view. To create a blend in a workbook already connected to at least two data sources, bring a field from one data source to the sheet—it becomes the primary data source. Switch to the other data source and use a field on the same sheet—it becomes a secondary data source. An orange linking icon will appear in the data pane, indicating which field(s) are being used to blend the data sources. A _____________ action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau. - answer-go to URL Tricky options! Go to hyperlink and Go to Web page are not valid Actions in Tableau. A URL action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau. You can use URL actions to create an email or link to additional information about your data. To customize links based on your data, you can automatically enter field values as parameters in URLs. A ________________ is a single zip file that contains a workbook along with any