Module 1: Data Warehouse Basics
- Why should we consider Data Warehousing solutions?
- Definition of Data Warehouse
- Characteristics of DWH
- Difference between DW’s and OLTP
- DWH Life Cycle
- DWH Architecture
- Dimensions & Facts
- Star Schema & Snowflake Schema Design
Module 2: Building Cubes and Views
- What is IBM Cognos Analytics?
- Examine IBM Cognos Analytics UI elements
- Run and view reports
- View the run history of a report
- Organize content with folders and shortcuts
- Customize report outputs by using report views
- Schedule single and multiple reports
- Backups-Export of Cognos Content
- Create a Data source
- Deployment
- Users, Groups and Roles
Module 3: Introduction to Query Studio
- List the packages available for reporting
- Understand report types
- Add and save data to ad hoc reports
- View data by using charts
Module 4: Create Reports in Query Studio
- Create a list, grouped list, and crosstab reports
- Calculate and sort report data
Module 5: Enhance Reports in Query Studio
- Highlight report items using conditional styles
- Focus the scope of a report using filters
- Format report objects
Module 6: IBM Cognos Framework Manager: Relational Metadata Modeling
- Introduction to Framework Manager
- User Interface, Navigation, Objects
- https://mindmajix.com © Mindmajix Technologies Inc. All Rights Reserved Page No. 5
- Create a list, grouped list, and crosstab reports
- Calculate and sort report data
- 4. Create Reports in Query Studio
- 5. Enhance Reports in Query Studio
- Highlight report items using conditional styles
- Focus the scope of a report using filters
- Format report objects
- Designing Project
- Create project
- Importing Metadata
- Working with Data Source Connections
- Create and Modify Data Sources
- Preparing Relational Metadata for use in Reports
- Verifying Relationships
- Working with Dimensions
- Working with Query Subjects
- Working with Query Items
- Supporting Multilingual Metadata
- Adding Business Rules
- Organizing the Model
- Verify Model
- Set Governors
- Create or Modify Package
- Publish Package
- Object Data and package security
- Making Metadata Available to Report Authors
- Edit Governors
- Guidelines for Modeling Metadata
- DMR model - Regular Dimensions, Measure Dimensions, Scope Relationship
Module 7: Advanced Report Authoring
- Introduction to the Reporting Application
- Create List Reports
- Focus Reports Using Filters
- Create Cross Tab Reports
- Present Data Graphically
- Focus Reports Using Prompts
- Extend Reports Using Calculations
- Design Effective Reports
- Customize Reports with Conditional Forming
- Drill-Through from One Report to Another
- Examine the Report Specification
- Create Reports Based on Query Relationships
- Distribute Reports Through Bursting
- Active Reports
Module 8: Advanced Report Authoring
- Analysis Studio Fundamentals
- Tools for Investigation in Analysis Studio
- Nest Data in Cross Tabs in Analysis Studio
- Build Advanced Cross Tabs in Analysis Studio
- Focus with Filtersin Analysis Studio
Module 9: Event Studio - Work Space
- Data Warehousing concepts ppt
- Cognos Connection ppt along with screenshots
- Query studio ppt along with screenshots
- Query Studio Topics for Practice Doc
- Report studio ppt along with screenshots
- Report Studio Topics for Practice Doc
- Framework Manager ppt along with screenshots
- Analysis Studio ppt along with screenshots