Improvements of Data Warehouse

We have made some changes on the LEARNING_ANALYTICS / DWH / TRAININGS view

• We have added the Last Publication Date for every training courses
• We have added the Keywords for every training courses
• All the languages of a training course are now available

Watch Out

As the title and the keywords of each training course is now available in each translated language, this means the size of the TRAININGS table can significantly increase if you have many translations.

If you use the TRAININGS table in your data visualization, ensure your data model can safely integrate the new columns before adding new filters based on these new fields.

Old Design

New Design