Data Modelling – Information Design Tool

Request info

Duration: 3 Days


  • Understanding the IDT environment
  • Creating local and remote connections
  • Creating data foundations
  • Creating Business Layers
  • Creating dimensions
  • Creating data foundations with multiple data sources
  • Creating measures
  • Recognising and resolving loops
  • Restricting data
  • Working with lists of values
  • Using @ functions
  • Deploying Universes
  • Working with security editor
  • Working with project synchronisation


  • The target audience for this course is Universe designers who need to create Objects Universes that take advantage of the new features of BI Platform 4.0.



  • Basic knowledge of Windows


  • Some exposure and understanding of SQL would be advantageous.


  • Participants will gain the comprehensive skills and in-depth knowledge needed to create Universes in the new .unx file format.
  • Participants will have a good knowledge of the new standard Universe Design tool going forward.

Cost: £1195 + VAT

SELECT wp_posts.*, wp_p2p.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_p2p WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'start_date' AND CAST(wp_postmeta.meta_value AS DATE) >= '2024-04-15' ) ) AND ((wp_posts.post_type = 'schedule' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) AND (wp_p2p.p2p_type = 'schedule_to_courses' AND wp_posts.ID = wp_p2p.p2p_from AND wp_p2p.p2p_to IN ( SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (2214) AND ((wp_posts.post_type = 'courses' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) ORDER BY wp_posts.post_date DESC )) GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS DATE) ASC