Cursos Para Trabajadores Consultor Oficial Sap Businessobjects-data Services (bo-ds) (sector: Empresas De Consultoría Y Estudios De Mercados Y Opinión Pública) 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