IBM Cognos Analysis for Microsoft Excel: Analyze BI Data (V10.1) - eLearning

Access IBM Cognos Data Sources

• Define a connection to IBM Cognos 10
• Log on to IBM Cognos 10
• Select a data package

Create an Exploration

• Build a basic crosstab in an exploration
• Explore the crosstab by filtering, nesting, and drilling down on data
• Open the exploration in Analysis Studio for further analysis

Create a Detailed Analysis within an Exploration

• Add a calculations to the analysis
• Rename and reorder the rows and columns of the analysis

Create a List

• Build a basic list report
• Organize the list report by grouping items together
• Publish the report to IBM Cognos Connection

Use Excel Capabilities with Formulas

• Convert the exploration to formulas
• Customize the crosstab by adding and removing rows and columns
• Add calculations to the crosstab
• Use conditional formatting
• Create charts

Create a Custom Cell-Based Analysis

• Add single items to an Excel sheet to create a custom analysis

Change Items in the Formulas

• Use the search function to locate items in the package
• Change the view of the analysis by replacing items in the formulas

Apply Filters to Reports

• Apply a filter to return specific data
• Combine two filters to perform more complex filtering

Explore Style Sheets and Custom Sets

• Display a complete level of data
• Save a custom set of items for reuse in other reports
• Explore style sheets to customize the appearance of the crosstab

Work with Multiple Packages

• Open a second package and create an exploration
• Create a single report using data from two different packages

Create Multi-Sheet Reports

• Create duplicate sheets
• Create and edit a global filter