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
  • 2023-05-26
  • 2023-05-16
  • 2022-02-24
  1. Data Connector 1.0 - Documentation
  2. [Data Connector 1.0] Explore Data Model

[Data Connector 1.0] Changelog

2023-05-26

Updated the data model for certification_dim and certification_fact. This is a significant update to bring both tables in line with the current state of the certification product.

The following fields have been deprecated:

  • certification_dim: created_at, updated_at

  • certification_fact: started_at, assessments_completed_at, challenge_started_at, challenge_completed_at, case_study_started_at, case_study_completed_at

The following fields have been added:

  • certification_fact: registered_at, expired_at, assessments_passed_at, coding_challenge_passed_at, first_exam_started_at, first_exam_completed_at, exam_last_passed_at, case_study_ready_at, first_case_study_submitted_at, last_case_study_submitted_at, is_passed_exams

The following fields have been renamed:

  • certification_dim: certificate_id to certification_id

  • certification_fact: certificate_id to certification_id

2023-05-16

Added new data model for workspace_visit_fact, containing four fields (visitor_id, workspace_id, visited_at, and nb_seconds). Also added additional fields in workspace_dim (owner_type) and workspace_fact (nb_shares, nb_viewers).

2022-02-24

Added new data models for assessments, certification, and workspaces.

Previous[Data Connector 1.0] Data ModelNext[Data Connector 1.0] Example queries

Last updated 1 month ago