Tableau Software for Piano Analytics

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
• Dashboards
• Data sharing
• Collaboration
• 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.

1. 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.
2. Export all your data to Tableau Software: Export and use all the data you collect with Piano Analytics in Tableau.
3. Customize your visualizations: Create custom visualizations from your key KPIs and insights. Adopt the visuals and graphs that best fit the data types.
4. Optimize your dashboards: Build your Tableau Software dashboards from the most relevant Piano Analytics insights.
5. 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:

Creating visualizations

With the AT Connect Tableau activated, you can now use Piano Analytics data, events and properties to create your various visualizations.

Creating dashboards

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.

Other resources

- 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

Privacy

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.