Cursos gratutitos SEFCARM

IFCT20 Consultor oficial SAP businessobjects-data services (BO-DS)

Objetivo general


Proporcionar al participante cualificaciones teórico-práctica de los distintos componentes que configuran la solución SAP BusinessObjects - Business Intelligence, para el manejo, integración, depuración de datos y la elaboración del reporting requerido por las compañías de
cara al análisis de datos, resultados y toma de decisiones por parte de los responsables de cada área de negocio dentro de una empresa.
Así mismo, esta formación se centra en la obtención de la certificación oficial e internacional de SAP cómo consultor en SAP Certified Application Associate - Data Integration with SAP Data Services 4.x

 

Objetivos específicos

  • Adquirir los conocimientos y habilidades básicas para crear informes con la herramienta Web Intelligence en función de las necesidades del cliente. Obtener datos y construir consultas usando la información de SAP Business Objects. Utilizar Web Intelligence para obtener documentos de análisis de la información disponible. Organizar, gestionar y distribuir los documentos utilizando las herramientas de SAP Business Intelligence
  • Crear documentos utilizando las funciones avanzadas de SAP Web Intelligence para la realización de consultas e informes incluyendo: Consultas combinadas y sub-consultas, Funciones Character y date string, Variables y cálculos contextuales y enlaces a documentos usando hyperlinks
  • Adquirir los conocimientos fundamentales para el diseño de informes utilizando la herramienta Crystal Reports.
  • Obtener conocimientos avanzados a la hora de la configuración / realización de informes complejos utilizando la herramienta SAP Crystal Reports
  • Adquirir las habilidades integrales necesarias para trabajar con la herramienta de diseño de información. La herramienta de diseño de información permite a los diseñadores extraer, definir y manipular metadatos obtenidos de diferentes fuentes para crear y desplegar universos de información SAP BusinessObjects. En este curso se obtendrán conocimientos para poder
    utilizar los datos de diferentes sistemas de origen (SAP y no SAP) con las herramientas de cliente de SAP BusinessObjects BI.
  • Adquirir las habilidades para resolver consultas SQL complejas. Aprender el uso avanzado de la función AggregateAware. Crear universos desde una fuente de OLAP y/o de múltiples fuentes relacionales. Implementar universos en diferentes idiomas. Administrar y optimizar los universos creados
  • Adquirir los conocimientos y habilidades básicas para aprender a almacenar de datos en almacenamientos operativos, data warehouse o almacenamiento de datos data mart. Actualización de datos de forma on-line o batch. Transformación de datos para el análisis de los mismos
  • Adquirir los conocimientos necesarios para cubrir cambiado de captura de datos, técnicas de optimización de rendimiento y escenarios de integración utilizando específicas integrator transforma los datos
  • Adquirir los conocimientos necesarios para trabajar con datos de direcciones global. Completar una limpieza de datos transformar. Establecer coincidencia con el Asistente de ajuste. Consolidar los registros coincidentes para formar registro de mayor calidad

 

Número de participantes

Máximo 25 participantes para cursos presenciales.

 

Relación secuencial de módulos formativos


 BOW310 Web Intelligence: Report Design I

 Web Intelligence
 o Describing Web Intelligence Concepts
 o Explaining Web Intelligence Core Functions
 o Describing Web Intelligence and the SAP BusinessObjects Business Intelligence Platform
 Web Intelligence Documents with Queries
 o Creating Queries
 o Creating a Document
 o Modifying a Document’s Query
 o Modify the Query Panel
 Data Return Restrictions from Queries
 o Restricting Data with Query Filters
 o Modifying a Query with a Predefined Query Filter
 o Applying a Single-Value Query Filter
 o Using Wildcards in Query Filters
 o Using Prompts to Restrict Data
 o Using Complex Filters
 Web Intelligence Document Design
 o Modifying Web Intelligence Documents
 o Displaying Data in Tables
 o Using Tables
 o Presenting Data in Free-standing Cells
 o Presenting Data in Charts
 Presentation of Data in Documents
 o Using Breaks and Calculations
 o Using Sorts and Hiding Data
 o Formatting Breaks and Cross Tables
 o Filtering Report Data
 o Ranking Data
 o Highlighting Information with Formatting Rules
 o Organizing a Report into Sections
 Web Intelligence Document Formatting
 o Formatting Documents
 o Formatting Charts
 Data Calculation
 o Applying Formulas and Variables
 o Using Formulas and Variables
 Drilling Functionality
 o Analyzing the Data Cube
 o Drilling in an Web Intelligence Document
 Web Intelligence Documentation Management
 o Publishing Documents to the Corporate Repository
 o Logging In to the BI Launch Pad
 o Managing Documents in BI Launch Pad
 o Viewing a Web Intelligence Document in the BI Launch Pad
 o Sharing Web Intelligence Documents
 o Setting BI Launch Pad Preferences
 o Logging Off From the BI Launch Pad


 BOW320 Web Intelligence: Report Design II

 Web Intelligence Core Report Design
 o Reviewing Core Report Design Concepts
 o Comparing the Differences between Java Report Panel (JRP) and WebI Rich Client (WRC)
 Multiple Data Sources
 o Synchronizing Data from Multiple Data Sources
 o Creating Multiple Queries in a Document
 o Synchronizing Data with Merged Dimensions
 o Interacting with Other Data Providers
 Advanced Query Techniques
 o Implementing Combined Queries
 o Implementing Subqueries
 o Creating a Query Based on Another Query
 o Changing Data Sources
 Calculation Contexts
 o Describing Calculation Contexts
 o Redefining Calculation Contexts
 o Implementing Extended Syntax Operators
 o Implementing Extended Syntax Keywords
 o Defining Calculation Context
 Formulas with Character and Date String Functions
 o Creating Formulas with Character and Date String Functions
 o Implementing the Right() Function
 o Implementing the Replace() Function
 o Implementing the SubStr() Function
 o Implementing the Pos() Function
 o Concatenating Character Strings
 o Implementing Date Functions
 If Logic
 o Executing If() to Group Data
 o Executing the If() Function to Modify Calculation Behavior
 Hyperlinks in Web Intelligence Documents
 o Managing Hyperlinks in Web Intelligence Documents
 o Managing Hyperlinks in Web Intelligence Desktop and the Rich Internet Application Panel
 o Managing Hyperlinks in the Web Intelligence Interactive Panel
 Additional Reporting Techniques
 o Implementing Data Tracking
 o Implementing Additional Report Functions


 BOC310 Crystal Reports: Fundamentals of Report Design

 Fundamentals of planning and creating a report
 Overview of record selection, data organization and formatting
 Basics of creating formulas and applying conditional reporting
 Introduction to exporting and distribution of reports


 BOC320 SAP Crystal Reports - Business Reporting and Report Processing Strategies

 Report Wizard
 Running Totals
 Alerts
 Functions
 Control Structures
 Variables
 Templates
 Parameters
 Additional Parameters Properties
 Additional Applications for Parameters
 Dynamic List of Values for Parameters
 Arrays
 Crosstabs
 Custom Functions
 Sections
 Introduction to Subreports
 Linked Subreports
 Report Linking Report Processing


 BOID10 Information Design Tool I

 Basic SAP BusinessObjects Universe Design
o Describing Universes
o Defining the Components of a Universe
 Data Connections
o Defining Connections
 Data Foundations
o Creating Data Foundations
o Using Joins
 Business Layers
o Accessing Data through the Business Layer
o Integrating the Business Layer Components
o Validating Objects
o Creating Measure Objects
o Creating Shortcut Joins
 Loops in a Data Foundation
o Resolving Loops with Joined Tables
o Resolving Loops Using Aliases
o Resolving Loops Using Contexts
o Detecting Contexts
o Editing Contexts
o Testing Contexts
o Resolving Recursive Loops
 Data Restrictions
o Defining Data Restrictions
o Applying Mandatory Data Restrictions
o Applying Optional Data Restrictions
 Lists of Values (LOV)
o Providing a List of Values
 Parameters
o Illustrating Runtime Parameters
 Object @functions
o Using Object @functions in Queries
o Applying the Aggregate Awareness Optimization Method
o Using Other @ Functions
 Navigation Paths
o Defining Drill Down Navigation Paths
 Derived Tables
o Creating Derived Tables
 Key Awareness
o Defining Numeric Keys
 Universe Management with Data Foundation and Business Layer Views
o Managing a Universe using the Data Foundation View
o Managing a Universe using the Business Layer View
 Universe Optimization
o Optimizing Universes Using Parameters
 Universe Deployment and Security
o Deploying a Universe
o Securing a Published Universe
o Creating Data Security Profiles
o Creating Business Security Profiles
o Assigning Security Profiles to Users
o Identifying the Priority of Security Settings
o Updating a Published Universe
 SQL Clause Processing Problems
o Determining How the Order of SQL Clauses Affects Data Returned
o Detecting Ambiguity Caused by SQL Requests Run Against Joined Tables
o Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables
o Identifying Fan Traps
o Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables
 Outer Join Problem Resolution
o Resolving an Ambiguous Outer Join Using @AggregateAware
 Universe Creation from Different Data Sources
o Identifying the Different Data Sources
o Creating an OLAP Universe
o Creating a Multi-source Universe
 Shared Projects
o Using Shared Projects
o Manipulating Other Designers' Resources
 Universe Conversion
o Converting Existing .unv Universes
 Translation
o Deploying Universes in Different Languages


 BOID20 Information Design Tool II

• SAP BusinessObjects Business Intelligence 4.0
• SAP BusinessObjects Information Design Tool 4.0 Content
• SQL Traps
• Advanced Use of the @Aggregate_Aware Function
• Creating Universes from Different Data Sources
• Deploying Universes in different languages
• Managing and Optimizing Universes


 BODS10 SAP Data Services: Platform and Transforms

 Defining Data Services
 Defining Source and Target Metadata
 Creating Batch Jobs
 Troubleshooting Batch Jobs
 Using Functions, Scripts, and Variables
 Using Platform Transforms
 Setting Up Error Handling
 Capturing Changes in Data
 Using Text Data Processing
 Using Data Service (Integrator) Platform Transforms


 BODS20 SAP Data Services: Data Integrator Transforms

 Capturing Changes in Data
o Describe the options for updating changes to data
o Explain the purpose of Changed Data Capture(CDC)
o Explain the roles of surrogate keys in managing changes to data
o Use and define the differences between source-based and target- based CDC
 Using Data Integrator Transforms
o Describe the Data Integrator transforms
o Use the Pivot transform
o Use the Hierarchy Flattening transform
o Describe performance optimization
o Use the Data Transfer transform
o Use the XML Pipeline transform


 BODS30 SAP Data Services: Data Quality Management

 Describing Data Services
 Using Data Quality Transforms
 Using Address Cleanse Transforms
 Using Data Cleanse Transforms
 Matching and Consolidating Data

 

Duración

Horas totales: 144 h

No hay artículos en esta familia