SAP BOBI

SAP BOBI “4.1” course content

MODELLING

  • 1. Introduction to SAP.
  • 2. Introduction to Business Objects.
  • 3. New features in SAP BO BI 4.1.
  • 4. Data Warehousing Architecture.
  • 5. Business Objects Architecture.
  • 6. Data Modelling
  • 7. ER Modelling
  • 8. Dimensional Modelling.
  • 9. Dimensional Tables.
  • 10. Fact Tables.
  • 11. Different types of Dimension Tables
    • a. Conformed Dimension Tables
    • b. Junk Dimension Tables
    • c. De generative Dimension Table
  • 12. Schema
    • a. Star Schema
    • b. Snowflake Schema
    • c. Galaxy Schema.
  • 13. Slowly Changing Dimensional Tables.
  • 14. Fact Table.
  • 15. Fact Less Fact Table.
  • 16. Different Types of Facts or Measures
  • 17. Bridge tables.
  • 18. Lookup Tables.
  • 19. Top Down Approach
  • 20. Bottom Up Approach
  • 21. ODS
  • 22. Data Mart
    • a. Dependent Data mart.
    • b. Independent Data Mart.
  • 23. Staging Area.
  • 24. Granularity
  • 25. Normalization
  • 26. De normalization
  • 27. OLTP
  • 28. OLAP & Types of OLAPs

ORACLE 10g (SQL):

  • 1. Introduction to Oracle Database.
  • 2. Data Types.
  • 3. SQL Statements.
    • a. DDL –Data Definition Language.
    • b. DML – Data Manipulation Language.
    • c. DQL – Data Query language.
    • d. DCL – Data controlling language.
    • e. TCS - Transaction Controlling Language.
  • 4. Build In functions.
    • a. Character Functions
    • b. Numeric Functions
    • c. Data Functions
    • d. Conversion Functions
    • e. Aggregate Functions.
  • 5. Joins:
    • a. Inner Join
    • b. Left Outer Join
    • c. Right outer Join
    • d. Full outer Join
    • e. Cartesian Join
    • f. Self Join
    • g. Natural Join
  • 6. Set Operators.
    • a. Union
    • b. Union All
    • c. Intersect
    • d. Minus
  • 7. Sub Queries.

 SAP BOBI 4.0 - Information Design Tool.

  • 1. Creation of Project.
  • 2. Relational Connection.
  • 3. OLAP Connection.
  • 4. Data Foundation Layer.
  • 5. Business Layer.
  • 6. Edit Connection.
  • 7. Shortcut Connection.
  • 8. Secured Connection.
  • 9. Publishing Connection .
  • 10. Publishing the Business layer.
  • 11. Converting Repository Universe from Unv into Unx.
  • 12. Publishing the Universe to Repository.
  • 13. Publishing the Universe to Local.
  • 14. Retrieving the Universe from Repository.
  • 15. Multi Source Universe.
  • 16. Data Foundation.
  • 17. Insert tables in Data Foundation
  • 18. Define Joins in Data Foundation.
  • 19. Cordiality setting in Data Foundation.
  • 20. Arrange Tables:
  • 21. View Table values in Data Foundation.
  • 22. Filter Table values in Data Foundation( Wont Impact in Reports O/P).
  • 23. Edit Table values( Removing Columns , Changing Data types & Keys ) .
  • 24. Calculated Column in Tables.
  • 25. Sort and re-ordering the columns in Data Foundation.
  • 26. Refresh Structure.
  • 27. Derived tables.
  • 28. Create Views.
  • 29. Detect Join / Cordiality / Alias /Keys / Row Counts .
  • 30. Resolving Loops.
  • 31. Alias.
  • 32. Context.
  • 33. Business Layer:
  • 34. Folders (Class)
  • 35. Sub Folder ( Sub Class)
  • 36. Objects
  • 37. Dimension
  • 38. Measure
  • 39. Attribute
  • 40. Filter .
  • 41. Native Filter.
  • 42. Business Filter.
  • 43. Hide Folders , Objects & filters.
  • 44. Show Script.
  • 45. Show Values .
  • 46. View Tables and Object Dependency .
  • 47. Custom Navigation Path.
  • 48. Queries .
  • 49. Parameters and List of values.
  • 50. Check Integrity.
  • 51. Data Security.
  • 52. Business Security.

SAP BOBI 4.0 BI launchPad & Web I Rich client:

  • 1. BI launch pad: What's new in 4.0 .
  • 2. Introducing Web Intelligence
  • 3. Creating BI workspace.
  • 4. Folders.
  • 5. SAP Steam.
  • 6. Scheduling a Document.
  • 7. Working with Thin Clients.
  • 8. Creating Web Intelligence Documents with Queries
  • 9. Report Design in the Java Report Panel
  • 10. Enhancing the Presentation of Reports
  • 11. Formatting Reports
  • 12. Creating Formulas and Variables
  • 13. Drilling
  • 14. Filtering data
  • 15. Alerts
  • 16. Input Control
  • 17. Scheduling
  • 18. Sharing Web Intelligence Documents .
  • 19. Filter
  • 20. Formula
  • 21. Functions
  • 22. Variable
  • 23. Merge dimensions
  • 24. Alert
  • 25. Rank
  • 26. Sort
  • 27. Break
  • 28. Section
  • 29. Hyperlink
  • 30. Page view
  • 31. View Structure
  • 32. Refresh
  • 33. Purge
  • 34. Drill Filter Tool bar
  • 35. Drill
  • 36. Snapshot
  • 37. Download to PDF, Excel & CSV.
  • 38. Export to CSV.
  • 39. Scope of Analysis.
  • 40. Database Rank.
  • 41. Sub Query.
  • 42. Combined Query.
  • 43. Custom SQL.
  • 44. Changing report source.
  • 45. Hyperlink.

SAP BOBI 4.0 Universe Design Tool:

  • 1. Connections.
  • 2. Connection Types.
  • 3. Universe parameters.
  • 4. Parameters
  • 5. Kinds of Joins.
  • 6. Loops.
  • 7. Context.
  • 8. Aliases.
  • 9. Class.
  • 10. Sub Class.
  • 11. Objects.
  • 12. Condition Objects.
  • 13. Functions
  • 14. @Functions
    • a. @Prompts
    • b. @Select
    • c. @Where
    • d. @Variable
  • 15. Cascading Prompts
  • 16. Hierarchy.
  • 17. LOV’s.
  • 18. Cascading LOV’s .
  • 19. Editing the LOV’s.
  • 20. Derived tables
  • 21. Check Integrity.
  • 22. Implementing Security.
  • 23. Universe options.
  • 24. Universe Locking.
  • 25. Linking Universe.
  • 26. Security Implementation.

SAP BOBI 4.0 Dashboards.

  • Introduction
  • Layout system
  • Grid system
  • Components
  • Themes
  • Creating Project with bootstrap

Angular JS

  • 1. What's new in SAP Business Objects Dashboards 4.0
  • 2. Connection to BO universe by using QAAWS Connection.
  • 3. Using Live Office Data.
  • 4. Connecting to Query Builder.
  • 5. Canvas
  • 6. Components.
  • 7. Component Properties.
  • 8. Dynamic Visibility.
  • 9. Drill option.
  • 10. Developing Chart Dashboards.
  • 11. Developing Maps Dashboards
  • 12. Using Containers.
  • 13. Uploading Images.
  • 14. Calling Hyperlinks in Dashboards.
  • 15. Getting around in Xcelsius
  • 16. Working with your Excel workbook
  • 17. Visualizing data with charts
  • 18. Applying formatting options
  • 19. Using themes and templates to apply formatting
  • 20. Using selectors .
  • 21. V lookup in Excel.
  • 22. Adding dynamic visibility
  • 23. Troubleshooting interactivity
  • 24. Working with Business Requirements

Administration :

  • 1. Setting up groups and users .
  • 2. Taking Meta data backup.
  • 3. Moving the code between environmants.
  • 4. Handling Services.
  • 5. License Up gradation.
  • 6. Organizing and changing Folders & Categories
  • 7. Time Out sessions .
  • 8. Instance Management.
  • 9. Managing Servers
  • 10. Connections .
  • 11. Migrating form Lower version to Existing version.
  • 12. Controlling Universes
  • 13. Scheduling through CMC
  • 14. Publication
  • 15. User Security
  • 16. Modify Settings for Applications
  • 17. Access Levels

Project Explanation.

Mock Interviews.

Resume Preparation.

BI Concepts.

About Instructor

KudVenkat

Software Architect, Trainer, Author and Speaker in Pragim Technologies.

Reviews

SAP BOBI

Average Rating

0

0 ratings

5 1

Details

5 Stars
0
4 Stars
0
3 Stars
0
2 Stars
0
1 Stars
0

ADD A REVIEW

Name
Email
Review Title
Rating
Review Content