Business Objects Desktop Intelligence Advanced Reporter Course - Albania

Business Objects Desktop Intelligence Advanced Reporter Course Outline

Module 1: Introduction to Desktop Intelligence

• What is Desktop Intelligence?
• Where does the Data Come From?
• Presenting and Analysing Data
• Sharing Information
• Security
• Keeping a Document's Data Up-To-Date
• Demo Materials and Samples
• Upgrading from Earlier Versions of Desktop Intelligence
• Repository
• Folders and Categories

Module 2: Introduction to Accessing Data with Desktop Intelligence

• What Data Sources are Available?
• How do you Access Data Sources?
• Restrictive Connections
• Workflows for Accessing Data
• Using the Repository
• Managing Categories
• Importing from the Repository
• Retrieving Different Instances of a Given Document
• Sending Documents from Desktop Intelligence

Module 3: Combining Data from Different Sources

• Which Data Providers can you Combine in One Report?
• Displaying Data from Separate Data Providers
• Prompts and Linking
• Linking Data Providers
• What Situations Require to Link Data Providers?
• Deleting the Link between Data Provider

Module 4: Managing Data Providers

• Overview
• Renaming Data Providers
• Why Rename Data Providers?
• Getting Statistics on Data Providers
• To Get Statistics on Data Providers
• Purging and Deleting Data Providers
• To Purge or Delete a Data Provider
• Using Data Providers Efficiently

Module 5: Slice and Dice Mode

• Working in Slice-and-Dice mode
• To Display the Slice and Dice Panel
• Working with Master/Detail Reports in Slice and Dice Mode
• Positioning Data Horizontally in Slice-and-Dice Mode
• Working with Crosstabs and 3-D Matrix Charts
• Displaying and Removing Data in Slice-and-Dice Mode
• Deleting, Renaming, and Resetting Blocks in Slice and Dice Mode
• To Transform Blocks in Slice-and-Dice Mode
• Applying Further Modifications in Slice and Dice Mode

Module 6: Using and Customising Lists of Values

• What is a List of Values?
• How are Lists of Values Created?
• Customising Lists of Values in Desktop Intelligence
• Editing Lists of Values
• To Assign Personal Data from a Text and Excel

Module 7: Formulas, Local Variables, and Functions

• Formulas
• Displaying the Formula Bar and Editor
• Local Variables
• Transforming a Formula into a Local Variable
• Creating Local Variables by Grouping Values
• Inserting Local Variables and Formulas in a Report
• Aggregate Function Equivalents
• Numeric Function Equivalents
• Character Function Equivalents
• Date Function Equivalents

Module 8: Desktop Intelligence and Visual Basic for Applications

• What is a Macro?
• What is an Add-In?
• Using Macros
• To Run a Macro
• Using Add-Ins
• Exchanging Add-Ins with Other Users
• Converting Scripts to Macros
• To Convert a Script
• Using the Visual Basic Editor