SAP Crystal Reports for Enterprise: Fundamentals of Report Design (BOCE10)

COURSE OUTLINE:

Description

Participants will gain the fundamentals of report design and acquire the basis for more advanced courses in the SAP BI curriculum.

Audience

Business analysts
System administrators

Prerequisites

Essential

Knowledge of Windows Conventions

Recommended

Basic database concepts

Learning Objectives

Plan and create a report
Organize and format data
Apply record selection
Create formulas and apply conditioning report
Export and distribute reports

1. Report Planning

Describing Database Concepts
Planning and Developing a Report Prototype

2. SAP Business Objects BI Platform and Data Source Connection

Logging On to SAP BusinessObjects BI Platform
Defining a Data Source

3. Report Creation

Connecting to a Data Source
Creating a Query
Describing the Report Design Environment
Setting Up Report Sections
Describing the Field Objects Controls
Saving a Report

4. Report Layout and Formatting

Setting Page Properties
Applying Report Formatting Options

5. Data Selection

Editing a Query
Inserting Additional Filter Conditions
Modifying Query Filters
Applying Time-Based Filters

6. Sorting, Grouping, and Totaling

Sorting Data
Grouping Data
Creating Nested and Multiple Groups
Creating a Custom Group
Grouping on Time-Based Data
Totaling Grouped Data
Totaling Column Data

7. Additional Report Objects

Inserting Predefined Objects
Adding Graphical Objects

8. Formulas

Defining Formulas
Using the Formula Workshop
Creating and Modifying Formulas
Applying Boolean Formulas
Applying If-Then-Else Formulas
Applying Date Calculations + Applying Numeric Calculations + Applying String Manipulation

9. Conditional Formatting

Formatting Objects Conditionally
Formatting Fields Conditionally with Formulas
Formatting Sections
Formatting Sections Conditionally
Drilling Down on Sections

10. Charting

Describing Charting Concepts
Charting On Data
Formatting Charts

11. Report Distribution

Exporting a Report
Saving Reports to SAP BusinessObjects Business Intelligence Platform

RELATED COURSES

Uncategorized

Monitoring and Operating a Private Cloud (M20246)

In this course, you will receive an overview of a private cloud infrastructure, the business and technical drivers behind the implementation, and how System Center 2012 can be used to monitor and operate the private cloud infrastructure. Through hands-on exercises you will gain the skills to configure and optimize a new business unit cloud, deploy pre-packaged applications, and create a new service template to deploy a service into the cloud. You will also learn how System Center Operations Manager is used to monitor the various services that underpin the private cloud. You will learn the core functionality of Service Manager and achieve the skills to create and manage change requests, incidents, and release records as well as the security model behind Service Manager.

Uncategorized

Puppet Configuration Management Boot Camp

The configuration management and data center automation tool that streamlines every step of IT service delivery, Puppet allows you to provision physical and virtual machines, orchestrate configuration management and develop, test and deploy code faster. Designed to easily automate repetitive and error-prone system administration tasks, Puppet’s declarative language allows you to state how your systems should be configured to do their jobs. It’s easy to quickly set up systems in a reliable and repeatable way.

Uncategorized

IBM Tivoli Workload Scheduler 9.2 Operations and Scheduling

This course introduces IBM Tivoli Workload Scheduler 9.2 features, environment, and terminology. You learn about the features for distributed environments and how to use both the Dynamic Workload Console and command-line interfaces. You also learn how to monitor production workflow, and to plan, implement, and manage Workload Scheduler objects to create a production day plan. You manage changes to objects, the plan, jobs, events, and job streams. You also learn how to optimize production workflow, troubleshoot plan problems, and manage dynamic and event-driven workloads. Hands-on labs reinforce concepts through production scenarios.

NOTE: This course is suitable for IBM Workload Scheduler versions 9.1 and 9.2 users.

Uncategorized

Certified Information Privacy Professional Europe (CIPP/E) Prep Course

In this course, you will gain foundational knowledge on concepts of privacy and data protection laws and practice. You will learn common principles and approaches to privacy as well as understand the major privacy models employed around the globe.

When the GPPR takes effect in 2018, among its mandates is the requirement to appoint knowledgeable DPOs (data protection officers) tasked with monitoring compliance, managing internal data protection activities, training data processing staff, conducting internal audits and more. Thereï¿½s a lot to know, thereï¿½s a lot at stake and thereï¿½s a lot of opportunity for privacy professionals with the right training and education.

Achieving a CIPP/E credential shows you have the comprehensive GDPR knowledge, perspective and understanding to ensure compliance and data protection success in Europeï¿½and to take advantage of the career opportunity this sweeping legislation represents.

You will gain an introduction to the legislative framework for current EU data protection law at both the EU and state level. Key concepts and practices related to the application of European law, data protection principles, legitimate processing criteria, information provision obligations, data subject rights, confidentiality and security, notification requirements, international data transfers, and supervision and enforcement.

This two-day program covering the principals of information privacy in Europe includes:

ï¿½ Official IAPP CIPP participant guide
ï¿½ Official IAPP CIPP textbook
ï¿½ Official IAPP CIPP practice test
ï¿½ IAPP CIPP/E certification exam voucher
ï¿½ IAPP membership for one year

Note: Your contact information must be provided to the IAPP for membership services fulfillment.