SAP BO

 


Over View

The Focus of this Training is for the beginners who are new to Business Intelligence and Business Objects. This takes the attendee through the deep drive of data warehousing concepts and Business Objects Business Intelligence that includes designing semantic layers against relational and OLAP data sources, design develop reports of adHoc and standard reports for business needs, designing interactive visualizations and distributing to the users.


Attendee Prerequisites

Basic knowledge on database concepts and writing SQL queries.


Career Path
  • SAP BO Business Intelligence Developer
  • SAP Business Objects Developer
  • SAP Crystal Reports Developer
  • XCelsius Dashboard Designer

Certification Path

The course helps you to prepare the following Certification exams

  • SAP Certified Technology Specialist

Why should you choose TECH BUCKS as your SAP BO Training Partner?

Techbucks is the professional online software training company. We offer software training in various technologies. Many may think what is the specialty in choosing TECH BUCKS?

  • Our online training is based on real-time exposure and live interactive classes.
  • Experienced software trainers and skilled professionals with in-depth knowledge.
  • Customized training packages at affordable prices.
  • Special classes by industrial experts.
  • Live project application are dealt in the training
  • Professional environment driven by friendly values.
  • We implement entirely different techniques, methodologies and training in all courses in the easier way to reach your goal.
  • Rigorous training and interactive sessions with real time experts.
  • Dedicated and skilled team to place you in the right job.
  • Assistance in resume preparation, mock interviews and technical questions after training.


 


Benefits Out Of This Training
  • 60 Hours Of Classes
  • 24 Hours access to the server.
  • Trained by Highly real time experienced trainers.
  • FAQs and Real Time Scenarios
  • Mock Interviews
  • On Job Support
  • Case Study
  • Resume Preparation Assistance

Session Details:

Module 1: Data warehouse concepts

  • OLTP/OLAP
  • Normalization / De Normalization
  • Pros and Cons of Data Warehousing against OLTP
  • SCHEMAS – STAR AND SNOWFLAKE
  • Fact and Dimension Tables and Granularity
  • Different types of Facts
  • Data Mart / Data warehouse differences
  • Different approaches to build Data warehouse
  • Difference between Versions 5.x/6/5/XI  R1, R2, R3
  • Business objects XIR3 Suite
  • Role of Business objects in Data warehousing real time life cycle.


Module 2: Universe Designer

  • Understanding how universes allow users to query databases using their everyday business terms
  • Creating an ODBC connection to the course database
  • Creating a universe
  • Populating the universe structure
  • Defining joins in a universe
  • Understanding classes and objects
  • Creating classes and objects
  • Understanding measure objects
  • Working with LOVs in Designer
  • Creating a cascading LOV
  • Resolving loops using aliases
  • Resolving loops using shortcut joins
  • Resolving loops using contexts
  • Resolving chasm traps
  • Resolving fan traps
  • Restricting the data returned by objects
  • Using @ Functions
  • Working with hierarchies
  • Using derived tables
  • Creating links between universes
  • Setting access restrictions on a universe
  • Documenting universes
  • Deploying and maintaining universes
  • Define aggregate awareness
  • Apply aggregate awareness to objects
  • Construct relative data-time objects
  • Create complex predefined conditions
  • Work with advanced LOVs
  • Work with advanced join syntaxes
  • Define connection and user credential parameters
  • Move content from development to production
  • Maintain universe design
  • Work with OLAP universes

Module 3: Desktop Intelligence

  • Introduction to desktop intelligence
  • Report Creation
  • Publishing the report


Module 4: Web Intelligence (Web and Richclients) Reporting

  • Accessing information with Web Intelligence
  • Understanding how universes allow you to query database using everyday business terms
  • Understanding Web Intelligence core functionalities
  • Creating a document in the Web Intelligence Rich Client
  • Viewing a Web Intelligence document in Info View
  • Building a simple query
  • Modifying a document query
  • Working with query properties
  • Restricting data with query filters
  • Modifying a query with a predefined query filter
  • Applying a single-value query filter
  • Using prompts to restrict data
  • Using complex filters
  • Working in the Report Panel
  • Displaying data in tables and charts
  • Using breaks and cross tabs
  • Formatting break, calculations, and report filters
  • Formatting breaks and cross tabs
  • Using default and custom sorts
  • Ranking data to see top or bottom values
  • Using alerter to highlight information
  • Organizing a report into sections
  • Copying data to other applications
  • Preparing document for PDF and print
  • Document formatting
  • Formatting charts
  • Understanding formulas and variables
  • Understanding how Web Intelligence calculates data
  • Creating formulas and variables to calculate data
  • Adding a new query using a personal data provider
  • Creating multiples queries in a document
  • Synchronizing data with merged dimensions
  • Analyzing the data cube
  • Drilling into the data
  • Setting Web Intelligence drill options
  • Exporting documents from the RichClient
  • Accessing Info View
  • Managing documents in Info View
  • Scheduling a Web Intelligence document
  • Setting Info View preference
  • Using combined queries
  • Using sub-queries
  • Creating a query based on another query
  • Understanding the impact of the query drill on performance
  • Understanding calculation contexts
  • Redefining calculation context
  • Using character string functions
  • Using the replace() function
  • Using the right ( ) function
  • Using the Substring ( ) function
  • Using the Pos ( ) function
  • Using If ( ) to group data
  • Using data tracking
  • Using additional report function
  • Understanding the options for creating hyperlinks in Web Intelligence
  • Creating hyperlinks in the different Web Intelligence interfaces
  • Web Intelligence Rich Client general preferences
  • To create a new document in Web Intelligence Rich Client without Universe
  • To select a universe in Web Intelligence Rich Client
  • How does Web Intelligence generate combined queries?
  • Scope of analysis
  • Levels of scope of analysis
  • To set the scope analysis

Module 5: Xcelsius

  • Understanding of Dashboards
  • Using canvas and Independent components
  • Creating Interactive Dashboards
  • Creating web services using  Query as WebService
  • Create Dashboards using against Query as Webservice
  • Create Dashboards for Crystal Reports.

Module 6: BusinessObjects Enterprise

  • Publishing reports to InfoView.
  • Scheduling Reports in InfoView.
  • Understanding of CMC (Management Console)

Module 7:Misc

  • Import Wizard.
  • Report Conversion Tool.

Module 8: OLAP

  • Overview of SAP BW.
  • Creating Universe against SAP BW.
  • Create WEBI Report against OLAP Universe.
  • Create crystal Reports against SAP BW Query.