Tableau glossary
44 terms, each linked to the full answer.
Aggregation & DisaggregationThe process of viewing numeric values or measures at higher and more summarized levels of the data is called aggregation. When you place a measure on a shelf,…aliasAn alternative name that you can assign to a field or to a dimension member.Assume referential integrityReferential integrity is a concept which ensures that relationships between databases/tables remain consistent, i.e. it ensures that the references to data are…calculated fieldA new field that you create by using a formula to modify the existing fields in your data source.Connect liveIt Creates a direct connect to the data source and speed up access.Context FilterThe concept of context filter in Tableau makes the process of filtering smooth and straightforward. It establishes a filtering hierarchy where all other filters…crosstab chartIt is a text table view. Use text tables to display the numbers associated with dimension members.Data BlendingUnlike Data Joining, Data Blending in tableau allows combining of data from different sources and platforms. For instance, you can blend data present in an Excel…data blending? When do you use thisAccording to Tableau, Data blending is the ability to bring data from multiple data sources into one Tableau view, without the need for any special coding. You can…data Source pageA page where you can set up your data source. The Data Source page generally consists of four main areas: left pane, join area, preview area, and metadata area.Data VisualizationA much advanced, direct, precise and ordered way of viewing large volumes of data is called data visualization. It is the visual representation of data in the form…default Data Blending JoinData blending is the ability to bring data from multiple data sources into one Tableau view, without the need for any special coding. A default blend is equivalent…difference between discrete and continuousThere are two types of data roles in Tableau – discrete and continuous dimension. Discrete data roles are values that are counted as distinct and separate and can…differences between groups and setsGroups simplify large numbers of dimension members by combining them into higher-level categories. Sets create a custom field based on existing dimensions that can…differences between twb and twbx- A twb is an xml document which contains all the selections and layout made you have made in your Tableau workbook. It does not contain any data. - A twbx is a…DimensionTableau treats any field containing qualitative, categorical information as a dimension. This includes any field with text or dates values.Dual AxisYou can compare multiple measures using dual axes, which are two independent axes that are layered on top of each other.extract is TableauA saved subset of a data source that you can use to improve performance and analyze offline.Extracts and Schedules in Tableau serverData extracts are the first copies or subdivisions of the actual data from original data sources. The workbooks using data extracts instead of those using live DB…fact table and Dimension tableFacts are the numeric metrics or measurable quantities of the data, which can be analyzed by dimension table. Facts are stores in Fact table that contain foreign…ForecastingForecasting is about predicting the future value of a measure. There are many mathematical models for forecasting. Tableau uses the model known as exponential…format paneA pane that contains formatting settings that control the entire worksheet, as well as individual fields in the view.Gannt ChartA Gantt chart shows the progress of the value of a task or resource over a period of time. So Gantt chart a time dimension is an essential field.Import all data featureIt Imports the entire data source into Tableaus fast data engine as an extract and saves it in the workbook.limitations of context filtersTableau takes time to place a filter in context. When a filter is set as context one, the software creates a temporary table for that particular context filter.…LOD expressionA syntax that supports aggregation at dimensionalities other than the view level. With level of detail expressions, you can attach one or more dimensions to any…marks cardA card to the left of the view where you can drag fields to control mark properties such as type, color, size, shape, label, tooltip, and detail.MeasureA measure is a field that is a dependent on value of one or more dimensions. Tableau treats any field containing numeric (quantitative) information as a measure.Page shelfTableau provides a distinct and powerful tool to control the output display known as Page shelf. As the name suggests, the page shelf fragments the view into a…Pages shelfYou can analyze data on Tableau using a feature called Pages Shelf. It helps you analyze data based on the individual values contained within a field. For example…platforms Tableau server can run onTableau server can run on Windows and Mac.possible reasons for slow performanceMore Extracts, filters and depends on data sources.Published data sourceIt contains connection information that is independent of any workbook and can be used by multiple workbooks.Quick FiltersGlobal quick filters are a way to filter each worksheet on a dashboard until each of them contains a dimension. They are very useful for worksheets using the same…shelvesThey are Named areas to the left and top of the view. You build views by placing fields onto the shelves. Some shelves are available only when you select certain…storyA story is a sheet that contains a sequence of worksheets or dashboards that work together to convey information. You can create stories to show how facts are…table calculationThese are inbuilt calculations in tableau which we normally used to calculate percentage changes and more.Tableau data paneA pane on the left side of the workbook that displays the fields of the data sources to which Tableau is connected.Tableau ReaderTableau Reader is a free viewing application that lets anyone read and interact with packaged workbooks created by Tableau Desktop.Tableau Show meShow Me is used to apply a required view to the existing data in the worksheet. Those views can be a pie chart, scatter plot or a line chart.Tableau workbookIt is a file with a .twb extension that contains one or more worksheets (and possibly also dashboards and stories).TDE fileTDE is a Tableau desktop file that contains a .tde extension. It refers to the file that contains data extracted from external sources like MS Excel, MS Access or…TrendlineTrend lines are used to predict the continuation of certain trend of a variable. It also helps to identify the correlation between two variables by observing the…types of filtersCustom Filters, Context Filters, Normal Filters.