Trending Courses

Vendors

Skip Navigation Links

Overview

This course provides participants with introductory to advanced knowledge of how to model metadata for predictable reporting and analysis results using IBM Cognos Cube Designer. Participants will learn the full scope of the metadata modeling process, from initial project creation, to publishing a dynamic cube, and enabling end users to easily author reports and analyze data.
img-course-overview.jpg

What You'll Learn

Please refer to course overview.

Who Should Attend

Data Modelers
img-who-should-learn.png

Prerequisites

  • Knowledge of dimensional modeling and design.
  • Experience using the IBM Cognos Analytics portal and Administration.

Learning Journey

Coming Soon...

1: Introduction to IBM Cognos Dynamic Cubes

  • Define and differentiate Dynamic Cubes
  • Dynamic Cubes characteristics
  • Examine Dynamic Cube requirements
  • Examine Dynamic Cube components
  • Examine high level architecture
  • IBM Cognos Dynamic Query
  • Review Dimensional Data Structures
  • Dynamic Cubes caching

2: Create and design a Dynamic Cube

  • Explore the IBM Cognos Cube Designer
  • Review the cube development process
  • Examine the Automatic Cube Generation
  • Manual development overview
  • Create dimensions
  • Model the cube
  • Best practice for effective modeling

3: Deploy and configure a Dynamic Cube

  • Deploy a cube
  • Explore the Estimate Hardware Requirements
  • Identify cube management tasks
  • Examine Query Service administration
  • Explore Dynamic Cube properties
  • Schedule cube actions
  • Use the DCAdmin comment line tool

4: Advanced Dynamic Cube modeling

  • Examine advanced modeling concepts
  • Explore modeling caveats
  • Calculated measures and members
  • Model Relative Time
  • Explore the Current Period property
  • Define period aggregation rules for measures

5: Advanced features of Cube Designer

  • Examine multilingual support
  • Examine ragged hierarchies and padding members
  • Define Parent-Child Dimensions
  • Refresh Metadata
  • Import Framework Manager packages
  • Filter measures and dimensions

6: Optimize performance with aggregates

  • Identify aggregates and aggregate tables
  • In-memory aggregates
  • Use Aggregate Advisor to identify aggregates
  • User defined in-memory aggregates
  • Optimize In-Memory Aggregates automatically
  • Aggregate Advisor recommendations
  • Monitor Dynamic Cube performance
  • Model aggregates (automatically vs manually)
  • Use Slicers to define aggregation partitions

7: Define Security

  • Overview of Dynamic Cube security
  • Identify security filters
  • The Security process - Three steps
  • Examine security scope
  • Identify scope rules
  • Identify roles
  • Capabilities and access permissions
  • Cube security deep dive

8: Model a virtual cube

  • Explore virtual cubes
  • Create the virtual cube
  • Explore virtual cube objects
  • Examine virtual measures and calculated members
  • Currency conversion using virtual cubes
  • Security on virtual cubes

A: Introduction to IBM Cognos Analytics (Optional)

  • Define IBM Cognos Analytics
  • Redefined Business Intelligence
  • Self-service
  • Navigate to content in IBM Cognos Analytics
  • Interact with the user interface
  • Model data with IBM Cognos Analytics
  • IBM Cognos Analytics components
  • Create reports
  • Perform self-service with analysis and Dashboards
  • IBM Cognos Analytics architecture (high level)
  • IBM Cognos Analytics security
  • Package / data source relationship
  • Create Data modules
  • Upload files

This course is not associated with any Certification.

Frequently Asked Questions (FAQs)

  • Why get IBM certified?

    IBM certifications validate your skills and expertise in a wide range of technologies, including hybrid cloud, data & AI, security, IT infrastructure, and business applications.

    These certifications are globally recognized and can help you advance your career, increase your earning potential, and demonstrate your commitment to professional development.

    IBM-certified professionals are in high demand, making them valuable assets to any organization seeking to leverage IBM's innovative solutions.

  • What to expect for the examination?

    IBM offers a variety of certification exams at different levels (Basic, Intermediate, and Advanced) covering various technologies and job roles.

    Exams typically consist of multiple-choice questions and may include scenario-based questions that assess your ability to apply your knowledge in real-world situations.

    Note: Certification requirements and policies may be updated by IBM from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.

  • How long is IBM certification valid for?

    The validity period of IBM certifications varies. Some certifications, particularly those focused on specific product versions or technologies, may have expiration dates.

    However, many IBM certifications, especially those focused on broader skills or newer technologies, do not have an expiration date.

    Note: Certification requirements and policies may be updated by IBM from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.

  • Why take this course with Trainocate?

    Here’s what sets us apart:

    - Global Reach, Localized Accessibility: Benefit from our geographically diverse training hubs in 16 countries (and counting!).

    - Top-Rated Instructors: Our team of subject matter experts (with high average CSAT and MTM scores) are passionate to help you accelerate your digital transformation.

    - Customized Training Solutions: Choose from on-site, virtual classrooms, or self-paced learning to fit your organization and individual needs.

    - Experiential Learning: Dive into interactive training with our curated lesson plans. Participate in hands-on labs, solve real-world challenges, and take on comprehensive assessments.

    - Learn From The Best: With 30+ authorized training partnerships and countless awards from Microsoft, AWS, Google – you're guaranteed learning from the industry's elite.

    - Your Bridge To Success: We provide up-to-date course materials, helpful exam guides, and dedicated support to validate your expertise and elevate your career.

Keep Exploring

Course Curriculum

Course Curriculum

Training Schedule

Training Schedule

Exam & Certification

Exam & Certification

FAQs

Frequently Asked Questions

img-improve-career.jpg

Improve yourself and your career by taking this course.

More Courses By IBM

Browse All Courses
es90g-advanced-parallel-sysplex-operations-and-recovery-workshop-training
System Z

Advanced Parallel Sysplex Operations and Recovery Workshop

ES90G - Advanced Parallel Sysplex Operations and Recovery Workshop
ILT VILT
Course Duration 5 Days
b6258g-ibm-cognos-analytics-author-reports-fundamentals-v11
IBM Analytics

IBM Cognos Analytics: Author Reports Fundamentals v11.1.x

This course provides authors with an introduction to build reports using Cognos Analytics.
ILT VILT
Course Duration 3 Days
esb3g-ibm-z-os-management-facility-implementation-and-use-2-1-training
System Z

IBM z/OS Management Facility Implementation and Use 2.1

This course is designed to provide you with the skills required to install and customize, and use the functions and features provided by z/OSMF.
ILT VILT
Course Duration 3 Days
img-get-info.jpg

Ready to Take Your Business from Great to Awesome?

Level-up by partnering with Trainocate. Get in touch today.

Name
Email
Phone
I'm inquiring for

Inquiry Details

By providing your contact details, you agree to our Privacy Policy.

Stay Connected. Be the first to Know.

Company

Vendors

Services

Customer Service

© Copyright Trainocate 2024. All rights reserved.