Master business intelligence concepts with ease!

What you'll learn

Learn to navigating around the Cognos BI application

Understand the different applications in Cognos and when to use Query Studio or Report Studio

Built adhoc reports to accomplish quick, on-the-fly reporting requirements

Create more complex reports that can be used by multiple users for multiple requirements

Develop charts, graphs, and dashboards for macro views of micro data and drill into that micro data

Requirements

Understanding of basic BI concepts is required.

Description

IBM Cognos BI is a web-based report development tool designed to create anything from simple list reports to complex multi-page dashboards across multiple databases. Framework Manager is a part of the IBM Cognos Business Intelligence suite that allows users to model data to facilitate report development and delivery. Framework Manager acts as the middleware between the database and report-writing tools such as Workspace Advanced and Report Studio. So if you are a business intelligence professional looking to get an insight of the IBM Cognos Business intelligence suite, then go for this Learning Path.

The highlights of this Learning Path are:
Become comfortable navigating around the Cognos BI application

Understand the different applications in Cognos and when to use Query Studio or Report Studio

Master complex reports that can be used by multiple users for multiple requirements

Let's take a look at your learning journey. To start off with, you will learn best practices for navigating Report Studio, the types of reports available, adding data, creating fixed filters, creating prompts and formatting. You will then learn advanced topics such as prompt pages, variables, joints/unions, dashboards, drill-through reports, and active reports. You will also learn to secure your reporting environment through Cognos Administration thus securing your reports/directories/data, and the use of macros. Next, you will understand how to efficiently analyze your data and create visually appealing reports and dashboards with IBM Cognos Business Intelligence. You will learn how to navigate and master the components of a model or package. You will then learn to design, build, deploy, and test your models. Finally, you will apply security to the model you have built.

By the end of this Learning Path, you will be able to create stunning reports and dashboards to get actionable insights using IBM Cognos Business Intelligence.

Meet Your Experts:

We have the best works of the following esteemed author to ensure that your learning journey is smooth:

Aaron Solar has involvement in both manufacturing and service industries across multiple sectors. He has 20+ years of experience in BI, financial system, accounting, and business intelligence. His depth of experience from IT and MIS demands continual process improvement and automation within departmental operations as well as zero tolerance for inaccuracies in management systems. He is currently a consultant for Aronson LLC, a firm based in Rockville, MD.

Overview

Section 1: IBM Cognos Report Studio

Lecture 1 The Course Overview

Lecture 2 Navigating Report Studio

Lecture 3 Types of Reports

Lecture 4 Adding Data

Lecture 5 Filters

Lecture 6 Prompts

Lecture 7 Formatting Reports

Lecture 8 Prompt Pages

Lecture 9 Conditional Formatting and Variables

Lecture 10 Joins and Unions

Lecture 11 Creating Dashboards

Lecture 12 Drill Through Reports

Lecture 13 Active Reports

Lecture 14 Navigating Cognos Administration

Lecture 15 Securing Reports

Lecture 16 Securing Directories

Lecture 17 Securing the Data

Lecture 18 Using Macros

Lecture 19 Changing Packages

Lecture 20 Adding jаvascript

Lecture 21 Linking Multiple Objects to One Query

Lecture 22 Page Breaking on Groups

Lecture 23 Cascading Prompts

Lecture 24 Working with SQL

Lecture 25 Handling BLOBs and CLOBs

Section 2: IBM Cognos Connection and Workspace Advanced

Lecture 26 The Course Overview

Lecture 27 The Four Steps to Report Development

Lecture 28 Navigating Cognos Connection

Lecture 29 Changing Your Pref-erences

Lecture 30 Report Management

Lecture 31 Portal Tabs

Lecture 32 Running Reports

Lecture 33 Report Views

Lecture 34 Scheduling Reports

Lecture 35 Navigating Workspace Advanced

Lecture 36 Selecting a Package

Lecture 37 Adding Data

Lecture 38 Adding Filters

Lecture 39 Grouping Data

Lecture 40 Custom Fields

Lecture 41 Formatting

Lecture 42 Exporting Data

Section 3: IBM Cognos Framework Manager

Lecture 43 The Course Overview

Lecture 44 Navigating

Lecture 45 Modeling Layers

Lecture 46 Database Layer

Lecture 47 Transformation Layer

Lecture 48 Presentation Layer

Lecture 49 Namespaces

Lecture 50 Folders

Lecture 51 Model Advisor

Lecture 52 Importing Data Sources

Lecture 53 Joins and Cardinality

Lecture 54 Creating the Three Layers

Lecture 55 Adding Data to the Data Layer

Lecture 56 Transforming the Data

Lecture 57 Adding Items to the Presentation Layer

Lecture 58 Adding Filters

Lecture 59 Adding Calculations

Lecture 60 Formatting Query Items

Lecture 61 Creating Packages

Lecture 62 Publishing Packages

Lecture 63 Editing Projects

Lecture 64 Model Advisor

Lecture 65 Transaction History

Lecture 66 Users, Groups, and Roles

Lecture 67 Filters

Lecture 68 Macros

Lecture 69 Package Security

Lecture 70 Object Security

Lecture 71 Data Security

This Learning Path is targeted at business intelligence professionals looking to get an insight of the IBM Cognos Business intelligence suite.