The Accelerator for Tableau Server Performance Monitoring surfaces the speed at which Tableau dashboards are loading on your server. As Tableau scales across your organization, it can be difficult to keep track of whether analysts are publishing performant content. Content led with poor design choices will take prolonged periods to load, frustrating consumers trying to get to their analysis, and analysts who don’t understand why their dashboard is slow. The first step to resolving performance is to understand where load time KPIs stand today, and which specific dashboards need the most help. This Accelerator will help you do that and get the conversation to improve your overall dashboard performance started. 

See below to find out how to connect to your own Tableau Server PostGreSQL Respository.

### Answer Key Business Questions
* What is my server’s average dashboard load time (VizQL)?
* How does that differ by site, project or owner?
* What are the slowest dashboards on my server? 
* How many dashboards have over ## views and take longer than ##s to load on average?

What does this not answer

* Why is my specific dashboard slow?
* How can I fix the speed on my dashboard?

### Monitor and Improve KPIs
* Dashboard load times

### Required Data Attributes
The following fields are found in the TS Web Requests table. Steps to access are in the next section. 

Dimensions

          Data Field | Explanation

* Created At (date) | When the dashboard request was made
* Site Name (string) | The name of the site where the item is located
* Project Id (whole) | The Id of the project where the item is located
* Project Name (string) | The name of the project where the item is located
* Item Id (whole) | The item identifier
* Item Name (string) | The name of the item
* Item Owner Friendly Name (string) | The name of the owner of the item
* Id (whole) | The unique identifier of each request

Measures

* Number of Requests (whole) | How many times users requested the item to load
* Duration (s) (decimal) | How long it took the item to load

Parameters

* Activity Threshold (whole) | Sets the threshold on number of requests for an item that you’d like to see
* Performance Threshold (whole) | Sets the threshold on duration(s) for an item that you’d like to see

Calculations

* Activity Threshold (T/F) | Dictates whether item is above Activity Threshold parameter
* Performance Threshold (T/F) | Dictates whether item is above Performance Threshold parameter
* Max Date (date) | High end of date range
* Min Date (date) | Low end of date range

Data Source Filters

* Action (string) = bootstrapSession
* Status Code Type (string) = success 
* Item Type (string) = view
* Item Id (whole) = Not Null

Who can help you succeed today

* Reach out to your Tableau Administrator

Steps to setup the Accelerator with your Tableau Server Data

1. Download TS Web Requests Data Source
    1. Visit Github (https://github.com/tableau/community-tableau-server-insights), right-click “ts_web_requests” for your version, “Save Link As” as .twb file.
2. Publish TS Web Requests to your server
    1. Open ts_web_requests.twb 
    2. Edit Data Source Connection to match your server name, URL, port, username, password. 
    3. Publish Data Source as an Extract with a daily reload. In the Authentication section, switch setting to “Embedded Password.”
3. Bring your data into the Accelerator
    1. Download Accelerator
    2. Add new data source, connect to your new “ts_web_requests” published data source from the “Tableau Server” connection
    3. Swap data sources: In the Data Tab (top left) right-click “TS Web Data Requests (Redacted),” then click Replace Data Source. Press OK. 
    4. Replace References: In the Data Tab (middle left), right-click the dimension “Adj Created At (For Accelerator),” then click Replace References. Select “Created At” as its replacement. 
    5. Fix Errors: If you see errors around “Id,” repeat previous step. Click the dimension “Id,” click Replace References, then select “Id” as its replacement. Repeat for any other fields with errors. 
4. Filter for Relevant Sites
    1. Some deployments have dozens of sites, which will squeeze the view. Select your relevant bundle of sites using the filter on the top right. 
5. Publish the Workbook to your Server for others to see.





Tableau Server Performance Dashboard

Tableau Server performance data for critical users, projects, and views.

ITSM

Localize listing name

Built by Tableau + Salesforce

English

Software Development

Free

The Tableau Accelerator for Sales and Margin + Target jumpstarts your data-driven insights by embedding Sales analytics and providing expert-level analytics for:
- RFM Analysis (customer segmentation): RFM stands for recency, frequency, and monetary value, each corresponding to some key customer trait.
- Client Lifetime Value (prediction of the total sales (or margin) attributed to the entire future relationship with a client) and client churn rate (percentage of clients that stopped buying product/services, compared to previous client base)
- PVM/Price-Volume/Mix Analysis /Sales Bridge: decomposes how volume or pricing changes of our product assortment contributed to the difference in performance between the actual and reference values

Expert analytical users can use this Accelerator to easily drill from top-level sales results down to individual customer performance to gain a holistic view of sales.


### Answer key business questions

- What are our sales results? What is our profitability?
- Which business lines generated the most sales?
- Who are our top customers? What is our level of profitability with them?
- How many active customers do we have? What about our ability to acquire new customers?
- How is our customer base segmented? What are the recommended marketing actions to address each customer segment?
- What is our Client Lifetime Value?
- What is our Client Churn Rate?


### Monitor and improve KPIs

- Total Sales
- Total Sales Margin
- Total Sales Quantity
- Active Customers #
- New Customers #
- Sales Margin %
- Total Sales Costs
- Sales Costs %
- Average Selling Price
- Sales per Customer


### Required attributes

- Date (date)
- Customer (string)
- Product (string)
- Business Line (string)
- Sales Amount (numeric)
- Sales Amount Target (numeric)
- Sales Margin (numeric)
- Sales Margin Target (numeric)
- Sales Quantity (numeric)


Sales and Margin + Target

Analyze not only sales results but also RFM Analysis, Client Lifetime Value and Churn Rate.

Expert

Desktop

Sales

The Tableau Accelerator for Sales and Margin jumpstarts your data-driven insights by embedding Sales analysis and providing expert-level analytics for:
- RFM Analysis (customer segmentation): RFM stands for recency, frequency, and monetary value, each corresponding to some key customer trait.
- Client Lifetime Value (prediction of the total sales (or margin) attributed to the entire future relationship with a client) and client churn rate (percentage of clients that stopped buying product/services, compared to previous client base)
- PVM/Price-Volume/Mix Analysis /Sales Bridge: decomposes how volume or pricing changes of our product assortment contributed to the difference in performance between the actual and reference values

Expert analytical users can use this Accelerator to easily drill from top-level sales results down to individual customer performance to gain a holistic view of sales.


### Answer key business questions

- What are our sales results? What is our profitability?
- Which Business lines generate the most sales?
- Who are our top customers? What is our level of profitability with them?
- How many active customers do we have? What about our ability to acquire new customers?
- How is our customer base segmented? What are the recommended marketing actions to address each customer segment?
- What is our Client Lifetime Value?
- What is our Client Churn Rate?


### Monitor and improve KPIs

- Total Sales
- Total Sales Margin
- Total Sales Quantity
- Active Customers #
- New Customers #
- Sales Margin %
- Total Sales Costs
- Sales Costs %
- Average Selling Price
- Sales per Customer


### Required attributes

- Date (date)
- Customer (string)
- Product (string)
- Business Line (string)
- Sales Amount (numeric)
- Sales Margin (numeric)
- Sales Quantity (numeric)


Sales and Margin

The Tableau Accelerator for Sales gives you a jumpstart to getting data-driven insights into your sales performance. Sales managers can use this Accelerator to better understand and monitor sales results across customers, products, or any level of detail they might have in their data source. 

This Accelerator allows you to easily measure sales performance versus last month, last year, your target, etc. It contains several dashboards that enable you to drill into the product or customer level of detail.


### Answer key business questions

- What are our sales results?
- Are we on track compared to last year? Are we on track to meet our target?
- Which products drive the most sales?
- Who are our top customers?
- How many active customers do we have?


### Monitor and improve KPIs

- Total Sales
- Total Sales (Target) (optional)
- Active Customers #
- New Customers #
- Sales per Customer


### Required attributes

- Date (date)
- Customer (string)
- Product (string)
- Business Line (string)
- Sales Amount (numeric)
- Sales Amount Target (numeric) (optional)


A simple but efficient sales Accelerator to monitor your sales results across customers, products...

Basic

The Tableau Accelerator for Online Sales & Marketing gives you a jumpstart to data-driven insights on your eCommerce business. 

Online sales managers can use this Accelerator to better understand online revenues, margin, and marketing investments to help evaluate eCommerce performance.


### Answer key business questions

- What are our revenues, and which products generate the most revenue?
- What is the performance of our marketing investments?
- What are our top sources?
- How many active customers do we have? What about our ability to acquire new customers?
- Who are our top customers? What is our level of profitability with them?
- What does our customer base look like?
- What is our Client Lifetime Value? What is our Client Churn rate?



### Monitor and improve KPIs

- Total Revenues
- Total Margin
- Total Sales Quantity
- Distinct Items Sold #
- Active Clients #
- Client Lifetime
- New Active Clients #
- Margin %
- Total Sales Costs
- Sales Costs %
- Average Selling Price
- Revenues per Client


### Required attributes

- Date (date)
- Client (string)
- Client Registration Date (date)
- Product (string)
- Marketing Source (string)
- Revenues (numeric)
- Margin (numeric)
- Quantity (numeric)
- Marketing Costs (numeric)


Online Sales & Marketing

Get insightful information for eCommerce, combining online Revenues, Margin & Marketing investments.

This connector provides a smooth and easy way to connect to Salesforce Marketing Cloud. Through this connector, customers can leverage APIs provided by Salesforce to extract data from their Marketing Cloud instance for analysis in Tableau.

Salesforce Marketing Cloud

Tableau connector to Salesforce Marketing Cloud.

**Tableau on Firebolt**

The Firebolt connector for Tableau delivers sub-second query speeds on live connections, thus enabling truly interactive analytics experiences without needing to compromise on data volume, freshness, or latency.

**About Firebolt**

Firebolt is the cloud data warehouse for builders of next-gen analytics experiences. Combining the benefits and ease-of-use of a modern architecture with sub-second performance at terabyte scale, Firebolt helps data and dev teams deliver data experiences that end users love.

Built on a cloud-native decoupled storage and compute architecture, Firebolt eliminates traditional challenges associated with provisioning, scale and resource utilization. Firebolt’s optimized storage format and tightly coupled indexing techniques make even the most challenging workloads fast and efficient, without the need for lengthy and customized engineering efforts.

Firebolt

Firebolt is the cloud data warehouse for next-gen analytics experiences.

Palantir Foundry is the world’s leading platform for data-driven operations and decision making. This technology, forged through years of direct experience with complex institutional data challenges, re-unifies companies around their central mission. It enables them to become fully digital "connected companies". Once data has been integrated, cleaned, and validated, the Palantir Foundry JDBC driver provides a SQL interface to Foundry datasets to easily access data and visualize it in Tableau dashboards.

Palantir Foundry

A Tableau Connector Plugin for Palantir Foundry

The Couchbase Analytics Tableau connector provides familiar and secure native Tableau connectivity so that you can quickly visualize and analyze your operational JSON data. It uses Couchbase Analytics tabular views to annotate your data with type and relationship information for Tableau and provides an easy-to-use SQL-based interface to support your analytics-driven query needs. This connector works with Couchbase Server v7.1 and later.

Couchbase Analytics

The Couchbase Analytics Tableau Connector enables visual operational data against JSON data

The ClickHouse ODBC connector is an Apache 2.0-licensed Tableau connector for ClickHouse tables. You will need to install the ClickHouse ODBC driver as a prerequisite. Once installed you can connect to ClickHouse servers and access tables using the full power of Tableau.

Altinity Connector for ClickHouse

Enable Tableau access to ClickHouse data via ODBC.

The Add Filters Extension lets dashboard authors customize which filters are visible on a dashboard. Empower dashboard consumers to customize the dashboard by adding filters that meet specific needs. It aids in quicker exploration of data without the need to contact the original author to drive change requests for adding desired filters to the dashboard and reduces the visual clutter of irrelevant filters. 

Add Filters is an object that authors add to their dashboards which then opens up this new capability for consumers. Once end-users have a filter configuration that suits their needs, they can create a custom view to save their work.


Add Filters Extension

Add Filters offers customized dashboards by showing/hiding filters, parameters, pages, & sheets

Sandboxed

Simple Tableau Extension that allows users to create styled backgrounds for their Dashboard objects and containers. Leverages Bootstrap CSS, Tailwind CSS color, and additional extended classes.

Addition documentation can be found here [Github Link](https://github.com/FsuLauncherComp/BootstrapTableau) 

Documentation

TabCSS

Style Tableau Objects and Containers using simple CSS Classes

Sunburst charts help us visualize hierarchical data and provide quick summaries. 

But in most cases, when the breakdowns are more at each level, inference gets tougher. That's the problem we are solving with this Dynamic Sunburst Chart by adding the ability to drill down. 

After a quick configuration, the extension will visualize your data as a Sunburst Chart, and any interaction on the chart will drill it down to the next level. 
This helps the user get both the high-level and individual element-specific from the same chart or widget. 

Dynamic Sunburst Chart

Dynamic sunburst chart helps you visualize hierarchical data instantly and explore with drill-downs

Insight into data requires users to build performant data models. Key and unique constraints provide structures to access data efficiently. Key Finder mines a data source to automatically find all valid key and unique constraints. Sample data and various measures of validity help users choose the key and unique constraints helpful for tasks such as managing entity and referential integrity, defining index structures, identifying dirty data, and finding all ids that reference the same entity.

### Use cases:
1. **Data Integration:** Key Finder is capable of automatically discovering keys that hold exactly on your dataset and checking the degree to which any other attribute combinations hold as keys. This information serves as a foundation for finding correct foreign keys and joining tables.
2. **Data Quality:** A very common problem that exists in production databases is data duplication. The same entity will often appear more than once in a table with different auto-generated ids. Key Finder makes it easy to quickly discover if this problem is present in your data.
3. **Performance Optimization:** One of the most important aspects of building a performant data model is choosing the right indexes to speed up data access. Key Finder quickly finds and suggests all attribute combinations that may serve as indexes.

Additionally, Key Finder automatically calculates metadata for sampled tables such as the number of null values and the number of distinct not-null values in the original table.

### Licenses

**Free** – This is a demo version of the extension available when you access it through the Tableau Exchange. It has some limitations compared to the full version that make it suitable for testing and evaluation purposes only. The restrictions for the demo version are: tables that are sampled cannot contain more than 1 million rows, samples are only stored for 1 hour and permanently deleted after that. Additionally, the demo version runs on our servers and cannot be deployed to the infrastructure that you manage.

**Paid** – None of the restrictions of the demo version apply to the full version. Please contact us if you are interested in purchasing the full version.

To find out more about **pricing** and watch a **demo video** of this dashboard extension, please visit our [website](https://viadotto.tech).

Key Finder

Key Finder mines keys and unique constraints from a given data source.

The Inovista Animator is a web based application that allows users to import SVG images and create intelligent animations that change their behavior based on external data.
This Tableau extension allows a user to take a data-driven animation created in the Inovista Animator and load it into Tableau. Variables in the animation can be linked directly to Tableau data values or defined as user editable properties.

In the Animator, a full range of animations are available including Movement, Rotation, Scaling, Path Animation, Text Animation, Clipping, Masking, Text Offsets, Morphing and Wave Motions. Animation can also be driven by events such as mouse clicks.
 
Highlights:

This extension will take any animation created in the Inovista Animator and convert it into a Tableau component. Animations may be charts or infographics driven by Tableau data or simply decorative items such as moving logos.

The animations can be exported from the Animator as JSON files or they can be copied to the clipboard. In Tableau, the JSON file can be loaded or can be pasted directly from the clipboard.

In the Animator, all aspects of the animation can be modified by creating variables, for example, how much of an image to display to simulate a bar chart. Each variable can be defined as either a data item or property. In Tableau, data items are linked to Tableau data and properties can be set by the user. 

Examples of properties may be fonts or colors. 
Once defined, data values can be updated by a filter and/or parameter change. 
View a short YouTube video to learn more:

The Inovista Animator for Tableau Extension: [https://youtu.be/OH9anhm7FZQ] 

View a short introduction to the Animator: [https://youtu.be/nCvLoHKSIxo]

Animator for Tableau

Create custom, data-driven chart and infographic animations based on any SVG image.

Tableau Exchange

Accelerators