Skip to main content

Visualizing and Exploring Data

Overview​

Skypoint Lakehouse SQL allows you to perform business intelligence operations on data through Power BI and Tableau. These dashboards provide meaningful insights into your data and easily build rich, visual analytics reports. You can simplify and scale your enterprise data strategy while supporting Business Intelligence (BI) and Artificial Intelligence (AI) use cases in one place utilizing Databricks as the primary computing engine.

To visualize data in Power BI​

You can connect Power BI Desktop to Skypoint Lakehouse SQL Endpoint. Download and open the connection file to start Power BI Desktop.

Prerequisite​

  1. Go to Lakehouse > SQL Access.
  2. Click Show fields and copy the credentials.

Alt text

  1. Click the Power BI tile. The Connect to partner dialog box appears.

Alt text

  1. Click Download Connection File.
  2. Open the downloaded file and Sign in with your email ID.

The Get started screen appears.

Alt text

  1. Click Get data.

The Get Data screen appears.

Alt text

  1. In the Get data screen, click Azure.

The Azure list appears.

Alt text

  1. In the Azure list, select Azure Databricks.
  2. Click Connect.

The Azure Databricks form appears.

Alt text

  1. In the Azure Databricks form, perform the following actions.
ToDo
Enter the Server HostnameCopy the Server Hostname on the SQL Access page of Skypoint studio.
Enter the HTTP PathCopy the HTTP Path on the SQL Access page of Skypoint studio.
  1. Click OK.

The Azure Databricks dialog box appears.

Alt text

  1. In the Azure Databricks dialog box, do one of the following to connect with Lakehouse:
If you want to useThen
Username/Password method

For the Username, type "token". This token is just the word token only.

For the Password, enter the Personal Access token.

Personal Access Token methodEnter the Personal Access token that you have copied from the Lakehouse SQL page.
  1. Click Connect to establish a connection.

The Navigator pane appears.

Alt text

  1. In the Navigator pane, select the data that you want to explore by marking the checkboxes.
  2. Click on Load to import your data into Power BI Desktop.

Now, you can use your selected data with Power BI's visualization tools.

To visualize data in Tableau​

You can connect Tableau Desktop to Skypoint Lakehouse SQL endpoint. Download and open the connection file to start Tableau Desktop.

Prerequisite​

imageNote

After Tableau starts, it will prompt you for your Skypoint Lakehouse credentials. You can provide your Lakehouse username and password, a Lakehouse personal access token, or sign in with Azure Active Directory.

  1. Click the Tableau tile.

The Connect to partner dialog box appears.

Alt text

  1. In the Connect to partner dialog box, click Download Connection File.
  2. Open the downloaded file to start Tableau Desktop.

Alt text

  1. In Sign In dialog box, enter your Username and Password. Do the following:
ToDo
Validate UsernameType "token". This token is just the word token only.
Validate PasswordEnter the Personal Access token that you have taken from the Lakehouse SQL page.
  1. Click OK.

After successfully connecting with Tableau Desktop, you can visualize and analyze your data.

Alt text