Cursos Para Trabajadores Consultor Oficial Sap Businessobjects-data Services (bo-ds) (sector: Intersectorial/transversal) Ifct20

Temario:

1. BOW310 - WEB INTELLIGENCE: REPORT DESIGN I
2. ? Web Intelligence
3. o Describing Web Intelligence Concepts
4. o Explaining Web Intelligence Core Functions
5. o Describing Web Intelligence and the SAP BusinessObjects Business Intelligence
6. Platform
7. ? Web Intelligence Documents with Queries
8. o Creating Queries
9. o Creating a Document
10. o Modifying a Document?s Query
11. o Modify the Query Panel
12. ? Data Return Restrictions from Queries
13. o Restricting Data with Query Filters
14. o Modifying a Query with a Predefined Query Filter
15. o Applying a Single-Value Query Filter
16. o Using Wildcards in Query Filters
17. o Using Prompts to Restrict Data
18. o Using Complex Filters
19. ? Web Intelligence Document Design
20. o Modifying Web Intelligence Documents
21. o Displaying Data in Tables
22. o Using Tables
23. o Presenting Data in Free-standing Cells
24. o Presenting Data in Charts
25. ? Presentation of Data in Documents
26. o Using Breaks and Calculations
27. o Using Sorts and Hiding Data
28. o Formatting Breaks and Cross Tables
29. o Filtering Report Data
30. o Ranking Data
31. o Highlighting Information with Formatting Rules
32. o Organizing a Report into Sections
33. ? Web Intelligence Document Formatting
34. o Formatting Documents
35. o Formatting Charts
36. ? Data Calculation
37. o Applying Formulas and Variables
38. o Using Formulas and Variables
39. ? Drilling Functionality
40. o Analyzing the Data Cube
41. o Drilling in an Web Intelligence Document
42. ? Web Intelligence Documentation Management
43. o Publishing Documents to the Corporate Repository
44. o Logging In to the BI Launch Pad
45. o Managing Documents in BI Launch Pad
46. o Viewing a Web Intelligence Document in the BI Launch Pad
47. o Sharing Web Intelligence Documents
48. o Setting BI Launch Pad Preferences
49. o Logging Off From the BI Launch Pad
50. BOW320 - WEB INTELLIGENCE: REPORT DESIGN II
51. ? Web Intelligence Core Report Design
52. o Reviewing Core Report Design Concepts
53. o Comparing the Differences between Java Report Panel (JRP) and WebI Rich
54. Client (WRC)
55. ? Multiple Data Sources
56. o Synchronizing Data from Multiple Data Sources
57. o Creating Multiple Queries in a Document
58. o Synchronizing Data with Merged Dimensions
59. o Interacting with Other Data Providers
60. ? Advanced Query Techniques
61. o Implementing Combined Queries
62. o Implementing Subqueries
63. o Creating a Query Based on Another Query
64. o Changing Data Sources
65. ? Calculation Contexts
66. o Describing Calculation Contexts
67. o Redefining Calculation Contexts
68. o Implementing Extended Syntax Operators
69. o Implementing Extended Syntax Keywords
70. o Defining Calculation Context
71. ? Formulas with Character and Date String Functions
72. o Creating Formulas with Character and Date String Functions
73. o Implementing the Right() Function
74. o Implementing the Replace() Function
75. o Implementing the SubStr() Function
76. o Implementing the Pos() Function
77. o Concatenating Character Strings
78. o Implementing Date Functions
79. ? If Logic
80. o Executing If() to Group Data
81. o Executing the If() Function to Modify Calculation Behavior
82. ? Hyperlinks in Web Intelligence Documents
83. o Managing Hyperlinks in Web Intelligence Documents
84. o Managing Hyperlinks in Web Intelligence Desktop and the Rich Internet
85. Application Panel
86. o Managing Hyperlinks in the Web Intelligence Interactive Panel
87. ? Additional Reporting Techniques
88. o Implementing Data Tracking
89. o Implementing Additional Report Functions
90. BOC310 - Crystal Reports: Fundamentals of Report Design
91. ? Fundamentals of planning and creating a report
92. ? Overview of record selection, data organization and formatting
93. ? Basics of creating formulas and applying conditional reporting
94. ? Introduction to exporting and distribution of reports
95. BOC320 - SAP Crystal Reports - Business Reporting and Report Processing Strategies
96. Contenidos teórico - prácticos:
97. ? Report Wizard
98. ? Running Totals
99. ? Alerts
100. ? Functions
101. ? Control Structures
102. ? Variables
103. ? Templates
104. ? Parameters
105. ? Additional Parameters Properties
106. ? Additional Applications for Parameters
107. ? Dynamic List of Values for Parameters
108. ? Arrays
109. ? Crosstabs
110. ? Custom Functions
111. ? Sections
112. ? Introduction to Subreports
113. ? Linked Subreports
114. ? Report Linking Report Processing
115. BOID10 - Information Design Tool
116. ? Basic SAP BusinessObjects Universe Design
117. o Describing Universes
118. o Defining the Components of a Universe
119. ? Data Connections
120. o Defining Connections
121. ? Data Foundations
122. o Creating Data Foundations
123. o Using Joins
124. ? Business Layers
125. o Accessing Data through the Business Layer
126. o Integrating the Business Layer Components
127. o Validating Objects
128. o Creating Measure Objects
129. o Creating Shortcut Joins
130. ? Loops in a Data Foundation
131. o Resolving Loops with Joined Tables
132. o Resolving Loops Using Aliases
133. o Resolving Loops Using Contexts
134. o Detecting Contexts
135. o Editing Contexts
136. o Testing Contexts
137. o Resolving Recursive Loops
138. ? Data Restrictions
139. o Defining Data Restrictions
140. o Applying Mandatory Data Restrictions
141. o Applying Optional Data Restrictions
142. ? Lists of Values (LOV)
143. o Providing a List of Values
144. ? Parameters
145. o Illustrating Runtime Parameters
146. ? Object @functions
147. o Using Object @functions in Queries
148. o Applying the Aggregate Awareness Optimization Method
149. o Using Other @ Functions
150. ? Navigation Paths
151. o Defining Drill Down Navigation Paths
152. ? Derived Tables
153. o Creating Derived Tables
154. ? Key Awareness
155. o Defining Numeric Keys
156. ? Universe Management with Data Foundation and Business Layer Views
157. o Managing a Universe using the Data Foundation View
158. o Managing a Universe using the Business Layer View
159. ? Universe Optimization
160. o Optimizing Universes Using Parameters
161. ? Universe Deployment and Security
162. o Deploying a Universe
163. o Securing a Published Universe
164. o Creating Data Security Profiles
165. o Creating Business Security Profiles
166. o Assigning Security Profiles to Users
167. o Identifying the Priority of Security Settings
168. o Updating a Published Universe
169. ? SQL Clause Processing Problems
170. o Determining How the Order of SQL Clauses Affects Data Returned
171. o Detecting Ambiguity Caused by SQL Requests Run Against Joined Tables
172. o Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables
173. o Identifying Fan Traps
174. o Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables
175. ? Outer Join Problem Resolution
176. o Resolving an Ambiguous Outer Join Using @AggregateAware
177. ? Universe Creation from Different Data Sources
178. o Identifying the Different Data Sources
179. o Creating an OLAP Universe
180. o Creating a Multi-source Universe
181. ? Shared Projects
182. o Using Shared Projects
183. o Manipulating Other Designers' Resources
184. ? Universe Conversion
185. o Converting Existing .unv Universes
186. ? Translation
187. o Deploying Universes in Different Languages
188. BOID20 - INFORMATION DESIGN TOOL II
189. ? SAP BusinessObjects Business Intelligence 4.0
190. ? SAP BusinessObjects Information Design Tool 4.0 Content
191. ? SQL Traps
192. ? Advanced Use of the @Aggregate_Aware Function
193. ? Creating Universes from Different Data Sources
194. ? Deploying Universes in different languages
195. ? Managing and Optimizing Universes
196. BODS10 - SAP DATA SERVICES: PLATFORM AND TRANSFORMS
197. ? Defining Data Services
198. ? Defining Source and Target Metadata
199. ? Creating Batch Jobs
200. ? Troubleshooting Batch Jobs
201. ? Using Functions, Scripts, and Variables
202. ? Using Platform Transforms
203. ? Setting Up Error Handling
204. ? Capturing Changes in Data
205. ? Using Text Data Processing
206. ? Using Data Service (Integrator) Platform Transforms
207. BODS20 - SAP DATA SERVICES: DATA INTEGRATOR TRANSFORMS
208. ? Capturing Changes in Data
209. o Describe the options for updating changes to data
210. o Explain the purpose of Changed Data Capture(CDC)
211. o Explain the roles of surrogate keys in managing changes to data
212. o Use and define the differences between source-based and target- based CDC
213. ? Using Data Integrator Transforms
214. o Describe the Data Integrator transforms
215. o Use the Pivot transform
216. o Use the Hierarchy Flattening transform
217. o Describe performance optimization
218. o Use the Data Transfer transform
219. o Use the XML Pipeline transform
220. BODS30 - SAP Data Services: Data Quality Management
221. ? Describing Data Services
222. ? Using Data Quality Transforms
223. ? Using Address Cleanse Transforms
224. ? Using Data Cleanse Transforms
225. ? Matching and Consolidating Data