- Why should we consider Data Warehousing solutions?
- Definition of Data Warehouse
- Who needs Data Warehouse?
- What are the most common sectors where Data Warehouse is used ?
- Characteristics of DWH
- Difference between DW’s and OLTP
- DWH Life Cycle
- DWH Architecture
- Dimensions & Facts
- Star Schema & Snowflake Schema Design
- Assignments Q&A's
- Quiz Q&A's
- 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
- Assignments Q&A's
- Quiz Q&A's
- List the packages available for reporting
- Understand report types
- Add and save data to ad hoc reports
- View data by using charts
- Assignments Q&A's
- Quiz Q&A's
- Create a list, grouped list, and crosstab reports
- Calculate and sort report data
- Assignments Q&A's
- Quiz Q&A's
- Highlight report items using conditional styles
- Focus the scope of a report using filters
- Format report objects
- Assignments Q&A's
- Quiz Q&A's
- Introduction to Framework Manager
- User Interface, Navigation, 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
- Assignments Q&A's
- Quiz Q&A's
- Introduction to the Reporting Application
- Examine Report Studio and its interface
- Explore different report types
- Create a simple, sorted, and formatted report
- Explore how data items are added to queries
- Create List Reports
- Group, format, and sort list reports
- Describe options for aggregating data
- Create a multi-fact query
- Create a report with repeated data
- Focus Reports Using Filters
- Create filters to narrow the focus of reports
- Examine detail and summary filters
- Determine when to apply filters on aggregate data
- Create Cross Tab Reports
- Format and sort crosstab reports
- Create complex crosstabs using drag and drop functionality
- Create crosstabs using unrelated data items
- Present Data Graphically
- Create charts containing peer and nested columns
- Present data using new chart type options
- Add context to charts
- Present key data in a single dashboard report
- Focus Reports Using Prompts
- Identify various prompt types
- Use parameters and prompts to focus data
- Extend Reports Using Calculations
- Create calculations based on data in the data source
- Add run-time information to the reports
- Create expressions using functions
- Design Effective Reports
- Enhance report design with report objects
- Reuse objects within the same report
- Share layout components among separate reports
- Customize Reports With Conditional Forming
- Create multi-lingual reports
- Highlight exceptional data
- Show and hide data
- Conditionally render objects in reports
- Drill-Through from One Report to Another
- Let users navigate from a specific report to a target report
- Pass parameter values to filter the data in drill-through targets
- Navigate through multiple reports
- Examine the Report Specification
- Examine the report specification structure
- Save and edit reports locally
- Discuss considerations for modifying a report specification
- Create Reports Based on Query Relationships
- Create reports by merging query results
- Create reports by joining queries
- Combine data containers based on relationships from different queries
- Distribute Reports Through Bursting
- Distribute reports using bursting
- Create burst keys
- Identify report recipients and data items using burst tables
- Distribute reports using email and IBM Cognos Connection
- Active Reports
- Active Reports Introduction
- Create active report templates
- Describe active report connections, Apply Filter and Select behavior to active report controls
- Identify active report controls and variables in a report
- Use variables to control multiple controls independently
- Describe characteristics of traditional charts inactive reports
- Control data display using decks and data decks
- Assignments Q&A's
- Quiz Q&A's
- Analysis Studio Fundamentals
- Define the fundamental terms of Analysis Studio
- Explain how to insert objects
- Define and create sets
- Identify the work area, overview area, and properties pane
- Tools for Investigation in Analysis Studio
- Employ drilling down and up to different levels of detail
- Apply changes to rows, columns, and measures in the analysis
- Explain how to change the display of data
- Use charts to display data graphically
- Nest Data in Cross Tabs in Analysis Studio
- Apply depth to rows and columns by nesting data
- Recognize drill behaviour in nested rows and columns
- Demonstrate how to swap nested levels
- Build Advanced Cross Tabs in Analysis Studio
- Demonstrate how to view a complete level of data
- Design a crosstab without retrieving data
- Compare multiple measures
- Apply stacked sets to the crosstab
- Construct an asymmetrical crosstab
- Compose a custom sort
- Focus with Filtersin Analysis Studio
- Apply Filters Using Expressions
- Apply filters using the Context area
- Create top and bottom lists
- Use several techniques to remove rows and columns
- Assignments Q&A's
- Quiz Q&A's
- 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
- Assignments Q&A's
- Quiz Q&A's