Cognos Traning:
Course content: IBM Cognos 10 BI
Course duration: 30 Hours
Classes: Classroom Training / Online Training
Data Warehouse Fundamentals:
Unit 1: Basic of Data Warehouse
- An introduction to Data Warehousing
- Purpose of Data Warehouse
- Characteristics of DWH
- Data Warehouse Life cycle
- Data Warehouse Architecture
- Different Approaches of DWH (Kimball Vs Inmon)
- Operational Data Store
- OLTP Vs OLAP Databases
- OLTP Vs Warehouse Applications
- Data Marts
- Data marts Vs Data Warehouses
- Fact Table Vs Dimension Table
- Concepts of Schemas (Star schema & Snowflake schema)
- Industry leading ETL and Reporting tools
Unit 2: Cognos Administration:
- Introduction to IBM Cognos 8 BI Administration
- Manage Scheduled Activities (Past, Present and Future)
- Manage Content in IBM Cognos Administration
- Manage content in IBM Cognos Connection
- Create and Manage Drill through Definitions
- How to connect to different Data Sources
- How to provide security to the Package
- Import and Export of Package (Deployment)
- Report migration from one version to Other Version (Eg 8.4 to 10.1)
- Security Maintenance by using Groups, Roles and Capabilities.
- Creating Port let Page,URL,Multipage Dashboards
- End-to-end Workshops
Unit 3: Cognos Framework Manager:
- About Framework Manager
- Creation of Interface and Usage
- Creating Model & Namespace (Layers)
- Importing Metadata
- Creating Query Subjects & Query Items
- Merging Query Subjects
- Creating Relationships & Setting Cardinalities
- Creating Parameter Maps & Macros
- Usage of Session Parameters
- Creation of Model Filters, Prompts & Calculations
- Creating Package & Security Settings
- Creating Multidimensional Package
- Multi-developer environment (Segmenting and linking& Branching and Merging)
- Synchronize Projects
- Framework Manager Repository Control
- Add Business Rules and Set Governors
- Publishing Package
- Performance Improvement Tips
- Creation of Multilingual Metadata
Unit 4: Query Studio:
- Business Authoring with Cognos Query Studio
- Create ad hoc reports in Query Studio
- Add data to existing ad hoc reports
- Customize ad hoc reports
- View ad hoc reports in different formats
- Create ad hoc reports with filters and calculations
- Create ad hoc charts and crosstabs
- Create ad hoc exception reports
- Define custom groups
Unit 5: Report Studio:
- Type of Report Templates
- Creating list, Cross Tab, Chart, repeater, Maps & Other Reports
- Report templates, formatting Reports – fonts, style, header, footer, boarder…etc
- Generating and Creating Prompt Page
- Types of Prompts
- Query Calculations & Layout Calculations
- Filters and Dynamic Filters
- Conditional Block
- Conditional Formatting
- Master Details
- Cascading Prompt
- HTML Items & Hyperlinks
- Set Operators
- Setting Burst Options
- Drill through
- Drill up & Drill down
- Setting Variables
- Report Functions
- Report Validation
- Reports Run with Options
Unit 6: Analysis Studio:
- Create agents
- Use parameters and calculations
- Add tasks (email, report, database update, agent)
- Manage task execution rules
- Reset the event list
- Run an agent
- Schedule an agent
- Cognos 10 New tasks: Approval, Notification tasks
Unit 7: Transformer:
- Discuss the basics of OLAP analysis
- Review Transformer capabilities and its role in IBM Cognos 10 BI
- Discuss Transformer components
- Define categories and members
- Using multiple Data sources in Transformer
- Define the regular,Time,Measure dimensions
- Creation of Signons
- Building the Powercubes
- Creation special,Manual categories
- Defining security by using custom views
- Drill thru creation
- Time based partition cubes
Unit 8: Cognos 10 New features:
- Active Reports:
- Discuss the value of Active Reports
- Examine an Active Report and its controls
- Convert an existing report to an Active Report
- Debug and save an Active Report
- Explore interactive properties
- Use filter and select in Active Reports
- Examine decks and cards
- Examine master-detail relationships and decks
- Use advanced features with Active Reports
- Drill up and down on an Active Report
- Create cascading prompts in an Active Report
- Business In sight:
- Self-service Authoring with Cognos 10 Business Insight
- Introduction to Business Insight
- Leverage pre-existing content in a Business Insight dashboard
- Modify content using basic Business Insight functionality:
- Sorting output
- Suppress and filter data
- Control display properties
- Add formatting
- Add basic calculations
- Business Insight Advance:
- Extend your analysis with Advanced Business Insight functionality:
- Apply conditional styles
- Create advanced set definitions
- Add advanced calculations
- Group and sort data
- Create advanced filter definitions
- Extend reports with external data
- And Many more Concepts……………