In this article we will show you, How to create Tableau reports in new version Tableau 9.0 using Microsoft SQL Server database as a data source. For this tableau report, we are going to use the Data connection we created in our previous article. Please refer Connecting Tableau to SQL Server article to understand the data Source and the Data set.
Before we start creating out first tableau report, Lets understand the different regions present in the Report Design.
- Data: This will display the list of currently connected data Sources. We have only one at this time otherwise, it will display all the data sources available.
- Dimensions: Columns with string data will be placed under the Dimensions section
- Measures: Columns with Numeric data or Metric values will be placed under the Measures section
- This is the region where we design our Tableau reports by dragging Measures and Dimensions
- Columns or Rows: This is the region where we place the Measures and Dimensions as per our requirement.
- Marks: Using this section we can change the color, size, metric value. We can also add the Tooltip for the tableau report.
- Filters: Tableau reports will be filtered by the fields placed in this region.
- Pages: Tableau reports preview will be divided into different pages using the field placed in this Pages Card.
- Show Me: This region will show the Visualizations or Charts available for the given data
- Data Source: This tab is used to create new Data Source or Edit the existing Data Source
- Sheet 1: This is the sheet we are currently working on
- This button will be used to create new Sheet
- This button will be used to create new Dashboard
- This button will be used to create new Story
When we select the State column, all the available regions will be highlighted. It means, we can place state column in any of the highlighted region. In this example, we are placing State column in Row section and we can do it in two ways:
Method 1: You can drag the State column from Dimensions region to Tableau Report region. From the below screenshot you can observe that, Row field is highlighted with blue color.
Method 2: You can drag the State column from Dimensions region to Rows section. From the below screenshot you can observe that, Blue color down arrow is indicating the position of the State dimension. You can choose your own method
Once you placed the State column, Tableau Report region will show the state name as shown below
Next, We have to add any metric or numeric value to analyze and we can do it in two ways:
Method 1: You can drag the Sales Measure from Measures Region to Text area in Marks region. From the below screenshot you can observe that, Text area is highlighted.
Method 2: You can drag the Sales Measure from Measures Region to tableau report region. From the below screenshot you can observe that, Abc Row field border is highlighted with black solid color and displays the Show me text. You can choose your own method
Once you placed the State column and Metric values, Tableau Report region will show the basic table report as shown below.
If you observe the upper right corner, there is a Show Me button and this will be the most import and useful one Tableau. In fact we can say, Show Me button made the Tableau developer life easy. We will explore more in coming articles but for now, please click on that button
Once you click on Show Me button, a drop down window will be displayed with available Charts. Although there are many charts, only few are active and remaining are Grayed out because Tableau Desktop will analyze our table report and shows the possibilities. To demonstrate, we are selecting Data bar as shown below
Once we selected, Our table report will automatically converted to Tableau Data bar as shown below.
Thank You for Visiting Our Blog