In the last block we saw Joins in SQL. In this blog, we will see how to do Joins in Tableau. Joins in Tableau Tableau uses 4 types of Joins: Step 1: Create an Excel file by naming the file “Sample.xlsx and Create two sheets with Table 1 and Table 2. Step 2: Launch Tableau […]
Learn Tableau
Joins in SQL
Joins in SQL are used to combine two or more tables. It returns the matching rows from the combined tables by using reference column in both the tables. Types of Joins: Inner Join: Inner join or Equi-join, returns rows from the both the tables based on the matching values of the columns. Example: Below we […]
How to Create Custom Color palette in Tableau – Part 2
In Part 1 of how to Create Custom Color palette in Tableau , we learned that in Tableau we can create two types of Color Palettes Regular – Used for Dimensions and Discrete Fields Sequential – Used for Measures or Continuous Fields Creating Custom Sequential Color Palette: Step 1: We have created the Custom Regular […]
Tableau developer – First few days at work
Congratulations!!! your dream came true and you have been hired as a Tableau developer. Now you need to know things to be successful and to provide value to your client. a. Get a licensed copy of Tableau desktop Tableau desktop is used for developing sheets, dashboards and data story. Tableau offers two weeks of trail version, […]
Tableau Training
Want to make a career in Business Intelligence ? Want to help your client with cool visualizations ? Learn Tableau and become an expert in Data visualization. 40 hours of Training Start from BI concepts and learn basics to advance concepts in Tableau Hands-on training, do exercises with the instructor Limited candidates per class, […]
What are Floor and Ceiling functions in Tableau ?
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 ?
As part of Tableau Questions and Answers series, I am asking questions related to Tableau and data warehousing concepts relating to dimensions and measures. I will encourage my students and other readers to explore the answers and reply with comments. ————————————————————————————- Tableau Question 1. What are Dimensions and Measures ? Leave your answers in the comment section below.
TDS file in Tableau
TDS file in Tableau is a Data Source file. What is a TDS file TDS file is a saved Tableau Data source file. It contains meta-data or information about the data. TDS file by default is saved to \My Tableau Repository\Datasources\ Users can connect to .TDS file. If TDS file is saved under the above […]
Tableau Dashboards
Tableau is a great visualization application. Tableau dashboards are one of the many ways to visualize data. Tableau helps in extracting data from variety of data sources and present it in the form of Tables, Charts and Maps. Tableau helps in answering business questions effectively. Tableau knowledge is important for both business users and developers. […]
Year by Year Comparison in Tableau
Recently, one of my client requested a dashboard where it is possible to do a year by year comparison in Tableau The requirement – if you have two charts, user should be able to perform comparison between any two Years such as 2014 vs 2017. I achieved this by creating a copy of the datasource in […]
: http://techkoncepts.com/