Enterprise Reporting
  • Introduction
  • Understanding reports with clarity (Definitions)
  • Optimizing key performance indicators (via the Groups tab)
    • Dashboard
    • Reporting section
      • Progress report
      • Adoption report
      • Engagement report
      • Content insights
        • XP
        • Courses
        • Projects
        • Tracks
      • Assessments
      • Certifications
      • Time in Learn
      • DataLab
      • Export
    • Skill Matrix
  • Integrating our data into your tools (via Data Connector 2.0)
    • Explore the data model
      • Fact tables
      • Dimension tables
      • Bridge tables
      • Metrics tables
    • Common use cases
    • Sample queries
    • Queries to recreate key reports in the Groups tab
      • Dashboard
        • Members who have earned XP
      • Reporting section
        • Progress report
        • Content insights
        • Assessments
        • Certification Insights
        • Time in Learn
    • Domain Gotchas
    • Getting started with Data Connector 2.0
      • Enable Data Connector 2.0
      • Your credentials
      • Storing your credentials
    • Using Data Connector 2.0
      • Integrating with your BI tools
        • Microsoft Power BI
        • Tableau
        • Looker
        • DataLab
      • Downloading your data
        • S3 Browser (Windows)
        • Cyberduck (Mac or Windows)
        • AWS CLI (Linux)
    • Changelog
    • Migrating from Data Connector 1.0
  • FAQ
  • Data Connector 1.0 - Documentation
    • [Data Connector 1.0] Explore Data Model
      • [Data Connector 1.0] Data Model
      • [Data Connector 1.0] Changelog
      • [Data Connector 1.0] Example queries
    • [Data Connector 1.0] Getting started
      • [Data Connector 1.0] Enabling the Data Connector
      • [Data Connector 1.0] Your Credentials
      • [Data Connector 1.0] Storing your Credentials
    • [Data Connector 1.0] Using the Data Connector
      • [Data Connector 1.0] Analyzing data
        • [Data Connector 1.0] DataLab
        • [Data Connector 1.0] Microsoft Power BI
        • [Data Connector 1.0] Tableau
      • [Data Connector 1.0] Downloading data
        • [Data Connector 1.0] S3 Browser (Windows)
        • [Data Connector 1.0] 3Hub (Mac)
        • [Data Connector 1.0] AWS CLI (Linux)
    • [Data Connector 1.0] Data Connector FAQ
      • [Data Connector 1.0] Deprecating dcdcpy and dcdcr
Powered by GitBook
On this page
  • Set up an Amazon Athena data connection
  • Query your data
  • Resources
  1. Integrating our data into your tools (via Data Connector 2.0)
  2. Using Data Connector 2.0
  3. Integrating with your BI tools

DataLab

PreviousLookerNextDownloading your data

Last updated 8 days ago

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 analyze Data Connector learning data with DataLab.

Complete these two steps to view your learning data in Power BI.

  1. Set up an Amazon Athena data connection

  2. Query your data

Set up an Amazon Athena data connection

First, make sure you have your credentials.

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

Click on Data Sources on the left-hand panel.

Select New Data Source.

Select Amazon Athena.

Enter the following data in the setup dialog.

  • Name: Free to choose (e.g., DataCamp Data Connector)

  • Description: optional; you can leave it blank

  • Region: The AWS Region from your credentials

  • Output Bucket: s3://{bucketname}/tmp-datalab → replace {bucketname} with the S3 Bucket Name from your credentials

  • Access Key: the AWS Access Key ID from your credentials

  • Secret Key: the AWS Secret Access Key from your credentials

  • Click Connect

Query your data

  • You can now access your organization's learning data with a SQL cell.

  • Create a new SQL cell and select the Athena connection you just created in the Select data source dropdown in the top left corner of the cell:

  • You can now write and run a SQL query through the Athena connection. See the Sample Queries page for examples of typical reports you can build.

Resources

  • DataLab documentation

You can browse all the available tables through the schema browser by clicking the icon in the SQL cell.