Cognos Build Data Marts Reports and Dashboards Online Training

Course overview

About the Cognos Build Data Marts Reports and Dashboards program.

This course is designed to prepare professional real world cognos reports. Teaches participants how to move, merge, consolidate, and transform data from a range of data sources to buildand maintain subject-area data marts. In the process, students will create a catalog and add connections to data sources and targets. They will also deliver fact and dimension data to a data mart through the use of builds and the dimensional framework. In addition, students will learn how to automate common functionality and handle complex data issues, such as unbalanced hierarchical structures. It is designed for professional report authors to learn fundamental and advanced report building techniques using relational data models, and methods of enhancing, customizing, and managing professional reports. Attendees will participate in hands-on demos and workshops that illustrate key concepts while learning how to use the product.

Why learn with BISP

Trusted by professionals across 30+ countries.

Industry trainers

Certified consultants with 12+ years of real project experience.

Hands-on practice

Real-time scenarios & live project modules, not just slides.

Placement support

Resume building, mock interviews & job referrals.

Certification

BISP certificate + full guidance for official exams.

Course curriculum

Download curriculum (PDF)

31 modules 119 topics

01 Getting Started 4 topics

Identify the purpose of IBM Cognos Data Manager
Define data warehousing and its key underlying concepts
Identify how Data Manager creates data warehouses
Examine the Data Manager architecture and user interface

02 Create Derivations 4 topics

Examine derivations
Apply operators and functions to derivations
Examine the derivation timing model
Add derivations to a fact build

03 Process Dimensional History and Late Arriving Facts 6 topics

Examine slowly changing dimensions (SCDs)
Use surrogate keys in SCDs
Manage type 1 and type 2 changes to dimensional data
Load historical data for a dimension
Examine late arriving facts
Process late arriving facts in a fact build

04 Customize Fact Data Processing 4 topics

Filter fact data
Merge duplicate fact data
Examine fact data integrity checking
Reject fact data

05 Automate Functionality Using Commands 4 topics

Differentiate between the Command Line Interface (CLI) and Data Manager Designer
Identify common commands
Use commands in a batch file
Examine variables

06 Pivot Fact Data 3 topics

Examine pivoting
Use the single pivot technique
Use the advanced pivot technique

07 Create List Reports 4 topics

Format, group, and sort list reports
Describe options for aggregating data
Create a multi-fact query
Create a report with repeated data

08 Present Data Graphically 3 topics

Create charts containing peer and nested items
Add context to charts
Present key data in a single dashboard report

09 Present Data Using Maps 2 topics

Present data using map reports
Navigate to another level within a map

10 Create Query Reports Based on Relationships 3 topics

Create reports by merging query results
Create reports by joining queries
Combine data containers based on relationships from different queries

11 Enhance UserInteraction with HTML 2 topics

Create tooltips that clarify report data
Send emails using links in a report

12 Create a Catalog 5 topics

Examine the purpose and contents of Data Manager catalogs
Create a catalog
Define connections to source and target data
Access data using SQLTerm
Configure flat data source files using SQLTXT

13 Create Conformed Dimensions 4 topics

Examine conformed dimensions and their advantages
Design conformed dimensions
Create conformed dimensions
Create data integrity lookups that use conformed dimensions

14 Transform Data Using Lookups and Derived Dimensions 5 topics

Identify when to use lookups
Identify the requirements for a lookup
Create a translation lookup
Create an optional lookup
Add derived dimensions to fact builds

15 Aggregate, Filter, and Partition Fact Data 5 topics

Aggregate fact data
Examine aggregate rules
Vertically restrict fact data
Horizontally restrict fact data
Partition fact data

16 Customize Functionality with User-Defined Functions and Variables 3 topics

Examine user defined functions (UDFs)
Create an internal UDF
Create a user-defined variable

17 Resolve Data Quality Issues 4 topics

Identify data quality and cleansing issues
Handle fostered and unmatched members
Perform debugging using SQLTerm and functions
Assess the quality of output data

18 Focus Reports Using Filters 3 topics

Create filters to narrow the focus of reports
Examine detail and summary filters
Determine when to apply filters on aggregate data

19 Focus Reports Using Prompts 4 topics

Identify various prompt types
Use parameters and prompts to focus data
Customize prompts to facilitate users' choices
Display users' prompt selections in the report

20 Customize Reports with Conditional Formatting 3 topics

Create multi-lingual reports
Highlight exceptional data
Conditionally render objects in reports

21 Design Effective Prompts 4 topics

Control report displays using prompts
Specify conditional formatting values using prompts
Specify conditional rendering of objects based on prompt selection
Create sorted and filtered reports based on prompt selection

22 Create Hierarchies 6 topics

Examine the role of the dimensional framework in Data Manager
Examine hierarchies and their data sources
Identify how to create hierarchies from the columns of one table, the rows of one table, and from multiple tables
Test and view hierarchies
Create a hierarchy of static date values
Handle weeks in a date hierarchy

23 Customize Reference Structures 6 topics

Create hierarchies manually using different approaches
Examine the features of a hierarchy
Examine literals
Set data access for hierarchy levels
Examine static and dynamic members
Examine fostering

24 Customize Data Delivery 3 topics

Configure fact and dimension delivery modules
Create indexes on fact and dimension tables
Update fact data using keys

25 Implement Job Control 4 topics

Examine where job control fits into the data warehouse lifecycle
Create a JobStream
Add, link, and reposition nodes
Execute a JobStream and view the results

26 Process Unbalanced Hierarchical Data 4 topics

Examine balanced, unbalanced, and ragged hierarchies
Add a recursive level to a hierarchy
Identify ways to balance a hierarchy and delivered flattened data
Examine circular references

27 Organize and Package Data Manager Components 2 topics

Export and import components using packages
Search for components in a catalog using Navigator

28 Create Crosstab Reports 4 topics

Format and sort crosstab reports
Convert a list to a crosstab
Create crosstabs using unrelated data items
Create complex crosstabs using drag and drop functionality

29 Extend Reports Using Calculations 3 topics

Create calculations based on data in the data source
Add run-time information to the reports
Create expressions using functions

30 Drill-through Definitions 4 topics

Enable users to navigate to related data in IBM Cognos BI
Parameter-driven drill through vs. dynamic drill through
Steps to enable drill-through access for a package
Limit the items that users can drill through from (set scope)

31 Create Additional Advanced Reports 4 topics

Create a report that displays summarized data before detailed data
Highlight alternate rows in a list report
Create a report using an external data file
Use single data items to summarize report information

Course details

Who it is for, what you need, and how it is delivered.

Who should learn Cognos Build Data Marts Reports and Dashboards?

Business Intelligence, Analytics and Reporting Professionals

IT Developers, Testers, Project Managers, Data Scientists, and Statisticians

Prerequisites

Anybody can take up this training regardless of their skills. However, having a basic knowledge of SQL is beneficial.

Delivery methodology

We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.

Class delivery

Live Interactive classes with expert

Certificate of completion

Earn an industry-recognised BISP Trainings certificate when you finish the course.

Verifiable certificate with a unique ID
Shareable on LinkedIn & your resume
Recognised by our hiring partners

Frequently asked questions

Everything you need before you enroll.

Can I attend a demo session before enrollment?

Yes. You may attend a demo class before enrollment for training quality evaluation, and interact one-to-one with the trainer for any specific requirement.

Can you schedule training as per my availability?

Yes. We discuss it with the trainer and schedule the training at a convenient time for you.

What if I miss a class?

You get the recorded session. You may also retake the whole training multiple times within a 6-month period with the same trainer.

Is there live project training?

Yes. The curriculum includes real-time scenarios and live project modules, with the trainer explaining every topic end-to-end.

How can I pay for the course?

Enroll securely via the payment gateway on this page using card, UPI or net-banking. EMI options are available.

More queries?

Call us at +91 769-409-5404 & +1 678-701-4914, or write to support@bisptrainings.com.

Case studies & learning PDFs

Free IBM resources to explore.

PDFAggregate Transformation DataStage Lab 11 PDFChange Data Capture DataStage Lab 13 PDFCognos Event Studio PDFData Stage Lab 12_Remove Duplicate PDFData Stage Lab 15_Sort Value and Range Map PDFImplement Change Data Capture Data Stage Lab 16

Relevant courses

Learners who took this also explored these.

Not sure if this course is right for you?

Book a free 1-on-1 counselling call and get a personalised learning roadmap.

Book free trial →

Cognos Build Data Marts Reports and Dashboards

AI practice, included with this course

AI mock interview

AI MCQ assessment

Scores and reports