Para qué te prepara:
Este curso para trabajadores IFCT20 CONSULTOR OFICIAL SAP BUSINESSOBJECTS-DATA SERVICES (BO-DS) (SECTOR: INTERSECTORIAL/TRANSVERSAL) le prepara para 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. pudiendo trabajar dentro de la Familia Profesional de Informática y Comunicaciones y más concretamente dentro del Sector Intersectorial/Transversal
A quién va dirigido:
Este Curso SEPE IFCT20 CONSULTOR OFICIAL SAP BUSINESSOBJECTS-DATA SERVICES (BO-DS) (SECTOR: INTERSECTORIAL/TRANSVERSAL) está dirigido a todas aquellas personas de la Familia Profesional de Informática y Comunicaciones y más concretamente del Sector Intersectorial/Transversal que deseen especializarse en dicha materia.
Titulación:
Titulación de IFCT20 CONSULTOR OFICIAL SAP BUSINESSOBJECTS-DATA SERVICES (BO-DS) (SECTOR: INTERSECTORIAL/TRANSVERSAL) con 144 horas expedida por la Administración Pública
Objetivos:
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.
Salidas Laborales:
Intersectorial/Transversal
Resumen:
Este CURSO GRATIS PARA TRABAJADORES IFCT20 CONSULTOR OFICIAL SAP BUSINESSOBJECTS-DATA SERVICES (BO-DS) (SECTOR: INTERSECTORIAL/TRANSVERSAL) le ofrece una formación especializada en la materia dentro de la Familia Profesional de Informática y Comunicaciones. Con este CURSO GRATUITO IFCT20 CONSULTOR OFICIAL SAP BUSINESSOBJECTS-DATA SERVICES (BO-DS) (SECTOR: INTERSECTORIAL/TRANSVERSAL) el alumno será capaz de desenvolverse dentro del Sector Intersectorial/Transversal 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. . Esta Formación de IFCT20 CONSULTOR OFICIAL SAP BUSINESSOBJECTS-DATA SERVICES (BO-DS) (SECTOR: INTERSECTORIAL/TRANSVERSAL) no consume crédito de su Empresa y no requiere de la autorización de la misma.
Metodología:
Temario:
- 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
- Contenidos teórico - prácticos:
- ? 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
- ? 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