| Course Length - 2 Days |
| |
| Course Description This class is a combination of instructor-led lecture, discussions, and demonstrations with a heavy emphasis on hands-on workshops to teach Desktop IntelligenceTM XI R2 basic reporting concepts. Topics to be covered include data warehousing concepts, Desktop IntelligenceTM 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 How To: 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 IntelligenceTM XI R2 reporting to access information contained in data warehouses. |
| |
Course 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 IntelligenceTM Basic Reporting tools. |
| |
Next Recommended Course Desktop Intelligence XI R2 Intermediate Reporting (1 Day) |
| |
| Course Outline |
| Desktop IntelligenceTM Overview |
- Data Warehousing
- Desktop IntelligenceTM Role
- Desktop IntelligenceTM As a Tool
- Desktop IntelligenceTM Data Sources/Providers
- What Is a Universe?
- Desktop IntelligenceTM Users
- Getting Started with Desktop IntelligenceTM
- 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
|
| Working with Cells and Columns |
- 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
|
| Report Functions (Using The Toolbar) |
- Ranking
- Breaking
- Sorting
- Grouping
- Filtering
|
| More Report Functions |
- Master/Detail (Sectioned) Reports
- Calculations (Sum, Count, Count All, Average, Min/Max, Percentage)
- Variance
- Safe Order to Apply
|
| Working with Blocks |
- Different Ways to Create a Financial Block
- Different Ways to Create a Crosstab Block
|
| Working with Charts and Pictures |
- 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
|
| Slice and Dice |
- 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
|
| Alerters |
- Creating Different Types of Alerters
- Formatting
- Applying Different Types of Alerters
|
| Predefined and Simple Conditions |
- Working with Predefined Conditions
- Working with Simple Conditions
|
| Simple Drilling |
- Basic Hierarchies
- Drill Down
- Drill Up
- Drill Across
- Drill Through
|
