Cognos 8 BI

1
Overview of the Data Warehouse Web Portal
Cognos 8 BI
2
Objectives

• In this module, we will
• introduce the Data Warehouse Web Portal
• examine the different studios
• identify the different data sources within the
  studios
• highlight key capabilities

3
Data Warehouse- Introduction

• The Data Warehouse is a complete enterprise
  business intelligence software solution
  integrating existing reports, analysis, and
  report authoring capabilities.

4
Examine the Studios

• Query Studio helps you quickly answer a focused
  question.
• Analysis Studio performs simple to complex
  analyses and comparisons of data to discover
  trends, risks, and opportunities.
• Report Studio builds sophisticated reports,
  including multi-page, multiple-query reports
  against multiple data sources.

5
Review Open Data Access
Query Studio
Report Studio
Analysis Studio
Cognos Viewer
Data Access
SQL
MDX
ODBC
XML
Cubes
Metric Database
Relational
Files
Composite
More
6
Work with PowerCube Data in Cognos 8 BI

• You can work with your PowerCube data in all the
  studios in Cognos 8 BI.

Query Studio
Report Studio
Analysis Studio
Cognos Viewer
Data Access
Cognos PowerCube
7
Analyze Data From Multiple Data Sources

• Use Analysis Studio to analyze data in
  dimensional data sources (for example,
  PowerCubes, MSAS, and SAP BW) or relational data
  sources that are modeled dimensionally.

OLAP data source
Relational data modeled dimensionally
8
Identify Data Source Types in the Studios
Relational model
Dimensional model
9
Design Informative Executive Dashboards

• You can design informative dashboards using the
  extensive capabilities of Report Studio.

10
Perform Self-Service Reporting

• Cognos 8 BI provides extended formatting,
  filtering, and calculations for ad hoc reports.

Highlight Exceptional Data
11
Perform Self-Service Reporting (contd)

• Cognos Office Connection extends the reach of the
  Cognos BI value to business users who prefer to
  work with Microsoft Office.

Import a Cognos Connection report into Microsoft
Office Excel using Cognos Office Connection.
12
Examine Integrated Metrics

• Metric Studio is fully integrated into Cognos 8
  BI.

13
Summary

• In this module, we have
• introduce the Data Warehouse Web Portal
• examine the different studios
• identify the different data sources within the
  studios
• highlight key capabilities