SAP Analytics, Data Modeling and Reporting Course

Introduction:

SAP Analytics, Data Modeling and Reporting Course is design to cover both SAP BI and BO course content. After completion of this course students can go for both SAP BI and BO certification.

Course Contents:

  • Overview of Data Acquisition in BW7.3
  • Data Acquisition and Process Chains
  • Direct Access to Source Data and Real Time Data Acquisition
  • Data Acquisition from SAP systems with the Service API
  • Delta Data Flow Management
  • Transfer of Flat File Data
  • Data Acquisition with DB Connect
  • Data Acquisition with Universal Data Integration
  • XML-Based Data Acquisition
  • Data Acquisition with Data Services
  • Data Mart Interface and Open Hub
  • Positioning and Overview of SAP NetWeaver Business Warehouse
  • Working with the most important objects (InfoObjects, InfoProviders etc.) of SAP NetWeaver BW
  • Creating a simple data model plus data flow and loading data from different source systems
  • Using BI Content
  • Learning BEx Tools: Query Designer, BEx Analyzer, Workbook etc
  •  Writing BEx Queries
  • Optimizing query performance
  • Administrating SAP NetWeaver BW
  • Aspects of Enterprise Data Warehouse architecture
  • Aspects of Enterprise Data Warehouse architecture
  • Layered Scalable Architecture
  • Using BW Content within an implementation project
  • Case Study for creating a requirements analysis and for developing a BW data model
  • along the principles of the Layered Scalable Architecture
  • Enhanced modeling of InfoObjects
  • Different DSO-types and InfoCubes with good performance
  • Multi Providers, Semantically Partitioned Objects, InfoSets
  • Enhancing/changing the data model, remodeling
  •  Supporting modeling by Information Lifecycle Management
  • Innovations in Business Solutions
  • A new beginning in your Career!
  • Using a Data Mining example within the Analysis Process Designer to create additional master data
  • Process Chains and different operational processes
  • Batch Scheduling using SAP Batch Jobs
  • Extraction from SAP
  • Extraction using flat file
  • Extractor, data source, info source, transfer structure, transformation
  • DTP, Info Packages
  • Work with Projects
  • Create a local project
  • Shared projects
  • Create a local project and retrieving a published Universe
  • Create the data foundation
  • Create a database connection
  • Create a data foundation
  • Define joins in a data foundation
  • Create a business layer
  • Create folders and objects
  • Create measure objects
  • Maintain universes
  • Deplore and manage
  • What is SAP Business Objects Business Intelligence platform
  • Managing content and objects in SAP Business Objects Business Intelligence platform
  • Describing Data Services
  • Examine data acquisition and process chains
  • Creating batch jobs for data integration
  • Troubleshooting batch jobs
  • Using functions, scripts and variables
  • Using Platform Transforms
  • Setting up error handling
  • Capturing change in data
  • Using the data integrator platform transforms
  • Introduction to IDT
  • Creating Projects
  • Create a connection to a relational database
  • Create a data foundation based on a single source relational database
  • Create a business layer based on a single relational data source
  • Publish a new universe file based on a single data source
  • Retrieve a universe from a repository location
  • Publish a universe to a local folder
  • Retrieve a universe from a local folder
  •  Open a local project
  •  Delete a local project
  •  Convert a repository universe from a UNV to a UNX
  • Convert a local universe from a UNV to a UNX
  • Creating Data Foundations
  • Overview of OLAP Connections
  • Overview of SAP BW Connections
  • Overview of a Query on an OLAP Universe
  • Creating Business Layers
  • Publishing Business Layers on CMS
  • Query Panel in Business Layer
  • Consistency Checks
  • Introduction to Business Objects (Reporter) Module (Part 1)
  • What’s New in Web Intelligence?
  • Introduction to Java Launch Pad
  • Launching Web Intelligence
  • Setting Web Intelligence Preferences
  • Navigate the Web Intelligence Interface
  • Creating Documents with Queries
  • Components of a Universe
  • Create a query using a universe as the data source
  • Modify a document’s query
  • Changing Data Sources
  • Work with query properties
  • Exploring the Query Panel toolbar
  • Exploring the Result Objects Pane
  • Exploring the Query Filters Pane
  •  Viewing the Query Script
  • Create a query using a BEx query and an Analysis View
  • Restricting Data with Query Filters
  •  Components of a Query Filter
  • Adding a Predefined Query Filter
  • Creating a Single-Value Query Filter
  • Creating a Prompted Query Filter
  •  Setting Prompt Properties
  •  Creating Complex Query Filters
  •  Prioritizing Operators and Grouping Filters
  •  Creating a Subquery
  •  Designing Web Intelligence Documents
  • Components of a Web Intelligence Document
  • Customize Document Preferences
  • Displaying Data in Tables
  • Displaying Data in Charts
  •  Displaying Data in Free-Standing Cells
  • Inserting Free-Standing Cells
  • Organizing Document Data
  • Grouping and Calculating Data
  • Applying Breaks to Group Data
  • Calculating Data
  • Applying Sorts to Data
  • Editing Break Properties
  • Adding Sections to a Report
  • Filtering Report Data
  • Applying Report Filters
  • Selecting a Report Filter
  •  Filtering Data with Input Controls
  •  Organizing Data
  •  Ranking Data to See Top or Bottom Values
  •  Folding and Unfolding Report Data
  • Hiding and Unhiding Report Data
  • Copying Data Blocks
  • Highlighting Data
  • Tracking Data Changes
  • Highlighting Data with Formatting Rules
  • Applying Multiple Conditions to Formatting Rules
  • Formatting Documents
  • Viewing Reports in Different Modes
  • Modifying Report Properties
  • Formatting Tables, Cells, and Sections
  • Formatting Cross Tables
  • Formatting Charts
  • Calculating Data with Formulas and Variables
  • Creating Formulas and Variables
  • Adding Formulas to a Document
  • Creating Variables in a Document
  • Creating a Formula from a Prompt Response
  • Creating a Variable to Calculate Data
  • Creating a Variable Using Document Functions
  • Modifying Data with Character and Date String Functions
  • Using Character String Functions
  • Using Date Functions
  • Calculating Data with Conditional Logic
  • Grouping Data Values with the If() Function
  • Synchronizing Data from Multiple Data Providers
  • Working with Multiple Data Providers
  • Projecting Data from a Single Query in Multiple Blocks
  • Projecting Data from Multiple Queries Using a Single Universe
  • Projecting Data Using Multiple Universes
  • Synchronizing Data with Merged Dimensions
  • Merging Dimensions to Link Two Data Sources
  • Analyzing Data in Drill Mode
  • Setting General Drill Options
  • Setting the Scope of Analysis
  • Drilling in a Document
  • Drilling in a Data Hierarchy
  • Drilling in Charts
  • Demo of Rich Client & Webi intelligence with Features Highlighted
  • Xcelsius Dashboard Overview
  • Creating Dashboards using Query As A Web Service (QAAWS) and Live Office
  • Create Drill Down dashboard reports
  • What’s new in SAP Business Objects Dashboards 4.1
  • Creating a Visualization
  • Producing interactive visualizations
  • Getting around in Xcelsius
  • Working with your Excel workbook
  • Visualizing data with charts
  • Using Xcelsius Components
  • Formatting a Visualization
  • Applying formatting options
  • Using themes and templates to apply formatting
  • Adding Interactivity to a Visualization
  • Using selectors
  • Adding dynamic visibility
  • Using live data sources
  • Connecting to BO Universes using Query as a Web Service
  • Using Live Office data
  • Creating Complex dashboards
  • Overview of Lumira
  • Overview of Analysis and Design studio
  • To Know about SAP  certification and FAQ please visit the below link

    White paper http://iibs.ca/knowledge-updates/business-intelligence-bi/
    Certifications http://iibs.ca/certifications

    ……………………………………

    SAP Training, SAP Training Toronto, SAP Training Mississauga,SAP BI

Comments are closed.