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

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

Auditing IT Infrastructures for Compliance

This course provides a unique, in-depth look at recent US-based information systems and IT infrastructure compliance laws in both the public and private sector. Written by industry experts, this course provides a comprehensive explanation of how to audit IT infrastructures for compliance based on the laws, and the need to protect and secure business and consumer privacy data.

In addition to premium instructional content from Jones & Bartlett Learning’s comprehensive Information Systems Security and Assurance (ISSA) curriculum, this course provides access to hands-on paper-based labs, case scenarios, and handouts, and eBook (via CourseSmart).

Certification:

This course covers content within the following industry certification exams:

Certified Information Systems Security Professional (CISSP) – "Telecommunications and Network Security" domain
Security + – "Network Security" domain
Systems Security Certified Practitioner (SSCP) – "Networks and Communications" domain.
8570.01 – "Network Security" domain

Uncategorized

SonicWall Network Security Administrator

This course provides you with the background, knowledge, and hands-on experience to begin setting up Basic Firewall Components that will guide you through the process of creating zones on the firewalls, configuring virtual interfaces, creating host address and service objects, deploying NAT policies, and configuring access rules. This technical training covers Basic Threat Protection, which includes Gateway Anti-Virus, Intrusion Prevention Service, and Anti-Spyware; and Advanced Threat Protection, which is comprised of Capture ATP, and GEO IP and Botnet filtering. You will become familiar with a wide spectrum of SonicWallï¿½s innovative feature set, such as Unified Threat Management (UTM), Single Sign-On, VPN, SSL VPN, and Content Filtering Service. As you examine the wide array of security features SonicOS has to offer, you will learn creating and applying app rules, application bandwidth optimization, and advanced application control implementations. Formative evaluations (knowledge checks and hands-on exercises) are incorporated throughout this course to test new skill sets.

Uncategorized

AppDynamics Test Drive Operations-(APPDYN)

This course covers a comprehensive topic list covering the keys aspects of AppDynamics deployment and use. You will discover faster, more efficient monitoring with an enterprise Application Performance Management (APM) solution that learns your apps. By understanding end-user monitoring, you can create superior experiences by monitoring where customers are connecting with your business the most. The topic of Infrastructure visibility allows you to monitor the servers and databases criticial to supporting application performance. By the end of the course, you will be able to successfully deploy and use AppDynamics.