Discover Tableau Software
A state-of-the-art solution for modern BI, Tableau Software enables users to quickly explore and manage their data. Tableau facilitates the discovery and sharing of insights that profoundly transform business.
Tableau helps users see and understand their data. Tableau solutions are designed to put users before everything else, whether they are analysts, data scientists, students, teachers, executives, or business users. From connectivity to collaboration, Tableau is a comprehensive analytical platform that is extremely powerful, secure, and flexible.
Find out more here: https://www.tableau.com/.
Their areas of expertise
- Connection to multiple data sources
- Data mining
- Analysis and data visualization
- Data sharing
- Secure technology
AT Connect Tableau
With AT Connect Tableau you can power your Tableau Software dashboards with Piano Analytics data. You can activate this connector in just a few clicks thanks to Data Flow's Data Sharing feature. The technology partnership between Piano and Tableau Software helps you get the most of both tools.
- Easily activate the connector: It only takes a few clicks to activate the integration between Piano Analytics and Tableau Software. The Snowflake connector is natively available in Tableau interfaces.
- Export all your data to Tableau Software: Export and use all the data you collect with Piano Analytics in Tableau.
- Customize your visualizations: Create custom visualizations from your key KPIs and insights. Adopt the visuals and graphs that best fit the data types.
- Optimize your dashboards: Build your Tableau Software dashboards from the most relevant Piano Analytics insights.
- Share information: Say goodbye to manual reports and hello to automation by scheduling, at your own pace, the sharing of your dashboards in a range of different ways: email, PDF, Web links...
Concept and requirements
The AT Connect Tableau allows you to export and display your Piano Analytics data in the Data Visualization Tableau Software tool. Thanks to this integration you can use all or part of Piano Analytics events and associated properties (standard and custom) to fuel your different dashboards.
This connector is based on the Data Sharing functionality included in the Data Flow product. Data Sharing is a feature enabled by the Snowflake technology, integrated into the Piano Analytics data processing and a true foundation of the Data Model.
The connector can be activated in a few clicks from the Snowflake data source natively available in the Tableau Software tool (Online and Desktop).
Prerequisites for using the AT Connect Tableau:
- Have a Tableau Software account (Online or Desktop)
- Have an Piano Analytics account
- Have the Data Flow option + Data Sharing feature enabled
Activation of AT Connect Tableau
To activate AT Connect Tableau you will need the IDs used for the Data Sharing feature (Data Flow option required). Here is what is used to activate the connector:
- Snowflake URL: URL of the Snowflake account hosting the Piano Analytics database (format https://xxx.xxx.snowflakecomputing.com)
- Username: login of the Snowflake account hosting the Piano Analytics DB.
- Password: password of the Snowflake account hosting the Piano Analytics DB.
When you have these items ready you can log in, as usual, to your Tableau Online (or Tableau Desktop) account to initiate the implementation of this connector. For example, you can create or edit a "workbook" to add a new data source.
You then need to choose the "Snowflake" data source in the pop-up window that just opened. This data source is present in the different versions of Tableau: Online, Desktop... The screenshots below show the Online version – you will find below a capture showing the "Snowflake" data source in the Desktop version, the operation is the same.
Then you will have to fill out the IDs for the Snowflake account hosting the Piano Analytics database (see the beginning of this chapter). You have to fill out 3 fields: Server, Username and Password.
Then you just have to select the "warehouse", the "database" and the "schema" in the left part of the interface. You will be able to retrieve all the Piano Analytics data by dragging and dropping the events database from the left side to the center of the interface. By clicking on the "upload data" button you will import the data. The table will be displayed in the lower part of the Tableau interface - congratulations, the connector is activated!
Here is the final display in the Tableau Online interface:
This connector is based on Data Flow Data Sharing functionality. Data Sharing is a feature enabled by Snowflake technology. In this context, each request made through the connector will consume Snowflake credits. This credit consumption is invoiced monthly.
It is important to watch the complexity of the requests you use. This connector allows you to query the entire database (as above via drag and drop) or to make a more precise query to only import the relevant data (and therefore consume less Snowflake credits). The "New Custom SQL" button on the left side of the interface allows you to carry out these customized queries, which consume less credits.
More info about Custom SQL requests:
In the Desktop version of Tableau the "Snowflake" data source is accessible by clicking on the "More" button located on the left side of the Tableau Desktop interface (see the screenshot below).
With the AT Connect Tableau activated, you can now use Piano Analytics data, events and properties to create your various visualizations.
With AT Connect Tableau, you can use visualizations that integrate your Piano Analytics data in all your Tableau Software dashboards. This connector works with both Online and Desktop versions of Tableau.
- Connector Demo Video: Watch the activation and use of the AT Connect Tableau with this video link - https://youtu.be/3Rgsg_tDnnA
- Official documentation of the Snowflake connector by Tableau: https://help.tableau.com/current/pro/desktop/en-gb/examples_snowflake.htm
Activating this partnership activates the export of Piano Analytics data into Tableau Software. Only the data necessary for the proper functioning of the bridge are exported.