Data Modelling with Board

This course is designed for Database Developers who are seeking to become self-sufficient in Board multi-dimensional Database design.  The course is suited to Administrators and Business Users from multiple disciplines.

Timezone: GMT

Price: £1,000/person

Delegates will learn the fundamental building blocks of Board database construction. The use and configuration of Entities, Relationships, Rules and Cubes are covered in depth, as well as the process of loading data into a Board database (Data Readers). These techniques will be put into practice on a sample data set to implement a simple sales analysis application drawing on multiple data sources.  The course also covers database maintenance and troubleshooting, as well as an introduction to the Board security model.

Agenda:

• Board Data Model
• Entities
• Hierarchies and Relationships
• Cubes
• Data Readers
• Custom Time Entity
• Managing Relationships
• Modifying and Maintaining the Application
• Performance Tuning
• Rules
• ROLAP and Drill-Through
• Non-Numerical Cube Types
• Security

Hardware:

• A laptop able to “remote desktop” to Board training server – each trainee is provided with their own connection for the course and all training software, materials and exercises are accessed from there.
• For online courses, a dual-screen setup is beneficial but not required