As data warehouses continually grow in size, the need for improved performance becomes more and more important. The ability to leverage star or snowflake structures through ad-hoc query and interactive analysis has become a business intelligence requirement for many organizations. IBM Cognos Dynamic Cubes helps meet this requirement.

Course Outline

This 2-day course is designed to provide fundamental and advanced coverage of the entire Dynamic Cube metadata modeling process, from the initial project creation to publishing cubes.

During the class, students will review the IBM Cognos BI landscape to understand where dynamic cubes fit, create and deploy cubes, and learn about advanced topics including performance optimization and defining security.

Each topic will be highlighted with in-depth workshops, question and answer sessions and tips and techniques drawn from years of cross industry experience.

Pre-requisites

A fundamental understanding of data modeling, business intelligence, and requirements gathering.
Attendance on the BI Masterclass would be beneficial.

High-level Curriculum

  • Overview of IBM Cognos BI
  • Introduction to IBM Cognos Dynamic Cube
  • Create and Design a Dynamic Cube
  • Deploy and Configure a Dynamic Cube
  • Advanced Dynamic Cube Modeling
  • Optimize Performance with Aggregates
  • Define Security
  • Model a Virtual Cube