Course Content
DATAWAREHOUSING/DIMENSIONAL MODELING PRACTICAL CONCEPTS:
- OLTP vs. OLAP
- Types of OLAP
- Dimensional modeling
- Data mart/Data warehouse Life cycle
- Star/Snow/Extended Star schema design
DATABASE CONCEPTS NEEDED FOR DATA WAREHOUSING
- Joins & Cardinality
- Views/Materialized Views
- Date/Time Functions
- Conversion functions
- Derived table & Stored Procedure
ARCHITECTURAL OVERVIEW
- Client tier components
- Application tier components
- Intelligence tier
- processing tier
- Data tier
- Security management
- Information flow
UNIVERSE DESIGN
- Understanding Business Objects Universes
- Creating the Course Universe
- Building the Universe Structure
- Creating Dimension Objects
- Creating Measure Objects
- Resolving Loops in a Universe
- Resolving SQL Traps
- Using List of Values
- Applying Restrictions on Objects
- Using @Functions with Objects
- Using Hierarchies
- Deriving Tables & Indexes
- Working with Aggregate Awareness
- Designing Advanced Objects
- Creating Predefined Condition
- LOVs & Joins
- Securing Universes
- Implementing Universe Life Cycle Mgmt
- Maintaining & Optimizing Universes
- Creating Universe from Other Data sources
WEB INTELLIGENCE
- Understand concepts of Web intelligence
- Create Web Intelligence documents with Queries
- Restrict data returned by a query
- Design a report
- Enhance the presentation of data in reports
- Format a report
- Calculate data with formulas and variables
- Use multiple data sources
- Analyze data
- Manage and share Web Intelligence documents
- Work with Advanced Query techniques
- Work with calculation contexts
- Create formulas with character & date string functions
- Use "If" logic
- Work with additional reporting techniques
- Create hyperlinks
CRYSTAL REPORTS
- Planning a Report
- Selecting Records
- Formatting a Report
- Representing Data Visually
- Distributing Reports
- Creating Basic Formulas
- Organizing Data on a Report
- Applying Section Formatting
- Applying Conditional Reporting
- Using the Repository
- Using Report Templates
- Creating Formulas
- Building Parameterized Reports
- Summarizing Data with Cross-Tabs
- Using Report Sections
- Managing Reports
- Presenting Data Visually
- Add hyperlinks to a report
DASHBOARD BUILDER
- Understanding Dashboard Manager
- Setting Up Dashboard Manager
- Creating Metrics
- Automating Dashboards with Rules
- Creating Analytics
- Creating Personal Dashboards
- Creating Corporate Dashboards
- Guiding Dashboard Navigation
MIGRATION FUNDAMENTALS
- How Business Objects Enterprise XI 3.0
- Migration concepts
- Import Wizard Concepts
- Understanding object migration
- Understanding user and group migration
- Migration planning and assessment
- After migration with the Import Wizard
ADMINISTRATION
- Understand the Business Objects
- Enterprise interface & architecture
- Manage Business Objects Enterprise content
- Secure Business Objects Enterprise content
- Secure application security
- Schedule content
- Publish reports
- Identify Business Objects Enterprise architecture
- Perform common server management tasks
- Manage the Business Objects Enterprise servers
WIDGETS
- Installing BI Widgets
- Using BI Widgets to Access BI Content
- working with widgets
- BI Widgets Content Authoring Guidelines
- Auto refresh of Widgets
DESKTOP INTELLIGENCE
- Introduction to desktop intelligence
- Scope of analysis
- Report creation
- saving the reports in local repository
- publishing the report
- Report conversion (desktop) to (Webi)
WEB I-RICH CLIENT
- Installing Web Intelligence Rich Client
- Web Intelligence Rich Client working modes
- Launching Web Intelligence Rich Client
- To set user preferences in Web Intelligence Rich Client
- Working with documents
- Working with universes in Web Intelligence Rich Client
- Accessing Web Intelligence from Info View
- Working with queries in Web Intelligence Rich Client
- Working with reports
UNIVERSE BUILDER & QUERY BUILDER
- Universe Builder basics
- Building universes from XML metadata sources
- Updating XML metadata source universes
- Exporting a universe to a XML file format
QUERY AS WEB SERVICE
- Configuring the QWS with BO System
- Creating Webservice report from Universes
- Creating WSDL reports
- Using WSDL reports in external application
VOYAGER
- Getting Started with Business Objects Voyager
- Using Queries to Analyze Cube Data
- Using Charts to Visualize Data
- Selecting Members to Display in Crosstabs and Charts
- Sorting, Filtering, and Ranking Data
- Highlighting Exceptions in Data
- Saving and Sharing Voyager Workspaces
SECURITY IMPLEMENTATION
- Creating Secured users & group
- Creation secured connections
- Creation of Secured objects
- Creation of security at Table, Column & row level
- Creation of secured restriction set and mapping to users or groups
IMPORT WIZARDPUBLISHING WIZARD
- Using Import wizard
- Creation of BIAR
- Migrating the BO objects
- From one CMS TO ANOTHER CMS
- Migrating the objects from one
- domain to another (dev/stage/Prod)
- Backup & Maintenance Deployment
BUSINESS VIEW MANAGER
- Creation of Semantic layer for Crystal reports
- Creation of Dynamic list of values in Crystal reports
- Creation of Cascading list of values in Crystal reports
- Creating Data connection and Dynamic data connection
- Creation of Data foundation
- Creation of Business Element
- Creation of Business View
- Creation of LOV
- Saving the Business view to repository
- Accessing the Business View in Crystal reports using Database expert
- Creation of Crystal reports using Business
LIVE OFFICE REPORTING
- Describe the benefits of using Live Office
- Connect to the repository
- Navigate the Live Office menu
- Insert charts, crosstabs, and fields from a Crystal report
- Insert report parts from a Web Intelligence document
- Insert a new query based on a Universe
- Insert Live Office objects into an email
- Navigate and refresh Live Office objects
- Enable consolidated prompts
- Set refresh settings for objects
- Set parameter binding
- Take a snapshot
- Save Live Office documents to the repository
- Open and view Live Office documents from the repository
SAP WEBI/DASHBOARD REPORTING
- Creation of Web intelligence reports using Info cube & BW Query
Creation of Web intelligence reports using Info cube & BW Query
- Introduction of BO Enterprise SDK
- Choosing the right SDK
- Customizing the Webi reports using SDK
