Floor and Ceiling functions belongs to number functions in Tableau. Ceiling: This function helps in rounding a decimal value to greater or equal value. Floor: This Function in tableau helps to round an integer to is Lesser values or equal value. Example: Sum of sales = 2,,297,200.8603 Floor(sum(Sales)) Floor of sales = 2,297,200.000 Ceiling Function […]
Dimensions and Measures are very important in any Business Intelligence implementation. An understanding of these concepts are important for learning Tableau. Exercise: Use the table below and Identify Dimensions and Measures. Post your answers in the comments section.
In Tableau, Filters are used to filter the data displayed in the view section. Filters can be of displayed in different ways, such as, Multiple values drop down, Multiple value list,Single Value list and so on. Filters create a Where clause to the underlying query of the View. For example, consider the following view, This view […]
Tableau desktop is used to create visualizations in Tableau. What is Visualization Visualization means pictorial representation of data. This representation can be in the form of charts,tables,maps and so on. Visualization helps in gaining understanding of the data. Using Tableau desktop, developer connects to data, preps the data according to the user requirements and creates various visualizations. […]
Tableau Question 7. What is LOD (Level of detail) calculation? Leave your answers in the comment section below.
Tableau Question 6. What is the difference between a Regular calculation and a Table calculation in Tableau? Leave your answers in the comment section below.
Tableau can connect to a variety of datasources in different ways. Tableau provides native connections to multiple datasources. Tableau can connect to the following datasources 1. Tableau can connect to datasources directly by creating a connection. 2. Tableau can connect to datasources as Live or Extract 3. Extract is a data snapshot, it creates a TDE(Tableau Data Extract) file. […]
Bar charts in Tableau is a good way of comparing measures in a category. I will use Tableau provided Sample-SuperStore.xls as my datasource. Please visit how to connect to excel data source in Tableau to learn about connecting to data. Create a Bar chart using Region and Sales. I get a bar chart as below […]
Tableau Question 5. What are context filters in Tableau? Leave your answers in the comment section below.
Tableau Question 4. In what scenarios scatter chart should be used ? Leave your answers in the comment section below.