Articles in this section

Access Vagaro's Data Lake with Tableau

Avatar
Jamie B
  • Updated

With Vagaro's Data Lake feature, you can retrieve your data—like appointment reports, payroll, and gross sales data—to Tableau. You can use Vagaro's Accelerator dashboard, which comes with pre-built reports, to connect your data with Tableau, or you can manually connect your data and create reports from scratch. Vagaro's Tableau Accelerator is a pre-build dashboard that you can use to quickly connect your data.

Important

It may take several hours for your data to fully load into Tableau after the initial connection.

What's in This Article?

Prerequisites

Vagaro's Data Lake Feature: $40 a month. Extra $10 a month for each additional location (within Vagaro's Multi-Location Feature).

Tableau Desktop: Tableau Desktop is required to use Vagaro's Accelerator dashboard (requires Tableau Creator license).

Tableau License Required: You will need a Tableau license to sync your data.

  • A Tableau Creator license is required to use Vagaro's Accelerator dashboard.

  • If you want to manually connect your data and build reports from scratch, you can use the Tableau Explorer license.

Connect Your Data to Vagaro's Accelerator

Before connecting your data with Tableau, you will need to download Vagaro's Accelerator from the Tableau Exchange. Keep in mind that Tableau Creator is required to use Vagaro's Accelerator.

  1. Go to Tableau Exchange.

  2. In the search box at the top of the screen, enter Vagaro.

  3. Select Vagaro's Accelerator.

  4. Select Download.

  5. Open the file in your Downloads folder to open Tableau Desktop. The Accelerator's pre-built charts will be displayed; this is just sample data.

  6. To sync Tableau with the Vagaro Data Lake:

    1. Select Data Source in the bottom-left corner.

    2. Enter the Data Location URL provided from the Data Lake as the Username.

    3. Enter the SAS Token provided from the Data Lake as the Password.

    4. Select Sign In.

Connect Your Data with Tableau Cloud

If you have a Tableau Explorer license, you can connect your data manually through Tableau Cloud. You can't use Accelerators on Tableau Cloud, so you must connect your data manually. Also, because you're not using Vagaro's Accelerator, you won't have any pre-built reports.

  1. Open the Tableau Cloud and go to the home page.

  2. To add a new data source, open the New list, then select Published Data Source.

  3. Select the Connectors tab.

  4. Select OData.

  5. To sync Tableau with the Vagaro Data Lake:

    1. For Server, enter the following: https://odata.vagaro.com/biz/reports.

    2. Expand the Authentification List and select Username and Password.

    3. Enter the Data Location URL provided from the Data Lake as the Username.

    4. Enter the SAS Token provided from the Data Lake as the Password.

    5. Select Sign In to connect your data.

Connect Your Data Without an Accelerator

If you don't want to use Vagaro's Accelerator, you can connect your data manually with Tableau Desktop. Just keep in mind that because you're not using Vagaro's Accelerator, you won't have any pre-built reports.

  1. Open the Tableau Desktop application.

  2. In the left panel, under the To a Server heading, select More.

  3. Search for and select OData.

  4. To sync Tableau with the Vagaro Data Lake:

    1. For Server, enter the following: https://odata.vagaro.com/biz/reports.

    2. Expand the Authentification List and select Username and Password.

    3. Enter the Data Location URL provided from the Data Lake as the Username.

    4. Enter the SAS Token provided from the Data Lake as the Password.

Related articles

Comments

0 comments

Please sign in to leave a comment.