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

Information Storage and Management v3

In this course, you will learn about the various storage infrastructure components in data center environments. You will leave this course knowing how to make informed decisions on storage-related technologies in an increasingly complex IT environment. You will learn about storage technologies, architectures, features, and benefits of intelligent storage systems including block-based, file-based, object-based, and unified storage; software-defined storage. This course takes an open-approach to describe all the concepts and technologies, which are further illustrated and reinforced with EMC-related product examples.

Uncategorized

Making Data Science Pay

Data Science is a big deal. But if you were to ask a hundred people what Data Science is ï¿½ and more importantly, to state its value ï¿½ youï¿½d probably get a hundred different answers. Data Science is too important to be so elusive.ï¿½ This seminar remedies that by defining the value and explaining the technology behind it.ï¿½ The purpose is to cut through the market buzz surrounding data science and boil it down to its practical concepts and applications.

Participants will learn the real-world usage and ROI of data science including why projects typically succeed or fail. The course simplifies the technology and the essential tasks of the data scientist. It peels away the complexities surrounding data science, boiling it down to its essence, presented in a style that all can understand.

Uncategorized

SQL Server Performance Tuning and Optimization (M55144)

In this course, you will learn practical tuning and optimization techniques for SQL Server 2014 that include indexing and statistics strategies, transaction log operations, tempdb and data file configuration, transaction and isolation levels, locking and blocking, and the new In-Memory OLTP engine. You will learn how to create baselines and benchmark SQL Server performance as well as analyze and fix workload for performance issues.

This course incorporates materials from the Official Microsoft Learning Product 55144: SQL Server Performance Tuning and Optimization.

Uncategorized

Project Portfolio Management

In this course, you will learn what it takes to maximize the number and strategic value of the projects that your organization completes. This course is designed for anyone involved in the development and execution of organizational strategy.