View
57
Download
1
Category
Preview:
Citation preview
Tableau Overview
Vivek Mohan
2
Tableau & its Product
Tableau Software is an American computer software company headquartered in Seattle, Washington.
It produces a family of interactive data visualization products focused on business intelligence.
Products - Tableau Desktop 9.3.0 : http://www.tableau.com/products/desktop
Tableau Server 9.3.0: http://www.tableau.com/products/server
Tableau Reader 9.3.0: http://www.tableau.com/products/reader
– Open visualizations built in Tableau Desktop for free with Tableau Reader. Tableau Online (cloud based): http://www.tableau.com/products/cloud-bi
– Scalable SaaS pricing and operations.– Reliable, secure, and always up to date.– Tableau-managed infrastructure.– Works with Tableau Mobile to take data everywhere.
Tableau Public (cloud based): https://public.tableau.com/s/
– Open data and explore it with Tableau Desktop Public Edition.– Save and store your visualizations on your Tableau Public profile. 1GB is free. Personalize your profile and
connect with other authors.– Share your visualizations with the world via social media. Or embed them on a site or blog. The published vizzes
are always live and interactive. Tableau Vizable (mobile app): https://vizable.tableau.com/
3
Overall Architecture
4
Overall Architecture
5
Terminology
6
Terminology
7
Gateway
8
Application Server
9
VizQL Server
10
Data Server
11
Backgrounder
12
Data Engine
13
Repository
14
Search
15
Licensing
16
Communication Flow
17
Summary
18
Licensing Consideration
19
Single Node Architecture
20
3-Node Architecture
21
HIGH Availability
22
Network Considerations
23
Failover
24
5 Node Architecture
25
Load
26
Performance and Scalability
27
Server Topology – Scenario 1
28
Server Topology – Scenario 2
29
Performance Guideline
Every server environment is unique, and there are many variables that can impact performance. Variables affecting performance include: Hardware details, such as disk speed, memory, and processor cores The number of servers in your deployment Network traffic Usage factors such as workbook complexity, concurrent user activity, and data caching Tableau Server configuration settings, such as how many of each server process you’re
running Data considerations—such as data volume, database type, and database configuration.
https://onlinehelp.tableau.com/current/server/en-us/perf.htm
http://kb.tableau.com/articles/knowledgebase/optimizing-tableau-server-performance?lang=en-us
30
Server Installation and Administration
https://onlinehelp.tableau.com/current/server/en-us/admin.htm
http://downloads.tableau.com/quickstart/server-guides/en-us/server_admin90.pdf
Planning and Architecting Tableau Server: https://www.youtube.com/watch?v=CpyrCryHr8c
Tableau Server Installation: https://www.youtube.com/watch?v=59LJyXbNd2A
Tableau Server Administration: https://www.youtube.com/watch?v=34WGBP221aw
31
Tabadmin & Tabcmd
TabadminYou can perform certain administrative tasks and change Tableau Server configuration settings using the tabadmin command line tool. It installs with Tableau Server by default
https://onlinehelp.tableau.com/current/server/en-us/reconfig_tabadmin.htmhttp://bnreddybi.blogspot.in/2015/08/configure-with-tabadmin-set-options.html
TabcmdThe tabcmd utility is one of the two command line tools that installs with Tableau Server (the other is tabadmin). The commands provided through tabcmd can help you automate common tasks, such as publishing workbooks in batches and administering users and groups. The tabcmd utility installs in the Tableau Server bin folder (C:\Program Files\Tableau Server\9.3\bin), but you can install and run tabcmd on another machine as well.
https://onlinehelp.tableau.com/current/server/en-us/help.htm#tabcmd.htm%3FTocPath%3DCommand%2520Line%2520Utilities%7Ctabcmd%7C_____0
32
Optimizing Queries – Two Step Process
https://www.youtube.com/watch?v=ZIlxe1UEJo8
33
Optimizing Queries – Principles
34
Useful Links
Tableau Server Installation: https://www.youtube.com/watch?v=59LJyXbNd2A
Tableau Server Administration: https://www.youtube.com/watch?v=34WGBP221aw
Tableau Architecture Part 1- https://www.youtube.com/watch?v=v8_iLBdGlm4
Tableau Architecture Part 2- https://www.youtube.com/watch?v=tLlETQJjFVg
Planning and Architecting Tableau Server: https://www.youtube.com/watch?v=CpyrCryHr8c
Server Log Files: http://onlinehelp.tableau.com/current/server/en-us/logs_loc.htm
Server Processes: http://onlinehelp.tableau.com/current/server/en-us/processes.htm
Performance: http://onlinehelp.tableau.com/current/server/en-us/help.htm#perf_guidelines.htm%3FTocPath%3DAdministrator%2520Guide%7CPerformance%7C_____1
Recommended