Curso de Consultor Oficial SAP Business Objects ‚Äď Data Services (BO-DS)(IFCT20)

Dificultad: Intermedio

Presentación Descargar PDF

Curso de Consultor Oficial SAP Business Objects ‚Äď Data Services (BO-DS)(IFCT20)¬†orientado a obtener la¬†certificaci√≥n oficial e internacional de SAP c√≥mo consultor en SAP Certified Application Associate – Data Integration with SAP Data Services 4.x. 100% gratuito si se imparte bajo alguno de los programas subvencionados por el SERVEF de Formaci√≥n Profesional para el Empleo.

 Duración: 144h

 Propósito

Este curso estará orientado a obtener 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

Al finalizar el Curso de Consultor Oficial SAP Business Objects ‚Äď Data Services (BO-DS)(IFCT20), el alumno habr√° adquirido cualificaciones te√≥rico-pr√°ctica de los distintos componentes que configuran la soluci√≥n SAP Business Objects – 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.

  Contenidos

  • M√≥dulo 1:¬†BOW310 Web Intelligence: Report Design I (12h)
    1. –¬†Web Intelligence
      • Describing Web Intelligence Concepts
      • Explaining Web Intelligence Core Functions
      • Describing Web Intelligence and the SAP BusinessObjects Business Intelligence Platform
    2. –¬†Web Intelligence Documents with Queries
      • Creating Queries
      • Creating a Document
      • Modifying a Document‚Äôs Query
      • Modify the Query Panel
    3. –¬†Data Return Restrictions from Queries
      • Restricting Data with Query Filters
      • Modifying a Query with a Predefined Query Filter
      • Applying a Single-Value Query Filter
      • Using Wildcards in Query Filters
      • Using Prompts to Restrict Data
      • Using Complex Filters
    4. –¬†Web Intelligence Document Design
      • Modifying Web Intelligence Documents
      • Displaying Data in Tables
      • Using Tables
      • Presenting Data in Free-standing Cells
      • Presenting Data in Charts
    5. –¬†Presentation of Data in Documents
      • Using Breaks and Calculationso
      • Using Sorts and Hiding Data
      • Formatting Breaks and Cross Tables
      • Filtering Report Data
      • Ranking Data
      • Highlighting Information with Formatting Rules
      • Organizing a Report into Sections
    6. –¬†Web Intelligence Document Formatting
      • Formatting Documents
      • Formatting Charts
    7. –¬†Data Calculation
      • Applying Formulas and Variables
      • Using Formulas and Variables
    8. –¬†Drilling Functionality
      • Analyzing the Data Cube
      • Drilling in an Web Intelligence Document
    9. –¬†Web Intelligence Documentation Management
      • Publishing Documents to the Corporate Repository
      • Logging In to the BI Launch Pad
      • Managing Documents in BI Launch Pad
      • Viewing a Web Intelligence Document in the BI Launch Pad
      • Sharing Web Intelligence Documents
      • Setting BI Launch Pad Preferences
      • Logging Off From the BI Launch Pad
  • M√≥dulo 2: BOW320 Web Intelligence: Report Design II (12h)
    1. ‚Äź¬†Web Intelligence Core Report Design
      • Reviewing Core Report Design Concepts
      • Comparing the Differences between Java Report Panel (JRP) and WebI Rich Client (WRC)
    2. ‚Äź¬†Multiple Data Sources
      • Synchronizing Data from Multiple Data Sources
      • Creating Multiple Queries in a Document
      • Synchronizing Data with Merged Dimensions
      • Interacting with Other Data Providers
    3. ‚Äź¬†Advanced Query Techniques
      • Implementing Combined Queries
      • Implementing Subqueries
      • Creating a Query Based on Another Query
      • Changing Data Sources
    4. ‚Äź¬†Calculation Contexts
      • Describing Calculation Contexts
      • Redefining Calculation Contexts
      • Implementing Extended Syntax Operators
      • Implementing Extended Syntax Keywords
      • Defining Calculation Context
    5. ‚Äź¬†Formulas with Character and Date String Functions
      • Creating Formulas with Character and Date String Functions
      • Implementing the Right() Function
      • Implementing the Replace() Function
      • Implementing the SubStr() Function
      • Implementing the Pos() Function
      • Concatenating Character Strings
      • Implementing Date Functions
    6. ‚Äź¬†If Logic
      • Executing If() to Group Data
      • Executing the If() Function to Modify Calculation Behavior
    7. ‚Äź¬†Hyperlinks in Web Intelligence Documents
      • Managing Hyperlinks in Web Intelligence Documents
      • Managing Hyperlinks in Web Intelligence Desktop and the Rich Internet Application Panel
      • Managing Hyperlinks in the Web Intelligence Interactive Panel
    8. ‚Äź Additional Reporting Techniques
      • Implementing Data Tracking
      • Implementing Additional Report Functions
  • M√≥dulo 3: BOC310 Crystal Reports: Fundamentals of Report Design (12h)
    1. –¬†Fundamentals of planning and creating a report
    2. –¬†Overview of record selection, data organization and formatting
    3. –¬†Basics of creating formulas and applying conditional reporting
    4. –¬†Introduction to exporting and distribution of reports
  • M√≥dulo 4: BOC320 SAP Crystal Reports – Business Reporting and Report Processing Strategies (18h)
    1. –¬†Report Wizard
    2. –¬†Running Totals
    3. –¬†Alerts
    4. –¬†Functions
    5. –¬†Control Structures
    6. –¬†Variables
    7. –¬†Templates
    8. –¬†Parameters
    9. –¬†Additional Parameters Properties
    10. –¬†Additional Applications for Parameters
    11. –¬†Dynamic List of Values for Parameters
    12. –¬†Arrays
    13. –¬†Crosstabs
    14. –¬†Custom Functions
    15. –¬†Sections
    16. –¬†Introduction to Subreports
    17. –¬†Linked Subreports
    18. –¬†Report Linking Report Processing
  • M√≥dulo 5: BOID10 Information Design Tool I (30h)
    1. –¬†Basic SAP BusinessObjects Universe Design
      • Describing Universes
      • Defining the Components of a Universe
    2. –¬†Data Connections
      • Defining Connections
    3. –¬†Data Foundations
      • Creating Data Foundations
      • Using Joins
    4. –¬†Business Layers
      • Accessing Data through the Business Layer
      • Integrating the Business Layer Components
      • Validating Objects
      • Creating Measure Objects
      • Creating Shortcut Joins
    5. –¬†Loops in a Data Foundation
      • Resolving Loops with Joined Tables
      • Resolving Loops Using Aliases
      • Resolving Loops Using Contexts
      • Detecting Contexts
      • Editing Contexts
      • Testing Contexts
      • Resolving Recursive Loops
    6. –¬†Data Restrictions
      • Defining Data Restrictions
      • Applying Mandatory Data Restrictions
      • Applying Optional Data Restrictions
    7. –¬†Lists of Values (LOV)
      • Providing a List of Values
    8. –¬†Parameters
      • Illustrating Runtime Parameters
    9. –¬†Object @functions
      • Using Object @functions in Queries
      • Applying the Aggregate Awareness Optimization Method
      • Using Other @ Functions
    10. –¬†Navigation Paths
      • Defining Drill Down Navigation Paths
    11. –¬†Derived Tables
      • Creating Derived Tables
    12. –¬†Key Awareness
      • Defining Numeric Keys
    13. –¬†Universe Management with Data Foundation and Business Layer Views
      • Managing a Universe using the Data Foundation View
      • Managing a Universe using the Business Layer View
    14. –¬†Universe Optimization
      • Optimizing Universes Using Parameters
    15. –¬†Universe Deployment and Security
      • Deploying a Universe
      • Securing a Published Universe
      • Creating Data Security Profiles
      • Creating Business Security Profiles
      • Assigning Security Profiles to Users
      • Identifying the Priority of Security Settings
      • Updating a Published Universe
    16. –¬†SQL Clause Processing Problems
      • Determining How the Order of SQL Clauses Affects Data Returned
      • Detecting Ambiguity Caused by SQL Requests Run Against Joined Tables
      • Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables
      • Identifying Fan Traps
      • Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables
    17. –¬†Outer Join Problem Resolution
      • Resolving an Ambiguous Outer Join Using @AggregateAware
    18. –¬†Universe Creation from Different Data Sources
      • Identifying the Different Data Sources
      • Creating an OLAP Universe
      • Creating a Multi-source Universe
    19. –¬†Shared Projects
      • Using Shared Projects o Manipulating Other Designers’ Resources
    20. –¬†Universe Conversion
      • Converting Existing .unv Universes
    21. –¬†Translation
      • Deploying Universes in Different Languages
  • M√≥dulo 6: BOID20 Information Design Tool II (12h)
    1. –¬†SAP BusinessObjects Business Intelligence 4.0
    2. –¬†SAP BusinessObjects Information Design Tool 4.0 Content
    3. –¬†SQL Traps
    4. –¬†Advanced Use of the @Aggregate_Aware Function
    5. –¬†Creating Universes from Different Data Sources
    6. –¬†Deploying Universes in different languages
    7. –¬†Managing and Optimizing Universes
  • M√≥dulo 7: BODS10 SAP Data Services: Platform and Transforms (18h)
    1. –¬†Defining Data Services
    2. –¬†Defining Source and Target Metadata
    3. –¬†Creating Batch Jobs
    4. –¬†Troubleshooting Batch Jobs
    5. –¬†Using Functions, Scripts, and Variables
    6. –¬†Using Platform Transforms
    7. –¬†Setting Up Error Handling
    8. –¬†Capturing Changes in Data
    9. –¬†Using Text Data Processing
    10. –¬†Using Data Service (Integrator) Platform Transforms
  • M√≥dulo 8: BODS20 SAP Data Services: Data Integrator Transforms (12h)
    1. –¬†Capturing Changes in Data
      • Describe the options for updating changes to data
      • Explain the purpose of Changed Data Capture(CDC)
      • Explain the roles of surrogate keys in managing changes to data
      • Use and define the differences between source-based and target- based CDC
    2. –¬†Using Data Integrator Transforms
      • Describe the Data Integrator transforms
      • Use the Pivot transform
      • Use the Hierarchy Flattening transform
      • Describe performance optimization
      • Use the Data Transfer transform
      • Use the XML Pipeline transform
  • M√≥dulo 9: BODS30 SAP Data Services: Data Quality Management (18h)
    1. –¬†Describing Data Services
    2. –¬†Using Data Quality Transforms
    3. –¬†Using Address Cleanse Transforms
    4. –¬†Using Data Cleanse Transforms
    5. –¬†Matching and Consolidating Data

 Dirigido a

A trabajadores y/o desempleados que pretendan dedicarse a ocupar puestos de trabajos para los que capacita este curso.

 Requisitos

Corresponderá a la Administración laboral competente la comprobación de que los alumnos poseen los requisitos formativos y profesionales para cursar con aprovechamiento la formación en los términos previstos en los apartados siguientes.

Para acceder a la formación de los módulos formativos de los certificados de profesionalidad de los niveles de cualificación profesional 2 y 3 los alumnos deberán cumplir alguno de los requisitos siguientes:

  1. Estar en posesión del Título de Graduado en Educación Secundaria Obligatoria para el nivel 2 o título de Bachiller para nivel 3.
  2. Estar en posesión de un certificado de profesionalidad del mismo nivel del módulo o módulos formativos y/o del certificado de profesionalidad al que desea acceder.
  3. Estar en posesión de un certificado de profesionalidad de nivel 1 de la misma familia y área profesional para el nivel 2 o de un certificado de profesionalidad de nivel 2 de la misma familia y área profesional para el nivel 3.

Materiales, metodología y evaluación

Profesor

Juan Carlos Hern√°ndez

Licenciado en Inform√°tica. BSc in Computer Science. 20 a√Īos de experiencia profesional y docente.