Data Visualization with Tableau (39 Blogs) Become a Certified Professional
AWS Global Infrastructure

BI and Visualization

Topics Covered
  • Pentaho BI (8 Blogs)
  • Microsoft BI (7 Blogs)
  • Data Visualization with Tableau (37 Blogs)
  • BI and Data Visualization with Qlikview (1 Blogs)
SEE MORE

Tableau Server Tutorial: All You Need To Know

Last updated on Aug 24,2023 3K Views


Tableau Server is the most secure way to distribute Tableau workbooks. It helps you to embed live interactive dashboards and provide high security to your data. This Tableau Server Tutorial, allows you to have an overview regarding the basics of Tableau Server. Following are the topics covered in this tutorial,

So let us get started with this Tableau Server Tutorial

Tableau Server Components

The following are the various server components of Tableau:

  • Application Server: This process handles browsing and permissions for Tableau Server Web and mobile interfaces.
  • VizQL Server: It sends queries to the data source upon request from clients and returns a result set that is rendered as images. Ultimately, it presents them to the users.
  • Data Server: It lets users manage and store Tableau data sources, while also maintaining the metadata from Tableau Desktop.

Tableau Server Installation

  • Double-click on the installation file.
  • Follow the directions on your screen to complete the Setup Wizard.
  • Install the application.
  • After the installation, click on Next to open the Product Key Manager window 

Image-Tableau Server Tutorials- Edureka

 

Moving on with this article on Tableau Server Tutorial

Activating the Product

After installing Tableau Desktop/Tableau Server, you need to activate your product. Both of them require product keys to activate these products.

Tableau Server requires at least one product key. It should be one that both activates the server and determines the number of license levels which can be assigned to users. Product keys can be accessed from the Tableau Customer Account Center. 

Activate and Register

After installing and configuring the server, the product key manager opens up automatically so you can enter your product key and register the product.

  • Select the Activate the Product

 

Image-Tableau Server Tutorials- Edureka

     

    • Paste your server product key into the corresponding text box and click on Activate.

    Image-Tableau Server Tutorials- Edureka

    • When you are online, it gets over here. But when you’re offline, activation will fail and you are given the option to save a file that you can use for offline activation. Click on Save.

    Image-Tableau Server Tutorials- Edureka

    • Go ahead and select a location for the file and click on Save. The file will be saved as tlq and will contain information about the host the license is to be activated on.

    Image-Tableau Server Tutorials- Edureka

    Moving on with this article on Tableau Server Tutorial

    Configuring the Server

    During a Tableau Server installation, the Tableau Server Configuration utility opens where you can set configuration options at this time, before the server starts. The server starts at the end of the installation process.

    1. The Tableau Server runs by employing the Network Service account, by default.

    Image-Tableau Server Tutorials- Edureka

            2. Select whether you want to use Active Directory to authenticate users on the server.

    Image-Tableau Server Tutorials- Edureka

     

    Image-Tableau Server Tutorials- Edureka

    Data Connection Configuration

    The Data Connection tab is used to configure aspects of cache and initial-SQL-statement usage that applies to complete data connections.

    The Data Connection tab is used to configure aspects of cache and initial-SQL-statement usage that applies to complete data connections

    The views published to Tableau Server are very interactive and often have a live connection to a database. As users interact with the views in a web browser, the queried data gets stored in a cache. Subsequently, the visits will pull the data from this cache if feasible.

    To configure caching

    • Select the tab called Data Connections in the Tableau Server Configuration dialogue box.

    • Then you can select from one of the following options;

    1. Refresh Less Often – Select this option when data is not changing frequently. Data is cached and reused whenever it is available regardless of the time of its addition to the cache. This option minimises the queries sent to the database and enhances the performance.

    2. Balanced – Data is removed from the cache after a specified time. If the data is added to the cache within the specified time range, the cached data will be used, otherwise, new data will be queried from the database.

    3. Refresh More Often – The database is queried each time the page is loaded. The data is still cached and will be reused until the page is reloaded by the user. This option will ensure users see the most updated data. However, it may decrease performance.

    Setup Tasks

    The following few steps are to add an administrator account.

    Image-Tableau Server Tutorials- Edureka.png

    Moving on with this article on Tableau Server Tutorial

    Setting Up Distributed Servers

    After completing the initial configuration, set up the Tableau Server to run on multiple computers. This is also known as distributed installation or cluster. This increases the scalability of your Tableau Server environment.

    • You can set the Tableau Server up to run on multiple machines. You can also fine tune which Tableau Server processes can run on individual machines (including the primary server).

    Image-Tableau Server Tutorials- Edureka.png

    • This type of environment can help you support more users, improve viewer interaction and browsing. It also optimises the handling of server background tasks.
    • Once the Worker software is installed on worker machines, you need to return to the primary server and open the configuration utility. You can do so by selecting Tableau Server 8 > Configure Tableau Server on the Start menu.
    • In the Configuration Utility, go to the Servers tab and click on the Add button.

    Image-Tableau Server Tutorials- Edureka.png

    • In the dialogue box that appears next, type the IP Address for one of the worker machines. Indicate the number of VizQL Processes, Application Server Processes, and Background processes allocated to the machine.

    Image-Tableau Server Tutorials- Edureka.png

     

      Moving on with this article on Tableau Server Tutorial

      Adding Local Users

      You can add all the individual users’ information and then import several users from a CSV file(Comma-Separated-Value file). You can also include attributes such as site role and the ability to publish,in the CSV file, in order to apply to the users at the same time to import them.

      So, to add local users, you need to do the following;

      • Log on to the Tableau Server by entering your admin username and password.
      • Click on the option Users in the Administration area on the left side of the page

      Image-Tableau Server Tutorials- Edureka.png

      • Click one of the following links

      1. Add User to add users by specifying a username and password one at a time .
      2. Add Users From CSV File to add multiple users from a CSV file.

      Image-Tableau Server Tutorials- Edureka.png

      1. Username – Type a username only consisting of letters and numbers.
      2. Full Name – Type a name for the display.
      3. Password – Enter a strong password.
      4. Confirm Password – Retype the password you’ve entered before to confirm it.
      5. License Level – Select license level.
      6. Assign User Rights – Choose whether it’s within the user’s authority to publish workbooks and assign administrator rights.

      Image-Tableau Server Tutorials- Edureka.png

      Click on the Add User

        With this, we’ve come to the end of this Tableau Server Tutorial.

        This brings us to the end of this Tableau Server Tutorial. If you wish to master Tableau, Edureka has a curated course on Tableau Course online which covers various concepts of data visualization in depth.

        Got a question for us? Please mention it in the comments section and we will get back to you at the earliest.

        Upcoming Batches For Tableau Certification Training Course
        Course NameDateDetails
        Tableau Certification Training Course

        Class Starts on 13th April,2024

        13th April

        SAT&SUN (Weekend Batch)
        View Details
        Tableau Certification Training Course

        Class Starts on 27th April,2024

        27th April

        SAT&SUN (Weekend Batch)
        View Details
        Comments
        0 Comments

        Join the discussion

        Browse Categories

        webinar REGISTER FOR FREE WEBINAR
        REGISTER NOW
        webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP

        Subscribe to our Newsletter, and get personalized recommendations.

        image not found!
        image not found!

        Tableau Server Tutorial: All You Need To Know

        edureka.co