Skip to main content

Tableau Desktop Integration

Dual Code's Tableau Desktop integration lets you connect Dual Code's data to Tableau Desktop. Once connected, Tableau Desktop lets you visually display your data with charts and graphs, and create reports.

The Tableau Desktop Integration services described below may require additional one-time and/or annual fees. For more information, please contact us.


Step-by-step Guide

To pull Dual Code learning records and data to Tableau Desktop:

  1. Open Tableau Desktop
  2. From the Home screen in the left-hand sidebar 'Connect', chose 'MySQL' (Please ensure any MySQL ODBC drivers are installed for Tableau Desktop)
  3. In the dialog enter your Dual Code BI credentials and click 'Sign in'
  4. Now you can work with the data as needed

Note: These steps are based on Tableau Desktop v2020.4.2

Check out the Tableau Help for more info on how to use Tableau Desktop.

Important Notes

When integrating your preferred Business Intelligence (BI) tool to the database, the following technical details are worth noting:

  • The learning environment is based on Moodle, the world's most popular open-source learning management system. Moodle does not currently generate actual foreign key constraints in the database. As such, Dual Code has defined the relationship using the following convention.

    • The ID column in a table always represents the primary key and usually has the comment of "Primary key of the table."

    • A foreign key usually has the comment of "Key referencing the primary key in the [tablename] table."

  • When dealing with dates or times:

    • As a general rule, most dates/times are stored in the database as a BigInt in Unix time format (also known as Epoch time, POSIX time, seconds since the Epoch, or UNIX Epoch time). Some exceptions apply.

    • The database read-only replica is in the same timezone as the production server.

  • Dual Code has developed views to facilitate your development. 

    • Regular table start with the mdl_ prefix (e.g. mdl_course)

    • Views start with the bi_mdl_ prefix (e.g. bi_mdl_users)

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.