Back to Courses

Datawarehousing Cognos BI Online Training

Online Training by SV Soft Solutions

Inquire Now

Online / Training

Inquire to Request Schedule

View this Course

Inquire for Price

Inquire Book Now

RESPONSE RATE

Details
About the Provider

Book Now

Inquire

Details

Introduction & Overview of Cognos BI

Basics of Data warehouse
- Methods
- Difference betweeen OLAP & OLTP
- ETL, Reporting, Analatics etc
- Differenc between Facts, dimensions, type of schema, methodologies
- What is Business Intelligence (BI)?
- Why BI?
- What is Cognos? And why Cognos?
- Cognos BI Architecture
- Cognos 10.2 New Features & Advantages
BI Applications
- Cognos Connection, Report Studio, Query Studio, Event Studio, Analysis Studio
- Transformers, Dynamic Cubes, Framework Manager
- IBM Cognos Workspace
- IBM Cognos Workspace Advanced
- IBM Rapidly Adaptive Visualization Engine (RAVE!)
Installation & Configuration
- Pre-requisits for installation
- Minimum space and memory required
Introduction to Report Studio
- The User interface
- Basic report structure
- Creating a basic report
- Specify the framework package
- Choose a report template
- Add data to the report
- Save report
- Run/Execute report
- Run with options (excel, PDF, HTML, etc)
Types of Reports
- LIST
  - Properties
  - hide columns
  - Limations
  - converting List to Repeater
  - Example : mailing label
- Cross tab
  - Properties
  - Single edge crosstab
  - nested crosstab
  - swap columns and rows
  - adding aggregated data (sum, average, etc)
- Charts
  - Line chart
  - pie chart
  - Chart types
  - convert chart from one type to another
  - customizing chart properties
  - Drill up and drill down chart
- Maps
  - Create Map report
  - Set Map properties
  - add colors to the region
  - add legend title
  - drill thourgh to anotehr report
  - edit map
  - additional maps
  - location intellignece
- Other Report Studio objects
Assignments:1
Formatting a Report
- Adding a Header or Footer
- Table object
- Adding Date
- Adding Time
- Adding Page Number
- Insert Other Objects and properties
- Text object
- Image
- Text Item
- Block
- Field Set
- Query Calculation
- Layout Calculation
- Image
- Bookmark
- Align an Object
- Apply a Table Style
- Apply Padding
- Set Margins
- Add a Page
- Reorder Columns
- Rename a Column
Working with Data
- Filter Data
- Detailed Filters & Summary Filters
- Sort Data & Grouping
- Create Sections
- Add a Summary
- Setting Aggregation, sum, count, min, max..etc
- Create a Calculation
- Conditional Functions
- IF, Else, When case statements
- Arithmetic operations, functions
- Format Data and its properties
Assignments:2
Prompts
- Adding Prompts to report
- Build Your Own Prompt and Prompt Page
- Types of Prompts
- Text Box Prompt
- Value Prompt
- Select & Search Prompt
- Date & Time Prompt
- Date Prompt
- Time Prompt
- Interval Prompt
- Tree Prompt
Working with Existing Reports
- Open and Save a Report in My folder
- Open a Report from the Clipboard
- Change the Package Connection
- Adding Conditional Formatting to a Report
- Drillthrough Access
- Understanding Drillthrough Concepts
- Set Up Drillthrough Access in a Report
- MasterDetail Relationship
- Working with Queries
- Union Query, Intersect, Except
- Create an query from SQL
- Join Relationship
Assignments:3
Active Reports (advance topics)
- Active report controls
- Active report variables
- Convert an Existing Report to an Active Report
- Specify Active Report Properties
- Summarize Data in the Active Report Output
Assignments:4
Miscellaneous Reports
- Bursting Reports
- Dashboards
- Scheduling a report
- Adding recipients in scheduled report
- Scheduling report using prompt values
- Scheduling set of reports
Assignments:5
Cognos Administration
- Examine Cognos Connection
- Creation of data Source connection at Cognos connection level
- Creation Of Report Shortcut
- Creation of Jobs
- Scheduling Reports, Report shortcut, Jobs
- Disabling Schedule
- Organize content with folders and shortcuts
- Personalize Cognos Connection
- How to add portal tab
- How to add report to portal tab
- Connecting Report to Another Package
- Create Users Groups and Users Roles
- Adding Users to Users Groups
- Importing and Exporting Reports From one Environment to Another Environment (Development Environment to production Environment )
- Publishing native metadata into Content store
- How to copy reports from one persons my folder to another persons my folder
- Drill through definition
- How to hide objects in cognos connection
- How to view hidden object in cognos connection
- my preferences
- How to change my preferences
Query Studio
- Working with Query Studio and its features
Event Studio
- Working with Event Studio and its features
Assignments:6Framework Manager (Metadata Modelling)
Introduction to Framework Manager
- Framework Manager Basics
- User Interface, Navigation, Objects
- Planning the project and data model
- Naming conventions for objects in the project
Desiging Project
- Creating project, Importing & Exporting Metadata
- Working with data source connections
- Creating and modify data sources
Preparing Relational Metadata for use in Reports
- Adding relationships between data/tables
- Working with Query subjects and Query Items
- Adding Business Rules
- Organizing the data model
- Performance Tuning
Misc tasks in FM
- Moving packages from one env to another env
- Creating and Modifing Packages
- Controlling access to Metadata
- Explore & Publish Package
- Guideline for Modeling Metadata & Scenarios
Project Work on Meta data Modelling & Assignment:7
Analysis Studio & Transformers
- Analysis Studio & working with Transformers
Extend your analysis with Advanced cognos workspace
- Apply conditional styles
- Create advanced set definitions
- Add advanced calculations
- Group and sort data
- Create advanced filter definitions
- Extend reports with external data
Additional Topics
- IBM Cognos Workspace
- IBM Cognos Workspace Advanced
- IBM Rapidly Adaptive Visualization Engine (RAVE!)
- Project Work
- FAQ's & Interview questions
- Resume Preparation
- Video's
- Cognos Study Materials
- Relatime project assignments

Reviews

Be the first to write a review about this course.

Write a Review

SV Soft Solutions is a premier IT Training and Placement Institute. We attempt best quality courses in areas of PeopleSoft, SAP, Oracle, Android, Microsoft, Servicenow, Datawarehousing, Hadoop, Amazon Web services and Tibco. Our online training institute is the best place for you to brush up your technical leading and build a good career ahead in IT related technologies. Our main assets are our Trainers who have minimum 8 years of experience in IT. Our training takes place with well prepared training materials. We provide excellent documentation and preparation materials for learners.

Online Learning Course Benefits