[Data Connector 1.0] DataLab

DataLab is a cloud-based notebook built by DataCamp that allows you to experiment with code, analyze data, collaborate with others, and share insights with no installation required.

This page describes the steps to seamlessly analyze Data Connector 1.0 learning data with DataLab with zero setup.

• Before starting, make sure that:

  • You are an admin in the group whose data you wish to analyze.

  • The Data Connector is enabled as described here.

• Head over to the datalab dashboard at https://app.datacamp.com/datalab/.

• Check the account context dropdown to ensure you're in the context whose data you wish to analyze. If you want to analyze data from your organization, make sure your organization context is selected here and not your personal context.

• Click "New Workbook":

• A new workbook with an empty notebook is created, where you can start your analysis:

  
• Create a new SQL cell, and select enterprise-custom-reporting-athena as the data source:

  
• You can now write and run a SQL query to fetch the learning data you need through the Athena connection. For example, we can check the total XP for each user in your group. See Example queries for more examples of SQL queries you can write.

  

You can browse all the available tables through the schema browser, which you can access from the "Databases" tab on the left-hand side or by clicking the icon on the SQL cell.