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

Process Implementing with IBM Business Process Manager v8.6 – I

IBM Business Process Manager is a comprehensive BPM environment that provides the visibility and insight required to effectively manage the business processes of an organization.

The course begins with an overview of business process management, emphasizing the concepts of reuse, ease of maintenance, and high-quality development strategies. Youï¿½ll create simple ad hoc activities by using the web-based tools and use the IBM Business Process Manager Process Designer to create a business process definition (process) from business requirements that are identified during process analysis. Youï¿½ll also learn how to make team collaboration more efficient by enabling all team members to use standard Business Process Model and Notation (BPMN) elements. Additionally, youï¿½ll learn core process modeling and implementation skills, the project development approach, process model implementation fundamentals, and exceptional delivery patterns. These skills improve the speed and quality of process definition and implementation efforts. The course continues with an overview of the architecture of IBM Business Process Manager and describes the use of process applications and toolkits within the tool. Youï¿½ll create business objects and variables, implement gateways, and demonstrate process flow on your diagrams. You build customized user interfaces (coaches) to enable business and process data flows throughout the process model.

This course uses an interactive learning environment, with hands-on demonstrations and class activities to reinforce concepts and check understanding. Lab exercises throughout the course provide hands-on experience with BPM tasks and skills. This course is intended to be collaborative, and you can work in teams to complete class activities.

Uncategorized

Quality for Project Managers

In this course, you will learn how to develop or improve the quality programs at your workplace. You will use systems thinking to plan quality into your project, prioritize requirements to meet customers’ quality needs, select quality assurance and quality control activities that are tailor-fit to your project, and use quality management processes, tools, and metrics to increase the likelihood of project success. You will use a Quality Management Plan to document and structure a thoughtful approach to project quality management. You will gain insight into applying quality planning, quality assurance, and quality control to real-world projects.

Students pursuing a university-recognized and/or accredited certificate in Canada or continuing education units in the US must attend at least 90% of class time, participate in class exercises and section-knowledge checks, and score at least 70% on an end-of-class, multiple-choice assessment.

PMI is registered mark of the Project Management Institute, Inc.

Uncategorized

Applied AI & Machine Learning | Design

The developers of this course have been actively involved with the design, implementation and deployment of real-world and predictive modeling solutions in large organizations for decades. Their clients have been richly rewarded by identifying and prioritizing valid projects ahead of development and deriving real value from successful deployments.

There simply is no other vendor-neutral event in the marketplace that focuses exclusively on analytic project assessment, planning and design ï¿½ let alone integrating seamlessly into an overarching series for end-to-end process implementation. The skills taught in this course are rare and highly valued in the market.

Uncategorized

SAP Access Control Implementation and Configuration (GRC300v16)

In this course, you will learn about the configuration and implementation of SAP Access Control 10.1, as well as important concepts you will need to know in order to prepare for implementation and ongoing access risk prevention.

Note: This course is based on software release SAP Access Control 10.1.