Desktop Intelligence XI R2 Basic Reporting

Course Length - 2 Days

Description

This class is a combination of instructor-led lecture, discussions, and demonstrations with a heavy emphasis on hands-on workshops to teach Desktop Intelligence^TM XI R2 basic reporting concepts. Topics to be covered include data warehousing concepts, Desktop Intelligence^TM data sources and providers, creating reports and charts, building queries, formatting techniques, using the Slice and Dice panel, sorting and filtering, creating drill-down reports, using new Find functionality, creating and applying alerters.

You Will Learn

The student will acquire skills to:

• Access Data
• Analyze Information
• Slice and Dice Data
• Create Useful Reports and Charts
• Use Built-in Help Features

The student will also learn data warehousing concepts and how to use Desktop Intelligence^TM XI R2 reporting to access information contained in data warehouses.

Prerequisites

Basic Windows Skills

Who Should Attend

This class is designed for both technical and non-technical business analysts working in a business environment who require access to information contained in a data warehouse to generate a variety of reports and graphs utilizing the Desktop Intelligence^TM Basic Reporting tools.

Outline

Desktop Intelligence^TM Overview

• Data Warehousing
• Desktop Intelligence^TM Role
• Desktop Intelligence^TM As a Tool
• Desktop Intelligence^TM Data Sources/Providers
• What Is a Universe?
• Desktop Intelligence^TM Users
• Getting Started with Desktop Intelligence^TM
• What Are Objects?
• Report Manager Overview
• What Is a Query?
• Query Panel Overview
• View Data Feature
• Query Options
• Introduction to Blocks
• Editing Existing Queries
• Report Manipulation
• Using the New Report Wizard
• Building Your Query

• Selecting Columns
• Removing Columns
• Inserting Columns
• Replacing Columns
• Sizing Columns and Rows
• Moving Columns
• Moving Report Elements
• Formatting Cells (Via the Toolbar)
• Free-standing Cells
• Different Ways to Create a Table Block

• Ranking
• Breaking
• Sorting
• Grouping
• Filtering

• Master/Detail (Sectioned) Reports
• Calculations (Sum, Count, Count All, Average, Min/Max, Percentage)
• Variance
• Safe Order to Apply

• Different Ways to Create a Financial Block
• Different Ways to Create a Crosstab Block

• Different Ways to Create a Chart
• Moving a Chart
• Changing Type of Chart
• Chart Formatting
• Inserting Titles in Charts
• Adding Legends to Charts
• Inserting Pictures

• Overview
• Object Manipulation (Moving, Inserting, and Removing Objects)
• Block Structure Transitioning
• Ranking, Breaking, Sorting, Filtering
• Master/Detail (Sectioned) Reports
• Calculations (Sum, Count, Count All, Average, Min/Max, Percentage)
• Transposing Blocks to Charts

• Creating Different Types of Alerters
• Formatting
• Applying Different Types of Alerters

• Working with Predefined Conditions
• Working with Simple Conditions

• Basic Hierarchies
• Drill Down
• Drill Up
• Drill Across
• Drill Through